Show All Bank Accounts in a Single Report

The Bank Register report can only display one bank account, which is determined by the Default Bank Account set in Home > Set Preferences > Analytics tab. To show all bank accounts in a single report, follow this alternative solution:

Solution:

  1. Navigate to Reports > Financial > Balance Sheet > Customize Detail.
  2. Click Filters.
  3. In the report builder, expand the Financial folder on the left side.
  4. Expand the Account Type folder and click Long Name.
  5. In the pop-up window, select Bank for its value.
  6. Click Preview or Save.

The report will now display all bank accounts and their transactions based on the selected date. Note that for single-instance accounts, the bank account balance will show in the Base Currency set on the Company Information page. For OneWorld accounts, it will display the Base Currency of the Parent Subsidiary.

Leave a comment

Your email address will not be published. Required fields are marked *