Shopify Bookkeeper Sydney: Your Store Sold $38,500 Last Week. The Books Say $36,157.

Your Shopify dashboard says one number. Your bank says another. Your Xero file, lovingly maintained by Boring Barry, has picked the bank's number, called it "sales" and moved on with its life. The gap between those two figures is where your fees, your refunds and a slice of your GST have gone to hide. A Shopify bookkeeper in Sydney closes that gap every week.

Published: November 2026

What does a Shopify bookkeeper actually do?

Everything a normal Sydney bookkeeper does, plus the part that is specific to selling through a store that pays you in lumps:

• Records orders at their full value, before fees and refunds
• Matches every payout from Shopify Payments, PayPal and buy now pay later providers back to the orders it settles
• Puts merchant fees, refunds and chargebacks on their own lines
• Codes GST by where the order shipped
• Treats gift cards and store credit as money owed to customers until they are used

That work sits inside our monthly bookkeeping in Sydney, reconciled weekly. This page covers the Shopify side. Stock, landed cost and third-party warehouse bills are covered on our ecommerce bookkeeper Sydney page.

Why the payout never matches the sales report

Shopify Payments does not deposit your sales. It deposits your sales for a batch of days, less its processing fees, less any refunds and chargebacks, and it does it on its own schedule. PayPal does its own version. Afterpay and similar providers do another. Three channels, three payout rhythms, three sets of fees.

A bookkeeper who codes each deposit to "Sales" gets three things wrong at once: revenue is understated, fees are invisible and refunds never appear. Barry calls this "keeping it simple". He also sends your P&L by post with a compliments slip.

Worked example: one week, one payout, $2,343 missing

Illustrative figures only. All sales are to Australian customers and include GST.

• Orders for the week: $38,500
• Refunds: $1,650
• Payment processing fees: $693
• Payout to the bank: $38,500 − $1,650 − $693 = $36,157

What should be in the books:

• Sales after refunds: $38,500 − $1,650 = $36,850
• GST on those sales: $36,850 ÷ 11 = $3,350
• Processing fees as an expense: $693

What ends up in the books when the payout is coded to sales:

• Sales: $36,157
• GST on sales: $36,157 ÷ 11 = $3,287
• Processing fees: nil

That is $63 of GST on sales under-reported for the week and $693 of fees that never show as a cost. Repeat it for 52 weeks and the file is short $3,276 of GST on sales and has hidden $36,036 of fees inside a lower sales figure. Nobody set out to get the BAS wrong. It just happens one deposit at a time.

The fix: a clearing account per channel

The method is not complicated, it just has to be done every time.

1. Each sales channel gets its own clearing account in Xero.
2. Orders are posted at gross value, with GST, as a daily or per-payout summary.
3. Fees, refunds and chargebacks are posted to their own accounts.
4. Each payout that hits the bank is matched against the clearing account.
5. The clearing account should fall back to zero once every payout has landed. If it doesn't, something is missing and it gets chased that week.

A payout connector can automate most of the posting. It still needs a person to check the clearing balances, because connectors happily post nonsense when a setting is wrong. If the backlog is already ugly, our scale for unreconciled transactions in Xero tells you how worried to be.

Refunds, chargebacks and gift cards

Refunds reduce sales in the period they happen and reverse the GST on the original order. They should be visible as their own number, because a rising refund rate is a product or fulfilment problem you want to see early.

Chargebacks are refunds you didn't choose, with a fee attached. Coded properly, you can see how many you had and what they cost. Coded Barry's way, they are a small unexplained dip in a deposit.

Gift cards and store credit are the ones most files get wrong. When a customer buys a $200 gift card, you have not made a sale. You are holding $200 that you owe back in goods. It belongs on the balance sheet until it is redeemed, then it becomes revenue. The GST timing on vouchers has its own rules, so ask your registered tax agent how they apply to the cards you sell.

GST on overseas orders

Plenty of Sydney Shopify stores ship to New Zealand, the US or the UK without thinking about it. The GST treatment is different from a domestic order.

Rule: The ATO's guidance on exports and GST says exports of goods from Australia are generally GST-free, provided the export conditions are met. The same page notes that those overseas sales still count towards your GST turnover.

Bookkeeper's job: post orders with the right tax code based on the shipping destination, so domestic orders carry GST and export orders are reported as GST-free. Whether a particular sale meets the export conditions is a question for your registered tax agent. Clean coding all quarter means the BAS is a check, not a rescue.

One more: app and platform subscriptions. Claim GST only where the supplier's tax invoice shows GST. Many don't.

What the monthly numbers should show

A Shopify store that is reconciled properly gets a monthly report with:

• Gross sales, refunds and net sales by channel
• Merchant fees by channel, as a dollar figure and as a share of sales
• GST-free export sales separated from domestic sales
• Gift card and store credit balance outstanding
• Cost of goods sold and gross margin
• Money owed to suppliers and what is due this month

The last line matters more than founders expect. Stock has to be paid for before it sells, and a store can be growing and short of cash in the same month. Our bookkeeper to manage supplier payments service keeps supplier bills scheduled against what is actually in the bank.

Staff, packers and Payday Super

Once a store has a warehouse team or customer service staff, payroll joins the list. The ATO's Payday Super rules started on 1 July 2026: super guarantee contributions must be received by each employee's fund within 7 business days after payday, with a longer period in limited cases such as new employees. The ATO's super guarantee rate table shows the rate at 12% for 2026-27. Casual packers paid weekly means super paid weekly. That gets built into the pay run, not left for the end of the quarter.

Where Sydney Shopify stores go wrong

Most of the product brands we see operate out of the same handful of suburbs. Alexandria and Rosebery are full of them, with racking to the ceiling and a Xero file that has never met the Shopify admin. The usual list:

• Payouts coded straight to sales
• Refunds not recorded at all
• PayPal and buy now pay later balances never reconciled
• Gift cards booked as sales on the day they are sold
• Export orders carrying GST, or domestic orders missing it
• Receipts for stock and freight sitting in an inbox instead of the file

If the last one is you, our comparison of Dext vs Hubdoc covers how to get paperwork into Xero without typing it.

If more than two of those sound familiar, the file probably needs a one-off tidy before it can be kept current. That is what our catch up on overdue books service is for. A Free Xero Roast will tell you which side of the line you are on, in plain English, on one page.

FAQ

Why doesn't my Shopify payout match my Shopify sales report?

The payout is your sales for a batch of days, less processing fees, refunds and chargebacks. The sales report shows orders before those deductions. A clearing account that records orders at full value and matches each payout explains the difference line by line.

How should Shopify sales be recorded in Xero?

As a summary of orders at gross value with the correct GST, posted to a clearing account, with fees and refunds posted separately. Each bank deposit from Shopify is then matched against that clearing account, not coded as new sales.

Do I need a separate clearing account for PayPal and Afterpay?

Yes. Each provider pays on its own schedule with its own fees. One clearing account per channel makes it obvious which one is out when something doesn't reconcile.

Are Shopify orders shipped overseas GST-free?

The ATO says exports of goods from Australia are generally GST-free if the export conditions are met, and those sales still count towards your GST turnover. Confirm how the conditions apply to your orders with a registered tax agent. Your bookkeeper's part is coding orders by destination so the BAS reflects it.

How are gift cards treated in the books?

A gift card sold is money owed to the customer, recorded as a liability. It becomes revenue when it is redeemed. Ask your registered tax agent about GST timing on the cards you sell.

How much does a Shopify bookkeeper cost in Sydney?

It depends on order volume, the number of sales channels, whether you hold stock and how much cleanup is needed first. Fixed monthly pricing gives you the figure before the month starts. An hourly bookkeeper at $80 to $150 an hour with no agreed scope tends to cost more once payout reconciliation is done properly. See ecommerce bookkeeper cost in Sydney for how pricing scales.

Can you fix a Shopify file that has been coded from bank deposits for years?

Yes. A catch-up rebuilds sales, fees and refunds from the Shopify and gateway reports for the periods that matter, corrects the GST position and sets up clearing accounts so it stays right.

How often should a Shopify store be reconciled?

Weekly. Payouts arrive every few days, and a missing or short payout is far easier to chase in the week it happens than three months later.

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.

Visit Sydney Bookkeeper | Get a Free Xero Roast | Book a Chat

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 hello@sydneybookkeeper.com. 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, Exports and GST: https://www.ato.gov.au/business/international-tax-for-business/australians-doing-business-overseas/exports-and-gst/
• Australian Taxation Office, How Payday Super works: https://www.ato.gov.au/businesses-and-organisations/super-for-employers/about-payday-super
• Australian Taxation Office, Super guarantee rates (2026-27): https://www.ato.gov.au/tax-rates-and-codes/key-superannuation-rates-and-thresholds/super-guarantee