Customer Balance Summary

The Balances report allows you to find information about posted (cleared) and pending (uncleared) totals one or more customers, ledgers, quarter, and/or bank accounts.

Customization

To customize this report:

Go to Reports > Liability Variance.
Click Customize at the top of the page.

You can change the Group by options to group the data by customer, bank, and/or quarter.

You can customize the report based on the following filters:

Choose the Account(s): Choose a single account, multiple accounts, or all accounts to include
Choose the Customer(s): Choose a single customer, multiple customers, or all customers to include
Choose the Ledger: Choose a single ledger, multiple ledgers, or all ledgers to include
Choose the Quarter: Choose a single quarter, current quarter, or all quarters to include
Set the As of Date: There are two date options, Transaction Date and Ledger Date. Transaction Date is the date of the ledger transaction. Ledger Date is the date the transaction was added to the ledger.

You can add and delete columns based on what you would like to see displayed in the report.

Click Run Report.

The Posted column includes the sum of ledger transactions that have cleared in a prior bank reconciliation and non-banking transfers.
The Pending column includes ledger transactions that have not cleared in a prior bank reconciliation.
The Ledger Balance column includes all posted and pending ledger transactions.

The report data can then be exported to a csv file.