An online sale can look straightforward until the payout arrives. Your store may show $5,000 in sales, but the amount that lands in your bank account is lower after payment fees, refunds, chargebacks, shipping adjustments and timing differences. This guide to e-commerce payment reconciliation explains how to make sense of those moving parts, so your records reflect what actually happened in your business.
For Australian e-commerce owners, getting this process right means more than keeping Xero or MYOB tidy. It gives you a clearer view of cash flow, protects the accuracy of your GST reporting and helps you spot missing income or unexpected fees before they become expensive problems.
What e-commerce payment reconciliation really means
Payment reconciliation is the process of matching information from several places: your online store, payment gateway, bank account and accounting software. The goal is to confirm that every customer payment, refund, fee and payout has been recorded correctly.
Unlike a service business that sends an invoice and receives one bank deposit, an online store often collects payments through Shopify Payments, PayPal, Stripe, Square, Afterpay, Zip or a marketplace. These providers usually batch transactions together and deposit the net amount into your bank account. That net deposit rarely matches a single day’s sales total.
A proper reconciliation separates the gross sale from the payment processing fee, then accounts for any refunds, disputes or reserve amounts. It also identifies the date the customer paid, the date the provider processed the transaction and the date the cash reached your bank. Those dates may fall in different reporting periods, particularly around month-end.
Why payment reconciliation matters for online stores
Small differences can add up quickly when you process dozens or hundreds of orders each week. A $2 fee missed here and a refund missed there may not feel urgent, but over a financial year those gaps can distort your margins and make your profit reports unreliable.
Accurate reconciliations also make it easier to answer practical questions: Which payment method costs the most? Are refund levels rising? Has a payment provider withheld funds? Does the cash in the bank support the sales reported by the store?
For businesses registered for GST, the detail matters even more. Sales, refunds and fees need to be coded correctly so your BAS information is based on complete records. The treatment can vary depending on the transaction and provider documentation, so it is worth having a consistent process rather than trying to reconstruct it at BAS time.
Set up a payment-clearing account first
The cleanest way to reconcile e-commerce payments is to use a clearing account in your accounting software for each major payment provider. Think of it as a temporary holding account between the customer checkout and your business bank account.
When a customer pays $110 through an online gateway, record the full $110 sale against that provider’s clearing account. If the provider charges a $2.20 fee and pays $107.80 into your bank, record the fee separately and transfer or match the $107.80 from the clearing account to the bank feed. The clearing account should return to zero once every transaction in that payout has been dealt with, apart from genuine timing differences.
This approach avoids a common mistake: coding the bank deposit directly to sales. If you do that, your sales are understated because the deposit is net of fees. You also lose visibility over how much payment processing is costing the business.
If you use several providers, keep their clearing accounts separate. Combining Stripe, PayPal, Afterpay and marketplace payouts in one account makes discrepancies harder to trace. Separate accounts provide a clearer audit trail and more useful reporting.
A practical e-commerce payment reconciliation process
The best frequency depends on your order volume. A business with daily sales and regular refunds may reconcile payment providers weekly or even daily. A smaller store may manage with a weekly review and a detailed month-end reconciliation. Waiting until the end of the quarter is risky because issues become harder to investigate when customer emails, provider reports and order records are months old.
1. Gather the source records
Start with reports for the same reconciliation period from your e-commerce platform and each payment provider. You will generally need sales reports, payout reports, transaction reports, refund reports and dispute or chargeback reports.
Do not rely on the payout summary alone. A summary tells you how much was paid out, but the detailed transaction report explains why. Keep these records organised by provider and period so they are available if you need to investigate a variance later.
2. Match gross sales to payment transactions
Compare completed orders in your store with successful payments in the gateway report. Check order numbers, customer names where appropriate, transaction references and amounts. Cancelled orders, failed payments and test transactions should not be treated as income.
Be careful with gift cards, store credits and discount codes. A gift card purchase may create a liability when the card is sold, while its later redemption is not a new cash sale. The correct treatment depends on how your store and accounting system have been set up.
3. Record fees, refunds and other deductions separately
Payment processing fees should be recorded as an expense, not netted against sales. Refunds should reduce sales or be recorded to a dedicated sales returns account, depending on your chart of accounts and reporting preference.
Also look for chargeback fees, foreign currency conversion charges, subscription fees, payout reserves and adjustments. These are easy to overlook because they may appear as a deduction without a matching customer order.
A useful check is to account for every component of the payout:
- gross customer payments
- less refunds and disputes
- less provider fees and other deductions
- equals the net payout received in your bank account
If the numbers do not agree, do not force a match. Leave the transaction unreconciled and investigate the difference. It may be a payment still pending, a refund processed after the reporting period, a duplicated entry or an integration issue.
4. Match net payouts to the bank feed
Once the clearing account reflects the individual transactions, match each provider payout to the corresponding bank deposit. Payout timing varies. Some providers settle in one or two business days, while others hold funds longer for new accounts, weekends, public holidays or risk reviews.
A payment received on 30 June may not arrive in your bank until July. That is not automatically an error. It is a timing difference that should remain in the clearing account until the payout is received. Keeping this distinction clear supports accurate month-end reporting.
5. Review the clearing account balance
At the end of the process, review every remaining balance in each clearing account. A small amount may be reasonable if it relates to recent sales awaiting payout. Old or unexplained items need attention.
As a rule, any item that has been sitting for more than a few payout cycles should be investigated. It could indicate a failed integration, a refund not recorded in the accounts, a withheld balance or a transaction posted to the wrong account.
Common problems that cause reconciliation headaches
The most frequent issue is recording net bank deposits as sales. This makes turnover look lower and hides payment fees. Another is allowing an app integration to post sales twice, once through the store integration and again through a bank rule.
Refunds are another pressure point. A customer may receive a refund this month for an order placed last month, and the payment provider may deduct it from a later payout. Without a clearing account, it can be difficult to see which sale the deduction relates to.
Marketplace sales need additional care. Amazon, eBay and similar platforms may deduct commissions, advertising costs, fulfilment charges, shipping labels and taxes before paying you. The payout can be correct while the accounting entry is incomplete. Detailed settlement reports are essential.
Currency conversion creates a separate layer of complexity for stores selling internationally. The amount paid by the customer, the amount converted by the provider and the Australian dollar amount received may differ. Your bookkeeping process needs to capture those differences consistently.
Use automation, but keep human checks in place
The right integrations can reduce manual data entry considerably. A well-configured connection between your store, payment providers and Xero or MYOB can bring through sales, fees, taxes and payouts in a structured way.
Automation is only helpful when the mapping is correct. Before relying on it, test a normal sale, a discounted sale, a refund, a partial refund and a payout with fees. Review where each transaction lands in your accounts and whether GST is being handled as intended.
Then keep a monthly human review. Software can match data quickly, but it cannot always recognise a duplicated feed entry, a missing marketplace adjustment or a pattern of rising chargebacks that needs a business response.
Turn reconciliations into better decisions
Once payment data is reliable, it becomes useful beyond compliance. You can compare payment fees by provider, assess the cost of buy-now-pay-later options and monitor refund rates by product range. These insights can inform pricing, promotions, checkout options and stock decisions.
For example, a low-margin product may look profitable until payment fees, shipping subsidies and refunds are included. Reconciliation gives you the detail needed to see the real result, not just the sales headline.
If payment reconciliation is taking up your evenings, an outsourced bookkeeper can build the workflow, check the integrations and keep the process current as your store grows. GoBookaroo helps Western Sydney businesses organise the financial administration behind online sales, so the numbers are ready when you need to make a decision.
A regular reconciliation routine gives you something every growing online business needs: confidence that the sales on screen, the cash in the bank and the figures in your accounts are telling the same story.