Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We See a Cash Squeeze Coming When Grants Arrive Late and Councils Pay in Arrears?
Problems We Solve

How Do We See a Cash Squeeze Coming When Grants Arrive Late and Councils Pay in Arrears?

Social enterprises get caught out when grant instalments and council payments arrive late. We build a rolling cash forecast from real payment patterns.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Social enterprises are caught out by cash shortfalls because grant instalments depend on reports being accepted, council contracts pay in arrears, and trading income is seasonal, while wages go out every month. We build a rolling cash forecast from your accounts, grant schedules, invoices and trading patterns, updated weekly, that shows the weeks when cash will be tight early enough to act.

Payroll week and an empty account

It is the week before payroll. The finance manager checks the bank and sees there is not enough to cover wages. The second instalment of a trust grant was due last month, but it is released only after the progress report is accepted, and the funder has not yet reviewed it. Two council invoices are overdue because of a missing PO. The café's takings dipped over the school holidays, as they always do. The trading arm bought stock for the Christmas market.

None of this was a surprise on its own. Together, nobody saw it coming. The finance manager spends two days chasing the council, emailing the funder and talking to the bank, and a director transfers money from a reserve account the board had meant to keep untouched.

Why cash is hard to predict in a social enterprise

A social enterprise's income arrives in more shapes than most small businesses', and most of them are lumpy or conditional.

IncomeWhy its timing is uncertain
Grant instalmentsReleased on reports being accepted, or on milestones
Council contractsPaid in arrears, on their terms, subject to PO and invoice checks
Payment by resultsDepends on outcomes being evidenced and claims processed
TradingSeasonal, affected by weather, holidays and events
Social investmentDrawn down on conditions

Costs, by contrast, are steady: wages every month, rent, loan repayments. The gap between the two is where cash problems live.

Decisions on reserves, borrowing or timing of spending are for your board and advisers. We do not give financial advice. We give them an early, clear view.

What cash surprises cost

Stress and distraction for the finance manager and directors, who drop everything to find money. Use of reserves that were meant for something else. In the worst case, late wages or supplier payments, which damage trust with staff and suppliers.

And missed chances. A social enterprise that does not know its cash position hesitates to take on a new contract or buy stock for a good opportunity, even when it could afford to.

A rolling cash forecast built from real patterns

What we build is a weekly cash forecast, updated from your own systems, for the next three to six months, or whatever horizon your board wants.

  1. The starting position comes from your bank feed through Xero or QuickBooks.
  2. Outstanding council and customer invoices are forecast to be paid on each payer's actual past payment pattern, not the invoice terms, so a council that usually pays late is forecast to pay late.
  3. Grant instalments are entered from each funding agreement with their conditions, such as report due, report submitted, report accepted, and the forecast date moves when a condition is not yet met.
  4. Trading income is forecast from the same weeks last year, adjusted by the manager for known changes such as a new site or event.
  5. Regular costs, such as payroll, rent, loans and suppliers, come from the accounts and scheduled payments, with one-off costs added by hand.
  6. The forecast shows the lowest point in each week and highlights weeks when cash falls below the minimum your board sets, with the items driving it listed.

Scenarios can be run, such as the grant being two months late or a new contract starting, so the board can see the effect before deciding.

The next squeeze, seen in advance

In September, the forecast shows a dip below the board's minimum in the second week of November. The drivers are listed: a grant instalment waiting on a report due in October, and the Christmas stock purchase. The finance manager brings the report forward, asks the funder about review timing, and staggers the stock order. The board is told at its October meeting, with the forecast attached.

November payroll goes out without anyone touching the reserve.

Could cash catch you out?

  • Cash shortfalls are discovered in payroll week.
  • Grant instalments arrive later than expected because of report conditions.
  • Council payments are later than their terms.
  • Trading income dips seasonally and catches you out.
  • The board sees cash only as a current bank balance.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Can you tell us what reserves to hold?

No. Reserves and borrowing decisions are for your board and advisers. The forecast shows them the likely position so they can decide.

How accurate is the forecast?

It is only as good as the inputs, but it uses each payer's real history and each grant's conditions, and it is updated weekly, so it improves as dates approach.

Does it replace our accounting software?

No. It reads from Xero or QuickBooks and your grant schedules, and presents a forward view the accounts do not.

What do we need to provide?

Access to your accounting software, your funding agreements and payment schedules, and your board's minimum cash level.

Keep reading

More on Problems We Solve

Start here

Tell us which report or payment run eats your week

Describe the report, forecast or payment process that takes the most time in your social enterprise, where the figures come from and who puts it together. We will tell you what we would automate and what we would leave alone, and if your accounting software can already do it, we will show you how.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →