You don't need accounting software or a finance degree to know where your business stands. You need a simple tracker and a habit.
A lot of small business owners run on a feeling. Sales seem good this month. Money feels tight this week. Was that supplier invoice paid? Probably.
That works until it doesn't — until tax season arrives, or a slow month hits, or you're trying to decide whether you can afford a new tool and you genuinely don't know. The problem usually isn't a lack of skill. It's that bookkeeping feels like a huge, vague chore, so it gets pushed off until it becomes a crisis.
This article lays out a deliberately small system: a few tracking sheets and one 20-minute weekly routine. It won't replace an accountant — and if your situation is complex, you should talk to one — but it will give you a clear picture of your business every week and make your accountant's job (and bill) much easier.
Why "simple" beats "complete"
Many owners start with a powerful accounting tool, spend an afternoon setting it up, and abandon it within a month. Complete systems have a cost: they demand regular attention to many fields and categories. If the system takes more energy than you have on a busy week, you'll skip it, and a skipped system is worth nothing.
A simple system you actually update beats a sophisticated one you don't. The goal for now is consistency. You can always upgrade later once the habit exists.
The four trackers you actually need
You can do all of this in Google Sheets or Excel. Four tabs cover the essentials for most small, early-stage businesses.
1. Income log
One row per payment received.
| Date | Customer / Source | Description | Amount | Payment method | Category |
|---|
Categories might be "Product sales," "Services," "Wholesale," depending on your business. Keep the list short — five categories or fewer.
2. Expense log
One row per expense.
| Date | Vendor | Description | Amount | Category | Receipt saved? (Y/N) |
|---|
That last column is the most underrated column in small business. When tax time comes, the question isn't just "what did I spend?" but "can I prove it?" A simple Y/N checkbox, plus a folder where you drop receipt photos, saves hours later.
Suggested categories: Materials/inventory, Software & subscriptions, Marketing, Shipping, Fees (payment processor, platform), Equipment, Other. Again, short lists win.
3. Monthly summary
A tab that totals income and expenses by month using simple formulas like SUMIFS. For example:
=SUMIFS(Income!D:D, Income!A:A, ">="&DATE(2026,11,1), Income!A:A, "<"&DATE(2026,12,1))
This gives you total income for November. Do the same for expenses, and subtract to get a simple monthly profit figure. Add a row per month and you have a year-at-a-glance view without any extra effort.
4. Unpaid & upcoming
A short list of money owed to you (invoices not yet paid) and money you owe soon (bills, subscriptions renewing, supplier payments).
| Item | Who | Amount | Due date | Status |
|---|
This tab is what prevents surprises. Most cash-flow stress isn't about profit — it's about timing.
The 20-minute weekly routine
Pick a fixed time. Friday afternoon or Monday morning work well for most people. Put it in your calendar as a recurring appointment with yourself.
Minutes 0–8: Log the week.
Open your bank, payment processor, and marketplace dashboards. Add every income and expense from the past seven days to the logs. Snap and file any receipts you haven't saved.
Minutes 8–12: Check unpaid & upcoming.
Mark paid invoices as paid. Add any new bills. Look ahead at the next two weeks: is anything large coming up?
Minutes 12–16: Glance at the summary.
How does this month compare to last month so far? Is any expense category growing faster than you expected? You're not doing analysis — just noticing.
Minutes 16–20: One decision.
Make one small decision based on what you saw. Chase an overdue invoice. Cancel a subscription you haven't used. Move a bit of money into a tax savings account. One action per week compounds.
The power of this routine isn't any single session. It's that after a few months, you'll know your business numbers almost from memory.
Using ChatGPT as a bookkeeping assistant
AI won't do your taxes, and you shouldn't trust it with legal or tax advice for your specific situation. But it's genuinely useful for the tedious parts of a tracking system.
Building and fixing formulas
I have a Google Sheet with an Expenses tab. Column A is date, column D is amount, column E is category. Write a formula that totals expenses for the category "Marketing" in the current month.
Formulas are where many people get stuck, and this is a task models handle well. Always test the result on a few rows you can check by hand.
Categorizing messy transactions
Here is a list of transactions from my bank export. Suggest a category for each from this list only: Materials, Software, Marketing, Shipping, Fees, Equipment, Other. Flag any you're unsure about instead of guessing.
[paste transactions — remove account numbers and personal details first]
The "flag instead of guessing" instruction matters. You want the uncertain ones surfaced, not silently mis-filed. And never paste full account numbers or sensitive personal data into any chat tool.
Writing a polite payment reminder
Write a short, friendly payment reminder for an invoice that is 10 days overdue. Client name: [name]. Invoice number: [#]. Amount: [amount]. Tone: polite but clear, no guilt-tripping.
Chasing late payments is uncomfortable, and having a calm, professional draft makes it far more likely you'll actually send it.
Monthly reflection
Here is my monthly summary: [paste totals by category]. Point out which categories changed the most compared to last month and suggest 3 questions I should ask myself about it. Don't give tax advice.
This turns a table of numbers into a short self-review — the kind of thinking a busy owner rarely makes time for.
Beyond money: a light operations tracker
Once the money routine is a habit, the same approach works for operations. A few small tabs can save a lot of mental load:
- Inventory: item, quantity on hand, reorder point, supplier. Highlight rows below the reorder point with conditional formatting.
- Customer follow-ups: name, last contact, next action, date.
- Content/marketing calendar: date, channel, topic, status.
Each one follows the same rule: few columns, one place, reviewed weekly.
Common mistakes
- Mixing personal and business money. If you can, use a separate account for the business. It makes every other step easier.
- Too many categories. If you hesitate over which category to choose, you have too many.
- Saving receipts "later." Later rarely comes. Snap them during the weekly routine at the latest.
- Waiting for the perfect system. Start with the four tabs today. Improve as you go.
The short version
- A simple tracker you update beats a complete system you abandon.
- Four tabs: income, expenses, monthly summary, unpaid & upcoming.
- One 20-minute weekly session, ending with one decision.
- Use ChatGPT for formulas, categorization drafts, and reminder emails — not for tax advice.
- Expand to inventory and follow-ups once the habit sticks.
If you'd like to skip the setup, I made a small free starter set of prompts for small business tracking and operations tasks like these: Free Small Business Prompt Sampler
Top comments (0)