Determining Subledger Budget Roll Down

Use the subledger budget roll down functionality to allocate funds from a main account into subledger accounts. On the G/L Budget Roll Down screen, you can specify what subledger accounts you want your budget figures to prorate to, and determine what amounts to allocate to each subledger.

To determine subledger budget roll down:

  1. From the G/L menu, select G/L Budgeting to display the G/L Budget Maintenance screen

  2. Enter the account for which you want to allocate subledger budget amounts.

  3. Use the Roll Down hot key to display the G/L Budget Roll Down screen.

The Account, Yr, and Branch fields reflect the information from the G/L Budget Maintenance screen.

  1. In the Subledgers column, do one of the following:

  2. Use the Get All hot key to populate this column with any active subledger accounts tied to the main account. The system populates the first row with the following information:

  3. Subledgers – *Default*

Note: Use the default account as a holding account where you can set aside funds that do not, as yet, have a subledger account established.

  1. Enter the name of the subledger account to which you want to allocate budget amounts. You can only enter subledgers that are tied to the main account you entered on the G/L Budget Maintenance screen.

  1. Leave the field blank to allocate budget amounts from the main account to a single subledger account.

  1. In the % column, enter the percentage of the budget amounts from the main account that you want to allocate to the subledger account. Percentages must add up to 100%.

The following occurs:

  1. The Description column reflects the short name or purpose of that subledger, as defined on the G/L Subledger Maintenance screen. For more information, see Creating Subledger Accounts.

  2. The Total field reflects the sum of all subledger amounts.

  1. Use any of the following hot keys to work with subledger accounts:

Hot Key

Function

Get All

Populates the SubLedger column with any active subledger accounts tied to the main account.

Note: The system does not retrieve accounts that are used for validation.

Clear All

Clears the SubLedger column of all subledger accounts.

Even Alloc%

Allocates an even percentage amount to each subledger.

When you select this option, the system calculates the amount based on the number of subledgers you selected.

Begin Roll

Allocates the budget amounts to each of the subledgers you selected.

When you select this option,the system overwrites any prior budget figures in the selected subledgers.

  1. Use the Begin Roll hot key to start the roll down process.

Displays a prompt where you can determine whether or not to include the amounts from all the subledger amounts for an account. Enter one of the following:

Note: The system applies any rounding that occurs because of percentages to the last subledger account.

  1. Press Esc to return to the G/L Budget Maintenance screen.