How to build a simple 13-week cash flow forecast for payroll

If you run a small business, you probably know your bank balance today. What’s harder to see is what it will look like six or eight weeks from now, on the day payroll runs. A 13-week cash flow forecast is a simple way to answer that question.

Thirteen weeks is one quarter, which gives you enough lead time to act on a tight week while keeping your estimates realistic. You don’t need accounting software or a finance background to build one. A spreadsheet works fine.

Why a weekly forecast works better for payroll

Most financial reports look backward. Your P&L tells you how last month went, and your balance sheet shows where things stand today. Neither one tells you whether you’ll have enough cash on the 15th.

Payroll runs on a weekly or biweekly schedule, so it helps to look at cash the same way. A monthly view can hide a problem. You might end the month in good shape overall but come up short on the one Friday when payroll, rent, and a tax payment all land in the same week.

How to set it up

Start with a spreadsheet that has 13 columns, one for each of the next 13 weeks. Then work down the rows.

Starting cash. In the first column, enter what’s in your operating account today. Each week after that starts with the ending cash from the week before.

Cash coming in. List the money you expect to receive each week. Use your AR aging report to estimate when customers will pay, based on how they’ve paid in the past, not just their invoice terms. If a customer usually pays at 45 days on net 30 terms, plan for 45.

Payroll. Enter each payroll in the week it runs, including payroll taxes and any PEO fees. This is usually your biggest and most predictable outflow, so it’s worth getting exact.

Other cash going out. Add rent, loan payments, insurance, materials, software, and any other regular bills. Include the ones that don’t come every month, like quarterly estimated taxes, annual renewals, or a large equipment payment.

Ending cash. For each week, take starting cash, add cash coming in, and subtract everything going out. That’s your ending cash for the week and your starting cash for the next one.

What to look for

Once the numbers are in, scan the ending cash row. You’re looking for any week where the balance drops below the cushion you’re comfortable with, or below zero.

Pay close attention to payroll weeks. A forecast often shows that cash is fine most of the time but gets thin in the same few weeks each quarter. Those are usually weeks where a big bill lands just before a large customer payment.

When you spot a tight week, you have options while it’s still weeks away. You can follow up on slow invoices early, ask a vendor to move a due date, delay a purchase that isn’t urgent, or line up funding ahead of time.

A simple 13-week cash flow forecast
Example of a 13-week cash flow forecast for payroll.

Keep it current

A forecast is only useful if it reflects what’s happening in your business. Once a week, replace the estimates for the week that just ended with the real numbers. Then add a new week at the end so you’re always looking 13 weeks ahead.

The weekly update doesn’t take long once the spreadsheet is set up. Over time, you’ll also get better at estimating, because you’ll see where your guesses were off and why.

When the forecast shows a gap

Sometimes the forecast shows a shortfall you can’t close by moving bills around. That’s common when a business is growing, because costs for new work start before the first payment arrives. We covered that situation in more detail in growing faster than your cash.

A gap is much easier to deal with when you see it weeks ahead. Ready’s payroll funding can help cover payroll through a timing gap, with repayment terms agreed to at the start. We don’t run a credit pull or require collateral, and we look beyond the numbers to understand your situation. If payroll funding is new to you, our guide to payroll funding explains how it works.


A 13-week forecast won’t make cash flow gaps disappear, but it will show you when they’re coming. That gives you time to plan, so payroll doesn’t become a last-minute scramble.


See a tight week coming?

Apply now or contact us today, and we’ll help figure out what fits. 347-766-8563

Need Business Funding?

We are Ready to Fund.

Get Started