Bookkeeping for Ecommerce Clients
Your online client’s payout is not its sales total. Reconcile orders, refunds, payment fees, tax and currencies before matching the balance to the bank.
- Published
- Updated
Ecommerce bookkeeping connects orders and refunds to payment settlements, stock records and bank receipts. Record the sale once, then explain every deduction and balance between the customer’s payment and the bank deposit.
A payout can include several days of collections, less fees and refunds from earlier orders. Reconcile each payment account separately so a delayed payout does not become missing revenue or a second sale.
Set the Client’s Sales Sources
Identify the legal seller for every store and marketplace before connecting an account or importing a file. Confirm the entity’s GST status, reporting basis and accounting period with the accountant responsible for the client.
Create a source register with one row for each store, marketplace and payment account. Record the seller entity, account reference, transaction currency, payout currency and destination bank account. Include each report’s time zone and reporting cutoff.
For a client using Shopify Payments, obtain both sales records and payout transaction exports. The payout details include fees and settlement adjustments. Payment accounts outside Shopify Payments need their own reports and reconciliation.
Collect opening balances for pending funds, reserves and payouts already sent but not received. Agree them to the previous bookkeeping file. Keep marketplace amounts owed to the seller separate from cash already in a bank account.
List every route that currently creates accounting entries. A store connector, a marketplace summary and a manual order import can cover the same sale. Decide which source records revenue and which reports only support reconciliation.
Before enabling an import, retain the original export and record its period. Check the first and last transaction references against existing entries. Confirm whether the connector creates individual invoices, daily summaries or settlement journals.
From Orders to Bank Receipts
Reconcile gross orders to customer collections, then reconcile the payment account to the payout. Discounts change the amount charged. Fees and retained reserves explain why the seller receives less cash than customers paid.
- Match order totals to completed payments. Separate cancelled orders, unpaid orders and partial payments before comparing sales with collections.
- Reconcile discounts and refunds to their original orders. Establish whether the source report already subtracts them before posting another adjustment.
- Match payment transactions to settlement deductions. Identify fees, chargebacks, reserves and other adjustments from their transaction references.
- Agree the payout to its bank receipt. Retain an outstanding payout in the reconciliation until it arrives or its failure is resolved.
- Reconcile the closing platform balance to pending collections and held funds. Trace each component to the supporting report.
Fictional Settlement Report
This invented example uses one payment account, one currency and a zero opening balance. Order amounts include any customer tax and shipping already charged. GST coding is a separate review and does not add another amount to these totals.
| Settlement component | Amount | Explanation |
|---|---|---|
| Gross order charges before discounts | $22,000 | Starting order total |
| Discounts | -$1,100 | Reduces customer charges to $20,900 |
| Refunds paid | -$2,200 | Net collections are $18,700 |
| Processing fees withheld | -$550 | Expense supported by transaction and fee records |
| Funds retained in reserve | -$1,000 | Still held by the payment provider |
| Other pending funds | -$1,500 | Not included in this payout |
| Payout sent | $15,650 | Amount to match to the bank |
The payout is $18,700 less $550 in fees, $1,000 in reserve and $1,500 pending. The closing platform balance is $2,500. Its reserve and pending components explain why that money remains outside the bank.
Recording the $15,650 deposit as sales would lose the relationship with customer collections and settlement deductions. Record the sales and their tax components from the approved source. Match the bank receipt against the payout clearing entry.
Shopify’s Payments activity report shows opening and closing balances for a selected period and payout currency. Shopify distinguishes that balance activity from accounting revenue. Its report also excludes third-party payment processors and has a three-day data delay.
Detect Duplicate Revenue
Compare imported entries by order reference, store, amount and transaction type. Repeated references within the same source period require investigation. Order numbers can repeat between different stores, so include the store identifier in the check.
A summary journal can duplicate revenue without repeating an order number. Reconcile its sales total and covered period to the individual invoices already recorded. Check whether the connector’s journal records sales or only clears payments against existing invoices.
For example, importing $20,900 of discounted orders and then posting another $20,900 sales summary counts the same orders twice. Keep the authorised revenue source and resolve the duplicate entries through a documented correction.
A bank rule can create the same error by coding payouts to sales after the connector has recorded the orders. Compare sales totals before and after the import, and review the payout’s matching entry before accepting it.
Tax, Currency and Stock Review
Give the accountant transaction evidence that explains the sale, its location and its tax treatment. A platform’s tax label is an input to the review. It does not establish the client’s Australian GST treatment.
For domestic sales, retain the order, invoice, refund record and product category. Separate customer GST from revenue under the approved coding. Record shipping charges and discounts so the accountant can assess their treatment with the underlying sale.
For overseas orders, retain the delivery destination, dispatch evidence and export records. The ATO’s exports guidance explains GST-free export treatment. An overseas customer address alone does not prove that the applicable export conditions are met.
Identify who sells the goods and which party collects or remits a marketplace tax. Keep foreign taxes distinct from Australian GST. Send uncertain marketplace or overseas arrangements to the accountant with the relevant terms and transaction records.
For GST on Shopify fees, retain the actual invoice and supplier details for each charge. Distinguish subscription invoices from processing fees withheld from payouts. The accountant assesses any GST credit using the supporting document and the client’s circumstances.
Keep the customer’s payment currency separate from the settlement currency. Retain the original amount, conversion details, fees and bank receipt. Record the exchange-rate source and conversion method the accountant approves for the relevant tax and accounting purpose.
Do not force a currency difference into sales or merchant fees to balance the account. Reconcile each original-currency balance first. Then identify conversion charges and exchange differences in the accounting records.
Reconcile stock quantities by product and location. Start with opening stock, add purchases and saleable returns, then subtract units sold and approved write-offs. Compare the result with physical stock or warehouse records.
Include stock held by fulfilment providers and goods moving between locations. A returned order does not prove the item is saleable or back on hand. Keep purchase costs, freight and damaged-stock evidence for valuation review.
The ATO’s stock-record requirements support the year-end review. Give the accountant quantity and valuation records, with the reason for each adjustment and any proposed trading-stock concession.
Resolve the Settlement Exceptions
Assign every unexplained balance to a person and a documented next action. Keep the original report and transaction reference beside the amount. A temporary clearing entry must remain visible until the difference is resolved.
| Exception | Diagnostic check | Owner and next action |
|---|---|---|
| Payout missing from the bank | Compare payout status, destination account and bank reference | Client obtains the bank or provider trace and records the outcome |
| Chargeback reduces a settlement | Match the dispute to its original order and any later reversal | Client confirms dispute status and supplies evidence for accounting review |
| Platform balance is negative | Reconcile refunds, fees and disputes against collections | Bookkeeper identifies the cause and matches any recovery from later payouts or bank debits |
| Inventory does not reconcile | Compare returns, warehouse transfers and stock counts | Client resolves quantity differences before the accountant approves valuation entries |
For Shopify Payments, the lower or missing payouts guidance helps distinguish settlement deductions from missing cash. Supply the payout reference when requesting a trace. Keep any provider case reference with the reconciliation.
Close the period when revenue agrees to the chosen sales source and each payment-account balance has supporting detail. Match payouts to bank receipts or named exceptions. Hand the accountant the tax decisions, stock differences and unresolved balances that still need review.
One client form. One finished return.
Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.
Made for Australian accounting firms