Small Business Bookkeeping Spreadsheet — Income, Expenses, P&L & Sales Tax (Excel + Google Sheets)

Bookkeeping for people who don't want bookkeeping software.QuickBooks is overkill for a one-person business. A shoebox of receipts is the opposite problem. This spreadsheet is the middle path: type what you earned and what you spent, and your P&L, dashboard, and sales-tax estimates build themselves. No subscriptions, no bank linking, no learning curve.What's inside:📊 Dashboard — YTD revenue, expenses, net profit, profit margin, a month-by-month cash-basis net table, and your top 5 expense categories. All automatic.💵 Income log — date, invoice, customer, dropdown category, amount. 400 rows ready to go.🧾 Expense log — dropdown categories aligned with common Schedule C lines (Advertising, Software, Supplies, Travel, Meals, Rent, Insurance, Contractors, Fees, Utilities), so tax time is a copy-paste instead of a panic.📅 Monthly P&L — a real profit & loss statement, revenue and expenses by category across all 12 months. Every cell is a live formula.🏛 Sales tax estimator — set your rate once and see taxable sales and estimated tax owed per quarter.🗂 Editable chart of accounts — rename or add categories and every dropdown and P&L line updates automatically.Works with: Microsoft Excel (2016+) Google Sheets (File → Import → Upload) LibreOffice / Numbers Instant download. Lifetime use. Free updates.No spreadsheet skills needed — sample data shows you exactly how it works. Delete the samples, add your numbers, done.Note: this is a bookkeeping tool, not tax advice. Confirm rates, deductions, and filing rules with your state or a tax professional.Questions? Message me here on Gumroad — happy to help you set it up.

Found on Devadex — the discovery index for independent software the big search engines bury. More from gumroad.

Report this listing