Can't see the data and the numbers seem wrong

The sections and accounts in a financial report are determined by the account groups in the report definition. If your report doesn't show some data, or the numbers seem wrong, the most common reason is that inactive data is hidden by filters.

Make sure inactive data isn't hidden

Most often, Hide inactives is used to exclude departments or locations that you're no longer using from appearing in columns or rows. If the Hide inactives filter is enabled for one or more dimensions, the report might not include the data you expect.

To turn off Hide inactives:

  1. Open the report with the unusual output.
  2. Tab to Filters.
  3. In the Define dimension filters section, make sure that Hide inactives is not selected.

Does an account have a R0.00 balance?

By default, account groups and accounts are included in the rows of a report only if they have amounts (other than R0.00).

However, you have the option of including rows in your report even if the amounts are R0.00. For example, you might want to show Charitable Contributions as a row in your report, even if you didn't make any contributions during the reporting periods covered by the report.

To always display a particular section or account:

  1. Go to the Rows tab of your report.
  2. Locate the section or account, and select the Always Display option.