Small business bookkeeping spreadsheet cover showing dashboard and tax center

Bookkeeping dashboard with revenue, expenses, profit, tax set-aside and health check

Tax Center with Schedule C totals, tax set-aside and quarterly estimated payments

Profit and loss by month with budget versus actual

Small Business Bookkeeping Spreadsheet: P&L, Schedule C & Tax Set-Aside (Excel)

$29.00

Track income, expenses, invoices and mileage, then see your profit, Schedule C totals and what to set aside for tax. Bank reconciliation, 1099-NEC check and quarterly estimates included. Excel and Google Sheets.

Instant download after payment
Excel 2016+ and Google Sheets, no macros
Two files: one with example data, one blank
File problem? We fix it or refund you within 14 days

Category: Excel Templates

Description
Reviews (0)

Description

Small Business Bookkeeping Spreadsheet for Excel and Google Sheets

Know your profit, what to set aside for tax and who owes you money, without paying for accounting software. Log each sale and cost once; the profit and loss, Schedule C totals and dashboard fill themselves in.

What you get

Transactions ledger: 3,000 rows a year with dropdowns. Every row is checked for a missing category, wrong type, possible duplicate and missing receipt.
Profit & Loss: 12 months by category with year total, budget to date and over or under budget.
Tax Center: Schedule C totals by line, an estimate of self-employment and income tax to set aside, quarterly estimated payments with due dates, and sales tax collected by quarter.
Invoices: what customers owe you, with Paid, Due soon and Overdue status and days late.
Bank reconciliation: type each statement’s ending balance and see a green tick when your records match to the cent.
Mileage log with the IRS rate for each year (72.5 cents a mile for 2026) and your deduction.
Contractors: payments per contractor and whether a 1099-NEC is needed, using the $2,000 threshold for 2026 payments.
Dashboard: 8 live numbers, a monthly chart, top expenses and a health check that points to anything that needs fixing.

Details

Two files: one with example data so you can see it working, and a blank one for your year.
Up to 6 accounts (bank, card, PayPal or Stripe, cash) and 40 categories you can rename.
Format: .xlsx for Microsoft Excel 2016+ and Excel 365. Opens in Google Sheets.
No macros, no subscription, nothing locked. Instant download after payment.
Every total is checked against independent calculations before release.

Schedule C lines, tax estimates, the mileage rate and the 1099 threshold are general guidance, not tax advice. Confirm with your tax preparer.

Want it set up for your business? See our Excel setup and automation services.