
Bank Feeds
Part of Accounting integrations
Connecting Shopify ecommerce settlements to bookkeeping
Reconcile ecommerce payments, refunds, fees and payouts without treating a net bank deposit as the whole sales record.
undefined
Connect Shopify ecommerce settlements to Xero by recording gross sales, refunds, provider fees and the net payout, then matching each payout to the bank deposit. A payout is a net figure; posting it as sales income alone hides the movements behind it. Shopify and Xero can be linked through an ecommerce accounting app such as A2X, a data-syncing app or manual entry (A2X).
Separate Shopify orders from settlement payouts
For a Shopify store using Shopify Payments and Xero, start with Shopify sales and payout data for the same period. Choose whether the accounts will receive a summarised entry or individual orders, and check whether an order can be paid in parts. A2X summarises transaction data, while data-syncing apps can send individual orders for manual categorisation (A2X).
Keep a reference linking each payment, refund and payout. Shopify order data records sales activity, while payout data explains the net amount paid out, so use each for its own check. Decide which source establishes the sale and which confirms the settlement.
In Xero, set up Shopify Payments as a clearing account, not a bank account, to track funds between customer payment and payout. A2X fetches each Shopify Payments payout and creates a summarised journal in Xero. Reconcile the clearing account against that journal and the bank deposit (Outback Accounting).
A2X’s Xero journal separates gross sales, fees, refunds, shipping revenue, GST collected and other line items into their own accounts; the payout it represents is net. Match the net deposit against the journal rather than recording the payout as another sale (Outback Accounting).
Build a traceable Shopify-to-Xero bookkeeping import
For Shopify and Xero, choose an ecommerce accounting automation app such as A2X, a data-syncing app or manual entry. A2X summarises Shopify transaction data and passes it to Xero as invoices, while data-syncing apps send individual orders for manual categorisation (A2X). Keep the source order and payout detail with any summary so entries can be checked.
Map Shopify refunds separately from provider fees. A refund adjusts a customer transaction, while a fee is a cost charged by the provider. Keep the original sale and refund references together; A2X can identify Shopify transaction types such as sales, refunds and shipping fees (A2X).
Have an accountant or bookkeeper review the GST mapping for the business’s actual sales and fees before posting. A2X recommends that an accountant or bookkeeper review its tax mapping (A2X).
Connect Xero’s bank feed for the account receiving Shopify Payments deposits, then match each payout to its bank deposit using the reference and amount. Outback Accounting says the corresponding deposit appears in Xero’s bank feed a day or two later.
Check Shopify settlements before automating
Test an ordinary Shopify payment, partial refund, fee, delayed deposit and retry of the same export. Confirm each source transaction appears once, the Xero clearing account explains unpaid amounts, and the bank deposit matches without creating new income.
Give a named owner responsibility for unmatched payouts and ageing balances. Continue these checks after launch, especially when the Shopify store adds a payment method or changes its refund workflow.
business.gov.au lists records of income and sales transactions, business expenses, bank records and GST records if registered among the records a business needs to keep. It says the ATO recommends digital record-keeping if possible. Keep Shopify source reports and supporting transactions with the accounting records, including when Xero receives a summary entry.
Further reading: Connecting an app: How does it work? (apps.xero.com).



