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.

  1. Match order totals to completed payments. Separate cancelled orders, unpaid orders and partial payments before comparing sales with collections.
  2. Reconcile discounts and refunds to their original orders. Establish whether the source report already subtracts them before posting another adjustment.
  3. Match payment transactions to settlement deductions. Identify fees, chargebacks, reserves and other adjustments from their transaction references.
  4. Agree the payout to its bank receipt. Retain an outstanding payout in the reconciliation until it arrives or its failure is resolved.
  5. 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 componentAmountExplanation
Gross order charges before discounts$22,000Starting order total
Discounts-$1,100Reduces customer charges to $20,900
Refunds paid-$2,200Net collections are $18,700
Processing fees withheld-$550Expense supported by transaction and fee records
Funds retained in reserve-$1,000Still held by the payment provider
Other pending funds-$1,500Not included in this payout
Payout sent$15,650Amount 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.

ExceptionDiagnostic checkOwner and next action
Payout missing from the bankCompare payout status, destination account and bank referenceClient obtains the bank or provider trace and records the outcome
Chargeback reduces a settlementMatch the dispute to its original order and any later reversalClient confirms dispute status and supplies evidence for accounting review
Platform balance is negativeReconcile refunds, fees and disputes against collectionsBookkeeper identifies the cause and matches any recovery from later payouts or bank debits
Inventory does not reconcileCompare returns, warehouse transfers and stock countsClient 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.

See how Tax Genie works

Made for Australian accounting firms

Tax GenieSee how Tax Genie works