Unrestricted Funds Brio Queries
The Hyperion Brio queries below are available to assist units in their year-end reviews of accounts with closing attributes, accounts with stops/deletes, and payroll suspense accounts.
 Account Closing Cycle Query
- This query identifies accounts with closing cycles and includes dept, sub-ledger, title, fund, source, close to account, close cycle, report year and last transaction date.
- Using "close to" accounts eliminates the need to process journal entries at year end. Each close cycle transfers funding to or from the "close to" account, depending on the cash balance using object code 2590.
- "Close to" cycles are generally used in fund group 43x, 46x, and may be used in other fund groups. All endowed 43X fund group accounts must have "close to" accounts.
- Four closing cycles take place between preliminary year-end and final year-end closings. The closing process starts after all JEMS journals are approved ().
- Prior to final close, general accounting reviews A1, A2, A3, and A4 cycles to make sure they are in sequence. An account cannot close to another account that closes within the same cycle.
- All requests to change closing cycles can be submitted via email to uco-unrfds@cornell.edu
 . Any requests submitted after must be reviewed and approved by the Accounting Supervisor.
- The closing cycles for non-state appropriations and 2006 year-end schedule are:
Accounts with Stops and Deletes Query
This query identifies accounts with stops and deletes. It includes department, sub-ledger, title, fund, function, source, stop transaction, delete code, to date account balance, to-date balance without commitments, report year, and last transaction date.
An account can be deleted from the accounting files only at year-end. At the time of final closing, if the balance must be zero ($0.00), there must be no commitments, and July payroll must not be charged to the account.
For any accounts that need a stop and/or delete placed on them, a request can be submitted by accessing the Account Management system.
Payroll Suspense Account (sub-ledger 3995) Query
- This query identifies suspense accounts with payroll charges. The query dept, sub-ledger, title, fund, function, source, to-date balance without commitment, report year, and last transaction date.
- These accounts must not contain any payroll charges and must not have a balance at year-end.
|
Note: The deadline for all stop and delete requests is Monday, July 14, 2008.