Customer Balance Detail Report
Lists every movement of customers' prepaid balances: money loaded, and money used in collections, down payments and other income, with the running balance.
Menu: Reports › Partner Reports › Customer Balance Detail Report
What it's for
Use it for customers who pay in advance (customer load): to show a customer how their deposit was used, or to check a balance. Filter by Transaction Type: customer balance load, collection, collection (down payment) or other income.
Juan's Canteen loaded 10,000.00 on 1 June. The report shows two collections that used 3,200.00 and 4,500.00 of it, leaving a Balance of 2,300.00.
Options on the screen
- At the bottom: Total In, Total Out and Total Balance.
Filters
Click Filters to narrow the report. You can filter by:
Date - Time, Customer Name, Customer Code, Transaction Type, Sheet Number, Remarks.
Columns
| Column | What it shows |
|---|---|
| Transaction Type | Load, collection, collection (down payment) or other income. |
| Sheet Number | The transaction's sheet number; click it to open the transaction. |
| In | Money added to the prepaid balance. |
| Out | Money used from the prepaid balance. |
| Balance | Prepaid balance after this line. |
| Remarks | The transaction's remarks. |
Also shows: Date - Time.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.