01
About this report
Bill lines less vendor credit lines, before tax, in base currency, by vendor and month for the last 24 months. The Bills column counts the bills and credits in the month.
Click a Spend figure to open Vendor bill lines filtered to that vendor and month, where the lines add up to the figure clicked. Group by Quarter or Year, or filter on Vendor, to prepare a vendor review.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Month | Vendor | Bills | Spend |
|---|---|---|---|
| 2026-09 | Cloudway Hosting | 2 | 14,200 |
| 2026-09 | Ridgeline Contractors | 3 | 11,380 |
| 2026-09 | Pacific Office Partners | 1 | 3,120.40 |
| 2026-08 | Ridgeline Contractors | 4 | 16,250 |
| 2026-08 | Metro Courier Services | 6 | 1,284.75 |
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,
t.entity AS vendor__id,
NVL(v.altname, v.entityid) AS vendor,
COUNT(DISTINCT t.id) AS bills,
SUM(tl.foreignamount * t.exchangerate) AS spend
FROM transaction t
JOIN transactionline tl ON tl.transaction = t.id
JOIN entity v ON v.id = t.entity
WHERE t.type IN ('VendBill', 'VendCred')
AND t.posting = 'T'
AND tl.mainline = 'F'
AND tl.taxline = 'F'
AND NVL(tl.itemtype, 'x') NOT IN ('TaxGroup', 'TaxItem', 'Subtotal', 'Description', 'EndGroup')
AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
GROUP BY TO_CHAR(t.trandate, 'YYYY-MM'), t.entity, NVL(v.altname, v.entityid)
ORDER BY period DESC, spend DESCSELECT TO_CHAR(t.trandate, 'YYYY-MM') AS period,
TO_CHAR(t.trandate, 'YYYY-MM-DD') AS tran_date,
NVL(v.altname, v.entityid) AS vendor,
BUILTIN.DF(t.type) AS type,
NVL(t.tranid, t.transactionnumber) AS document,
BUILTIN.DF(tl.expenseaccount) AS account,
BUILTIN.DF(tl.item) AS item,
tl.memo AS memo,
tl.foreignamount * t.exchangerate AS amount
FROM transaction t
JOIN transactionline tl ON tl.transaction = t.id
JOIN entity v ON v.id = t.entity
WHERE t.type IN ('VendBill', 'VendCred')
AND t.posting = 'T'
AND tl.mainline = 'F'
AND tl.taxline = 'F'
AND NVL(tl.itemtype, 'x') NOT IN ('TaxGroup', 'TaxItem', 'Subtotal', 'Description', 'EndGroup')
AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
ORDER BY t.trandate DESC, t.tranid04