01
About this report
Vendor bill payments by month for the last 24 months, voided payments left out, in base currency at each payment's exchange rate. Vendors paid counts distinct payees in the month. Check transactions are not included.
Read it next to Customer payments by month to compare cash in and cash out. Vendors paid shows for months only, because a vendor paid in two months of a quarter is still one vendor.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Month | Payments | Vendors paid | Amount paid |
|---|---|---|---|
| 2026-05 | 58 | 31 | 241,800 |
| 2026-06 | 61 | 29 | 255,310.40 |
| 2026-07 | 55 | 30 | 238,905 |
| 2026-08 | 63 | 33 | 270,112.80 |
| 2026-09 | 42 | 24 | 188,450 |
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 t.entity) AS vendors,
SUM(ABS(t.foreigntotal) * t.exchangerate) AS amount
FROM transaction t
WHERE t.type = 'VendPymt'
AND t.voided = 'F'
AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
GROUP BY TO_CHAR(t.trandate, 'YYYY-MM')
ORDER BY period