Small Business Bookkeeping & Tax Dashboard Template (Excel + Google Sheets)

What's included: income, expenses, and P&L in one file

The workbook is built around six sheets: Instructions, Settings, Income, Expenses, P&L, and Tax Dashboard, with a CPA Export sheet on top. Settings holds your fiscal year, your estimated effective tax rate, a set-aside percentage, your state, and a list of expense categories already mapped to Schedule C lines.

Income logs each payment by date, client, category, amount, and whether it's been paid. Expenses does the same for spending, with each entry assigned a Schedule C category from a dropdown. P&L then rolls both up into a monthly view across all 12 months plus a year-to-date total, broken out by category, all built on SUMIFS formulas rather than anything fragile.

As with the rest of the line, entry cells are shaded and validated, formulas are protected, and everything is designed to be filled in by someone without a bookkeeping background.

Schedule C category mapping and the quarterly tax dashboard

Every expense category in the template maps directly to a Schedule C line item (lines 8 through 27), so your P&L isn't just organized for your own reading, it's organized the way the IRS expects a sole proprietor's expenses to be categorized. That mapping happens automatically once you pick a category from the dropdown; there's no separate reclassification step at tax time.

The Tax Dashboard takes your year-to-date net income and multiplies it by the effective tax rate you set in Settings to estimate what you owe, then splits that into quarterly set-aside amounts aligned to the actual IRS due dates for Q1 through Q4. It tracks what you've already set aside against what's left to provision, so you're not guessing at a lump sum in April.

This estimate is a planning tool based on the rate and figures you enter, not a tax filing and not a substitute for a CPA or the IRS's own guidance for your specific situation.

CPA Export: a clean handoff for your accountant

At year-end, the CPA Export sheet compiles your full annual P&L organized by Schedule C line into a single clean summary, ready to print or send to whoever prepares your return. You're not exporting raw transaction data and hoping your accountant can make sense of it; the categorization work is already done by the time you get there.

This is one of the clearest gaps we found across every competitor reviewed, free and paid: none of them offer any kind of formatted, accountant-ready export. Everything else on the market stops at a generic monthly P&L or a sales-tax tracker, leaving the Schedule C sorting and CPA handoff entirely up to you.

How this compares to free and Etsy bookkeeping templates

Smartsheet's free bookkeeping bundle is actually 23 separate templates, a cash book here, a P&L there, with no single connected workbook and nothing tying expenses to Schedule C. The Etsy templates we reviewed range from a bare-bones income/expense log to a 12-tab dashboard with sales tax tracking, but none of them map categories to Schedule C or calculate a quarterly estimated-tax set-aside.

Format parity is another common weak spot: one popular Etsy bookkeeping template is Google Sheets only and explicitly doesn't work in Excel or Numbers, while another sells both formats but warns in its own listing that the Excel version's charts and theming differ from the Google Sheets version. Every formula and dashboard in this template is built to calculate identically in both formats, so you're not getting a downgraded Excel or Sheets copy depending on which one you pick.

Who this is for and how to set it up

This template is built for self-employed freelancers, consultants, and single-member LLCs who file a Schedule C and want their bookkeeping organized around that from day one, without paying for accounting software they don't need for a solo business.

Setup takes a few minutes: enter your fiscal year, effective tax rate, and set-aside percentage in Settings, then start logging income and expenses as they happen. The P&L, Tax Dashboard, and CPA Export update on their own from there. Both the Excel and Google Sheets builds use the same SUMIFS-based formulas, so pick whichever tool you already work in.