The purpose of the Budget vs Actuals Report is it allows you to compare planned performance (budget) against actual results, spot variances quickly, and share insights with your team or stakeholders.
1) Creating a Budget vs Actual Report
From the main dashboard, go to Group Financial Reporting → Reports.
Click Add Report (top-right corner).
Select Budget vs Actual as the report type.
Complete the setup form:
Report Name – e.g., “Q1 2025 Budget vs Actual”
Budget – choose which budget to compare against
Group & GRT – select your reporting group and reporting template
Year & Periods – e.g., 2025, Q1
Frequency – Monthly, Quarterly, etc.
Currency – e.g., USD
Click Add to generate your report.
2) Understanding the Report
The report shows:
Header: Group, GRT, Financial Year, Currency, and Report Type.
Body: Account rows with Budget, Actual, and Variance (and %) by selected periods. Subtotals and totals mirror your GRT.
Supporting Data: Exchange rates for multi-currency groups, applied automatically.
3) Customisation & Export Options
Report Display via Gear icon: Change frequency, add/remove periods, show absolute or % variances, and scale amounts (e.g., thousands).
Notes: Add up to 500 characters explaining major variances.
Export: Download in XLS or XLSX for analysis or distribution.
Need help? Visit gather.nexus, click the chat icon in the bottom-right corner, or email us at [email protected] for assistance.