How to Track Business Income and Expenses for Taxes in a Spreadsheet

Every year, the same scene plays out in millions of small businesses: it’s April, the return is due, and the owner is elbow-deep in a shoebox of receipts trying to reconstruct twelve months of money from memory and bank statements. It’s stressful, it’s error-prone, and it almost always leaves money on the table in missed deductions.

There’s a better way, and it doesn’t require expensive software or an accounting degree. It requires one habit — logging income and expenses in a spreadsheet as they happen — and one bit of structure that makes those logs tax-ready. Here’s exactly how to do it.

The Goal: Books That Are Always Tax-Ready

Good bookkeeping isn’t about impressive reports. For a small business, it has one job: at any moment, you should be able to answer “how much did I make, how much did I spend, and what do I owe in taxes?” If your system can’t answer that in under a minute, it isn’t working.

The way you get there is to stop treating tax prep as a once-a-year event and start treating it as a byproduct of clean records you keep all year. When every transaction is logged and categorized as it happens, filing taxes becomes copying totals — not archaeology.

Rule 1: Separate Business From Personal, Completely

Before any spreadsheet helps you, draw a hard line between business and personal money. Open a dedicated business bank account and card, and run only business activity through them. This single move does three things: it makes your records credible if the IRS ever asks, it makes monthly reconciliation trivial, and it stops the constant question of “was that dinner personal or a client meeting?”

Your bookkeeping spreadsheet should only ever contain business transactions. Personal spending doesn’t belong there, and business spending shouldn’t hide in your personal account where you’ll forget to deduct it.

Rule 2: Log Income With Enough Detail to Prove It

Your income log records every dollar the business earns. Each row should capture:

• Date received — when payment cleared
• Client or source — who paid
• Invoice number — to match your invoice records
• Amount — the full payment
• Payment method — so it reconciles to the right account

Why the detail? Because if a payment platform sends you a 1099, you need to reconcile it against your own records — and because the IRS expects you to report all income, whether or not a form was issued. Your log is the master record that ties every deposit, 1099, and cash payment together.

Rule 3: Categorize Every Expense the IRS Way

This is where a spreadsheet becomes a tax tool instead of a diary. Categorize each expense using IRS Schedule C categories — advertising, supplies, contract labor, utilities, car and truck, office expense, and roughly 25 lines in all.

Tag the category on every single entry, using a dropdown so it’s fast and consistent. Do this and your tax return becomes a matter of totaling each category and copying the numbers. Skip it and you’ll be re-sorting a year of “misc” expenses at the worst possible time.

While you’re at it, capture the deductions people most often forget:

• Business mileage, logged at the 2026 IRS standard rate of 72.5 cents per mile
• Home office costs, if you have a dedicated workspace
• Software and subscriptions you pay for the business
• Payment processing and bank fees — small individually, meaningful in total
• Self-employed health insurance premiums

Rule 4: Let Formulas Do the Accounting

Manual math is where errors and abandonment happen. Wire your summary tab with formulas so entering one transaction updates everything:

• =SUM(...) for total income and total expenses
• =SUMIF(...) to total each Schedule C category
• Net profit as income minus expenses, updating live

Now your P&L is never out of date, your category totals are always ready for tax time, and you never touch a calculator.

Rule 5: Reconcile Monthly

Set a recurring 20-minute appointment with yourself at each month’s end. Compare your spreadsheet to your bank and card statements, add anything you missed, and confirm the totals match. Monthly reconciliation catches missing transactions while you still remember them, surfaces bank errors, and means your year-end numbers are already correct. It’s the habit that separates people who dread taxes from people who file in an afternoon.

The Fastest Way to Start: Use a Pre-Built System

Building all of this yourself — income and expense logs, Schedule C dropdowns, a tax summary, and every formula — is doable, but it’s hours of setup and easy to get subtly wrong. A single broken formula quietly throws off your numbers all year.

Our Small Business Bookkeeping Spreadsheet gives you the whole system, ready to use. It includes separate income and expense trackers, 25 pre-built IRS Schedule C categories, an invoice log with aging, cash flow tracking, bank reconciliation, and a tax summary tab that organizes every expense by Schedule C line item automatically. With 836+ auto-calculating formulas across nine tabs, you just enter your data and watch your P&L, category totals, and tax summary update themselves — in Excel or Google Sheets. It’s the “log it as it happens, file in minutes” system, already built.

Featured on ReadySheetGo

Small Business Bookkeeping Spreadsheet Template — Track business income and expenses with 836+ auto-calculating formulas, 25 IRS Schedule C categories, invoice aging, cash flow, and bank reconciliation across 9 professional tabs. Print a tax-ready summary at year end. Works in Microsoft Excel and Google Sheets. $17.99 (currently $10.79 with the LAUNCH40 sale). Instant digital download — start keeping clean books today.