Small Business Cash Flow Dashboard — Solo Business Cashflow & A/R OS

When client invoices arrive late while bills still have due dates, today’s bank balance alone can hide a cash squeeze. This manual Excel workbook is for freelancers and one-person businesses that need to see what is owed, when cash may fall below their own reserve floor, and what to follow up on first.

WHAT IT HELPS YOU DO

• Track invoices, payments, overdue days, aging buckets, expected receipt dates, and follow-up dates.

• Forecast cash week by week across 13 weeks, including expected collections, recurring income, and committed outflows.

• See the first forecast week that falls below your chosen cash floor, and identify the outflows contributing to it.

• Calculate Safe to Spend from your own inputs and assumptions.

• Get ranked weekly actions to chase receivables, reserve for bills, or defer planned spending.

• Compare late-payment and next-quarter scenarios, then review forecast versus actual.

WHAT’S INCLUDED

• 27 worksheets total, including 19 business worksheets.

• DEMO workbook with fictional sample data and a CLEAN workbook for your own inputs.

• 15 CSV table files, a five-page Quick Start Guide PDF, README, and one-business license.

COMPATIBILITY

Designed for Microsoft Excel 2016 or later. Google Sheets, LibreOffice Calc, and Apple Numbers have not been independently tested.

LIMITS

This is a manual workbook: it does not connect to banks, sync calendars, send automatic reminders, or contact customers. Forecasts depend on the figures and assumptions you enter. It is an operational tracking tool, not accounting, tax, or legal advice.