Small Business Cash Flow Tracker: Excel + Google Sheets, No Macros
By ZMS Store
Free
By ZMS Store
Free
Know exactly where your business cash stands. This Excel and Google Sheets tracker turns a simple log of money in and out into a live dashboard with your cash balance, monthly results, runway and a 6-month forecast, so you see a cash crunch before it arrives.
What's inside:
1. Dashboard: cash balance, income, expenses and net for the month, average monthly net, runway in months, year-to-date margin, low-cash warnings, two charts and your top 5 expense categories
2. Transactions: log up to 1,000 payments; pick Income or Expense and the category list adjusts
3. Cash Flow: 12 months side by side with opening balance, income and expenses by category, net cash flow and closing balance (prints on one page)
4. Forecast: projects the next 6 months from your last 3, with growth rates and one-off items such as a tax bill or a big purchase
5. Settings: opening cash, first month, alert level and your own categories
6. A sample file (fictional studio, 10 months) and a blank file, plus a 2-page Quick Start PDF
Works in Microsoft Excel 2010+ and Google Sheets. No macros, no add-ins. Any currency. Formulas are unlocked so you can adapt it.
Good to know: for your own business use only; please don't resell or share the files.
You get an instant download after payment.
We don't do refund & return ✌️
Zero Minute Studios