Rolling Twelve Month Business Report

This 12 month financial report can be used to reflect a full year's business position for a year in progress by using posted G/L totals up to a determined Period End date, and then substituting the budget amounts to anticipate the remaining months up to the Report End date.
As the year progresses and each month is closed out, the report can be re-run with the new Period End date to reflect actual G/L figures replacing the predicted Budget figures for that month.
Any layout code can be used to generate the report even though the G/L need not be summarized for the period first.

The Total Column is the sum of the Actual and Budgeted figures used on the report to illustrate the financial position.
The Budget Column is the sum of just the budget figures allocated for each month, even though they may not be used on this report.
A comparison of the Total Column and the Budget Column can help determine how close your G/L figures are to the proposed budget.

For confidential purposes, special Security Roles can be defined, limiting access to this report through Menu Security.

The prompts are:

LAYOUT NUMBER

Enter an existing layout code or select one from the drop-down list.

The layout description will print on the financial business report as the report title.

PRINT DIVISION DETAIL

This is an information display field only.

If the report layout has been setup in Statement Layouts with divisions specified in the G/L account detail, then this report will automatically be printed in division detail and this box will be checked to identify that this feature is being used.
If the layout has NOT been setup with division detail, this box will display unchecked.

DIVISION, "ALL" OR "SEL"

This field is skipped if the selected layout has been designed to print the G/L accounts using division detail.
All divisions will automatically be included and the report will respect the divisions specified in the layout setup.

If the layout is not setup to Print Division Detail, a division range can be specified.

• Type ALL to include all divisions in the report.
• To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
• Type SEL to select multiple divisions or use Accounting regions to include in the report, as outlined in Division Select By Region.

Note: This G/L report does not respect divisional restrictions set by operator Divisional Restricted Views .

PERIOD ENDING DATE

Enter the ending PERIOD date.
This will be translated into the ending month of the ACTUAL G/L data to be reflected in the 12 month report.
On the report, the column heading dates of months displaying the actual G/L data are underlined with a double line.

REPORT ENDING DATE

Enter the ending REPORT date.
This will be translated into the ending month of the 12 month report. Any months between the Period Ending Date and this Report Ending Date will reflect predicted Budget amounts, as entered in Budgets .
On the report, the column heading dates of months displaying the budgeted amounts are underlined with a single line.

SUMMARY BY ACCOUNT

If the selected report Layout Number has been setup in Statement Layouts with divisions specified within the G/L account detail, then this option does not really apply and this box will be checked.

If the layout has NOT been setup with details by specific divisions, and the report is NOT being printed for a single division, then the choice is provided to print in account summary or account by division.

Check this box to print only the account totals.

Uncheck this box to print the report with totals by account within each division.
The output will display on separate tabs if output to Excel is selected in Report Options.

TRANSACTION LOCATION

Select one of:

• Select Current use the posted transactions from the current GL file.
• Select History to use the transaction detail from the GL history created when the GL was compressed.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click the ACCEPT button to begin printing the report, or CANCEL to abort.