Budget Holder (Document Detailed) report

The Budget Holder (Document Detailed) report shows the spend against a specified account for the current period, year to date, and annually, broken down by each individual document.

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.

The report shows a summary of each document. It includes the nominal used for the posting, together with the supplier account if you used one.

This report uses commitments. The commitments in the report depend on settings in IRIS Financials that the person in your establishment/organisation who administers the system controls. This is someone who has a CUSTADMIN login.



  • Please select the Company: Select the company to run the report for. You can select only one company at a time.

  • Please select the Location: Select a location to report on. You can select only one location at a time. The locations available depend on your security settings.

  • Please select the Ledger: Select a ledger to report on. Open the list and select the options you need. You can select multiple ledgers at once, but you can select only ledgers related to the location you selected. The ledger list depends on your security settings.

  • Please select the Account: Select an account to report on. You can select multiple accounts at once: open the list and select the options you need. You can select only accounts linked to the ledgers you selected.

  • Please select the Budget: Select a budget to compare the report against. 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 shows period 5 data and the Year to Date 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.

What data is in the report

The Budget Holder (Document Detailed) report contains a summary of the account and a transaction list showing the individual documents.

The header has three sections: Current Period, Year to Date, and Annual, as shown in this image:

Example of the Budget Holder (Document Detailed) report. The header shows the selection criteria, the account ADMIN - Administration, and the percentage of full year budget spent. The Current Period, Year to Date, and Annual sections show the Actual, Commitments, Budget, and Left to spend columns.

Current Period

  • Actual: This is the total actual spend for the selected period. The detail lines on the report show the transactions.

  • Commitments: This shows any purchase orders that have not been invoiced for the current period. The transaction list section of the report shows the transactions.

  • Budget: This shows the selected budget for the period for the selected account.

  • Left to spend: This adds the Actual and Commitment values and subtracts the total from the Budget value. This shows the amount left to spend against the budget for the selected period.

Year to Date

  • Actual: This is the total actual spend from the start of the financial year to the selected period. The transaction list section of the report shows the transactions.

  • Commitments: This shows any purchase orders that have not been invoiced for the current financial year up to the selected period. The report lists these transactions in the Commitments section.

  • Budget: This shows the selected budget from the start of the financial year, up to and including the period for the selected account.

  • Left to spend: This adds the Actual and Commitment values and subtracts the total from the Budget value. This shows the amount left to spend against the budget for the financial year, up to the selected period.

Annual

  • Budget: This shows the selected budget for the entire financial year.

  • Left to spend: This adds the Year to Date, Actual, and Commitment values and subtracts the total from the annual Budget value. This shows the amount left to spend against the budget for the financial year.

The report splits the individual transactions into two sections: Actual and Commitments.

Actual

The data in the actual section depends on your selection in the Show Current Period Transactions Only? criteria. If you select Yes, the transaction list shows only the transactions for the selected period. If you select No, the transaction list shows all actual spend for the financial year up to and including the selected period.

The transaction section includes these details:

  • Document: The document type and number of the transaction.

  • Nominal: The nominal code used in the transaction.

  • Supplier: The name of the supplier, if you used one. The date of the document also shows.

  • Description: The description you entered when you posted the transaction.

  • Balance: The value of the transactions for each document. The report shows credit values in brackets and a total for the document.

Commitments

This section shows any purchase orders that have not been invoiced.