Category Balance Report
Reports
Use the Category Balance Report to list the accounts in a category and total the amounts. The category balance is the sum of credits and debits on the accounts in a category. You can set up the report options to view category information by single period, YTD totals, or by quarter.
This report allows you to filter accounts based on the reporting categories in the Account table (Organization > Chart of Accounts). The report will list each account that is tied to the selected categories and then give a total for each category.
You can view a Single Period or YTD totals. You can also view Quarterly options, which displays three periods and the total. If you are looking for the budget information, be sure to select the Budget Amount option.
To learn more, watch a video (1m03s).
Printing a Category Balance Report
1. Open Connect General Ledger > Reports > Category Balance Report.
2. Set up the report dates.
Report dates
How do I change the report date range?
How do I change the date type?
How do I change the date type?
How do I prompt a user to enter a date?
3. Set up the report options on the Report Options tab.
Report options tab
Include report only transactions
4. Set up the report options on the Additional Options tab.
Additional options tab
Provide a running total by account type
Include accounts from these grants only
5. Set up the selection criteria, report order, report sections, and columns.
How do I set up the Selection Criteria?
How do I set up the Report Order?
How do I set up the Report Sections?
6. Click Print (CTRL+P).
202011, 2020Aug19
Report options
Amount type
Choose the amount type to print on the report. Use actual amount to report the real amount. Use encumbrance amount to report amounts that will cover obligations that arise from unpaid purchase orders. Use budget type to report amounts for planning, and projecting revenues, expenses, and capital expenditures for future fiscal periods.
Amount type box
Include pending amounts
Include amounts that have been submitted for approval.
Include pending amounts checkbox
Include report only transactions
Include amounts that will be recorded and updated to the General Ledger application as a report only transaction.
Include report only transactions checkbox
Include all accounts
Include accounts to report amounts for all accounts.
Include all accounts checkbox
To include only accounts for the categories that are selected in the Category list, do not select the Include All Accounts checkbox and then select the category codes to include on the report from the Category list.
Category list
Categories
The list shows category codes in the General Ledger application. Selecting the checkbox in the header row will include all category codes in the report. To report amounts by category code, select the checkbox next to a category code.
Categories
Additional options
Total
Use Total Segments by Segment to use the segment to group accounts. When the segment changes, the report will total the transactions in the group and then print the segment total.
Use Total Segments with Leading Segments to use the leading segment to group accounts. When the leading segment changes, the report will total the transactions in the group and then print the leading segment total.
Total box
To learn more about segment selection and reports, see Segment Selection.
Provide a running total by account type
Use the account type to group accounts by account type. When the account type changes, the report will total the transactions in the group and then print the account type total.
Provide a running total by account type checkbox
Include accounts from these grants only
This option is only available when a journal allows grants. To learn how to set up grant accounting in the General Ledger application, see How do I turn on grant accounting?
Include accounts from these grants only
Copyright © 2025 Caselle, Incorporated. All rights reserved.