Customer Balance
Shows how much each customer owes: sales, minus down payments, payments and returns, plus refunds, gives the balance due.
Menu: Reports › Partner Reports › Customer Balance
What it's for
Use it for accounts receivable: at month end, before extending credit, or to send statements. Choose whether checks that aren't deposited yet count as paid (Consider "Pending Deposit Checks" as Paid). Filter Balance Due to see only customers with a balance.
ABC Grocery: Sales 180,000.00, Paid 140,000.00, Pending Deposit Checks 20,000.00 (a post-dated check), Return 3,500.00, Balance Due 16,500.00. Since the check hasn't cleared, the manager waits before approving a new credit order.
Options on the screen
- Consider "Pending Deposit Checks" as Paid: tick to treat undeposited checks as paid.
- In the filters: Branch, Trans. Date, the customer, Transaction (with or without transactions) and Balance Due (with or without balance).
- At the bottom: Total Sales, Total Paid, Total Unpaid, Total Return, Total Refund and Total Due.
Filters
Click Filters to narrow the report. You can filter by:
Branch, Trans. Date, Customer, Transaction, Balance Due.
Columns
| Column | What it shows |
|---|---|
| Customer | The customer. |
| Sales | Total of the customer's sales outbounds. |
| Downpayment | Down payments received. |
| Paid | Payments collected. |
| Pending Deposit Checks | Checks received but not yet deposited or cleared. |
| A Pending "For Transfer" "Checks" | Payments by pending transfer or check that are counted as paid. |
| Return | Value of goods returned by the customer. |
| Refund | Money refunded to the customer. |
| Balance Due | What the customer still owes. |
| Last Sales Date | Date of the customer's last sale. |
| Prepaid Balance | Prepaid money the customer has with you (customer load). |
For searching, express filters, sorting, column settings, exporting and printing, see About reports.