Example

FP&A Workflow Example

A 150-person mid-market company in Leeds with £11M revenue. The FP&A team of three people runs a disciplined planning cadence covering monthly close, quarterly reforecasts, and annual budgeting. This workflow ensures the business always has a current view of performance and outlook.

Example data

Financial model

Week
Activity
Owner
Output
Day 1-3
Close books, import actuals
Controller
Trial balance
Day 4-6
Variance analysis
FP&A Analyst
BvA report
Day 7-8
Update rolling forecast
FP&A Manager
Updated model
Day 9-10
Management pack
FP&A Manager
Monthly pack
Day 12
Leadership review
CFO
Decisions logged
Day 15
Board pack (if board month)
CFO
Board pack sent
Day 1-3

Automated actuals import from Xero saves 2 days of manual data entry. The FP&A team focused on analysis, not data gathering.

Day 9-10

The management pack is assembled from the same model used for variance analysis and forecasting -- no re-keying of numbers. One source of truth.

Day 15

Board pack is produced every other month (6 times per year). In non-board months, the management pack serves as the executive report.

Formulas

Key formulas

fxMonthly Close: Day 1-3 post month-end

Fast close is critical. Actuals should be available by day 3. This requires automated data feeds from the accounting system and pre-reconciled intercompany balances.

fxVariance Analysis: >£5k or >5% = investigate

Materiality thresholds prevent the team from chasing immaterial variances. Only investigate variances above £5k or 5% -- everything else is noise.

fxQuarterly Cadence: Reforecast in Jan, Apr, Jul, Oct

A full reforecast every quarter updates the forward view. This is more comprehensive than the monthly rolling forecast update and involves department head input.

Analysis

What makes this example good

Clear deadlines and owners for every step in the process
Day-by-day timeline ensures the management pack is out by day 10
Materiality thresholds prevent wasted time on immaterial variances
Quarterly reforecasts balance rigour with resource constraints
The same model is used for close, analysis, forecast, and reporting

Customisation

How to adapt for your business

1

Adjust the timeline if your close takes longer (e.g., day 1-5 for close)

2

Add a "flash report" step on day 2-3 for CEO/CFO early visibility

3

Include department head review meetings in the first week

4

Add an annual budget timeline (typically September-November for Jan year-end)

5

Include a quarterly business review (QBR) with deeper strategic analysis

Common variations

  • --Three-day close process for fast-moving startups
  • --Weekly flash reporting with monthly detailed packs
  • --Continuous planning model with real-time forecast updates
  • --Annual planning calendar showing the full year of FP&A activities

FAQ

Frequently asked questions

Best-in-class companies close within 3-5 working days. Average is 7-10 days. If your close takes longer than 10 days, you are likely spending too much time on manual processes that should be automated. Focus on getting flash numbers out by day 3.

Build this in Grove FP in 10 minutes

No credit card required. Set up in minutes. 30-day money-back guarantee.