When a Shopify order has been tagged in Shopify to be synced to the connected general ledger, A2X creates accounting entries for this order as part of a grouped settlement, and as an individual B2B invoice.
The First process - the order is fetched and processed as part of a generated settlement.
1(a) The tagged order is still included in the A2X Settlement generation process:
Once a day, the tagged order is fetched by A2X along with all other orders that have been created or edited during this 24 hour period.
A2X creates a settlement that includes this order, by payment gateway type which debits a payment gateway clearing account (or pending payment if the orders are unpaid) and credits the applicable profit & loss accounts, as specified in the Accounts & Taxes page.
1(b) If the order is unpaid in the first settlement, a further settlement will be created when that order is paid.
When the unpaid order is marked as paid in Shopify, A2X will debit the payment gateway clearing account nominated in the Shopify order, and credit Pending Payment.
The Second Process - the order is processed by A2X as an individual B2B invoice.
2(a) The tagged order is created as an individual invoice in the ledger.
A2X creates a B2B Order settlement which syncs as an invoice to the connected ledger which will debit accounts receivable and credit the account selected by the user in the A2X B2B settings page.
2(b) If the tagged order is unpaid at time of syncing, A2X will create a B2B Payment entry when that order is subsequently paid.
A2X creates a B2B Payment settlement which will sync as an invoice (in Xero) or a journal entry (in QBO). This entry debits the account selected in the A2X B2B settings page, and credits the payment gateway clearing account which was used in the Shopify Order.
Please note that there are parts of the B2B process that the Bookkeeper will need to take ownership of, which are:
3(a) If the B2B invoice is paid by a bank deposit, matching the bank deposit to the open accounts receivable invoice.
3(b) If the B2B invoice is subsequently paid within Shopify, "paying" the open invoice by using same contra account that is nominated in the B2B settings page.
Example #1 - Syncing an Order when it is already Paid.
An order is created and fully paid by AfterPay is tagged in Shopify with the tag 'A2XB2B'.
The account selected in the B2B settings page is a contra asset account called A2X B2B.
Step | Shopify Event | A2X Posting | Dr Account | Cr Account |
1(a) | Order Created and Paid | AfterPay | AfterPay Clearing Account | Profit & Loss |
2(a) | Order is Tagged | B2B | A2X B2B | A2X B2B |
Bookkeeper | Bank Deposit Received | N/A | Bank | AfterPay Clearing Account |
Example #2 - Syncing an Unpaid Order, that is subsequently paid by Bank Deposit.
An unpaid order that is paid by a bank deposit (which is called Manual payment in Shopify) is tagged in Shopify with the tag 'A2XB2B'.
The account selected in the B2B settings page is a contra asset account called A2X B2B:
Step | Shopify Event | A2X Posting | Dr Account | Cr Account |
1(a) | Order Created, Unpaid | No_Gateway | Pending Payment | Profit & Loss |
2(a) | Order is Paid | No_Gateway | Manual Gateway | Pending Payment |
1(b) | Order is Tagged | B2B | Accounts Receivable | A2X B2B |
2(b) | Order is Paid | B2B | A2X B2B | Manual Gateway |
Bookkeeper | Bank Deposit Received | N/A | Bank | Accounts Receivable |
Example #3 - Syncing an Unpaid Order, that is subsequently paid by Shopify Payments
An unpaid order that is subsequently paid in Shopify using Shopify Payments is tagged in Shopify with the tag 'A2XB2B'.
The account selected in the B2B settings page is a contra asset account called A2X B2B:
Step | Shopify Event | A2X Posting | Dr Account | Cr Account |
1(a) | Order Created, Unpaid | No_Gateway | Pending Payment | Profit & Loss |
2(a) | Order is Paid | Shopify Payments | Accounts Receivable | Pending Payment |
1(b) | Order is Tagged | B2B | Accounts Receivable | A2X B2B |
2(b) | Order is Paid | B2B | A2X B2B | A2X B2B |
Bookkeeper | Shopify Pmts Bank Deposit Received | N/A | Bank | Accounts Receivable |
Bookkeeper | Manually "pays" the B2B Invoice from the Contra Account | N/A | A2X B2B | Accounts Receivable |
Example #4 - Syncing an Unpaid Order, that is subsequently paid by a Payment Gateway that is not Shopify Payments
An unpaid order that is subsequently paid in Shopify using PayPal is tagged in Shopify with the tag 'A2XB2B'.
The account selected in the B2B settings page is a contra asset account called A2X B2B:
Step | Shopify Event | A2X Posting | Dr Account | Cr Account |
1(a) | Order Created, Unpaid | No_Gateway | Pending Payment | Profit & Loss |
1(b) | Order is Paid | PayPal | PayPal Gateway Clearing Account | Pending Payment |
2(a) | Order is Tagged | B2B | Accounts Receivable | A2X B2B |
2(b) | Order is Paid | B2B | A2X B2B | A2X B2B |
Bookkeeper | PayPal Bank Deposit Received | N/A | PayPal Bank | PayPal Gateway Clearing Account |
Bookkeeper | Manually "pays" the B2B Invoice from the Contra Account | N/A | A2X B2B | Accounts Receivable |