Overview
This report provides visibility to accounts by Account Category in a monthly format for trend analysis. Use this report to track spending throughout the fiscal year and discover the seasonality of your financial activities.
- How much has my unit spent each month so far this year on Compensation? On non-compensation expenses?
- How does that spending break down by Chart1?
Report
Report Views
- Summary (Default) view includes Account Group, Account Category, Actuals Amount for each month (selected in the prompts), and the total actual amount.
- Expanded view also includes the chartstring columns: Dept ID, Fund Code, CF1 Code and CF2 Code.
- You can exclude columns, move columns, change the sort order of data within a column, and include these columns that aren’t present in a report.
Drill Down
The By Accounting Period and General Ledger Detail reports use the same data set. When you click on the link for an amount in the By Accounting Period report, Cal Answers opens the General Ledger Detail report so you can see the transaction details that sum to the clicked value. Click the Return link in the bottom left corner of the window to return to the By Accounting Period report. See User Experience Tips for more detailed information about drill down.
Prompts
- There are 4 required prompts that are identified with an * and are selected by default.
- For best performance, it is recommended that you select additional prompt(s) to limit the results. Filtering on Org and/or Account is recommended.
User Experience Tips
- Results and bookmark links may take slightly longer to load in this report than for the General Ledger Summary and General Ledger Detail tabs because all months through the selected accounting period need to be loaded.
- The 00-Beg column is not drillable because there are no transactions behind it. This is a rollover amount that is a “dummy row” like what is present in BAIRS.
- This report ties to the General Ledger Summary report for Actuals Amount when you have both accounting period prompts set to the same value.
- This report ties to the Compensation by Accounting Period report when both Account Group prompts = Compensation Expenses and you omit the 00-Beg column.
- This report ties to the By Month report in the Financial Management Reporting dashboard for Account Group = Revenues, Compensation Expenses, Non-Compensation Expenses, and Operating Transfers, and you omit the 00-Beg column.