Small Business Bookkeeping Spreadsheet, Small Business Expense Tracker, Income and Expense Tracker Excel, Google Sheets Bookkeeping Template

Small Business Bookkeeping Spreadsheet and expense tracker for Excel and Google Sheets - track income and expenses, see your profit, and get an automatic quarterly estimated tax figure for all four IRS periods. 9 tabs, 1,200+ built-in formulas, instant download.

Stop guessing what you owe.

Most small business owners find out what they owe in April, and by then it is too late to do anything about it. This bookkeeping spreadsheet flips that around. You log income as it arrives and expenses as you spend, and the workbook does the rest:

profit, margin, category totals, mileage deduction, and a running quarterly tax estimate that updates every time you add a row.

Nine tabs. Nothing to set up beyond your own tax rates. No subscription.

• * * WHAT'S INSIDE THE SPREADSHEET * * *

DASHBOARD

Your whole business on one screen. Total income, deductible expenses, net profit, profit margin, estimated tax, what you have already paid, what is still to set aside, profit after tax, and how much clients still owe you. Two live charts.

Nothing on this tab is typed - it all calculates.

SETUP

Business name, tax year, and your own tax rates. Also holds the income and expense category lists that feed every dropdown in the workbook. Rename or add categories to match your business in seconds.

INCOME LOG - 500 ROWS

Date, invoice number, client, description, category, payment method, amount, and a paid / unpaid flag. Unpaid invoices turn red and roll straight up to the Dashboard, so nothing you are owed gets forgotten.

EXPENSE LOG - 500 ROWS

Every business cost, with a Deductible % column. Claim 60% of a phone bill, 50% of a business meal, 25% of home electricity. Type the percentage and the spreadsheet works out the deductible amount for you. Receipt tracking built in.

MONTHLY SUMMARY

Twelve months of income, expenses, net profit, profit margin, running profit and tax set-aside, with a live income versus expenses chart.

CATEGORY BREAKDOWN

All 24 expense categories ranked by spend, each one mapped to its US Schedule C line, with monthly averages. This is the tab where you find the subscription quietly costing you $600 a year.

QUARTERLY TAX ESTIMATOR

The four real IRS estimated tax periods with their due dates. Self-employment tax, federal income tax, state tax and a safety buffer, worked out per quarter. Enter what you actually pay and the balance turns green.

MILEAGE LOG - 200 ROWS

Date, purpose, from, to and miles, at whatever mileage rate you set.

START HERE

The setup instructions, kept inside the workbook so you never lose them.

• * * WHY THIS ONE AND NOT A FREE TEMPLATE * * *

IRS estimated tax quarters are NOT equal calendar quarters. Q2 covers two months and Q4 covers four. Most bookkeeping templates split the year into four even chunks and quietly get your estimate wrong. This one uses the real periods and the real deadlines.

Partial deductions are built in, not bolted on. If a cost is only 40% business, you should only claim 40% - and you should not have to reach for a calculator to do it.

Every expense category is mapped to a Schedule C line, so filing season turns into a copy job instead of an archaeology project.

Sample data is included so you can see a filled-in workbook working before you clear it and start your own. No guessing what goes where.

• * * WHAT YOU GET - INSTANT DIGITAL DOWNLOAD * * *

1. Small Business Bookkeeping Spreadsheet (.xlsx) - 9 tabs, 1,200+ formulas

2. Printable Bookkeeping Pack - US Letter (.pdf) - 10 undated pages

3. Printable Bookkeeping Pack - A4 (.pdf) - the same 10 pages, A4 sized

4. START HERE setup guide (.pdf) - 2 pages, up and running in five minutes

The printable pack includes a monthly income log, monthly expense log, business mileage log, quarterly tax worksheet, monthly summary sheet, year at a glance, receipt and deduction checklist, client and invoice tracker, and an expense category reference. Undated, so print them as many times as you like, every year.

Files are available the moment your payment clears. Nothing ships.

• * * WORKS WITH * * *

Microsoft Excel (Windows and Mac)

Google Sheets (free, works in any browser)

Apple Numbers (Mac and iPad)

LibreOffice Calc (free, any computer)

Using Google Sheets? File > Import > Upload, then choose "Replace spreadsheet".

Formulas, dropdowns and charts all carry across.

No subscription. No account to create. No add-ons to install. Bookkeeping software costs $20 to $70 every single month - this is a one-time download you own outright.

Save a fresh copy, clear the rows, change the tax year, and reuse it

for as many years as you like.

• * * WHO IT'S FOR * * *

Freelancers and consultants

Etsy, Shopify and Amazon sellers

Coaches, therapists and service providers

Photographers, designers and creatives

Trades, contractors and mobile businesses

Anyone self-employed filing a Schedule C

If you are running a business from a shoebox of receipts and a bank app, this is the