A monthly QuickBooks or Zoho Books file for the bookkeeper of a small shop works best as a routine rather than a rescue job: export each account on the same day every month, tidy it, categorise it, and send it. The shop owner's version of this problem is that sales, supplier payments and card fees all land in the same account.
What does a messy month look like in a shop account?
Picture a month where the account shows card sales deposits, supplier payments, rent, a cash withdrawal for the float and a few personal purchases that slipped in. Say deposits total C$18,400 and payments out total C$15,950, a net movement of C$2,450. Your job is to make every one of those rows readable and categorised so the bookkeeper is not guessing.
| Row type | Suggested category label | Watch out for |
|---|---|---|
| Card sales deposit | Sales | Deposits are often net of processor fees, so the figure may be lower than the day's sales |
| Supplier payment | Stock purchases | Keep the supplier's name in the description |
| Cash withdrawal | Cash float or owner draw | Say which one it was |
| Rent | Premises | Same amount each month, easy to rule |
| Personal purchase | Owner draw | Better to move it off the business card |
How do you set up a repeatable routine?
- Pick a fixed day, such as the third of each month.
- Download last month's CSV from each account.
- Open it, delete non-transaction lines, and keep a pristine copy.
- Categorise rows, starting with the repeat ones: rent, utilities, the card processor.
- Total the file and compare with the statement's net movement.
- Send the file with a short note listing anything unusual.
Which rows should you categorise first?
Sort by description, not date. Rows from the same payee sit together, and one decision covers many lines. If 22 of 60 rows come from three suppliers, you have finished over a third of the work after three decisions. Then handle the one-off items individually.
Does an app help or is a spreadsheet enough?
For a few dozen rows a month, a spreadsheet is enough. As volumes grow, retyping categories gets slow. SpendixAI is built around India and INR, so it is not designed for Canadian dollar shops, but it illustrates the idea: statements go in, your corrections become rules, and a Zoho Books or QuickBooks template comes out of the export centre.
What should you do about sales taxes and tips in the file?
Keep the method simple and let your bookkeeper decide the treatment. Do not strip anything out or split amounts yourself unless asked. If a supplier payment of C$565.00 is a single line on the statement, leave it as one line and attach the invoice reference in a note column. Your bookkeeper can split the amount in their software, using their own rules, and checking the invoice. Your job is a complete, readable list of what moved through the account, with documents available on request.
What if staff or a partner also use the card?
Ask each person to photograph receipts the same day and name the file with the date and supplier. When you categorise the month, match each card row to its receipt and write the receipt name in a note column. A row without a receipt is not wrong, but it is the first thing a bookkeeper will ask about, so flag it yourself with a short question mark in the notes. Over a few months this habit makes the monthly file almost routine.
Month-end checklist
- All accounts exported, not only the main one
- Non-transaction lines removed
- Categories from the bookkeeper's list
- Net total matches the statement
- Unusual rows annotated
- Original files saved for reference
Useful ideas start with a clearer picture of your own spending.
Explore your reports

