This guide explains how to upload Accounting KPI Budgets in FAM.
Accounting KPI Budgets allow users to forecast how budgeted revenue will be derived from:
Budgeted production (MWh)
Budgeted price per MWh
Accounting adjustments
Ancillary or other income
This enables a consistent operational-to-financial bridge between:
Production forecasts
Power price assumptions
Budgeted revenue in the financial statements
⚠️ Important:
The system does not perform validation checks against financial budgets. Users are responsible for ensuring uploaded KPI data supports their financial budget assumptions.
Overview of the Budget Upload Process
Uploading Accounting KPI Budgets follows the same two-step structure as Actuals:
Upload Budgeted Production
Upload Budgeted Pricing
However, there are two key differences from Actual uploads:
Budgets are uploaded at the Entity level
Periods follow the financial year of the entity
Understanding Budget Periods
Budget uploads use period numbers (1–12) rather than calendar months.
The period numbering aligns with the entity's financial year end.
Example: 30 June Year End
| Month | Period |
|---|---|
| July | 1 |
| August | 2 |
| September | 3 |
| October | 4 |
| November | 5 |
| December | 6 |
| January | 7 |
| February | 8 |
| March | 9 |
| April | 10 |
| May | 11 |
| June | 12 |
Example: 31 December Year End
| Month | Period |
|---|---|
| January | 1 |
| February | 2 |
| March | 3 |
| April | 4 |
| May | 5 |
| June | 6 |
| July | 7 |
| August | 8 |
| September | 9 |
| October | 10 |
| November | 11 |
| December | 12 |
Step 1 – Upload Budgeted Production
Budgeted production represents the expected generation (MWh) for each CGU during the financial year.
Navigate to Accounting KPI Budgets
Go to Accounting
Select Budgets
Click Accounting KPI Budgets
Select Production Budgets
Click Create Budget
You will then be prompted to upload the Production Budget template.
Upload the Production Budget File
Download the Production Budget template
Populate the template
Upload the file
Production budgets are recorded per CGU within the entity.
Production Budget Template Structure
| Column | Description |
|---|---|
| Site / CGU Ref ID | Reference ID of the CGU or site - this is added in the General Details screen. |
| Period | Budget period (1–12) |
| Production | Budgeted generation (MWh) |
Example:
| CGU Ref ID | Period | Production |
|---|---|---|
| CGU Site 1 | 1 | 3200 |
| CGU Site 1 | 2 | 3100 |
📌 Notes
Production must be uploaded before pricing budgets
Period numbers must align with the entity financial year
Step 2 – Upload Budgeted Pricing
Once production budgets are uploaded, users can upload Pricing Budgets.
Pricing budgets explain how budgeted revenue will be generated from production and other income streams.
Pricing Budget Logic
For each CGU and GL Code, users should determine whether revenue is:
1️⃣ Production-Driven Revenue
Examples:
PPA revenue
Merchant power sales
Energy sales agreements
Users should enter:
GL Code
Budgeted Price per MWh
Budget Adjustments
The implied revenue should equal:
Production (MWh) × Price per MWh ± Adjustments
Where production comes from the Production Budget uploaded in Step 1.
Adjustments may include:
Accounting adjustments
Revenue true-ups
Hedge impacts
Budget rounding differences
⚠️ Adjustments are mandatory
If no adjustment is required, enter 0.
2️⃣ Ancillary or Other Income
If revenue is not production-linked, such as:
Grid services
Capacity payments
ROC / subsidy income
Other operating income
Users should enter the value directly in the Adjustments / Ancillary Income field.
Pricing Budget Template Structure
| Column | Description |
|---|---|
| CGU Ref ID | CGU or site reference |
| Period | Budget period |
| GL Code | Financial statement GL account |
| Pricing | Budgeted price per MWh |
| Adjustments / Ancillary Income | Budget adjustments or non-production revenue |
Example:
| CGU Ref ID | Period | GL Code | Pricing | Adjustments |
|---|---|---|---|---|
| CGU Site 1 | 1 | 500000 | 52.00 | 0 |
| CGU Site 1 | 1 | 520000 | 0 | 15000 |
Important Rules
Upload Order
Budgeted Production must be uploaded before Pricing.
Entity-Level Upload
Unlike Actuals, budget uploads are performed at the entity level.
Data Replacement
Uploading a new budget file will replace existing budget data for that period.
Responsibility for Accuracy
FAM does not validate budget data against financial budgets. Users must ensure that:
Budgeted production
Budgeted pricing
Accounting adjustments
correctly support the entity's financial budget.
Recommended Workflow
Upload Production Budgets (MWh)
Upload Pricing Budgets per GL Code
Confirm the implied revenue matches the entity's financial budget
✅ Best Practice
Many users derive their pricing assumptions by:
Starting with budgeted revenue per GL code
Dividing by forecast production
Entering the resulting average price per MWh
This ensures the operational KPIs remain aligned with the financial budget model.
Comments
0 comments
Please sign in to leave a comment.