Small Business Bookkeeping Spreadsheet with Profit & Loss

Who it’s for

It’s made for US solopreneurs, makers, cleaners, freelancers and small service businesses who want to get off the shoebox and be ready for tax season, without paying for accounting software they only half use.

You keep your own categories: 8 income and 25 expense categories to start, with room for 40 and 60. Add one on Setup and it appears in every dropdown and report. If your business year doesn’t start in January, set the start month and every monthly report follows it.

What’s inside, tab by tab

Start Here

Three steps and one colour 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

A 1,000-row ledger with category, payment method and Paid? dropdowns.

Expenses

A 1,500-row ledger. Meals default to 50% deductible.

Invoices (AR)

An 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, with net profit, cumulative profit and margin.

Dashboard

Eight key numbers, an income vs expenses chart, cumulative profit and your top 10 expense categories.

Sales Tax

Collected vs paid to the state by month and quarter, and what you owe now. Leave the rate at 0% if you don’t collect it.

Reconciliation

Match your books to your bank statement, with uncleared items listed and the difference shown until it is zero.

Mileage

Business drives and the standard mileage deduction.

Tax Summary

One print-ready page grouped by IRS Schedule C line, for your accountant.

Excel and Google Sheets

The workbook is an .xlsx file that opens in Excel 2010 or later, Excel for Mac and LibreOffice. For 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 can look slightly different. The quick-start guide walks you through it.

There are no macros and nothing to install. Every formula uses only functions that Excel and Google Sheets share, and before release the workbook was filled with a sample business year and checked by 80 automated tests. Apple Numbers can open the file but isn’t supported.

How delivery works

You buy on Etsy, with Etsy’s checkout and buyer protection. As soon as payment goes through, the download is ready on your Etsy Purchases page and Etsy emails you a link. You get one ZIP file containing:

• Small_Business_Bookkeeping_PL.xlsx
• Quick_Start_Guide.pdf (6 pages)

Nothing is shipped. Because it’s a digital file, Etsy returns don’t apply, but if something isn’t working, send a message through the shop and we’ll help put it right.

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