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 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 |
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.