Free bookkeeping spreadsheet templates: what to use and how to set one up

What a good bookkeeping template actually contains

A bookkeeping spreadsheet doesn't need to be clever. It needs four tabs, each doing one job. If a template has fewer than these, it's missing something; if it has many more, it's probably more than a small business needs to start.

• An income tab. One row per payment that comes in: the date, who paid you, what for, and the amount. This is the record of every dollar the business earned.
• An expense tab. One row per business cost going out, with a category on each row. This is the record that turns into your deductions at tax time, so it's the tab that matters most for your tax bill.
• A summary tab (your profit and loss). A handful of formulas that add up income, add up expenses by category, and show the difference. This is the tab you actually look at to know how the business is doing. You don't type into it; it reads from the other two.
• An invoice tracker. A list of invoices you've sent with their status: sent, paid, overdue. This is what stops a forgotten invoice from quietly costing you money. If you don't send invoices, you can skip this one.

That's the whole thing. Two tabs you type into, one that does the maths, and one that watches your unpaid invoices. Everything else a fancy template adds, like budgets, forecasts, and dashboards, is optional and can wait until the basics are a habit.

The exact columns for your income log

Keep the income tab simple enough that logging a payment takes ten seconds. These columns cover what you'll need at tax time without turning data entry into a chore:

If you don't charge sales tax, drop that column. If you never take cash, drop the method column. The rule is to add a column only when it earns its keep, because every extra column is one more thing to fill in on every row, and the templates people abandon are always the over-built ones.

The exact columns for your expense log

The expense tab is the one that saves you money, because every cost you log is a deduction you can claim. It needs one extra column the income tab doesn't: a category, so your costs sort themselves into the buckets your tax return wants.

For the category column, set a short fixed list and reuse it: materials and supplies, vehicle and travel, tools and equipment, software and subscriptions, insurance and professional fees, and meals kept separate because their tax treatment often differs. In a spreadsheet you can turn this list into a drop-down (Data, then Data validation in both Excel and Google Sheets) so you pick a category instead of typing it. That one step keeps your categories spelled the same way every time, which is what lets the summary tab total them correctly.

Where to find free templates

You don't have to build from nothing. Several genuinely free sources will get you a working template in minutes:

• Excel's built-in templates. Open Excel, choose New, and search "expense" or "income" or "small business". Microsoft ships several free bookkeeping and budget templates. They're plain but solid, and they're already on your machine.
• Google Sheets template gallery. In Google Sheets, the template gallery has expense reports and simple budget sheets you can copy for free. The advantage is that it's online, so you can log an expense from your phone, and it saves automatically.
• Vertex42, Smartsheet, and similar template sites. A handful of long-running sites offer free, well-built bookkeeping and small-business templates as Excel downloads. They tend to be more complete than the built-ins, with income, expense, and summary tabs already wired together. Just be a little wary of the ones that bury a free download under newsletter sign-ups or upsells.
• Your accountant. If you have one, ask. Many will hand you a simple spreadsheet set up the way they like to receive it, which makes tax time smoother because the categories already match what they file.

Whichever you pick, check it has the four tabs above and the columns you actually need, then strip out anything you don't. A trimmed-down template you understand beats a feature-packed one you don't.

How to set one up in an afternoon

Building your own from scratch isn't hard, and doing it once means you understand every cell. Here's the order that works:

1. Make the four tabs. Name them Income, Expenses, Summary, and Invoices. Three blank sheets and a header row each is the whole skeleton.
2. Add the column headers from the two tables above to the Income and Expenses tabs. Put one bold header row at the top and freeze it (View, then Freeze) so it stays visible as the list grows.
3. Set up the category drop-down on the Expenses tab using Data validation, pointing at your fixed category list. This is the step that keeps your totals trustworthy.
4. Wire up the Summary tab. Use SUM to total income and total expenses, and SUMIF to total expenses by category (it adds every expense row whose category matches). Subtract total expenses from total income and you have your profit. That's the entire profit-and-loss in about six formulas.
5. Build the invoice tracker. Columns for invoice number, client, date sent, due date, amount, and a status drop-down of Sent / Paid / Overdue. You now know at a glance what's owed to you.
6. Log a week, then breathe. Enter a real week of income and expenses. If a column feels useless, delete it now. The template you keep is the one that fits how you actually work.

Keep it somewhere it backs up on its own. Google Sheets does this by default; an Excel file lives more safely in OneDrive, Dropbox, or Google Drive than on a single laptop. A bookkeeping file that exists in only one place is a file you can lose.

When a spreadsheet stops being the easy option

Here's the honest part. A spreadsheet is the easy option right up until the typing becomes the job, and then it quietly becomes the hard one. The signs are consistent:

• The manual entry is eating real time. When you're spending more than an hour a month typing rows and chasing the total that won't match the bank, the spreadsheet is costing you more in time than software would in money.
• Receipts and rows have drifted apart. The spreadsheet has the numbers; the receipts are in a drawer. When matching the two at tax time is an afternoon of detective work, the spreadsheet has stopped doing its main job.
• A formula quietly went wrong. One mistyped range or a row inserted in the wrong place and the summary is off, and you can't fully trust the number you're handing your accountant.
• The volume climbed. Twenty transactions a month is fine in a sheet. Two hundred, across several suppliers, with sales tax and invoices to track, is a part-time data-entry job.

None of this means the spreadsheet was a mistake. It did exactly what it should: it got you tracking money for free while the business was small. When the typing outgrows it, the good news is you don't start over. Most accounting software lets you import a spreadsheet directly, so the months you've already logged carry across instead of being retyped. Argo Books, for example, takes a drag-and-drop of your Excel or CSV file and maps your columns to its fields no matter how you laid them out, with one-click undo if a mapping looks off, and the first 25 imports a month cost nothing. That's the natural next step when the sheet gets heavy: not throwing away your work, but moving it somewhere that does the typing for you.

Until then, a clean spreadsheet you keep current is a complete, valid bookkeeping system, and there's no rule that says you have to leave it. Plenty of small businesses never do.