The Actual vs. Budget Comparison report (GL_BudgetComparison) compares general ledger actual amounts compared to budgeted amounts with variances over a time period. The tolerance can be by variance amount or variance percentage. The data on the report is sorted according to the variance from the budget: poor (red), neutral (yellow) and good (green). The grid is sorted from poor to good. Grey data indicates no budget values for comparison.
Note
You can use parameter presets to save and select settings used frequently, or schedule the report to run at a specific time in the future.
To run the Actual vs. Budget Comparison report (GL_BudgetComparison), follow these steps:
1. Open the report from the Home page or from the Recent Reports list.
2. Select the data to include or exclude in the report by completing the standard filtering options.
3. Select the Financial Format to use to arrange the raw data on the report.
4. In the Start Period field, select the starting period for the report.
5. In the End Period field, select the ending period for the report.
6. In the Budget Type field, select the budget from which to retrieve budgeted amounts for the specified period. On the report, the budgeted amounts retrieved are compared to the actual amounts retrieved for the same period and year-to-date range.
7. In the Basis field, select the accounting basis to use to retrieve financial information for the report. You can select more than one basis.
8. In the Tolerance by field, select whether to use a variance amount or percentage when determining the tolerance for the report.
9. In the Upper threshold and Lower threshold fields, enter the upper and lower values for the tolerance. These values are treated as either monetary amounts or percentages, depending on the selection in the Tolerance by field.
10. In the Report type field, select a format for the report.
11. Click Generate.