Direct answer: An ecommerce integration should capture orders, GST, shipping, discounts, refunds, gift cards, marketplace fees and payment settlements in a way that reconciles store reports to the bank and general ledger. Define channels and tax treatment first, then test full, partial and refunded orders.
This guide provides general information for Australian small businesses, with practical context for Epping, Melbourne and Victoria. It is not personal tax, legal or employment advice.
Which ecommerce records need a source of truth?
Identify which system owns products, orders, customers, tax settings, refunds and inventory. Avoid letting two apps update the same field without clear precedence and change controls.
How should marketplaces and payment gateways be handled?
Record gross sales separately from fees, refunds, chargebacks and reserves. Reconcile each gateway settlement to the orders it contains and use clearing accounts for timing differences.
What should be tested before launch?
Test domestic and relevant overseas sales, shipping, discounts, gift cards, partial refunds, cancellations, fees and multi-currency if used. Compare GST and revenue reports across the store, gateway and accounting file.
Practical checklist
- Map each store and payment gateway
- Document tax and currency settings
- Separate gross sales, fees and refunds
- Test full and partial refunds
- Monitor sync failures and duplicates
- Reconcile orders, settlements and ledger
Hypothetical example
Hypothetical example: A hypothetical Victorian online retailer tests a partial refund and finds the connector reverses revenue but not GST. The mapping is corrected before launch.
Where can you get related help?
Read the live parent guide, review our Accounting System Management service information, or visit the TNS Accounting homepage. Confirm scope and suitability for your circumstances.
Frequently asked questions
Does a Shopify or marketplace payout equal sales revenue?
Not necessarily. Payouts may be net of fees, refunds, chargebacks and timing differences.
Should every order create a separate accounting invoice?
Choose detail or summarisation based on reporting, performance and reconciliation needs, while retaining accessible source records.
Official sources
Published by TNS Accounting. Official sources checked 16 November 2026. Rules, rates and software features can change; check the linked sources before acting.





