13-Week Cash Flow and Unpaid Invoices | Excel Starter Workbook

See upcoming cash gaps before the week arrives.

Small businesses planning near-term cash using a dated opening balance.

WHAT YOU CAN DO

- Plan 13 weekly opening and closing balances

- Track expected invoice collections

- Schedule other cash in and cash out

- Compare forecast cash with a chosen buffer

WHAT YOU RECEIVE

Includes a clean Excel workbook, a fictional guided practice workbook, a four-page Quick Start PDF, README and use terms. 250 prepared records per input sheet. Macro-free .xlsx files. Microsoft Excel and a desktop or laptop are required; software is not included. One currency per file. No integrations, automatic imports or ongoing data service.

SETUP

Set Overview B6 to the first Monday of the forecast. Enter cash available immediately before that date in B8 and your minimum cash buffer in E6. Invoice paid-to-date amounts must use the same opening snapshot.

SCOPE & REQUIREMENTS

A forecast, not a bank reconciliation or accounting ledger. One expected collection date per invoice balance. Updating the opening week requires the rollover steps in the guide.

Google Sheets, Apple Numbers and mobile use are not supported release targets. A single business may make internal working copies; resale or redistribution of the template is not included.

Start with the guided practice file, then enter your own records in the clean file. Contact Bear Digital through Payhip for file support.