Financial report output

If you run a financial report and the output is different from what you were expecting, you might find the answer to your question in this topic. In some cases, you or the report owner might need to review the report definition and make changes.

Accounts or sections are missing from the report

Generally, sections and accounts in a financial report are determined by the account groups in the report definition. For example, including an "Assets" account group in a report automatically includes Assets, any subgroups (such as Fixed Assets), and individual accounts. By default, the account groups and associated accounts are included in the report as long as they have amounts other than $0.00.

In most cases, missing sections or accounts is due to:

  • Accounts that aren't included in any account group
  • Account groups that are incorrect or not complete
  • Accounts have a $0.00 balance for the reporting period, which results in the row not being included in report output
  • Accounts with inactive dimensions members

For troubleshooting instructions, refer to Missing accounts and account groups in financial reports?

Problems drilling down from amounts

In most cases, selecting an amount in a financial report lets you drill down to a general ledger report that shows how that amount was derived. For example, selecting a $5000.00 amount for Accounts Payable displays a general ledger report that shows the transactions that resulted in the $5000.00 amount.

There are some cases in which you can't drill down from an amount in a financial report to see the detail. In general, this situation occurs when account groups selected for the financial report have additional filters applied to them, which wouldn't be applied in the general ledger report. In this case, you can't drill down from the amount because the general ledger report would result in different transactions or amounts.

To resolve the problem, consider editing the account groups or using different account groups that do not have filters applied.

Except in specific situations, it's recommended that you avoid adding filters to account groups. If you need to filter a financial report, you can do that on the Filters tab of the financial report.

If you drill down from an amount on a financial report and the resulting general ledger detail report displays different transactions or totals, the financial report can be filtered to hide inactive departments or locations.

  1. Go to the Filters tab of the report definition.
  2. If the Hide inactive checkbox is selected next to either the Department or Location filter, clear the checkbox.
  3. Run the report again.

The most common reason that you do not see this feature is that you're using a custom view.

When you select a custom view, some options are hidden. Depending on the page you're on, the Include inactive, Include one-time use, Include private, and Display hierarchy options are not visible. For example, if you're viewing from a custom view, the Financial Reports list will not provide the Include inactive option.

To see the options again, switch back to View All. See Custom views for more information.

Row formatting and Expand by options don't appear as expected

Following are some common problems that you might encounter when updating the rows of your report.

An account group can have only one set of formatting and Expand by options per report. For example, suppose that you add a Cash account group and then add a Current Assets group that also contains the Cash account group. Changing the formatting for the group in one section, such as expanding the Cash account group to show details, automatically changes the formatting for that group everywhere that it appears in the report.

To resolve this problem, try duplicating the account group. Then, edit the report so that each account group appears only once.

Some formatting options apply only to the printed (PDF) output. These include:
  • Center heading
  • Blank lines above
  • Page break after

If a dimension group has both parent and child dimensions, children will be grouped with their parents. Then the report shows the parent as the last member of the group when Expand by dimension, all levels is selected.

For example, suppose that you have a department group named '100-level Department Group'. This group contains both parent and child departments. Within this group, the group member "100--Customer relations" is the parent and rest of the group members are its children.

If you select Expand by dimension All levels, with individual balance, Intacct groups child departments with their parent, then puts the parent as the last member in the group. In this case, Intacct doesn't consider the order of the group members.

Verify that both users have the same permissions and report settings. Look for different permissions, such as permissions for Entities or Departments. Check to see if one user has Include subdimensions enabled on a Location filter and the other doesn't.

Transactions not picked up when a financial report is filtered by a dimension group

When filtering a financial report by a dimension group, if you note that transactions are not getting picked up, that's because the filters on the dimension group are filtering for the dimensions' data, not the transaction data.

For example, suppose that there's a company with the locations:

  • 100--New York
  • 200--San Francisco

To create a location group for the East Coast locations only, do one of the following:

  • Set the group type to All members and filter for the ID not equal to 200.
  • Set the group type to Specific members and select the specific locations to include in the group.

To view the members of this location group, select Members next to the location group.