Small Business Budget Spreadsheet, Profit and Loss Tracker, Excel Google Sheets, Income Expense Tracker, Budget vs Actual, Cash Flow Sheet

Know exactly where your business money goes, and how much profit you are really making.

The Small Business Budget & Profit Tracker is a ready-to-use spreadsheet for freelancers, solo founders, shop owners and small teams. Log your sales and expenses once. The monthly budget, profit and loss statement, cash flow and dashboard charts all update on their own.

Works in Microsoft Excel and Google Sheets. No macros, no add-ons, no subscription.

━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE (8 connected sheets)
━━━━━━━━━━━━━━━━━━
1. START HERE: a 5-step guide, plus your business name, currency symbol, year and fiscal year start month
2. SETTINGS: 10 income and 10 expense categories with room for more, payment methods and your tax set-aside rate. Rename them to fit your business
3. TRANSACTIONS: 500 ready rows with Type, Category and Payment Method dropdowns. A category that doesn't match the type is flagged
4. MONTHLY BUDGET: budget vs actual for every category and every month, plus annual variance and % of budget. Colour flags show when you overspend
5. PROFIT & LOSS: monthly income and expenses by category, net profit, profit margin, a tax set-aside line, profit after set-aside, cumulative profit and year totals
6. DASHBOARD: 8 key numbers (income, expenses, net profit, margin, best month, biggest expense, tax set-aside, unpaid invoices) and 3 charts that update automatically
7. CASH FLOW: opening balance, money in, money out, owner draws, loan and tax payments, and a monthly closing balance with a chart
8. INVOICE TRACKER: each invoice shows Paid, Unpaid or Overdue automatically, with days overdue and totals outstanding

━━━━━━━━━━━━━━━━━━
ALSO INCLUDED
━━━━━━━━━━━━━━━━━━
• Setup Guide (PDF): step-by-step instructions with screenshots, tips and troubleshooting
• Setup video: watch the listing video and the full walkthrough on our YouTube channel (@notionmarkethub)

━━━━━━━━━━━━━━━━━━
WHY YOU'LL LIKE IT
━━━━━━━━━━━━━━━━━━
✓ Everything is calculated by formulas, so nothing is typed in by hand
✓ Light-blue cells are where you type. Everything else updates itself
✓ Use any currency symbol ($, €, £, A$, ₹ and more)
✓ Your fiscal year can start in any month
✓ Sample data is included so you can see how it all works. Clear it in a minute (the Start Here sheet shows you how)
✓ Calm navy and blue design that prints neatly

━━━━━━━━━━━━━━━━━━
HOW TO OPEN IT
━━━━━━━━━━━━━━━━━━
• Excel: download the .xlsx file and open it (Excel 2010 or newer, Windows or Mac; also Excel for the web).
• Google Sheets: go to sheets.google.com and open a blank spreadsheet. Choose File > Import > Upload, select the .xlsx file, then choose "Replace spreadsheet". It works straight away in your Google Drive.
• Also opens in Apple Numbers and LibreOffice, though charts and colours may look slightly different.

━━━━━━━━━━━━━━━━━━
PLEASE NOTE
━━━━━━━━━━━━━━━━━━
• This is a digital download. Nothing physical will be shipped.
• The tax set-aside is a planning estimate based on the rate you choose (25% to start with). It is not tax or accounting advice.
• Because it's a digital file, refunds aren't available. If anything doesn't work, message me and I'll help.
• For personal or single-business use. Please don't resell or share the file.

Made by Create Digital Tools · createdigitaltools.com