Small Business Bookkeeping Starter - P&L, Cash Flow, Receipts (Excel & Sheets)

Run your numbers without accounting software. This Excel & Google Sheets workbook is a simple cash-basis bookkeeping system for sellers, freelancers and micro-businesses: log each sale and expense once and get a monthly profit & loss, cash flow and a month-end close checklist.

What's inside

• Transactions sheet: 1,500 rows with dropdowns for type, category and payment method, receipt-saved flag and cash effect
• P&L: monthly income and expenses by category, net profit and margin
• Cash Flow: opening cash, money in, money out and closing cash for every month
• Month-End Checklist: 8 close tasks x 12 months, months turn green when complete
• Dashboard: income, expenses, profit, margin, cash, missing receipts, top expense categories and 2 charts
• Setup sheet: business name, year, opening cash and your category lists
• Start Here guide in every file

You get: a BLANK workbook and an EXAMPLE workbook (a candle shop's year) with sample data that is easy to clear.

Works in: Excel 2010+, Microsoft 365, Excel for Mac and Google Sheets (upload the .xlsx, Open with Google Sheets). Standard formulas only, no macros.

Instant DOWNLOAD. For your own business use.

Disclaimer: A simple record-keeping template, not accounting, tax or legal advice. It does not replace professional bookkeeping where the law requires it.