General Ledger Reporting

The GL Reporting dashboard contains data from the campus general ledger: Berkeley Financial System (BFS) and includes the following reports:

General Ledger Summary

Provides an interactive summary level report with information from the BFS general ledger to review balances as of the accounting period that you’ve selected. Dept, Fund, and Account Category are the default columns, but you can choose the Expanded view to see the full chartstring, or include/exclude columns on the fly. Data is summarized into columns for Authorized Budget Amount, Temporary Budget Amount (includable column), Actuals Amount, Ending Funding Balance (includable column), Encumbrance Amount, and Remaining Balance (less encumbrances). Use the prompts at the top to filter this report by different chartfields, and more.

By Accounting Period

Supports trend analysis by providing a report of all accounts by account category in a monthly format. The data includes activity in all accounts for both current and non-current funds. 

Compensation by Accounting Period

This tab displays data in a monthly format and facilitates tracking and reconciling payroll activity as posted to BFS by including compensation related expenses by month. The data includes activity in the Compensation accounts for both current and non-current funds. 

General Ledger Detail

Enables monthly reconciliation down to the lowest level of transaction detail. This tab provides all types of transactions at the lowest level of transaction detail, including key identifiers for tracing activities back to the source system, such as Journal ID, Document ID, Journal Posted Date, Purchase Order ID, etc. Use this tab to reconcile transactions after the close of each month, or to view selected transactions using the filters at the top. 

Prior vs Current

This report tab allows you to select a range of periods to review balances at the beginning of the range, in-range activity, and balances at the end of the range. It replaces the popular 9 column summary and detail reports that are especially useful for Contracts and Grants. It is based on a range of Accounting Periods selected using the filters at the top and displays activity and balances across the chartfields through the end of the selected time range. 

Encumbrances

This tab provides encumbrance details, including Purchase Order Number and Journal ID, for tracing purchasing activities back to the BearBuy and BFS source systems. Use this tab to track outstanding liabilities your unit has to suppliers and other entities that need to be paid. This report is useful for financial services, business services, and procurement professionals who use BearBuy and/or BFS to close out purchase orders.

Transaction Verification 

This report tab displays transactions initiated outside selected Org Nodes, so you can verify transactions that belong to your unit. There is no summarization; the data returned is all at the transaction level.