Build a focused nine-week view of expected cash receipts, payments, and ending liquidity so you can see when the business may need action before a cash gap arrives.
This editable Excel workbook is designed for owners and finance teams that need more timing detail than a monthly forecast provides. Enter the cash movements expected in each week, organize incoming and outgoing amounts by category, and review how those assumptions move the beginning and ending cash balance across the forecast period. Because each week carries its ending balance into the next period, the schedule shows how one delayed receipt or concentrated payment can affect liquidity beyond the week in which it occurs.
Spot weekly cash pressure
See which projected weeks produce a negative or declining ending balance, giving you a clearer window for adjusting collections, payments, or spending.
Coordinate receipts and obligations
Place receivables, future sales, payables, recurring expenses, and transfers into the weeks when cash is expected to move.
Test near-term changes
Revise forecast inputs to examine the cash effect of different sales timing, expense amounts, supplier payments, or staffing-related outflows.
What can you analyze week by week?
The template brings short-term cash timing into one projection so you can connect operational assumptions with the balance expected to remain at the end of each week.
Opening liquidity: Start with the beginning cash balance that will fund the first week of the forecast.
Cash receipts: Schedule expected collections from accounts receivable, future sales, and manually entered receipt items.
Cash payments: Plan accounts payable and recurring expenses in the specific weeks when they are expected to be paid.
Net weekly position: Compare total cash received with total cash paid rather than relying only on revenue or profit measures.
Ending cash trajectory: Follow the calculated balance from one week into the next and identify projected shortfalls or excess liquidity.
What is inside the workbook?
The workbook centers on a single weekly cash-flow schedule. Editable forecast rows capture the timing of receipts, payments, recurring expense categories, and transfers. Calculated totals roll those entries into weekly cash received, cash paid, and ending cash balance figures. A right-side reference area also presents actual figures and compact trend lines for selected rows.
Weekly projection columns
Nine dated periods organize the forecast by week, making uneven collection and payment timing visible.
Structured cash categories
Separate sections cover receivables, sales-related receipts, payables, recurring expenses, and transfers.
Calculated balance roll-forward
Beginning cash, total receipts, total payments, and ending cash are connected across the forecast horizon.
The weekly schedule groups cash receipts and payments by category, then shows total inflows, total outflows, transfers, and the projected ending cash balance for each period.
Read the timing behind the cash balance
The worksheet separates cash activity into operational lines instead of presenting only a final total. This makes it easier to trace a projected deficit back to the specific week and category driving it. Negative ending balances are visibly highlighted, while the adjacent summary area provides a quick view of actual values and row-level movement.
How do you use the template?
Set the forecast timing
Confirm the as-of date and the weekly periods covered by the nine-week projection.
Enter opening cash and receipts
Add the beginning cash balance, expected receivable collections, future sales receipts, and other incoming cash by week.
Schedule payments
Enter accounts payable, recurring expense categories, and any transfers in the periods when cash is expected to leave the business.
Review ending balances
Check the calculated weekly totals and identify the first period where liquidity becomes tight or turns negative.
Revise assumptions
Adjust collection timing, sales inflows, payment dates, or expense amounts to evaluate practical responses to a projected cash gap.
Who is this template for?
This weekly cash flow template is suited to business owners, controllers, finance managers, and advisers who need a short-term liquidity view for operating decisions. It can support weekly cash meetings, payment planning, receivables follow-up, expense timing, and near-term scenario reviews. It is especially useful when cash movements are uneven within a month and a monthly total would hide the week in which pressure occurs. The format also helps teams discuss the same dated assumptions, rather than relying on separate notes about customer collections, supplier commitments, and recurring operating costs.
