Small Business Bookkeeping & Tax-Prep Spreadsheet

Keep clean books all year and walk into tax season with your numbers ready.

Receipts in a shoebox, income spread across three apps, and a scramble every April. Sound familiar? This spreadsheet gives freelancers and small business owners one place to record money in, money out, and business miles. It then builds your monthly profit and loss, quarterly estimated-tax figures, and a year-end summary automatically.

What's inside

• Income Log: date, category dropdown, client, amount, payment method, and invoice number.
• Expense Log: 16 editable expense categories, payment method, and a "receipt saved?" check that flags anything missing.
• Mileage Log: enter odometer readings or miles. The deduction uses the 2026 IRS business rates (72.5¢ per mile Jan 1–Jun 30, 76¢ from July 1), and both rates are editable for future years.
• Monthly P&L: income and expenses by category and month, with net profit and each category's share of income.
• Quarterly Estimated-Tax Worksheet: estimates self-employment tax plus federal and state income tax for each IRS payment period, using rates you enter. Track what you paid and see a suggested set-aside percentage.
• Annual Summary: year totals by category, miles, mileage deduction, estimated tax vs. paid, and charts that are easy to hand to your tax preparer.

Built to be easy to use

• Colour-coded cells. Yellow cells are for your inputs and lavender cells hold formulas, so the math stays intact.
• Labeled example data. Pink example rows show how each sheet works. Delete them when you're ready to start.
• Frozen headers, filters, dropdowns, and print-ready layouts on every sheet.
• PDF mini guide that walks you through setup, monthly review, and year-end.

Who it's for: freelancers, sole proprietors, side-hustlers, creators, and small service businesses who want simple bookkeeping without accounting software.

Format: Instant digital download (ZIP) containing an XLSX spreadsheet for Microsoft Excel, Google Sheets, or LibreOffice Calc, plus a PDF mini guide. This is a digital product; nothing will be shipped.

Please note: this spreadsheet is not tax advice. The estimated-tax worksheet gives rough planning estimates based on rates you enter. It does not cover every rule, such as credits, deductions, wage-base limits, or state specifics. Confirm amounts with a qualified tax professional or the IRS.