Overview
This unscheduled yearend job has two purposes:
- Loads the previous year’s balance sheet items ending balance into the new fiscal year with accounting period of BB (Beginning Balance). These balances are displayed in the Beginning Balance Line Amount column on the General Ledger Balance lookup.
- Loads the previous year's revenues and expenses actuals and budgets to facilitate project to date reporting. Transactions are loaded with accounting period CB. CB represents Cumulative Balances and displays in the Beginning Cumulative Balance Amount column on the General Ledger Balance Lookup.
Entries are summarized by chart code, account number, sub-account number, object code, sub-object code, balance type, and object type. Each combination is considered as a unit of work in the application of the following business rules.
Business Rules
The following define Balance Sheet balances to roll forward:
- Balance types are defined in the parameter BALANCE_SHEET_BALANCE_TYPES
- Object types representing assets, liabilities, and fund balance defined in the Systems Options table
- Annual balance amount plus the beginning balance amount does not equal zero
The following define Cumulative Balances to roll forward:
- Balance types are defined in the parameter INCEPTION_TO_DATE_BALANCE_TYPES
- Sub-funds and fund groups defined in parameters INCEPTION_TO_DATE_FUNDS INCEPTION_TO_DATE_SUB_FUNDS
- The annual balance amount plus the Cumulative balance amount does not equal zero
Parameters
The following parameters are used by the balanceForwardJob.
- BALANCE_SHEET_BALANCE_TYPES: Asset, liability and fund balance balance types selected by the balanceForwardJob when rolling balances forward to the next fiscal year. The entries will post with fiscal period BB, Beginning Balance.
- INCEPTION_TO_DATE_FUNDS: Fund groups treated as inception to date by the balanceForwardJob in order to create project to date balances. The entries will post with fiscal period CB, Cumulative Balance. Used in conjunction with INCEPTION_TO_DATE_BALANCE_TYPES.
-
INCEPTION_TO_DATE_SUB_FUNDS: Sub fund groups treated as inception to date by the balanceForwardJob in order to create project to date balances. The entries will post with fiscal period CB, Cumulative Balance. Used in conjunction with INCEPTION_TO_DATE_BALANCE_TYPES.
-
INCEPTION_TO_DATE_BALANCE_TYPES: Balance types that will be rolled forward to create income and expense inception to date balances by the balanceForwardJob. The entries will post with fiscal period CB, Cumulative Balance. Used in conjunction wth INCEPTION_TO_DATE_FUNDS and INCEPTION_TO_DATE_SUB_FUNDS.
Reports and Files
Directory |
Name |
Description |
staging/gl/originEntry |
gl_balance_forwards.data |
Beginning balance entries for open and expired accounts. This file can be loaded via the General Ledger Correction Process. |
staging/gl/originEntry |
gl_balance_forwards_closed.data |
Beginning balance entries for closed accounts. This file should be reviewed and if appropriate, the account reopened in order to post the beginning balances; or the account changed to a different account. Not posting these entries may result in the General Ledger getting out of balance. The file can be loaded via the General Ledger Correction Process. |
reports/gl |
year_end_balance_forward_ date/time.txt |
Summarizes the entries created by the balanceForwardJob. |
Comments
0 comments
Please sign in to leave a comment.