Small Business Bookkeeping Spreadsheet, Profit and Loss Template, Expense Tracker, Excel & Google Sheets, Schedule C Tax Prep

A bookkeeping and profit/loss spreadsheet that adds everything up for you: record income and expenses, and your monthly P&L, dashboard, sales tax, invoices and tax-time summary update by themselves.
Made for US solopreneurs, makers, cleaners, freelancers and small service businesses who want to get off the shoebox and be ready for tax season.

WHAT'S INSIDE (11 tabs)
- Start Here: three steps and one color rule (yellow cells are where you type)
- Setup: business details, fiscal year, sales tax rate, mileage rate, payment methods and your own category lists
- Income: 1,000-row ledger with category, payment method and Paid? dropdowns
- Expenses: 1,500-row ledger; meals default to 50% deductible
- Invoices (AR): invoice log with suggested due dates, Paid / Due / Overdue status and an aging summary
- Monthly P&L: income and expenses by category for 12 months, net profit, cumulative profit, margin
- Dashboard: 8 key numbers, income vs expenses chart, cumulative profit chart, top 10 expense categories
- Sales Tax: collected vs paid to the state by month and quarter, and what you owe now
- Reconciliation: match your books to your bank statement, with uncleared items listed
- Mileage: business drives and the standard mileage deduction
- Tax Summary: one print-ready page grouped by IRS Schedule C line, for your accountant

HOW IT WORKS
1. Set up in 5 minutes: business name, year, sales tax rate. Keep the starter categories or add your own.
2. Record as you go: one row per sale or expense, categories picked from dropdowns.
3. Read your numbers: P&L, dashboard, sales tax and tax summary fill themselves in. Once a month, match your bank.

WHAT MAKES IT DIFFERENT
- Your categories, not a fixed list: 8 income and 25 expense categories to start, room for 40 and 60. Add one and it appears in every dropdown and report.
- A real bank reconciliation: statement balance vs your books, uncleared deposits and payments listed, and the difference shown until it is zero.
- Built to stay fast: no volatile or array formulas; every report adds up fixed ranges, so a full year of entries recalculates instantly.
- Ready for tax time, not just tidy: Schedule C line mapping, deductible % per category, sales tax tracker, receivables aging, mileage log and a one-page summary for your accountant.
- Simple to use: one Start Here page, three steps, and the same color rule on every tab.
- Works the same everywhere: every formula was tested in LibreOffice and uses only functions that Excel and Google Sheets share. No macros.

FILE FORMAT
You receive one ZIP file containing:
- Small_Business_Bookkeeping_PL.xlsx (Excel 2010 or later, Excel for Mac, LibreOffice)
- Quick_Start_Guide.pdf (6 pages)
Google Sheets: upload the .xlsx to Google Drive, right-click it and choose Open with Google Sheets. Formulas and dropdowns carry over; Google redraws the charts, so they may look slightly different.
Apple Numbers can open the file but is not supported.

Digital download, nothing is shipped.

Because this is a digital file, returns and exchanges aren't accepted. If something isn't working, message me and I'll help put it right.

Not tax advice. The workbook organizes your records; check current IRS rules and confirm how items are reported with your tax professional.

Designed by WrenWorks with AI assistance.