balanceForwardJob

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 determine when Cumulative Balances will 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 and  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. Typically this file does not need to be loaded, it primarily contains Project to Date entries for Revenue and Expense carry forward. However, the file should be reviewed to make sure that if there are any Asset, Liability or Fund balance transactions they do not need to be loaded. The file can be loaded via the General Ledger Correction Process or the file can be staged in the staging/gl/originEntry directory with a .done file of the same name. The file will then be processed by the nightly batch processes.
reports/gl	year_end_balance_forward_ date/time.txt	Summarizes the entries created by the balanceForwardJob.