The reports in the General Ledger (GL) Reporting dashboard replace the GL summary and detail reports in BAIRS with the Cal Answers functionality and global access to campus financial data. The project team partnered with the Controller's Office, Divisional Finance Leaders, and the Contracts and Grants team to develop the reports included in this dashboard, which is especially relevant to those who are responsible for BFS journals, who manage non-current funds and who need to report on asset and liability accounts.
General Ledger Reporting Tabs
The GL Reporting dashboard contains data from the campus general ledger: Berkeley Financial System (BFS) and includes the following reports:
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.
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.
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.
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.
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.
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.
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.
- Getting Started with General Ledger (GL) Reporting: Updated 10.04.18 to include details on the new Encumbrance Reporting tab. An overview of the reports in the GL Reporting dashboard.
- General Ledger Reporting Wiki
- Cal Answers Basic Navigation Learning Map: A linear guide to a comprehensive set of the latest training materials to support you in getting started working with the all of the Cal Answers dashboard reports.
General Ledger Top 10 Report Runners, July 2018
Congratulations to our early adopters of the new Cal Answers General Ledger Reports! The top 10 report runners in July ran over 30% of the total General Ledger reports run.
These report runners are leading the way in our campus migration from BAIRS to Cal Answers Finance. Here is what your colleagues have to say about running reports with Cal Answers:
I love how easily I can customize the viewing and reporting in Cal Answers!
Stop using BAIRS and move to Cal Answers.
Learning how to include and exclude columns(link is external) on those dashboards that allow for it really opened my eyes to the power of Cal Answers
This is a very user-friendly system.
I have prepared reports in Cal Answers without any problems, it is so easy.
We appreciate their efforts to embrace the change and move to the future of financial reporting at Berkeley!