Are you ready to streamline your ecommerce finances? This guide is designed for A2X users who want to efficiently post their settlements or payouts to their accounting software. Whether you're using QuickBooks Online, Xero, or Sage, you'll find simple steps to ensure your financial data is accurately recorded and reconciled.
Step-by-Step Instructions:
Preparation: Before you start, ensure that your ecommerce channel, accounting software are connected, and that you have mapped your accounts and taxes appropriately.
Accessing Settlements: Settlements from your sales channels are displayed in your A2X account. To find them, navigate to the Home or Settlements tab.
Posting the Payout: To post your first payout, simply click 'Post to....' on the Settlements tab.
Alternatively, if you prefer to review the settlement details before posting, click on the Settlement date. This allows you to check the invoice details, accounts, and tax rates before sending them to your accounting system.
Click on the down arrow to show invoice details
Review your accounts and tax rates and then send them to your accounting:
Finding and Reconciling the Entry in Different Accounting Systems:
QuickBooks Online
Locate the A2X Entry: One of the easiest ways to find the journal straight after posting it is
to click the magnifying glass at the top right of the page in QuickBooks Online, and display a drop-down showing your recent transactions:
To reconcile the journal entry to the deposit in your bank account, simply click on the 'match'.
Click HERE for more details and step-by-step instructions.
Xero
Locate the A2X Entry: In Xero, the transaction appears as a Draft Invoice, or a Draft Bill if it's negative. Approve this to proceed."
To reconcile: During the bank feed reconciliation, Xero will suggest a match to the approved invoice. Confirm by clicking 'OK'.
Click HERE for more details and step-by-step instructions
Sage
Locate the A2X Entry: In Sage, the settlement appears as a Sales Invoice (or a Purchase Invoice if the settlement total is negative). You can find it by clicking Sales, then selecting Sales Invoices from the drop-down.
To reconcile: Go to the Banking tab and click on Imported Transactions to find the deposit from your sales channel. Click Match to reconcile the deposit to the Sales Invoice A2X created.
Click HERE for more details and step-by-step instructions.
If your settlements are in a currency other than GBP, reconciliation works a little differently — see How do I reconcile Sage Sales Invoices when my settlements are not GBP for that walkthrough.
Do you need help with your A2X set-up?
Are you having difficulty setting up your Accounts and Taxes, and you would like some help from an accountant or bookkeeper? We have a directory full of expert accounting/bookkeeping partners around the world who are ready to assist with your e-commerce accounting and A2X.
Please click HERE to find an expert