This expense tracker gives the whole picture one clear home. It is a single spreadsheet that works in Microsoft Excel and Google Sheets, built for small business owners who want to see their money clearly without learning complicated accounting software.
WHAT IS INSIDE
The workbook has six tabs, each with one job.
Start Here explains how the file is set out and where to type. The coloured cells are the only ones you need to touch — everything else calculates for you.
The Income Log holds up to 500 entries, with columns for date, source, description, and amount. Every payment gets its own row, so nothing is forgotten.
The Expense Log holds up to 1,000 entries, with date, vendor, description, category, and amount. Twelve spending categories cover the usual costs of a small business, from supplies and inventory to rent, marketing, and shipping — and the category list can be edited to fit your own business. A deductible flag column lets you mark expenses your own way, because only you and your tax professional decide what counts.
The Dashboard pulls it all together: total income, total expenses, net profit, and profit margin, all updating automatically as you add entries. One glance tells you whether the month is healthy.
The Monthly Summary shows income and expenses month by month, with a spending chart, so patterns stand out — a quiet month, a heavy supplies month, a season that always costs more.
The Tax Set-Aside planner helps you put money aside regularly. You choose your own set-aside rate, and the planner works out the amount from your income. No rate is pre-filled, because the right rate is different for every person and every country.
A WEEK WITH THE TRACKER
The routine is simple. When money comes in, add a row to the Income Log. When money goes out, add a row to the Expense Log with its category. Once a month, open the Dashboard and look at the totals. That is the whole system — a few minutes at a time, instead of a stressful pile-up at the end of the month.
It suits market stall sellers, tutors, crafters, freelancers, and anyone who runs a small business on their own. Because no country-specific tax figures are pre-filled, it works wherever you are.
WHAT IT IS NOT
This is an organising spreadsheet, not accounting software and not tax advice. It does not file anything or decide what is deductible — check with a tax professional for your own situation. The workbook contains formulas only, with no macros, and the example figures shown in the pictures are fictional, so your own numbers start clean.
If your business money currently lives in three notebooks and a pile of receipts, one clear spreadsheet changes the feeling of it. Everything in one place, totals that update themselves, and a monthly picture you can actually trust.
0 Comments