13-Week Rolling Cash Flow Timing Tracker Template Structure for SMEs

This post is a tutorial of how a rolling cash flow timing tracker would work based on a previous post that introduced the importance of a rolling cash flow tracker. :) see related post section for more info.

Setup Notes for Founders

• Update weekly

• Use conservative receivable timing assumptions

• Include quarterly tax obligations even if weeks appear stable

• Adjust threshold as payroll or overhead changes

Week 1 – Beginning Cash Balance

What goes in the very first cell?

Week 1 Beginning Cash Balance = Your actual cash available today.

That includes:

• Bank account balances

• Operating checking

• Savings designated for operations

• Cash equivalents that are immediately accessible

It should NOT include:

• Accounts receivable

• Inventory value

• Credit line limits

• Future expected revenue

It is strictly liquid cash on hand.

Example

If today your business bank account has: Checking: 85,000; Savings: 15,000

Then: Week 1 Beginning Cash Balance = 100,000

Formula Logic

In Excel or Google Sheets: You manually enter Week 1 Beginning Balance.

Then:

Week 1 Ending Balance = Beginning Balance + Total Inflows – Total Outflows

For Week 2 and Beyond

Beginning Balance for Week 2 = Ending Balance from Week 1

Beginning Balance for Week 3 = Ending Balance from Week 2

And so on.

Formula example:

If Week 1 Ending Balance is in cell C6

Then Week 2 Beginning Balance formula is: = C6

This creates the rolling structure.

Minimum Liquidity Threshold

This is not a formula. It is a policy decision.

It represents the minimum cash cushion required to operate safely without stress.

There are three common ways to calculate it:

Method A: Payroll-Based Threshold (Most Practical for SMEs)

Minimum Liquidity Threshold = 1–2 payroll cycles + essential fixed expenses

Example:

Biweekly payroll = 40,000

Monthly rent = 12,000

Loan payments = 8,000

Minimum Threshold might be: 40,000 + 12,000 + 8,000 = 60,000, Or slightly higher for safety buffer, say 75,000.

Method B: Weekly Burn Coverage

Minimum Threshold = Average Weekly Outflow × 4 weeks

If average weekly outflow is 25,000:

25,000 × 4 = 100,000

This gives one-month operating buffer.

Method C: Risk-Adjusted Buffer

Higher volatility businesses might use:

Average Weekly Outflow × 6 to 8 weeks

This is more conservative and stronger for resilience positioning.

In the Sheet

You enter the Minimum Liquidity Threshold as a constant number across all 13 weeks.

It should remain stable unless your payroll or cost structure changes.

Cushion Above Threshold

This one is calculated.

Formula:

Cushion Above Threshold = Ending Cash Balance – Minimum Liquidity Threshold

Example:

Ending Cash = 120,000

Threshold = 75,000

Cushion = 45,000

What It Tells You

If Cushion is:

Positive → You are above safety buffer

Zero → You are exactly at risk boundary

Negative → Liquidity stress zone

You can apply conditional formatting:

If Cushion < 0 → Red

If Cushion < 10% of Threshold → Yellow

This creates early warning.

Why This Matters Structurally

The Beginning Balance anchors realism.

The Threshold defines discipline.

The Cushion reveals risk trajectory.

Without a defined threshold, businesses often mistake “positive cash” for “safe cash.”

Positive does not mean resilient.

Resilience means staying above the operating floor.

Free Excel Template to download: