Bookkeeping in Excel: A CPA's Honest Guide

You run two trucks and a crew, or you shoot weddings on weekends, and every guide you find says the same thing: get real accounting software. Meanwhile your books are a spreadsheet, and it has been working fine.

Here is the honest answer, and it is not the one the software companies give. For a small enough business, a spreadsheet is a legitimate set of books — the IRS says so in writing. What matters is not the tool. It is what your records do, how long you keep them, and knowing the point at which a spreadsheet stops being enough.

Is Excel actually allowed?

Yes, and the source is the IRS rather than an opinion. IRS Publication 583, the recordkeeping guide written for new businesses, answers it in one sentence: "Except in a few cases, the law does not require any specific kind of records." There is no rule that your books must live in accounting software, no rule that they must be double-entry, and no line on any return where you declare what you used.

Publication 583 goes further and names the simple method approvingly: "A single-entry system is based on the income statement (profit or loss statement). It can be a simple and practical system if you are starting a small business." Single-entry is exactly what a spreadsheet does naturally — one row per transaction, income and expenses, totalled by category.

You will find bookkeeping forums where that gets called not-real-bookkeeping. As accounting theory, they have a point: single-entry does not track assets and liabilities, and it will never produce a balance sheet. As a description of what a sole proprietor filing a Schedule C is required to do, it is the method the IRS's own publication calls practical. If you want a lender or an investor to read your numbers, that is a real reason to move to double-entry. Compliance is not.

So the question was never permission. It is fit — and fit is something you can actually test. If you want the wider picture first, our guide to bookkeeping for small business covers what the job involves regardless of what you keep the books in.

What your books actually have to do

Strip away the software argument and your books have four jobs. A spreadsheet can do all four. A spreadsheet built carelessly does none of them.

1. Support every number on your return. Every figure on your Schedule C has to trace back to something. If your return says $14,200 of materials, you should be able to filter one column and land on $14,200 without doing arithmetic in your head.

2. Tie to your bank. Books that have never been compared against a bank statement are a guess written in a grid. Reconciliation is the step that turns a list into a record, and it is the step people skip.

3. Hold the documents behind the rows. This is the part the template articles leave out. Publication 583 is specific: "Purchases, sales, payroll, and other transactions you have in your business generate supporting documents. Supporting documents include sales slips, paid bills, invoices, receipts, deposit slips, and canceled checks." Your spreadsheet is an index of those documents, not a replacement for them. A dated folder per month, scanned or paper, is enough — but it has to exist.

4. Be readable by someone who is not you. An examiner, a lender, or the CPA preparing your return. If a category only makes sense because you remember what you meant in April, it is not a category.

The four tabs and what goes in them

One workbook per tax year, four tabs. The design decisions matter more than the formulas, so this is not a click-by-click tutorial.

Tab 1 — Chart of accounts. This is the tab that separates a CPA's spreadsheet from a downloaded template, and it takes twenty minutes. Name your categories after the lines on the tax form you will actually file. For a Schedule C that means Advertising, Car and truck expenses, Contract labor, Insurance, Legal and professional services, Office expense, Repairs and maintenance, Supplies, Taxes and licenses, Travel, Meals, Utilities. A contractor's fuel goes to Car and truck expenses, the framer he pays goes to Contract labor, and the lumber goes to Supplies or to cost of goods sold depending on how the job is billed. Get this list right and tax preparation becomes transcription instead of reconstruction — which is the same argument for CPA-reviewed bookkeeping, done for free by you.

Tab 2 — Transaction log. One row per transaction, no exceptions: date, payee or description, category, amount, payment method, and a notes column you will be glad of later. Point the category column at Tab 1 with data validation so it becomes a drop-down — that single step eliminates the "Fuel" / "fuel" / "Gas" problem that quietly breaks every total downstream. Select the range and press Ctrl+T to format it as a table so formulas extend themselves as you add rows.

Tab 3 — Monthly reconciliation. Twelve columns. For each month: your bank's closing balance, your log's closing balance, and the difference. The difference is supposed to be zero. When it is not, you find out in February rather than the following January.

Tab 4 — Profit and loss. Categories down the side, months across the top, SUMIFS pulling from the log by category and date range. Nothing is typed into this tab by hand, ever. If a number here is wrong, the fix belongs in the log.

Four signs to stop using a spreadsheet

The usual advice is that you should switch "as your transaction volume grows," which is unfalsifiable and therefore useless. Here are four triggers you can actually check. Any one of them is a real reason to move.

1. You hire someone. This is the hard stop. Payroll means withholding calculated correctly, deposits made on a schedule set by your deposit frequency, quarterly Form 941s, W-2s in January, and Michigan withholding on top of the federal side. A spreadsheet does not calculate withholding and cannot make a deposit. The recordkeeping bar also rises: Publication 583 requires you to "keep all employment tax records for at least 4 years after the date the tax becomes due or is paid, whichever is later."

2. You start collecting Michigan sales tax. Sales tax has to be tracked by period, not by year, because you file returns on Treasury's calendar and remit what you collected in that specific window. Tracking it in a spreadsheet is possible and it is unforgiving — a missed period is a penalty, not a rounding error.

3. You carry inventory or move to accrual accounting. Both need the balance sheet that single-entry does not produce. Once you are matching revenue to the period it was earned rather than the day it landed, you have outgrown the model the spreadsheet is built on.

4. You have stopped reconciling. The honest one, and the most common. If the last month you tied to a bank statement was five months ago, the tool is not the problem — but software that imports the bank feed removes the excuse.

There is one more thing worth knowing, because nobody selling you a template mentions it: a workbook keeps no audit trail. Someone opens the file in November, retypes a number in the March column, and nothing anywhere records that it changed. Microsoft 365 keeps file version history, but that is a snapshot of the whole file, not a log of who changed which transaction and when. Accounting software keeps that log by default.

When you do cross one of these lines, the destination is QuickBooks Online or Xero. Both are cloud products, both import bank feeds, and both keep the audit trail you have been doing without. If what you actually need is a person rather than a product, the difference between the two is worth understanding first — we cover it in CPA vs bookkeeper.

How long to keep your records

This applies to the supporting documents as much as to the workbook, and it is the part of the answer that no spreadsheet guide seems to carry. The IRS retention rules set five periods, each tied to a condition:

• 3 years — the default, if none of the situations below apply to you.
• 4 years — employment tax records, kept at least four years after the date the tax becomes due or is paid, whichever is later.
• 6 years — if you do not report income that you should report and it is more than 25% of the gross income shown on your return.
• 7 years — if you file a claim for a loss from worthless securities or a bad debt deduction.
• Indefinitely — if you do not file a return, or if you file a fraudulent one.

The practical version for most owners: keep the workbook and the folder of documents for seven years and stop thinking about it. Storage is free and reconstructing a year you no longer have records for is not. Note also that these are the tax minimums — a lender, an insurer, or a partnership agreement can require longer.

If you would rather not build it

Building the workbook above is an afternoon, and the categories are the only part that needs real thought. Two shortcuts, in order of cost.

Start from a pre-built one. Microsoft publishes free accounting templates for Excel and they are a fine skeleton. The part you should still change is the category list, for the reason in Tab 1 — a generic template's categories rarely line up with the form you file on. If you would rather have that already done, our Small Business Bookkeeping Tracker is a $37 workbook built in Google Sheets with an income tracker, an expense tracker, and a profit dashboard, and its categories are written against a Schedule C. It downloads to Excel, though the formulas and charts are designed and tested in Google Sheets.

Or hand it off. The trigger is usually time rather than complexity: the books are two hours a month you would rather spend on the work that bills. Our bookkeeping services are CPA-reviewed, which means Mindy designs the chart of accounts and reviews the reconciliations personally rather than handing you a report she has not read. If you are weighing that against doing it yourself, the arithmetic is in our guide to how much bookkeeping costs.

There is no wrong answer here. A spreadsheet kept properly beats software kept badly, every time.

FAQ

Can I do my own bookkeeping with Excel?

Yes. IRS Publication 583 says the law does not require any specific kind of records, and it calls a single-entry system practical for a small business. A spreadsheet works if you categorize consistently, reconcile to your bank every month, and keep the receipts and statements behind every row.

Can I just use Excel instead of QuickBooks?

For a sole proprietor with no employees and modest transaction volume, yes. Excel stops being the right tool once you run payroll, file Michigan sales tax, carry inventory, or stop reconciling. At that point QuickBooks Online or Xero does work a spreadsheet cannot do at all, not work it does more slowly.

How can I create a bookkeeping system using Excel?

Build four tabs: a chart of accounts whose categories match your Schedule C lines, a transaction log with one row per transaction, a monthly bank reconciliation, and a profit and loss summary driven by SUMIFS. Use one workbook per tax year and format each range as a table so formulas extend.

Is there an Excel template for bookkeeping?

Many. Microsoft publishes free accounting templates for Excel, and they are a reasonable starting point. The part worth changing is the category list — a template's generic categories rarely line up with the tax form you actually file on, and that mismatch is what creates work at year end.