Daily Cash Flow Forecast Template: When You Need One

Most businesses manage cash well with a weekly or monthly forecast. But there are times when the question isn’t “what happens this month?” but “can we make payroll on Thursday?”. That’s when a daily cash flow forecast earns its keep. This guide explains when you need one, how to build it, and how to keep it from becoming a burden.

When a daily forecast helps

• Very tight cash, with the balance close to zero or an overdraft limit.
• A crisis or turnaround, when every payment is being prioritised.
• Large daily flows, such as retailers, restaurants and wholesalers with high daily takings and supplier payments.
• Around big dates: payroll, a large tax payment, a loan repayment or a major customer receipt.
• When a lender asks for it during a restructuring.

If none of these apply, a weekly 13-week forecast is usually more useful and far less work.

How far ahead?

Two to four weeks. Beyond that, the exact day of most payments and receipts is uncertain, and daily detail adds work without adding accuracy. Run the daily view alongside a weekly one: daily for the next fortnight, weekly for the rest of the quarter.

Building a daily forecast

1. Start with today’s cleared bank balance, and your overdraft limit if you have one.
2. List known dated payments: payroll, direct debits, standing orders, loan payments, tax deadlines, rent, and supplier payments you’ve scheduled.
3. List known dated receipts: card settlements, marketplace payouts, customer payments with confirmed dates.
4. Add expected takings by day for businesses with daily sales, using the same day last week or last year as a guide.
5. Add expected customer payments on the most realistic day, based on each customer’s history.
6. Calculate each day’s closing balance and compare it with zero or your overdraft limit.

Example: a two-week view around payroll

Opening balance: $8,000. The week ends positive, but Thursday dips below zero because payroll goes out the day before a large customer payment arrives. The fix is small: ask the customer to pay a day earlier, move a supplier payment from earlier in the week, or agree with the bank to cover one day. A weekly forecast would never have shown it.

Making it manageable

• Keep lines few: takings, customer receipts, payroll, suppliers, other.
• Mark confirmed items differently from estimates, so you know which days are firm.
• Update daily from the bank feed, in five minutes, first thing in the morning.
• Only forecast what you know or can reasonably estimate; lump small items into “other”.
• Stop when the pressure eases. Daily forecasting is a tool for a period, not a permanent routine.

Prioritising payments when cash is tight

A daily forecast often reveals days when not everything can be paid. Agree an order of priority in advance, commonly:

1. Payroll and payroll taxes
2. Tax authorities
3. Secured lenders and leases on essential equipment
4. Critical suppliers who could stop supply
5. Rent and utilities
6. Other suppliers, with agreed payment plans
7. Discretionary spending

Communicate early with anyone whose payment will be late. A call before the due date is received very differently from silence.

Talking to your bank

If the daily forecast shows a day or two below zero, tell your bank before it happens. Many banks will agree a short temporary increase to an overdraft, or honour a payment for a day, if they know in advance and can see a forecast showing when the balance recovers. The same request after a payment has bounced is far harder. A clear daily forecast for the next fortnight is exactly the evidence they need.

Daily forecasting for high-volume businesses

Restaurants, cafés and shops take cash every day and often pay suppliers weekly. Their daily pattern is predictable: quieter on Mondays, busier at weekends, card settlements a day or two later. For these businesses, a daily view in busy periods or before a big order is simple to build from last year’s daily takings. See the restaurant and café guides.

Daily, weekly and monthly together

The totals should agree where they overlap: the daily figures for a week should add up to that week in the weekly forecast.

Getting daily visibility of actuals

A daily forecast needs a daily actual to compare against. Most business bank accounts offer online banking with same-day transaction lists, and many accounting packages import bank transactions automatically each day. Spend five minutes each morning checking yesterday’s actual receipts and payments against the forecast, and moving anything that didn’t arrive to the next realistic day.

After the pressure eases

Once the balance has recovered and the critical dates have passed, step back to weekly forecasting. Before you do, note what caused the squeeze and what you’ll do differently: a larger buffer, different payment dates, a facility arranged in advance, or faster collections. The best outcome of a period of daily forecasting is not needing to do it again.

Common mistakes

• Using forecast rather than cleared balances, so the starting point is wrong.
• Forgetting card settlement delays, which move takings a day or two later.
• Missing direct debits, which don’t appear in your payment run.
• Keeping the daily routine going long after it’s needed.
• Not telling anyone when the forecast shows a day that can’t be covered.
• Ignoring weekends and bank holidays, when payments and settlements don’t move.

Templates

There isn’t a separate daily template on this site because most businesses need daily detail only briefly. The simplest approach is to copy the free 13-week template and change each column from a week to a day for the next fortnight. For the weekly method, see the weekly template guide.