How Does a Founder Build a 13-Week Cash Forecast?

Our guide to what a founder's weekly scorecard should track explains why cash is read first and how the cash block is calculated. This page builds the forecast that the cash block depends on.

What is a 13-week cash forecast, and why thirteen weeks?

A 13-week cash forecast estimates receipts and payments for each of the next thirteen weeks, starting from a verified cash balance. Finance teams call this the direct method, because it follows money entering and leaving the bank.

Thirteen weeks covers roughly one quarter. That span takes in several payroll cycles and the quarterly payments that disappear inside monthly averages. The near-term weeks can be grounded in invoices, contracts and payment calendars, and the later weeks can show a projected shortfall and how much time remains before it arrives.

A profit forecast follows accounting rules for when income and expenses are recognized, so it can place an item in a different month from the day the money moves, and it leaves out payments such as loan principal. A cash forecast needs the dates money will enter and leave the bank.

The forecast stays thirteen weeks long because it is rolled forward every week. Its usefulness depends on updating those dates as new information arrives.

What do you need before you start?

Choose a fixed weekly cutoff, such as Friday's close of business. Gather balances at that cutoff for every bank account included in your definition of cash. Identify restricted funds separately, so money unavailable for operating payments does not inflate the opening balance.

Collect the receivables ledger, including invoice amounts, due dates, disputes and recent collection notes. For larger customers, check how they have paid in the past. A customer who pays after a monthly approval meeting needs a different receipt assumption from one who pays as soon as an invoice arrives.

You also need the payables list, the payroll calendar, tax and loan schedules, rent commitments, recurring subscriptions and known one-off payments. Check annual insurance renewals, equipment purchases, deposits and owner distributions. Confirm the date payroll funding leaves the bank, which may come before employees' payday.

If the books are behind, begin with bank activity and supporting records. Outstanding invoices, supplier statements and the payroll provider's schedule can support a first version. Mark missing information for follow-up. An incomplete payables list needs an explicit estimate and an owner who will verify it.

How do you build the forecast step by step?

Use a spreadsheet with thirteen dated weekly columns. Put receipt and payment categories in rows, with opening cash at the top and closing cash at the bottom. Keep a short note beside any assumption someone may need to question.

1. Set the opening balance

Use the same cutoff, account scope and definition of cash as the scorecard's cash block, which starts from bank balances and deducts payments already issued that have not yet cleared. Reconcile the starting figure to the bank records. Because those issued payments are already out of the opening balance, leave them out of the payment rows when they clear the bank, so each payment reduces cash once.

Apply the same availability test in every later week. Leave restricted receipts out of operating cash, record a new restriction as a reduction in available cash, and include a release only when its timing is supported.

Transfers between included bank accounts do not change combined cash. If you show them for account-level tracking, eliminate them from the company total.

2. Schedule expected receipts

Give larger customer balances their own rows. Put each receipt in the week the money is expected to become available, using payment history and current collection information. An invoice due date is evidence, and a customer's paying habit can point to a later week.

Group smaller receipts where that keeps the forecast readable. Forecast card receipts in the week the processor is expected to settle them, at the amount it will deposit, and enter fees as a separate payment only when they are not already withheld from that deposit.

Later weeks may include collections from work not yet invoiced. Estimate those from scheduled work or supported sales assumptions, allowing time for invoicing and payment, and make sure a future invoice is not counted again once it reaches receivables. Mark uncertain receipts so the founder can test the effect of a delay.

3. Enter payments on their own calendars

Separate payroll, suppliers, rent, taxes, debt service and other material categories. Use the dates payments will leave the bank. Include both principal and interest on loans, plus known purchases that have not reached the payables ledger.

Follow agreed supplier terms. If a different payment date needs the supplier's agreement, keep it as a proposed action until the supplier confirms it. Spreading a quarterly payment evenly across thirteen weeks would hide the week you need the cash.

4. Calculate each closing balance

Closing cash for each week equals opening cash, plus cash received during the week, minus cash paid during the week. Link the next week's opening cash directly to the previous closing balance and continue through week thirteen. Keep financing receipts and repayments on their own lines, so the effect of borrowing stays visible.

5. Find the lowest balance and compare it with the floor

Find the lowest weekly closing balance and the week it falls in. Then flag every week that closes below the cash floor agreed by the leadership team.

Set that floor from the company's obligations and its exposure to late payments. It is a management threshold for action, and no single amount suits every business. Keep any lender requirement separately identified, and confirm how it is measured with the lender or the company's accountant.

What does a completed forecast look like?

The table below is illustrative arithmetic for a services company, in thousands of dollars. The balances, the payment pattern and the $50,000 cash floor are invented for explanation and imply no benchmark. To keep it readable, ordinary payments are combined into one column, and a working forecast would show their categories, payroll included. A quarterly tax payment falls in week four.

Week four closes at $40,000: $110,000 of opening cash, plus $50,000 received, less $120,000 paid. That is the forecast minimum, and it sits $10,000 below this example's floor.

Across the thirteen weeks, receipts total $670,000 and payments total $700,000, so the company ends at $70,000 after using $30,000 over the period. An average weekly burn spreads that $30,000 evenly across the quarter and hides the dip in week four.

The larger collection in week five restores cash after the tax payment, and its timing matters. Moving it into week four without evidence would make the forecast look more comfortable and leave the payment problem unresolved.

How do you update it each week?

Save a dated copy before changing anything. You need the forecast issued last week to judge what happened in the week that has ended.

Enter the week's actual receipts and payments, using the same categories and the same definition of cash as the forecast. Check that opening cash plus the actual net movement equals closing cash under that definition, meaning the bank balance less payments issued and not yet cleared, and resolve any unexplained difference before carrying the balance forward.

Compare actuals with last week's forecast line by line. For each receipt and payment category, record the forecast, the actual, the difference, its cause, and any revised payment or collection date. As an illustration, if the forecast showed $30,000 arriving from one customer and $18,000 arrived because one invoice is in dispute, the record shows a $12,000 shortfall, the dispute as the cause, and the week the balance is now expected.

Ask the owner to explain any difference large enough to change a payment decision or the expected minimum. A missed customer receipt and a delayed supplier payment can cancel each other out in the total while leaving two assumptions wrong.

Separate changes in timing from changes in amount. A customer paying next week moves a receipt to a later column. A disputed invoice may reduce it. A payment that cleared early comes out of the week it was forecast for, so it is not counted twice.

After recording the comparison, remove the completed week from the forward view and keep it in the history. Refresh the remaining twelve weeks, add a new week thirteen, and use the actual closing cash as the new opening balance.

The variance record shows which assumptions deserve confidence. Repeated late receipts from one customer should change that customer's collection timing in the forecast. Add a short note on any material revision, so the founder can see why the projected minimum moved.

What should you read in the weekly meeting?

The forecast is read with the cash block at the start of the weekly scorecard. Read the expected closing balance for the current week first. Then find the lowest closing balance across the thirteen weeks, its date, and any week below the floor. Finish with the largest variance from the week that ended, and its cause.

Keep the review tied to decisions. A forecast minimum that depends on one uncertain customer receipt deserves attention even when it stays above the floor. Ask the owner to show what happens if that receipt slips by a week or two.

When a breach appears, start with overdue collections. Confirm whether the invoices are approved for payment and get credible payment dates. Next, discuss timing with suppliers whose terms could change by agreement, and review discretionary spending that can move without creating a larger operating problem.

Talk to the bank early if those actions leave a funding gap. An approaching shortfall may call for several of these conversations at once, as soon as the forecast shows it. Take tax timing, lending conditions and covenant questions to the company's accountant or lender.

Give each agreed action one owner and a completion date. Update the forecast once there is evidence the action will change the timing of cash, and keep a hoped-for extension visible as an assumption until it is confirmed.

Weekly closing balances can miss a shortfall inside a week. If payroll leaves on a Wednesday and a large receipt is due on the Friday, check the daily timing around those two transactions.

Which mistakes make the forecast unreliable?

Starting from a profit and loss forecast can leave out cash movements or put them in the wrong period. Use it as supporting information where it helps, then check each receipt and payment date against the underlying records.

Putting every customer receipt on its invoice due date creates false confidence when payment history says otherwise. Record an expected collection date and the evidence behind it, and follow up on overdue balances before moving them forward again.

Missing quarterly and annual payments produces a forecast that looks strongest in the weeks before a large obligation. Review the tax calendar and renewal dates, including commitments that have not generated an invoice yet.

Treating an undrawn credit line as cash inflates the opening balance. Record available borrowing separately, with its conditions. An expected draw belongs in the forecast as a financing receipt in the week it is expected to arrive, once its availability is confirmed.

Sharing ownership across several people lets omissions persist. One person is accountable for completing the update, even when colleagues supply the inputs.

Skipping the variance check keeps weak assumptions in place, and overwriting last week's estimates without saving them destroys the evidence needed to improve them. Keep enough history to see recurring errors by customer or by payment category.

Who should own the forecast?

Assign one owner who can obtain the records and explain the assumptions. In a smaller company that may be the founder, or a bookkeeper working directly with the founder. A controller can take it on as the finance function grows.

Ownership includes keeping the dated versions and resolving missing inputs before the weekly review. The founder stays responsible for decisions about spending, collections and funding.

Agree when colleagues must report changes that affect cash. A new hire, a purchase commitment or a revised customer payment date needs to reach the forecast owner before the next review, on a deadline that matches the weekly bank cutoff.

If nobody inside the company can produce and maintain a credible version, our guide on when a founder needs a fractional CFO or COO covers how to assess the finance capacity the company needs.

Where should you start this week?

Choose one owner and a weekly cutoff, and gather the bank balances and supporting records. Build thirteen dated weeks of expected receipts and payments, agree the cash floor with the leadership team, and save the first version so next week's comparison has something to measure against. This is the weekly cash read we install through the Founder Blueprint, where the forecast's lowest balance is read with the cash block at the top of every weekly scorecard.

Frequently asked

Next step

If the harder question is whether the company can run its weekly cash read without you, the Leadership Scorecard is a ten-minute self-assessment across twelve leadership dimensions and the six drivers of founder-led growth, and it shows where the company still depends on you.