Small Business Finance Bundle, Complete Accounting Suite, Excel Templates, Auto-Calculating Spreadsheets

Running a business means juggling expenses, sales, cash flow, and client profitability all at once. This suite gives you six purpose-built spreadsheets, one for each part of that picture, each pre-built with the formulas and structure you need. Enter your data once per file and watch the totals calculate.

WHAT YOU GET (6 workbooks, 27 tabs, 1947 formulas)

START HERE: A walk-through of the entire bundle. What each file does, which one to open first, and which settings you need to enter in each workbook. Read this first.

FINANCE KIT: Invoicing, a client list, an invoice log, expense tracking, and a live Dashboard in one file. Pick a client from a dropdown, build a print-ready invoice, and log it to track what is paid, sent, or overdue. The Dashboard pulls it together automatically: total revenue, total expenses, net profit, outstanding receivables, overdue invoices, tax position, revenue by month, expenses by category, and your top 5 clients by revenue. 7 tabs, 913 formulas. This is the most complex file in the suite; Start Here explains it step by step.

EXPENSE TRACKER: Every business expense (date, category, vendor, amount, tax, deductibility status). 4 tabs, 267 formulas, 200-row buffer. Breaks down totals by category and by month. Includes a customizable category dropdown.

SALES TRACKER: Every sale you close (customer, date, what you sold, quantity, unit price). 4 tabs, 289 formulas, 200-row buffer. Shows revenue by month and by customer. Includes a customizable customer dropdown.

CASH FLOW FORECAST: List every expected source of cash in and cash out, then fill in the amount for each of the next 12 months. 4 tabs, 135 formulas. Shows your running balance month by month and flags the lowest point the forecast expects, and when.

CLIENT PROFITABILITY: Track revenue, hours spent, and direct costs per client, with profit, effective hourly rate, and margin calculated automatically. Flags any client below your target rate or your healthy margin threshold. 4 tabs, 343 formulas. Useful for freelancers and service businesses.

HOW IT WORKS

1. Download and extract all 6 files. Open Start Here first (it explains what you need to know).
2. Open Settings in each workbook and fill in your business name and currency symbol; some files also ask for a tax rate, a starting balance, or your target hourly rate. Each file reads from its own Settings tab.
3. Go to the main tracking tab in each file (Expenses, Sales, etc.) and add your rows. Every row total is a formula, so totals calculate as you type.
4. Check the Summary tabs in each file any time. Totals, breakdowns, and forecasts are all formulas reading from your entries, so they update instantly.

WHAT YOU NEED

Microsoft Excel or Google Sheets with no macros, no add-ins, and no other software required. Colored cells are the only ones you ever touch; white cells are formulas. Nothing in these workbooks is locked or password-protected, so you are always free to inspect or adjust a formula if you want to.

A note on Google Sheets: every formula in these workbooks was checked individually and uses only functions Google Sheets also supports. No XLOOKUP, no dynamic arrays, nothing Excel-only. Upload each file to Drive and open it with Google Sheets, not in Drive's preview window. I build and test in Excel, so I will not promise you a pixel-perfect Sheets import. The dropdowns and date formats are worth a quick look after import, since the two programs render them differently.

WHAT THIS ISN'T

These are not connected workbooks. Business Name and Currency Symbol must be entered separately in each file's Settings tab. There is no one-click sync between files; if you change your business name, you change it in five places. This is a limitation of Excel and Google Sheets at this price point (true integration requires a dedicated app or database). The files are designed to work side by side, not to replace manual data entry or a proper bookkeeping app. This is not tax or accounting advice, not accounting software, and not a substitute for a bookkeeper or accountant. Deductibility is only what you mark yourself; deductibility rules vary by country and business type. The Cash Flow Forecast only reflects the amounts you enter each month; it is not a guarantee of future income. Not a subscription. One purchase, six files, yours to keep with no login and no recurring fee.

INSTANT DOWNLOAD

You get 6 .xlsx files delivered immediately after purchase with no waiting for an email. Each file arrives pre-filled with realistic example data so you can see every formula working before you change anything. Start Here explains exactly which rows to clear and which to leave alone. All 1947 formulas were recalculated in Excel and checked cell by cell; zero error values anywhere in the suite. Questions before you buy? Send a message and I am happy to help you work out whether this fits how you actually run things.