How Webgility Online Handles Split-Tender Payments for Shopify Orders
This article explains how Webgility Online handles split-tender payments for Shopify orders when posting transactions to QuickBooks Online.
What is a split-tender payment?
A split-tender payment occurs when a customer uses two or more payment methods to complete an order.
For example, a customer places a $150 order and pays using:
- Credit Card: $100
- Gift Card: $50
- Total: $150
Each payment method represents a separate portion of the order total and should be accounted for accordingly.
How does Webgility Online handle split-tender payments?
When a Shopify order is paid using multiple payment methods, Webgility Online handles the accounting entries as follows:
- Sales Receipt: Webgility Online posts the full order amount to Undeposited Funds in QuickBooks.
- Journal Entry: Webgility Online creates a corresponding Journal Entry to allocate the payment amounts to their respective clearing accounts.
- Payment Allocation: Each payment method is recorded separately using its configured Chart of Accounts mapping.
This helps ensure that the payment amounts are allocated correctly and that the clearing accounts reflect the individual payment methods used by the customer.
How are gift cards and store credit handled?
Gift cards and store credit can also be part of a split-tender payment.
For example, if a customer pays using a credit card and a gift card, Webgility Online allocates each payment amount to its corresponding mapped account.
Note: If the existing item-based gift card netting setting is enabled, Webgility Online continues to use the existing gift card netting process. A separate Journal Entry is not required for that scenario.
How are partially paid and unpaid orders handled?
Webgility Online also accounts for orders that are not fully paid when initially downloaded.
- Partially paid orders: Webgility Online records the payment amount available at the time of synchronization. When the remaining payment is received, an additional Journal Entry is created to account for the outstanding amount.
- Unpaid orders: No additional payment allocation is made during the initial posting. Once the payment status changes, Webgility Online creates the corresponding Journal Entry to record the payment.
This allows payment allocations to be updated as the order's payment status changes.
What happens when you undo a posted order?
When you undo a split-tender order, Webgility Online also reverses the associated Journal Entry.
The Journal Entry is reversed first, followed by the Sales Receipt. If the Journal Entry cannot be deleted, Webgility Online will not proceed with deleting the Sales Receipt. This helps prevent incomplete reversals and orphaned accounting entries.
You can also review the Journal Entry posting or reversal outcome in the order's Order History.
Important considerations
The following limitations apply to the current split-tender implementation:
- Sales Receipt: Split-tender payment allocation is supported for Shopify orders posted as Sales Receipts.
- Invoice: Invoice posting and payment synchronization are not changed by this implementation.
- Consolidated Posting: Split-tender payment allocation through Consolidated Posting is not included in this implementation.
- Supported channels: Shopify is supported in the initial implementation. Square and BigCommerce are not included in this release.