Small Business Bookkeeping Spreadsheet Bundle

Everything a solo business needs to keep its books in one workbook.

FEATURES

• Invoices with aging and partial payments (payments counted in the month paid)

• Other-income log for marketplace payouts and cash sales

• Expense log with categories, and mileage log with 2026 IRS rates (current as of Oct 2026; confirm at irs.gov)

• Annual P&L by month plus a quarterly view with the usual due dates and an informational self-employment tax line, for the tax year you choose; includes an Education category; expense totals by category (with an 'Other / not in list' line so totals reconcile) and receivables aging

• Overpayments shown as credits; business meals counted at 50% (editable)

• Tax set-aside line at a % YOU choose (no rate recommended); annual figure = your % × annual net profit

WHAT YOU GET

• 1 Excel (.xlsx) file, plus a PDF with a Google Sheets 'Make a copy' link and setup steps

• Works in Microsoft Excel 2016+ and free Google Sheets (desktop recommended for setup)

• Instant digital download. No physical item will be shipped.

LICENSE: One license = use by one person or one business (including its employees and contractors) for its own records. You may edit the file and send documents you create with it (invoices, quotes) to your clients. You may not resell, share, give away or redistribute the template or its 'Make a copy' link, in original or modified form, or use it to create templates for sale. Need it for multiple businesses? Message me for a multi-business license. © 2026 Sheetsmith Studio. All rights reserved.

RETURNS: Because this is a digital download, returns and exchanges aren't accepted. If your file won't open or something isn't working, message me and I'll fix or replace it, or help you get set up. This doesn't affect your statutory rights. Your files are available under Purchases & Reviews after payment.

TRADEMARKS: Microsoft Excel is a trademark of Microsoft Corporation; Google Sheets is a trademark of Google LLC. Other platform names mentioned are trademarks of their respective owners and are used only to describe compatibility. Sheetsmith Studio is not affiliated with, sponsored or endorsed by any of them.

AI disclosure: This template was designed with the help of AI tools (layout ideas, formula drafting and description writing). Every formula was then built, tested and checked by Sheetsmith Studio before listing.

Please note: This is an organizing tool, not tax, legal, accounting or financial advice, and it doesn't calculate tax owed. Results depend on the numbers you enter. Talk to a qualified professional about your own situation.