Practitioner toolkits

Rolling forecast model

A six-quarter driver-based rolling forecast, with revenue, costs and working capital calculated from operational drivers, a variance view against budget and prior forecast, and an accuracy log.

• Drivers by quarter, with owners
• Forecast calculations
• Variance: budget, prior forecast, current forecast
• Accuracy and bias log

Excel workbook · 15 KB

Standards applied

FP&A ProfessionalFinancial Modelling & Analysis with AI

Practice note

Building a driver-based rolling forecast

Working capital and cash forecast

A twelve-month forecast of receivables, inventory and payables from days outstanding, showing the monthly change in working capital, operating cash flow and the lowest point of the cash balance.

• Monthly sales and cost of sales
• Days sales, inventory and payables outstanding
• Working capital balances and movement
• Cash profile and lowest point

Excel workbook · 11 KB

Standards applied

FP&A ProfessionalFinancial Modelling & Analysis with AI

Month-end close calendar

A close calendar and task tracker: every task with its owner, reviewer, dependency and working day, a status for each, and a sheet for the measures that show whether the close is improving.

• Close tasks by working day
• Owners, reviewers and dependencies
• Status tracking
• Monthly close measures

Excel workbook · 14 KB

Standards applied

Accounting ManagerIFRS Specialist

Practice note

Designing a faster month-end close

Balance sheet reconciliation

A standard reconciliation for any balance sheet account: ledger and independent balances, identified and dated reconciling items with automatic ageing, the unexplained difference, and preparer and reviewer sign-off.

• Ledger and trial balance agreement
• Independent source balance
• Reconciling items with ageing
• Sign-off and review questions

Excel workbook · 11 KB

Standards applied

Accounting Manager

Supplier evaluation scorecard

A weighted evaluation for competitive bids: criteria and weightings set in advance, a defined scoring scale, individual and moderated scores, a total cost of ownership comparison and a conflict-of-interest log.

• Criteria and weightings
• Scoring scale descriptors
• Individual and moderated scores
• Total cost of ownership
• Conflict-of-interest declarations

Excel workbook · 14 KB

Standards applied

Procurement & Supply ManagerCompliance & Risk Professional

Practice note

Evaluating supplier bids

Risk register

A risk register that describes each risk by cause, event and consequence, rates it before and after controls on defined scales, records whether controls have been tested, and tracks key risk indicators against thresholds.

• Risk descriptions and owners
• Inherent and residual ratings
• Control testing record
• Key risk indicators
• Rating scales and heat map

Excel workbook · 17 KB

Standards applied

Compliance & Risk ProfessionalOperations Manager

AI system inventory

A register of the AI systems an organisation uses, with the fields that governance needs, a worksheet that classifies each system by the consequence of its being wrong, and a review log.

• Inventory register
• Consequence classification worksheet
• Minimum controls by tier
• Review log

Excel workbook · 19 KB

Standards applied

AI Governance ProfessionalArtificial Intelligence Professional

Practice note

Establishing an AI system inventory

Data quality scorecard

A scorecard for measuring the quality of important datasets at source: completeness, validity, uniqueness and timeliness checks with pass rates against thresholds, owners and a monthly trend.

• Checks by dataset and field
• Pass rates against thresholds
• Owners and actions
• Monthly trend

Excel workbook · 14 KB

Standards applied

Data Analytics Professional