Ecommerce Bookkeeper Sydney: Why Your Shopify Books Are Lying to You

Your store is doing $2.8M. Your P&L says you are turning a 64% gross margin. Your bank account, oddly, looks like a Coogee cafe at 4pm: empty, with a faint smell of regret. That gap is not a mystery. It is the single most common thing a Sydney ecommerce bookkeeper finds the moment they open the file, and it is almost always Barry booking the Shopify payout as revenue and calling it a day.

Published: June 2026

‍

What an ecommerce bookkeeper actually does (that yours probably isn't)

A normal bookkeeper reconciles a bank feed. Money in, money out, tick. That works fine for a law firm or a consultancy where the money that lands in the bank is the money you earned.

Ecommerce does not work like that. The money that lands in your bank from Shopify Payments, Stripe, PayPal or Afterpay is already chopped up before you ever see it. Fees are netted out. Refunds are netted out. Chargebacks are netted out. Multi-day payout timing means the deposit on Tuesday relates to sales from last Thursday, minus a fee you never recorded, plus a refund you forgot about.

An ecommerce bookkeeper reconciles the sale, the fee, the refund, the chargeback, the payout, and the timing gap between them, separately, so that your revenue is your actual revenue and your margin is your actual margin. Barry sees one number hit the bank and books it as sales. That is not bookkeeping. That is guessing with extra steps.

If your Xero file already smells like a messy Xero file in Sydney, this is usually patient zero.

‍

The five ways ecommerce books quietly break

1. The Shopify payout is not your revenue

This is the big one. When $11,400 lands from Shopify Payments, that is net of processing fees, partial refunds, and sometimes a reserve. Book it as $11,400 of sales and you have just understated revenue, hidden your fees, and made your GST wrong in one move.

Done properly, the gross sales go to revenue, the processing fees go to a cost-of-sales or bank-fees account, refunds reduce revenue, and the payout reconciles through a clearing account. Most Sydney stores we see have none of that. They have a bank feed and a vibe.

2. Payment fees are eating your margin and nobody booked them

Blend cards, Afterpay and PayPal and your processing fees usually land somewhere around 2 to 3 per cent of gross sales, before you add Afterpay's merchant fee on top, which is heavier again. On $2.8M of sales that is roughly $56,000 to $84,000 a year in fees, and a chunk more once buy-now-pay-later is in the mix.

If those fees are buried inside the net payout and never split out, your gross margin on paper is a fantasy. The headline 64% is really closer to 51% once fees, freight-out and returns land where they belong. You are making decisions, hiring, discounting, buying stock, off a margin that does not exist.

3. Cost of goods sold and stock on hand are never reconciled

Plenty of Sydney stores run COGS off "what we paid suppliers this month" rather than the cost of what actually sold. That means in a month you buy stock, your profit craters. In a month you sell down stock, your profit looks heroic. Neither is real.

A proper ecommerce bookkeeper ties COGS to units sold and keeps stock on hand on the balance sheet where it belongs. Get this wrong and your P&L swings like a Bondi backpacker's bank balance, and your tax position is wrong too.

4. Returns and chargebacks vanish into the void

Returns are not "negative sales we will sort out later". They reduce revenue and, if the stock comes back, they restore inventory. Chargebacks are worse: you lose the sale, you lose the goods, and you cop a fee. If these are not tracked, your returns rate is invisible, which means the product that is quietly killing you looks like a winner.

5. GST on imports and the multi-channel mess

If you import stock, GST on imports works differently to GST on your local costs, and there is an ATO deferred GST scheme that monthly lodgers may be eligible for. That is a conversation for a registered BAS Agent, not a guess. Add Amazon, eBay, a wholesale channel and a physical pop-up, and you have multiple revenue streams with different fee structures, all of which Barry will cheerfully dump into one "sales" line.

‍

Worked example: the $2.8M store that wasn't winning

A Sydney apparel store doing $2.8M a year through Shopify, Afterpay and a bit of wholesale. The dashboard said 64% gross margin and a healthy net profit. The owner could not work out why cash was always tight.

Here is what an ecommerce bookkeeper found:

• Gross sales booked net of fees, understating revenue and hiding roughly $71,000 of annual processing and BNPL fees.
• Freight-out (the cost of shipping orders) sitting in general expenses instead of cost of sales, flattering the gross margin by several points.
• COGS run on supplier payments, not units sold, so three months looked amazing and three months looked terrible for no real reason.
• A 14% returns rate that nobody could see, concentrated in two product lines that were actually loss-making once returns and freight were counted.

Rebuilt properly, the real gross margin was 51%, not 64. The business was still viable, but two hero products were quietly funding two dogs, and the discounting strategy was set off a margin number that was 13 points too high. None of that is visible when the books are a single net payout line.

The fix is not heroic. It is a clearing-account structure, fee mapping, COGS tied to sales, and a returns process. Boring, in the best way.

‍

What this should cost (and what the cowboy charges)

A real ecommerce bookkeeper works on a fixed monthly retainer that covers the reconciliation properly: payouts, fees, refunds, chargebacks, COGS, inventory and your BAS lodgement in Sydney. You know the number before the month starts. The Packs (BAS Slayer, Payroll Party, The Lot) bundle it so there are no surprise invoices.

The alternative is the $80-to-$150-an-hour operator who quotes nothing, ghosts you between quarters, and then bills you to fix the mess they made of your Shopify file. If you are not sure which one you have, our piece on the cost of a Sydney bookkeeper lays out what fair looks like.

‍

How to switch without losing your mind

Switching an ecommerce file mid-year sounds scary and is not. You give the new bookkeeper Shopify, Stripe, PayPal, Afterpay and Xero access, the last 12 months of payouts, and your supplier invoices. They rebuild the clearing structure, restate the fee and COGS history, and clean the inventory position. Our how to change your Sydney bookkeeper guide walks the mechanics. If you are a maker or warehouse-based store, the Marrickville bookkeeper page covers the local crowd we work with most.

‍

FAQ

What does an ecommerce bookkeeper do differently to a normal bookkeeper?

‍They reconcile the things a bank-feed-only bookkeeper never sees: payment processing fees, refunds, chargebacks, payout timing, COGS tied to units sold, and inventory on the balance sheet. The result is revenue and margin you can actually trust, rather than a single net payout line treated as sales.

Why does my Shopify store show a profit but I have no cash?

‍Usually because revenue is booked net of fees, COGS is run on supplier payments rather than what sold, and inventory is not carried properly. Your profit on paper includes stock you have already paid for and excludes fees you have already lost. The cash tells the truth; the P&L is mis-built.

How much should a Sydney bookkeeper cost for a $2M to $3M ecommerce business?

‍Expect a fixed monthly retainer rather than hourly billing. The right number depends on order volume, the number of sales channels, and how much inventory and reporting work is involved. The key test is that it is fixed and scoped, not an open meter.

Can you fix a Shopify file that is already a mess?

‍Yes. The standard job is rebuilding the clearing-account structure, mapping fees correctly, restating COGS, and cleaning inventory. Most files can be brought back to accurate within a few weeks, with the current quarter clean and the prior periods restated.

Do I need to worry about GST on imported stock?

‍Yes, and it is handled differently to GST on local purchases. There is an ATO deferred GST scheme that some monthly lodgers can use. The treatment depends on your setup, so it is a question for a registered BAS Agent rather than something to guess at.

What about Amazon, eBay and wholesale on top of Shopify?

‍Each channel has its own fee structure and payout logic, so each needs its own reconciliation path. Lumping them into one sales line is how margin by channel becomes invisible. A proper setup shows you which channel actually makes money.

Should returns and chargebacks change how I read my numbers?

‍Completely. A high returns rate on a specific product can turn a apparent winner into a loss-maker once freight and restocking are counted. If returns are not tracked, you cannot see it, and you keep promoting the thing that is bleeding you.

‍

About Sydney Bookkeeper

Sydney Bookkeeper is the modern, fixed-price Sydney bookkeeper for businesses with staff that are tired of slow, hourly, jargon-spouting incumbents. We work with professional services firms, construction and property businesses, agencies, tech and ecommerce companies, hospitality groups, and health practices across Sydney. Monthly bookkeeping, BAS lodgement, payroll, and Xero file cleanups, all on fixed monthly pricing, no lock-in.

‍

The team uses a registered BAS Agent for all BAS and IAS lodgement services. Full registration details, agent particulars, and copies of the Tax Practitioners Board (TPB) Code of Professional Conduct, the TPB complaints process, and any conditions on the agent's registration are available on request by emailing the team. This content is general information only, written for Australian small and mid-market businesses. It does not constitute tax, financial product, or legal advice and should not be relied on as such. Tax obligations depend on your individual circumstances. For advice specific to your business, contact the team directly or consult a registered tax agent or licensed financial adviser. Sydney Bookkeeper is not a licensed tax agent or licensed financial adviser. Information was current at the time of publication and may change without notice. We review and update guides periodically.

‍

Sources

• Australian Taxation Office, GST and imported goods (including the deferred GST scheme): https://www.ato.gov.au/businesses-and-organisations/gst-excise-and-indirect-taxes/gst/in-detail/rules-for-specific-transactions/international-transactions/gst-and-imported-goods
• Australian Taxation Office, GST for business: https://www.ato.gov.au/businesses-and-organisations/gst-excise-and-indirect-taxes/gst
• Australian Taxation Office, business activity statements: https://www.ato.gov.au/businesses-and-organisations/preparing-lodging-and-paying/business-activity-statements-bas

‍