Shopify POS Bookkeeping
The accounting under a till: why the day's sales and the day's deposit are never the same number, where the processing fees went, and what the gift card balance actually is.
Shopify POS is your till and your team runs it. What this page is about is the accounting underneath it, which is the same problem in every retail business and has the same four causes. None of them depends on who is standing at the terminal.
What the work looks like in Shopify POS
The day's sales and the day's deposit are different numbers, on purpose
A till rings the gross sale. The payout arrives net of the processing fee and usually a day or more later. Recording the deposit as the sale understates revenue and expenses by the same amount, which leaves profit correct and every sales figure, every margin and every sales tax calculation wrong. The reconciliation that works runs from the Shopify POS settlement report to the bank line, with the fee recorded as the cost it is.
A gift card sold is money you owe, and it stays owed until somebody spends it
Selling a gift card is not a sale, it is a deposit from a customer against future goods. It becomes revenue when it is redeemed. A shop running gift cards through income on the day they are sold books the same money twice, once on sale and once on redemption, and carries no record of what is still outstanding. The balance of unredeemed cards is a real liability and it is worth knowing.
The sales tax you collected is in the payout and it was never yours
The deposit contains the tax, and for a Canadian retailer that is money collected on the CRA's behalf. Where the payout is recorded as one gross figure of income, the tax sits inside revenue, the sales figures are overstated by the tax rate, and the return gets prepared from numbers the books do not support. Separating it at the point the day is recorded is much cheaper than unpicking it at year end.
A refund and a chargeback land in a later month than the sale
Both reverse out of a later payout, which means a strong month can be partly undone by a month that reads as weak. That is not an error to correct; it is a timing effect to understand, and on a business with seasonal returns it is the difference between a trend and a blip.
Whose system this is
Your team runs the till, the catalogue and the day-to-day of it. We are not the administrators of your Shopify POS and we do not need to be: everything above is read from the reports it already produces, and that is the part that has to agree with the bank.
Questions about Shopify POS
Our sales never match our deposits. Is something wrong?
Almost certainly not. The two are supposed to differ by the processing fees and by the settlement timing, and the job is to explain the difference rather than remove it. What is worth looking at is any part of the gap that nothing accounts for.
Do you need access to our Shopify POS?
Read access to the reports is enough, and that is all we would ask for. We are not the operator of your till and the accounting does not require us to be.
We also sell online. Does that change anything?
It adds a second settlement stream with its own timing and its own fees, and for a Canadian business it can add sales tax in provinces you do not have a shop in. Both are handled the same way, by reconciling each stream to its own payouts rather than netting them together.
Who files the sales tax return?
We prepare and file GST/HST from your own books for Canadian businesses. Corporate, trust and partnership returns are done by our associated CPA.
More questions answered on the FAQ page.
Where this fits
Running Shopify POS?
A free 20-minute consultation, no obligation.