01
About this report
Customer payments grouped by the month received, for the last 24 months, in base currency at each payment's exchange rate. Customers paying counts distinct top-level customers in the month.
Read it next to Sales by customer by month to see whether collections keep pace with billing. Group by Quarter or Year for longer views. Customers paying shows for months only, because a customer who pays in two months of a quarter is still one customer.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Month | Payments | Customers paying | Amount collected |
|---|---|---|---|
| 2026-05 | 41 | 28 | 351,200 |
| 2026-06 | 38 | 26 | 322,940.50 |
| 2026-07 | 44 | 30 | 380,115 |
| 2026-08 | 36 | 25 | 309,870.25 |
| 2026-09 | 29 | 21 | 262,400 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT TO_CHAR(t.trandate, 'YYYY-MM') AS period,
COUNT(*) AS payments,
COUNT(DISTINCT e.toplevelparent) AS customers,
SUM(t.foreigntotal * t.exchangerate) AS amount
FROM transaction t
JOIN entity e ON e.id = t.entity
WHERE t.type = 'CustPymt'
AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
GROUP BY TO_CHAR(t.trandate, 'YYYY-MM')
ORDER BY period04