QUICK ANSWER
A Shopify month end includes seven steps: tie every payout to the bank deposit, separate the gross sale from the fees netted out of it, post refunds and chargebacks against the product rather than against revenue, treat gift cards as a liability until redeemed, reconcile inventory and landed cost, record sales tax collected by jurisdiction, and produce a close pack by a fixed date. A bank reconciliation alone is not a close.
What does a Shopify month end actually involve?
Seven steps, in this order. Most bookkeepers who are not working with ecommerce daily do the first and the last and treat the middle five as detail, which is where the errors live.
- Tie every Shopify payout to the deposit that landed in the bank, individually rather than in aggregate.
- Separate the gross sale from the processing and platform fees that were netted out of it, so revenue is revenue and fees are an expense.
- Post refunds and chargebacks against the product they relate to, not against total revenue.
- Treat unredeemed gift cards as a liability, and recognise the revenue only when the card is used.
- Reconcile inventory and update landed cost, including freight and duty rather than the supplier invoice alone.
- Record sales tax collected by jurisdiction, separately from revenue, so the filing position is visible rather than reconstructed.
- Produce and deliver a close pack by a date that was fixed in advance.
A close that stops at step one gives you a bank balance that agrees and a profit and loss statement that does not describe the business. That is the most common condition we find in a first month of work, and it is rarely the result of carelessness. It is the result of a process designed for a retail shop being applied to a store that sells through a platform, which nets out its fees before the money arrives.
Why does my Shopify payout never match my revenue?
Because the payout is what is left after Shopify has taken its share, and several other things have happened in between. A single deposit can contain sales from more than one day, processing fees deducted, refunds issued during the period, chargebacks, adjustments and sometimes a reserve. The deposit is a net figure. Revenue is a gross figure. They were never going to be the same number.
Booking the deposit as revenue is the single most common error in Shopify books, and it understates both revenue and expenses by the same amount. The profit figure can look roughly right, which is exactly why it survives. What it destroys is every ratio underneath: gross margin, the fee percentage, the real cost of each channel. An owner trying to work out whether the store is getting more or less efficient cannot answer the question from books built this way.
This is what A2X is for, and what the mapping underneath it decides. The tool pulls the settlement detail and splits it into its parts. The accuracy depends on whether the chart of accounts and the mapping were set up for this business. We hold a 99.7% zero variance rate on those tie-outs, which is a statement about the mapping rather than about the software.
How quickly should the books close?
A workable standard is a close pack delivered by the fifteenth of the following month, with the documents you owe in by the fifth. That gives a real review window: the owner sees October in the middle of November, while November can still be changed.
The test is not whether the close is fast in the abstract. It is whether it arrives before the decision it is supposed to inform. A close delivered at the end of the following month is a historical record. A close delivered in the first half is a management tool. The same work, performed on a different schedule, is a different product.
What does a fixed close date actually change?
Posterjack is a Canadian print-on-demand company selling custom photo products through Shopify, with high order volume and a large fulfilment team. Before the rebuild, the bookkeeping was mostly manual, paper receipts were hard to track down, bills were paid by hand, and month-end reports were consistently late with no reliable close date. GST, PST and QST each needed a last-minute scramble, and year-end meant payroll records scattered across several places.
The fix was unglamorous: DEXT for receipt capture, Plooto for bill payments, a standard monthly document submission, a cleaned-up chart of accounts, and a schedule with documents in by Day 5 and the close delivered by Day 10. The company now closes every month by the 10th without exception, has 100% of receipts digitized, runs three tax regimes on a calendar rather than in a panic, and describes its year-end as organized and predictable every time.
Worth saying plainly: none of that is a technology outcome. The tools took the manual handling out, but the thing that changed the business was agreeing a date and then meeting it. That is also why it holds. A close date is a commitment both sides can see being kept or missed, which is a different kind of accountability from a service description.
How do I tell whether my current close is working?
Three questions answer it. What date did last month’s close pack arrive, and was that date agreed in advance or did it just happen? Does your profit and loss statement show platform and processing fees as an expense line, or has revenue been booked net? And can you see sales tax collected by jurisdiction without someone going back through the settlement files?
If the first answer is vague, you do not have a close date, you have a tendency. If the second shows net revenue, the margin figures above it are not reliable. If the third requires reconstruction, your filing position is being assembled under time pressure every period, which is where errors come from. Any one of the three is worth a conversation. All three together usually means the books need rebuilding rather than continuing.
Frequently asked questions
Can my regular bookkeeper handle Shopify?
Many can, if the chart of accounts and the settlement mapping are built for it. The question to ask is not whether they have Shopify clients but how they handle payouts, fees and gift cards. If the answer is that the deposit is booked as revenue, the books will not support margin analysis.
What is A2X and do I need it?
A2X pulls Shopify and Amazon settlement data and splits each payout into sales, fees, refunds and taxes so it can be posted correctly. For a store doing meaningful volume it removes a large amount of manual work, but the accuracy comes from how it is mapped, not from installing it.
How long does it take to clean up books that were done this way?
It depends on how many periods are affected and whether the underlying data is still available. A single year with intact settlement records is usually a matter of weeks. Several years, or missing records, takes longer and is worth scoping before committing to a date.
What should arrive in my inbox at month end?
A profit and loss statement, a balance sheet, a cash summary, a reconciliation confirmation for every account, and a short note on anything unusual. Delivered on an agreed date rather than when it happens to be ready.
NEXT STEP
Transcounts keeps the books for Canadian Shopify and Amazon sellers on a Day-15 close cadence, with 92% of closes landing on time and a 99.7% zero variance rate on A2X payout tie-outs. The $99 Ecommerce Diagnostic reviews your current books and reports back within seven business days, including what a first proper close would turn up. The fee is credited against onboarding.
