Structure the workbook
Separate raw inputs, calculations and the dashboard so monthly updates stay organised and dependable.
PRACTICAL PROJECT / Planning & analysis
Financial Performance Tracker
A practical workbook for comparing actual results with targets, monthly movement and cost variance.
DATACRAFT / FINANCE
Planning & analysisFinancial tracker
JAN — AUG 2026Actual₦5.76M+4.8%
Budget₦5.50MOn plan
Variance₦264KFavourable
Actual vs budgetMONTHLY
Cost mix
41%
- Operations
- Marketing
- People
THE BUSINESS QUESTION
“Where is the business ahead of plan, and which cost lines need attention before the next reporting cycle?”
01 / THE PROCESS
From untidy records
to a useful answer.
Clean with formulas
Standardise dates and categories, handle missing values and validate totals before analysis begins.
Analyse variance
Use pivot tables and formulas to compare actuals, budgets and month-on-month movement.
Create the tracker
Surface exceptions with restrained conditional formatting, clear charts and useful filters.
02 / WORKING VIEWS
See the analysis
take shape.
Each project moves through a working layer before the final dashboard. These views show how clean structure and clear hierarchy make the result easier to trust.
fx =IF([@Amount]>0,[@Amount],0)
DATECATEGORYREGIONACTUAL04/03/26TechnologyWest₦238,40011/03/26OperationsCentral₦196,25018/03/26ServicesEast₦174,90025/03/26TechnologyWest₦261,780
DATACRAFT / FINANCE
Planning & analysisFinancial tracker
JAN — AUG 2026Actual₦5.76M+4.8%
Budget₦5.50MOn plan
Variance₦264KFavourable
Actual vs budgetMONTHLY
Cost mix
41%
- Operations
- Marketing
- People
03 / WHAT IT REVEALS
Analysis becomes useful when it changes the next decision.
A repeatable monthly reporting process that highlights exceptions instead of asking teams to inspect every row.
01
Actual performance finished 4.8% above budget.
02
Operations created the largest favourable variance.
03
Marketing spend needs review after two months above plan.