Columns

1. Column Format

Specify the format of the twelve columns that print on the spreadsheet:

1: Last 12 Months Actual (default)

2: Year-to-Date Actual

3: Year-to-Date Actual plus Remaining Budget.

2. Budget Ledger Type

If the Column Format processing option is set to 3, enter the ledger type for the remaining budget. If you leave this processing option blank, the system uses ledger type BA.

3. Ledger Type

Enter the ledger type in which to base the spreadsheet. If you leave this processing option blank, the system uses ledger type AA.