Get 90% off your plan for your first 6 months*
Guide

Quarterly cash flow review: How to use your Q1 numbers to plan for H2

Use your Q1 cash flow data to build a stronger plan for the second half of the year.

A person looking at a computer with a bar graph and money.

Chesney McDonald–Small business & finance writer/editor. Read Chesney's full bio

Published Friday 21 August 2026

Table of contents

Key takeaways

  • A quarterly cash flow review is a structured look at your operating, investing, and financing cash flows that helps you spot trends and act on them before they become problems.
  • Comparing Q1 actuals to your forecast reveals where your assumptions were off and gives you a foundation for a realistic H2 plan.
  • Late payments remain a growing pressure point, with UK small business sales growth slowing to 2.9% year on year in Q1 2026, making receivables management a critical focus for H2 planning.
  • A 13-week rolling cash flow forecast built from Q1 data gives you weekly visibility into the quarter ahead and keeps your H2 plan grounded in real numbers.

What is a quarterly cash flow review?

A quarterly cash flow review is a structured process for analysing the previous quarter's cash inflows and outflows across operating, investing, and financing activities. It gives you a clear picture of where cash came from, where it went, and whether the pattern is sustainable.

It's worth distinguishing this from a simple profit check. A business can be profitable on paper and still run out of cash if receivables are slow, capital expenditure is front-loaded, or financing repayments drain the account. Cash flow tells you what actually moved through the bank; profit tells you what the accounting rules say you earned. Both matter, but cash flow is what keeps the lights on.

So why quarterly? Monthly reviews are useful for operational monitoring, but they're often too granular to reveal strategic patterns. Annual reviews catch trends far too late. A quarterly cadence aligns with tax periods, board reporting cycles, and the natural rhythm of business planning. It gives you enough data to separate one-off events from recurring patterns, and enough time to act on what you find.

Why quarterly matters more than monthly or annual

At your scale, monthly cash flow check-ins are still valuable for flagging anomalies. But the quarterly review is where you step back and ask bigger questions: are your cash reserves growing or shrinking? Is your receivables position improving? Are your financing costs sustainable?

Annual reviews, on the other hand, often become backward-looking exercises that confirm what you already know. By the time you've reviewed 12 months of data, the insights are stale. Quarterly reviews sit in the strategic sweet spot: frequent enough to catch problems early, broad enough to reveal meaningful trends.

Why your Q1 numbers matter right away

Your Q1 numbers are actionable data you have right away. When Q1 is complete, and Q2 data is starting to come in, you're sitting at the mid-year inflection point where what you've learned directly shapes your second-half strategy.

The timing matters because the economic context is shifting. According to Xero Small Business Insights, UK small business sales grew 2.9% year on year in the March quarter, a pace that's been slowing. These numbers signal tighter conditions ahead; not a crisis, but a clear reason to review your own position before committing to H2 plans.

If your Q1 cash flow was weaker than expected, you want to know now, not in September. And if it was stronger, you want to understand why so you can sustain it. Either way, this is the moment to turn backward-looking data into a forward-looking plan.

How to run a quarterly cash flow review in 5 steps

A solid quarterly review follows a consistent process. These five steps take you from raw data to actionable insights, giving you a clear foundation for H2 planning.

1. Pull your cash flow statement for Q1

Start by generating your cash flow statement (CFS) for the quarter. This should break your cash movements into three categories:

  • Operating activities: cash generated or consumed by your core business operations, including customer receipts, supplier payments, payroll, and tax
  • Investing activities: cash spent on or received from long-term assets such as equipment, property, or business acquisitions
  • Financing activities: cash from loans, credit facilities, shareholder contributions, or dividend payments

Pull the same report for Q1 of the previous year so you can compare like for like. Year-on-year comparison is more useful than quarter-on-quarter at this stage because it strips out seasonal effects.

2. Compare actuals to your forecast

Line up your Q1 actuals against the forecast you set at the start of the year. Look at where revenue, expenses, and net cash flow differed from your projections.

Some variance drivers you'll commonly see at your scale include late customer payments pushing receipts into Q2, unplanned costs such as equipment repairs or recruitment fees, and seasonal revenue dips that were sharper or shallower than expected. The goal isn't to explain every pound of variance. It's to separate one-off events from recurring patterns that need to be reflected in your H2 forecast.

3. Analyse your receivables and payables

Your receivables and payables position is often where the real story sits. Calculate your average days sales outstanding (DSO): divide your average accounts receivable for the quarter by your total credit sales, then multiply by the number of days in the quarter.

A rising DSO means you're waiting longer to get paid, which directly compresses your cash position. If your DSO has crept up, look at which customers or segments are driving it. Are your payment terms still appropriate? Are you following up consistently on overdue invoices?

On the payables side, review your payment timing. Paying suppliers too early ties up cash unnecessarily; stretching terms too far risks supplier relationships and early-payment discounts. The balance you strike here directly affects your working capital position heading into H2.

4. Review your cash reserves and runway

How much cash do you have on hand relative to your monthly operating costs? A common benchmark is to hold cash reserves equivalent to 10 – 30% of annual revenue, though the right figure depends on your industry, seasonality, and risk profile.

Compare your current reserve position to where you stood at the end of Q4. Did reserves grow, shrink, or hold steady? If they shrank, was it planned (for example, a deliberate investment) or unplanned (for example, a revenue shortfall)? Your reserve trend over the past two to three quarters tells you whether your cash position is strengthening or weakening, and that trend matters more than any single quarter's snapshot.

5. Flag risks and opportunities for H2

With the data in front of you, document the key risks and opportunities for the second half of the year. You're looking for items that require action in your H2 plan.

Common red flags to watch for include:

  • Declining operating cash flow: If your core operations are generating less cash quarter on quarter, investigate before you plan.
  • Rising DSO: Late payments compound, meaning every extra day your cash sits in receivables is a day it's not available for operations.
  • Shrinking reserves: If you're drawing down reserves without a clear repayment path, you're borrowing from future flexibility.

Opportunities to capture might include seasonal revenue peaks in your sector, cost reductions identified from Q1 spending analysis, or a favourable window for capital investment before year-end.

Turning your Q1 review into an H2 cash flow plan

The review is the diagnostic; the H2 plan is the prescription. Once you know where you stand, you can build a realistic cash flow plan for the second half of the year.

Set updated revenue projections

Start with your Q1 actuals, not your original annual forecast. Layer in any early Q2 signals you already have: pipeline data, order book trends, or contract renewals. If your Q1 revenue ran 10% below forecast, don't assume H2 will magically snap back to plan. Adjust your projections to reflect what actually happened, then add growth assumptions only where you have evidence to support them.

Factor in seasonal patterns. If your business typically sees a summer slowdown or a Q4 surge, build that into the model rather than averaging across months.

Build your expense budget for H2

Review your Q1 fixed and variable costs. Did any fixed costs change unexpectedly? Did variable costs scale in line with revenue, or did they outpace it?

Use your Q1 actuals to set a realistic expense baseline for H2. Layer in known upcoming costs: planned hires, marketing campaigns, inventory builds, or capital expenditure. Separate discretionary spending from committed costs so you have levers to pull if cash flow tightens mid-quarter.

Create a 13-week rolling cash flow forecast

A 13-week rolling forecast covers a full quarter at weekly granularity. It's the most practical tool for managing cash flow in real time because it forces you to think in specific, near-term figures rather than broad monthly estimates.

To build one, start with your current cash balance. For each of the next 13 weeks, project your expected cash inflows (customer payments, other income) and cash outflows (supplier payments, payroll, rent, loan repayments, tax). The difference gives you your projected closing cash balance for each week.

Update the forecast weekly with actuals. As each week passes, replace your projections with real numbers and extend the forecast by one week. This rolling approach keeps the forecast current and builds your confidence in the numbers over time.

Set cash reserve targets

Based on your Q1 findings and H2 expense projections, define your minimum cash position. This is the balance below which you'd need to take action: drawing on a credit facility, accelerating collections, or deferring discretionary spending.

Build a buffer above the minimum for seasonal fluctuations and unexpected costs. If your industry sees a summer dip, your reserve target for July and August should be higher than for October and November. Tie these targets back to your 13-week forecast so you can see exactly when you might breach them.

Managing seasonal cash flow through H2

Seasonal fluctuations are a reality for most businesses, and H2 often brings specific challenges. A quarterly review that ignores seasonality is only doing half the job.

Summer months can create a squeeze from multiple directions. Collections often slow as customers and their finance teams take holidays. Staffing gaps from annual leave can delay invoicing or follow-up on overdue payments. And depending on your sector, demand may dip or shift in ways that affect revenue timing.

Several strategies can help you smooth these fluctuations:

  • Arrange a credit facility in advance. Negotiate a line of credit or overdraft facility while your cash position is strong, so it's available if summer cash flow dips.
  • Renegotiate payment terms. If your DSO is rising, consider offering early-payment discounts to key customers or tightening your standard terms for new contracts.
  • Diversify revenue timing. Look for opportunities to bring forward revenue: annual subscriptions paid upfront, retainers, or milestone-based billing that front-loads payments.
  • Stagger major outflows. Where possible, schedule large payments (supplier orders, tax instalments, capital purchases) to avoid clustering them in the same week.

The quarterly review framework gives you the data to anticipate these seasonal dips rather than react to them. If Q1 showed a similar pattern last year, you already know what's coming and can plan accordingly.

Common mistakes in quarterly cash flow reviews

Even finance teams that run regular reviews can fall into patterns that reduce the value of their insights. Knowing the common pitfalls helps you avoid them.

  • Focusing only on profit: Profit and cash flow can tell very different stories. A profitable quarter can mask a deteriorating cash position if receivables are growing faster than revenue or if capital expenditure is funded from operating cash. Always review the cash flow statement alongside the profit and loss.
  • Ignoring receivables aging: Your total receivables balance matters less than its age profile. A growing balance of invoices over 60 or 90 days is a warning sign that headline figures can obscure. Break your receivables down by aging band every quarter.
  • Not comparing to the same quarter last year: Quarter-on-quarter comparisons are useful, but they don't account for seasonality. Comparing this year’s to last year’s Q1 to last year’s gives you a cleaner read on whether your cash flow is genuinely improving or just following its usual seasonal pattern.
  • Treating the review as a one-off: A single quarterly review is useful, but a series of them is powerful. The real value comes from tracking trends over time, like DSO, operating cash flow margin, and reserve levels. Build a simple dashboard or tracking sheet so each quarter's review builds on the last.
  • Relying on outdated or manual data: If you're pulling numbers from spreadsheets that haven't been updated in weeks, your review is based on assumptions, not facts. Real-time financial data makes the difference between a review that confirms what you suspect and one that reveals what you've missed. HMRC's guidance on record keeping outlines the minimum standards for UK businesses, but best practice goes well beyond compliance.

Track your cash flow with Xero

A quarterly cash flow review is only as good as the data behind it. Xero helps give you real-time visibility into your cash position, so your quarterly reviews can start from accurate, up-to-date numbers.

With automated bank feeds, your transactions flow in daily, keeping your books current without manual data entry. Customisable reporting lets you generate cash flow statements broken down by operating, investing, and financing activities; exactly the view you need for a structured quarterly review. Short-term cash flow projections show you where you're heading, and invoice tracking with automated payment reminders helps you stay on top of receivables before DSO starts to creep.JAX, Xero's AI financial superagent, can answer questions about your business using your own financial data alongside real-time public information, giving you faster access to the insights that drive better decisions.

Ready to see your cash flow clearly? Get one month free.

FAQs on quarterly cash flow review

Here are answers to some of the most common questions about running a quarterly cash flow review.

What's the difference between a cash flow review and a cash flow forecast?

A cash flow review looks backward at actual inflows and outflows; a cash flow forecast projects future ones. The review informs the forecast: without understanding where your cash went, your projections are guesswork.

How much cash should a business keep in reserve?

Most financial advisers recommend holding cash reserves equivalent to 10–30% of annual revenue.The right figure for your business depends on your industry's seasonality, your payment terms, and how quickly you could access external finance if needed.

What are the signs of a cash flow problem?

Watch for consistently negative operating cash flow, a rising DSO trend over two or more quarters, declining cash reserves without a planned recovery path, and increasing reliance on credit facilities to cover day-to-day operating expenses.

Can accounting software automate a quarterly cash flow review?

Software can automate the data collection and reporting: pulling transactions, generating cash flow statements, and tracking receivables aging. The analysis and strategic decisions that follow still require human judgement, but starting from accurate, real-time data makes the whole process faster and more reliable.

Get one month free

Purchase any Xero plan, and we will give you the first month free.