About the Account Balances report

Use the Account Balances report to:

  • view balances of accounts by a single account, a range of accounts or an account group
  • include or exclude statistical accounts
  • further filter the list to specific locations and/or departments
  • display accounts with a zero balance or just those zero-balance accounts that have had activity
  • select the Retain YTD Balances feature to show accumulated balances for income statement accounts that close into retained earnings at year-end.
  • drill down through accounts to the general ledger, and then to individual transactions.

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

Who typically uses this report?

This report is helpful to many people across the company: budget planners, forecasters, CFOs, and auditors who need the current information about the company, based on account balances.

What’s in the report

When run in Summary mode, the Account Balances report consists of the following columns.

Report Column Heading Description

Account number

The account number included in the report.

Account name

The account name.

Opening Balance

The amount of the account's balance on the date shown.

Debit

The charges posted to the account for the selected period.

Credit

The payments posted to the account for the selected period.

Adjusting Credit

Adjustments made to the payments posted to the account for the selected period.

Adjusting Debit

Adjustments made to the charges posted to the account for the selected period.

Closing Balance

The total amount of the account's balance after adjustments.

When you run the report in Details mode, the report displays the following columns.

Report Column Heading Description

Account number

The account number included in the report.

Account name

The account name.

Date

The date on which a transaction was made. The initial entry is the opening balance for the selected time period.

Doc

Any documents related to the transaction.

Memo

Any memo included when the transaction was made.

Amount

The amount of each transaction by account (deposits and receipts, cheques, and disbursements), with a subtotal and ending balance for the period selected.

If you require additional information on the report, customize or create a new financial report to include it.