Print Trial Balance Report

Use this screen to print a condensed report of all account balances.

Normally, you print and review the Trial Balance report before you close each accounting period. During Costpoint implementation, print the Trial Balance after initializing project and non-project beginning balances to determine that the general ledger is in balance and that account balances were properly initialized.

The Trial Balance report retrieves account balances from the FS_SUM table, which stores balances by fiscal year/account/organization combinations.  There is only one line in the FS_SUM table for each fiscal year/account/organization combination. Each record contains individual fields that summarize the beginning balance, period 1 amount/hours, period 1 amount/hours, and so on. For a detailed listing of each posting for a particular account, you can use GL_POST_SUM, along with GL_DETL.

The Trial Balance report is an essential part of the system audit trail. You may want to retain a copy of it with your other period closing reports.

Note: You can apply organizational security to this screen. Use organizational security to grant or deny rights for individual users to view or update information for specific organizations. For more information about organizational security and how to apply it, see the related topic on Organizational Security.