01
About this report
Postings to Expense accounts from the general ledger, primary accounting book, grouped by the department on each line and the month of the posting period. It covers the last 24 months in base currency, with debits positive. Cost of sales and other expense accounts are not included. Lines with no department are grouped as (no department).
Group by Quarter to compare with budgets, or filter on Department to follow one cost centre.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Month | Department | Expense |
|---|---|---|
| 2026-09 | Engineering | 118,400 |
| 2026-09 | Sales and Marketing | 76,210.50 |
| 2026-09 | Administration | 51,300 |
| 2026-09 | (no department) | 2,140 |
| 2026-08 | Engineering | 121,950 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT TO_CHAR(p.startdate, 'YYYY-MM') AS period,
NVL(BUILTIN.DF(tl.department), '(no department)') AS department,
SUM(tal.amount) AS expense
FROM transactionaccountingline tal
JOIN accountingbook ab ON ab.id = tal.accountingbook AND ab.isprimary = 'T'
JOIN transaction t ON t.id = tal.transaction
JOIN account a ON a.id = tal.account
JOIN accountingperiod p ON p.id = t.postingperiod
JOIN transactionline tl ON tl.transaction = tal.transaction AND tl.id = tal.transactionline
WHERE tal.posting = 'T'
AND a.accttype = 'Expense'
AND p.startdate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
AND p.startdate <= SYSDATE
GROUP BY TO_CHAR(p.startdate, 'YYYY-MM'), NVL(BUILTIN.DF(tl.department), '(no department)')
ORDER BY period DESC, expense DESC