Small Business Bookkeeping Spreadsheet – Income, Expenses & P&L

Simple bookkeeping for freelancers, crafters and side hustlers. Log your sales and expenses, and the spreadsheet works out your monthly profit, how much to set aside for taxes, and how much sales tax you owe.

This is a starter bookkeeping spreadsheet, not a 50-tab accounting system. You get one clean workbook with 10 tabs. Type in the cream cells and the grey cells calculate on their own. The formula cells are protected so nothing breaks. It works in Microsoft Excel and Google Sheets (free), with no macros, add-ins or subscriptions.

What's inside (10 tabs):

• Dashboard: YTD income, expenses, net profit, margin, tax set-aside, sales tax collected and due, unpaid invoices, deductible expenses, missing receipts, inventory value, best month, top clients, and 2 charts
• Income: up to 300 entries with date, client/source, description, category, amount, taxable?, auto sales tax, payment method, invoice # and paid?
• Expenses: up to 400 entries with date, vendor, description, category, amount, payment method, tax-deductible? and receipt?
• Monthly P&L: Jan–Dec income, expenses, profit, margin, tax set-aside, sales tax and running profit, plus category × month breakdowns
• Sales Tax: taxable vs non-taxable sales, tax collected, tax remitted, and running balance due
• Simple Inventory: up to 50 products with SKU, cost, price, qty on hand, reorder point, inventory value and margin
• Clients: up to 40 clients or channels with billed, paid, balance and last sale (all from Income)
• Categories: editable income and expense categories and payment methods for every dropdown
• Settings + Start Here: business name, year (2026 by default, ready for 2027), tax set-aside %, sales tax rate, and a 6-step quick start

You get: 2 .xlsx files (instant download): a blank workbook ready to use, and a sample version filled with a fictional side hustle ("Maple Street Templates").

Record-keeping tool only, not tax, legal or accounting advice. This is a digital download. No physical item will be shipped.