Small Business Cash Flow Tracker: Excel + Google Sheets, No Macros

By ZMS Store

Free

ABOUT THE PAGE

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

CONTACT ME FOR ANY ISSUES OR QUERIES
zerominutestudio@gmail.com
Invite your network