In some cases, you might have to reconcile your Shopify sales information with your bank feed in Xero.
Shopify creates an authorized invoice for each Shopify order and then applies a payment to the invoice. How you reconcile in Xero depends on how you've mapped your Payment account in Xero Sync's settings.
There are two recommended approaches:
- Map the payment account to a bank account where your funds are deposited
- Map to a clearing account (which is typically a current asset account with payments enabled)
Please see each option below.
Option 1: map your payment account to a bank account in Xero
Before you begin your reconciliation, it is important to make sure that Xero Sync is configured for this approach.
These instructions assume you are using Shopify Payments to process credit card transactions and you've already mapped your payment account to the bank account where your credit card batch deposit is made.
Export Shopify Payments fees and adjustments
Within the Xero Sync Settings page under Payout settings, select Export your payout fees and adjustments from Shopify Payments.
You can then choose a Payout fees and adjustments account.
Export all orders to a single contact
Within the Xero Sync Settings page under Customer export settings, select Do not export customers to Xero.
When paid orders are exported over via Xero Sync, fees and adjustments for any Shopify Payments payouts contained in the export date range are sent to the account you selected. There is one entry per payout for both fees and adjustments.
If you select a bank account as the payment account, fees and adjustments appear as Spend Money transactions on the account.
How to reconcile with your bank feed
Many of your customers pay using a credit card. One challenge with reconciliation, in this case, is that funds arrive as batch deposits which involve multiple Shopify orders.
To reconcile this information, you need to match your deposits with the appropriate invoices.
From your Xero dashboard, select Accounts, then select the Reconcile to start account reconciliation.
On the right side of the Reconcile screen, select Match, then select Find and Match.
Search by Name using the keyword Shopify to find all invoices created by Shopify.
Once you find all Shopify invoices, select all invoices for that day; the totals should match, and select OK to reconcile.
Option 2: map your payment account to a clearing account in Xero
Before you begin reconciliation, make sure Xero Sync is configured for this approach. These instructions assume that you've already mapped your payment account to a clearing account.
How to reconcile with your bank feed
Think of a clearing account as a running total of sales that increases and decreases over time. An invoice paid from a clearing account increases the total of the clearing account while reconciling a deposit decreases the total of the clearing account. The clearing account is a rolling amount due to delays in credit card processing, but in the end, when all orders are done, and all deposits are made, the clearing account reaches zero.
To reconcile this information, you need to match your deposits with the appropriate invoices. Create a receive money transaction and assign it to the clearing account.