Enhanced interface

Account Balances report filters

To access this report, go to General Ledger > All > Reports > Account balances.

Subscription	General Ledger
Regional availability	All regions
User type	Business, Employee, Approval
Permissions	Permissions inherited from Trial balance report Trial balance: Run

You can filter the list of accounts by single account, account range, account group, or multiple accounts. You can include normal GL accounts as well as statistical accounts. And you can constrain all these by location and/or department. You can also choose to suppress or display accounts with zero balances. And you can constrain all these by location and/or department.

Select the main Reporting book to be used for this report from the drop down menu.
If you enabled Other reporting books, select any combination of Other books to use in the report.
If your administrator has configured a default for Other Books, these books will already be preselected. You can change the selections if necessary but most often the defaults will be correct.
If you enabled Other reporting books, decide whether to combine amounts from your main Reporting book with the Other books.
By default, amounts from all books are combined together. For example, if you include your compliance book with your accrual book, the report will show accrual amounts with the compliance adjustments applied.
Tell me more about including or excluding the main reporting book
By default, amounts from the main reporting book are included to create a combined amount. However, there are times when you might want to deselect this option.
For example, suppose that your compliance adjustments equal -1,000 and the accrual amount is $10,000. What do you want to see in the column?
-1,000 (the compliance amount, not including accrual)
OR
9,000 (the combined amount, including accrual)
Select accounts to include in your report by using one of the following methods:
- Select a single account in the From account field.
- Select a range of accounts in the From account and To account fields.
- Select an account group in the Account Group field. You can select any type of account group except statistical account groups.
To include statistical accounts in the report output, select the Include statistical accounts checkbox.
From the dropdown lists, select the dimensions to include in your report.

What are dimensions?

A dimension is a category of data that you can organize and sort in meaningful ways. Sage Intacct provides the following predefined dimensions:

Location
Department
Class
Customer
Item
Project
Vendor
Employee
Warehouse (if you subscribe to Inventory Control)
Contract (if you subscribe to Contracts)

In addition, Intacct enables you to define new dimensions to suit your needs. Use these user-defined dimensions to organize and sort categories of data unique to your business. For example, if you’re a software company with multiple product lines, you can create a user-defined dimension called Line of business. Then add the values Direct customers, Channel partner, and OEM.

Dimensions enable you to collect, sort, analyze, and report on data within one category, or between categories, so you can identify key factors such as:

Your most profitable or most costly items or customers
The return on investment of a project or department
Whether and to what degree a new product or product line is successful
Which way a particular aspect of your business is trending
Intacct dimensions give you fine control over data definition and data hierarchy

With dimensions, you can customize financial reports around specific business activities, get greater visibility into how the business is doing, and make faster, more meaningful business decisions.

Think of dimensions as a more powerful alternative to subaccounts.

Additional fees can apply for the Project dimension and user-defined dimensions. Contact your account representative for more information.

Using dimensions

If you use dimensions for reporting, you can filter them by selecting the appropriate combinations. You can also select predefined dimension groups.

For example, if you select the department group ENG, which includes hardware and software engineering plus Quality Assurance, the report will include the data for those three departments only.

In multi-entity shared companies, location groups also include entities.

Use dimensions for reporting by entering the desired dimensions information in this section, in one of the following ways:

Enter information directly in fields.
Select the pick icon to display a list, and then select Select next to the entry you want.

Except for the Class dimension, each dimension has an additional corresponding filter you can use to focus your report and refine (or filter) the results. These additional filters are:

Additional dimension filters
Dimension	Additional filter
Project	Project type
Customer*	Customer type
Vendor	Vendor type
Item	Product line
Employee	Employee type
Class	None

Include subdimensions, Individual reports, and Prompt on run

These options provide additional control over how dimensions are handled in the report.

Reporting options
Option	Description
Include subdimensions	Includes subdimensions, such as child locations or child customers, when filtering. Clear this checkbox if you don't want Intacct to include children of the dimension when filtering.
Individual reports	If you select a department group and/or location group, this option creates a separate report for the individual department and/or location combinations. The order in which individual reports are created is determined by the order of the locations and departments in the groups. When you select Individual reports, all of the individual reports are contained in a single report or Excel workbook. You can include additional report header text for each department or location. Learn more about generating individual reports by department or location.
Prompt on run	Select this checkbox to be prompted for a department, location, and/or time period each time you run the report. If you select a department or location to filter on, and also select the Prompt on run option, the department or location that you selected will be autofilled as the default.

For multi-entity shared companies with multiple base currencies: Reports that you run at the top level require a location to ensure that Intacct will display all amounts in the same base currency.

The following table describes each item in the Filters section of this report settings page:

Filter option	Description
Reporting book	Displays the name of main reporting book to be used for this report. If you opted for dual-method reporting (Accrual and Cash) or if you are using Global Consolidations, you can select a different main reporting book.
Other books	Appears only if you have enabled other reporting books, such as compliance, tax, or user-defined books. You can select any combination of Other books to include in the report and decide whether to combine amounts from your main Reporting Book with the other books. Learn more about Report on other books—compliance, tax, and user-defined.
From account/To account	Select a single account or a range of accounts from the dropdown lists.
Account group	Select an account group from the dropdown list.
Include statistical accounts	Select this checkbox to include statistical GL accounts as well as normal GL accounts.
Department	Enables you to limit report results to 1 or more specific departments.
Location	Enables you to limit report results to 1 or more specific locations.
Individual report	Select this checkbox if you want each entity or department and/or location to have its own report page.
Prompt on Run	Select this checkbox to require you (or anyone using this report) to enter an entity or location and department before the report will run.
Project	Enables you to limit report results to 1 or more specific projects.
Project type	Enables you to limit report results to 1 or more types of projects.
Customer	Enables you to limit report results to 1 or more customers.
Customer type	Enables you to limit report results to 1 or more types of customers.
Item	Enables you to limit report results to 1 or more items.
Product line	Enables you to limit report results to 1 or more product lines.
Employee	Enables you to limit report results to 1 or more employees.
Employee type	Enables you to limit report results to 1 or more employee types.
Vendor	Enables you to limit report results to 1 or more vendors.
Vendor type	Enables you to limit report results to 1 or more vendor types.
Class	Enables you to limit report results to 1 or more classes.