How to Build a Simple 13-Week Cash Forecast Template

Spot payroll shortfalls before payday

A 13-week cash forecast gives a rolling, week-by-week view of your actual cash over the next 90 days.

It uses the direct method to track cash moving in and out of your bank accounts.

That weekly granularity helps you spot payroll funding gaps weeks before they become crises.

We’ll walk you through building a simple, spreadsheet-based, payroll-focused 13-week template you can update each week.

Grab the companion template to follow along and start flagging shortfalls, adjusting payment timing, and making confident cash decisions.

Gather the exact inputs and where to pull them this week

Start with one goal: make your 13-week forecast reflect real cash in the bank, not accrual balances or guesses.

Below are the core weekly inputs to put in your template and the best places to source each number.

Core weekly inputs and where to find them

• Opening cash position. Use reconciled bank balances or bank feeds so your starting line equals actual available cash.
• Cash inflows. Pull open invoices from your accounting system and use CRM or contracts for signed sales that have not invoiced yet.
• Payroll and payroll taxes. Use payroll registers for gross wages, withheld taxes, employer taxes, and benefit deductions.
• Accounts payable and regular bills. Export upcoming vendor payments from AP aging or your accounting software to schedule disbursements.
• Capital expenditures and irregular spends. Place planned capex and known vendor draws in the exact week you expect the bank debit.
• Financing activity. Add scheduled debt payments, line draws, or injections as dated cash events rather than spreading them out.

Separate payroll line items so you never miss a debit

Payroll is often the largest weekly cash outflow, so split it into clear rows.

List gross payroll, employee tax withholdings, employer payroll taxes, benefits and 401(k) deferrals, and contractor payouts as separate lines.

Map payroll tax deposits and recurring compliance payments to their actual debit dates in the weekly columns.

We recommend keeping these in a recurring payment register rather than averaging them monthly so you know which week will hit the bank.

Simple, defensible ways to estimate AR collections

Use historical behavior and customer-level facts instead of guesses to project weekly collections.

• Weighted-average DSO by customer or segment. Calculate how long each customer usually takes to pay and apply those patterns to open invoices.
• Customer risk scoring. Assign probabilities to receivables based on payment history, disputes, and credit risk, then apply those percentages to balances.
• Direct confirmation for material items. If a major client promises a week-four payment, record it at 100 percent for that week.

Cleaning up inputs makes forecasting simple. Our month-end checklist helps you produce reliable numbers, and outsourcing bookkeeping can keep those inputs accurate and repeatable.

For a ready-to-use guide, see our month‑end checklist and our article on when to outsource bookkeeping for ways to keep your forecast honest.

Design a clear grid and automations so weekly updates take minutes

Want a 13-week sheet you can update in minutes each Friday? Keep the layout strict and the formulas simple.

Use a vertical list of labelled rows and horizontal week columns. Reserve the first column for labels and the next 13 columns for sequential weeks.

Build a waterfall from a beginning balance through inflows and outflows to an ending balance. That ending number becomes next week’s beginning balance.

Sheet sections and must-have rows

Group related items so scanning is fast. Keep recurring, high‑impact items in dedicated rows for repeatable entry.

• Opening balance. Reconcile this weekly to your cleared bank balance before you start.
• Inflows. Include AR collections, cash sales, and confirmed receipts in their own rows.
• Outflows. Break payroll into gross wages, employee taxes, employer taxes, benefits, and contractor pay.
• Other payments. Put rent, utilities, loan payments, and capex each on their own lines.

Automations, shortfall alerts, and rolling the weeks

Use basic functions so the sheet stays robust. SUM and SUMIFS handle totals and filtered sums.

XLOOKUP or VLOOKUP pulls recurring amounts from a master tab. IF statements plus data validation create scenario switches.

• Conditional formatting to flag ending balances below your payroll or reserve threshold.
• A Scenario Switch cell to toggle conservative or base assumptions across weeks.
• Lock formula cells and color inputs so you never overwrite calculations by accident.

1. Reconcile the opening cash balance to your bank so the forecast starts from a trusted number.
2. Replace the completed week with actuals and record a variance row to learn from errors.
3. Drop the done week, shift columns left, and add a new Week 13 at the far right with the same formulas.
4. Review alerts and adjust driver assumptions, like collection timing or payroll needs, before you publish the updated forecast.

Keep the sheet lean. Fewer line items, consistent data entry, and clear color cues make weekly updates fast and trustworthy.

If you want broader KPIs that tie to your 13-week view, see our monthly dashboard guide for next-level monitoring: Monthly Financial Dashboard Template.

Record irregular cash in the week it clears and test three scenarios

Ever had a big invoice land in the same week you run payroll and felt your heart drop? Place each irregular receipt or payment in the exact week it will clear the bank.

Don’t smooth seasonal spikes or annual bills across months. Use at least 24 months of history and apply realistic collection rates to open receivables.

Build best, expected, and worst cases with simple toggles

Create a base case that reflects normal collection behavior. Then copy the sheet for upside and downside scenarios.

Add a Scenario Switch cell that changes collection rates or delays expense timing across all weeks. That toggle shows how many weeks of payroll runway you have.

Immediate actions to cover a projected payroll shortfall

• Draw on an existing business line of credit so you have immediate, flexible cash.
• Use invoice factoring to convert unpaid B2B invoices into near‑term cash within 24 to 48 hours.
• Negotiate extended payment terms with key vendors to shift outflows until receivables arrive.
• Defer discretionary spending and noncritical capex until your payroll needs are secure.
• If you must alter payroll timing, communicate transparently with staff and document agreements to avoid compliance risks.

Controls and documentation that make your forecast trustworthy

• Anchor each week to the actual cleared bank opening balance so the model starts from reality.
• Use the direct cash method and map inflows to AR aging and outflows to AP aging or contract dates.
• Perform weekly variance analysis and record explanations for material differences to create an audit trail.
• Keep a stable row structure and retain supporting documents like invoices, payment confirmations, and bank statements.

When you model timing precisely and test scenarios, the 13-week forecast becomes an actionable plan. For lender-ready steps and documentation tips, see our prepare-your-books-for-a-lender guide.

Turn your forecast into payroll certainty

Want to avoid payday panic? A weekly, rolling 13-week forecast spots timing gaps before they become crises. Start each update by reconciling the opening cash balance to your cleared bank balance. Use the add/drop method: replace the completed week with actuals and add a new Week 13.

Focus on actual cash movement, not accrual dates. Use driver-based assumptions and standardized inputs so updates stay fast and reliable. Test best, base, and worst cases to see how many pay periods you can cover. Record weekly variances and document assumptions so the forecast gets more accurate over time.

Grab our companion 13-week template to follow along and start flagging shortfalls: companion template. If your books are messy or forecasts feel unreliable, we can clean the records and build a payroll-safe forecast for you. For help in Northern Virginia, call FATIZ LLC at (703) 870-5120.