Customer Payment Report
All money received from sales - POS receipts, the invoice Payments tab, and Receivable Collection - grouped per division, per user who recorded it, per payment type. The cashier takings report.
Questions It Answers
- How much must each cashier hand over today - how much cash, how much card/transfer?
- How much customer prepayment was used as payment this period?
- How much payment charge (e.g. card fees) and payment discount occurred?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Date range of the payments. Empty means the whole history - slow on years of data, so always fill it. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Payment Type | One type only; pre-filled from the role's default when set. |
| Customer | One customer only. A role locked to a specific customer gets it pre-filled and read-only. |
| Currency | Only transactions in that currency. Amounts are still shown in the company default currency. |
How To Read It
Nested result: Division > User Code (the user who recorded the payment - the cashier) > one row per payment type.
| Column | Meaning |
|---|---|
| Code, Payment Type | The payment type from the master. |
| Kind | Its class: Cash, Cheque, Bank, Giro, Sales Prepayment, or Purchase Prepayment. |
| Debit | Money received. |
| Credit | Money given back (change, return refunds). |
| Payment Discount | Payment discount granted. |
| Payment Charge | Charge applied to the payment, e.g. a card fee. |
| Total | Debit - Credit - payment discount + Payment Charge. |
Why The Numbers May Differ
- This is money received, not sales: unpaid credit invoices are absent, and a payment of last month's invoice lands in this month.
- The Sales Prepayment row is not money in on that day - the deposit was received when the Customer Prepayment form was made.
- The user is whoever created the payment row; a payment edited by someone else still belongs to its creator.
- This report does not filter on invoice approval status.
Menu Location
- Sales & POS / Sales Reports / Customer Payment Report
/report/repsalespayment