Small Shop Bookkeeping: How to Start (Free Template Inside)
Opening a shop and not sure how to keep the books, or never quite know if you're making money? From a small-business angle: how to track income and expenses, the difference between cash flow and profit, how to work out margin, and a free income & expense log.
A friend opened a small drink shop. Business was decent for three months and the account looked healthy — then he did the maths and realised he'd barely made anything; it had all gone to stock and rent, while he'd assumed "money in the account = profit." That's what happens without bookkeeping: you think you know, but you don't.
Running a shop without books is like driving with your eyes closed. Here's how to start, from a real small-business angle.
Don't overthink it: one sheet, every day
People hear "bookkeeping" and picture complex accounting software and debits and credits, then give up. For a new shop, a single income & expense log is enough — what matters isn't the tool, it's recording every day.
After closing, spend five minutes logging the day's income and expenses, line by line:
| Date | Item | Category | Income | Expense | Balance |
|---|---|---|---|---|---|
| 06/01 | Cash sales | Revenue | 820 | 820 | |
| 06/01 | Stock (supplies) | Cost | 350 | 470 | |
| 06/02 | Platform payout | Revenue | 540 | 1,010 | |
| 06/02 | Utilities | Expense | 120 | 890 |
That's it. Don't want to build the sheet? Download the ToolKing income & expense log, open it in Excel or Google Sheets, and the balance can auto-calculate (previous balance + income − expense).
The key is consistent categories — fix a few (revenue, cost, operating expenses) so at month-end you can see where the money went at a glance.
The crucial idea: cash flow ≠ profit
This is the trap my friend hit, and the one beginners confuse most.
- Cash flow: the money actually moving — how much is in the account, can you cover the next bill.
- Profit: what's left after all costs — what you actually earned.
They often diverge:
- The account looks full because you took a deposit but haven't paid suppliers — good cash flow, not necessarily profit.
- You're profitable on paper but customers haven't paid yet — profit exists, but you could run short.
So track both. Updating the balance daily in your log is exactly how you watch cash flow.
Know if you're actually earning: margin
A running log isn't enough; you need to know what's profitable. Start with gross margin:
Margin = price − cost
Margin rate = margin ÷ price × 100%
A drink at $6, cost $2: margin $4, rate ~67%. Don't want to tap a calculator each time? Use the percentage calculator with cost and price, line your products' margins up, and you'll spot that "best-seller ≠ best margin."
Remember: gross margin still has to cover fixed costs (rent, utilities, wages) — what's left after that is real profit. So your margin needs to be high enough to carry those.
If you issue invoices, handle tax as you go
If you issue invoices/receipts, record the tax as you book. Keep your sales and purchase records so filing reconciles. When you need to convert between pre-tax and tax-inclusive amounts for quotes or invoices, use the invoice / tax calculator instead of multiplying by hand every time.
Three steps to your first month
- Download the income & expense log, open it in a spreadsheet, and fix your categories (revenue / cost / operating expenses).
- Each day after closing, log income and expenses so the balance updates — this is how you watch cash flow.
- At month-end, use the percentage calculator for margins and the invoice / tax calculator for tax-inclusive figures, and see clearly whether you actually made money.
The bottom line
Bookkeeping is easier than you think — one sheet, recorded daily, consistent categories already beats nine in ten "run on vibes" owners. Hold two ideas: cash flow tells you if you'll stay solvent, margin tells you if you're earning — watch both. Fill one month with a template and your grip on your own shop will be on another level.
FAQ
Do I need accounting software, or is a spreadsheet enough?
When you're starting, a single income & expense log (Excel or Google Sheets) is plenty. What matters isn't fancy software but recording every day, completely. Move to accounting software or apps later, once you have many line items, payroll, sales-tax filing or a need to analyse cost ratios. Build the daily habit first — it beats jumping straight to a complex system.
Are cash flow and profit the same thing?
No — and confusing them is the classic beginner trap. Cash flow is the money actually moving in and out; profit is what's left after costs. You can take a deposit and have a full account (good cash flow) yet make nothing after stock, rent and wages (low profit); or look profitable on paper but run short because customers haven't paid yet. Watch both: profit tells you if you're earning, cash flow tells you if you'll stay solvent.
How do I work out gross margin, and what's reasonable?
Margin = price − cost; margin rate = margin ÷ price × 100%. A drink selling for $6 that costs $2 has $4 margin, about 67%. A reasonable rate varies hugely by industry — food often 50–70%, retail maybe 20–40%. The point isn't to match others but whether your margin covers fixed costs (rent, wages) with something left. A percentage calculator makes this quick.
Is bookkeeping related to tax? What should I keep?
Yes — good records make tax easy. If you issue invoices/receipts, keep your sales and purchase records and supporting documents so filing reconciles. Even as a very small operator, recording income and expenses daily and keeping receipts clarifies your revenue and helps with any audit. Bookkeeping is the daily habit; filing is just handing over the organised numbers.