Budget Matrix report
The Budget Matrix report contains a copy of the budget in the format you entered it: nominal, ledger code, account code, then budget values for each period. You can produce the report for specific ledgers, ledger accounts, or nominals. You can also use this report to print a copy of your current or previous year's actuals to compare with, or to produce, your current budget.
To open the Reporting Suite, go to Processing Modules, then select Reporting Suite. For more information about the budget reports, go to Produce budget reports.
- In the General Reports section, select Budget Matrix.
- The Reporting Services Browser opens. Select the criteria for the report.
- Select the filter options to decide what to include in the report. In most circumstances, use Select All. You can also filter the report by ledger, ledger account, nominal, and specific periods, as described in this table:
Criteria Description Please select the Company(s) Only select a company if you have more than one business entity set up. Otherwise, leave the default. Please select the Location(s) Budgets are produced for each location. Select the location to report on, for example LLL. Please select the Ledger You are likely to want to report on all ledgers in most cases. However, you can select individual ledgers from the list. The ledgers you can select depend on the location you select. Please select the Account(s) This is useful if you want to review each ledger account separately, such as each cost centre. Select the accounts you need from the list, or select All. You can select only accounts from the ledger you selected. Please select the Budget Select the budget to report on. You can select only one budget at a time. Please select the Period Select the period to report against. This controls the Current Period and Year to Date columns in the report. For example, if you select Period 5, the Current Period column shows period 5 data and the Year to Date column shows periods 1 to 5. Include Year End Period(s)? Use this to include the year-end period transactions in the report. These are usually adjustments rather than in-year transactions, so you do not usually need them. Show Current Period Transactions Only? Select Yes to show only individual transactions in the selected period. Select No to show all transactions for the selected account up to and including the specified period.
- Make sure you have selected the Year and Budget code you need. Select View Report to produce the report.