---
name: thirteen-week-cash-forecast
description: "Use when the user wants a 13-week cash flow forecast built from pasted open receivables, open payables and known recurring payments, week by week, with every line marked known or assumed and the lowest cash week called out. Triggers: 13 week cash flow, cash forecast, will we make payroll, short-term liquidity, weekly cash."
metadata:
  lane: use
  requires: "none"
  source: https://harbinger.finance/skills/thirteen-week-cash-forecast
  updated: "2026-11-18"
---

# Draft a 13-week cash forecast from what you already know

Turn open receivables, open payables and the recurring payments into a week-by-week cash forecast that shows the lowest week and what it rests on.

## When to use it

When cash is tight, a lender asks for one, or an owner wants to know whether a payment can go out next month. A 13-week forecast is mostly bookkeeping: what's owed to you and when it's likely to arrive, what you owe and when it's due, and the payments that happen every period. The slow part is laying it out by week and keeping the arithmetic straight.

The assistant does the layout and the arithmetic. It doesn't know which customers pay late or which bills you can stretch unless you say so, and the prompt tells it not to invent sales that aren't in what you gave it.

**Where it works.** Any AI assistant. No setup.

## Ask the user for

- Cash on hand, and the date week 1 starts.
- Open receivables: customer, amount, due date.
- Open payables: vendor, amount, due date.
- Recurring payments: payroll, rent, loan payments, taxes, with amounts and dates.
- What you know about timing: who pays late, what can wait.
- The cash floor you don’t want to go below.

Ask for anything missing before you start. Never invent a figure to fill a gap.

## Do this

Carry out the request below. Fill each [bracketed] item from what the user gave you.

Build a 13-week cash forecast. Starting cash is [starting cash], and week 1 starts [date].

1. Lay out 13 weekly columns. Rows: receipts by source, disbursements by type, net change, ending cash.
2. Place each open receivable in the week it's due, moved by what I've told you about timing. Place each payable in the week it's due. Place every recurring payment in each week it falls.
3. Mark every line "known" (it's in the data) or "assumed" (you placed it from a pattern or from my timing notes). Don't add sales, receipts or costs that aren't in what I gave you. If the forecast needs new sales to be realistic past the open receivables, say so and leave the row empty for me.
4. Check the arithmetic: each week's ending cash is the prior week's plus the net change. Show the check.
5. Name the lowest week, and every week where ending cash is below [cash floor].
6. List the three assumptions that move the lowest week most, and what the lowest week becomes if each is wrong by two weeks.

Timing I know about:
[who pays late, what can wait]

Open receivables:
[paste]

Open payables:
[paste]

Recurring payments:
[paste]

## Before you hand it over

Tell the user which of these checks they still need to make:

- Tie starting cash to the bank, and the receivable and payable totals to your aging reports.
- Fill the new-sales row yourself. The assistant left it empty on purpose.
- Read every line marked assumed. Those are its guesses, not your data.
- Recheck the lowest week by hand before it goes to a lender or an owner.

The assistant drafts. The person whose name is on the work approves it.

## What a good answer looks like

*Illustrative figures for a made-up company. Weeks 4 to 13 not shown.*

| | Wk 1 | Wk 2 | Wk 3 |
|---|---|---|---|
| Receipts: receivables (known) | 18,400 | 6,200 | 27,500 |
| Disbursements: payroll (known) | (31,000) | 0 | (31,000) |
| Disbursements: payables (known) | (9,800) | (14,300) | (4,100) |
| Disbursements: rent (known) | 0 | (6,500) | 0 |
| Net change | (22,400) | (14,600) | (7,600) |
| **Ending cash** | **71,800** | **57,200** | **49,600** |

Check: 94,200 − 22,400 = 71,800; 71,800 − 14,600 = 57,200; 57,200 − 7,600 = 49,600.

**Lowest week: week 7, at 31,900**, below your 40,000 floor in weeks 7 and 8.

**New sales.** Open receivables run out in week 6. I've left a "new invoices collected" row empty from week 7. Without it the forecast understates receipts.

**What moves week 7**
1. Northfield's 27,500 (assumed week 3, 20 days late). Two weeks later: week 4 drops to 22,100.
2. The quarterly tax payment of 18,000 (known, week 7).
3. The equipment vendor's 12,400 (known, week 6). Paid two weeks later, week 7 is 44,300.

---

From the Harbinger FinLab skill library: https://harbinger.finance/skills/thirteen-week-cash-forecast
