01
About this report
One row per posting line in the primary accounting book, for posting periods in the last 24 months. Each row gives the period, date, transaction type and number, account and account type, the customer, vendor or employee, the line memo, debit, credit, and an amount that reads credit-positive the way income shows on the statement.
Opened from Income statement by month, it arrives filtered to one account and month, and its Amount column adds up to the figure clicked. On its own, filter by Account and Month for a reconciliation. In a busy account this report is large, so use it for drill-through and narrow filters.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Month | Date | Type | Document | Account | Account type | Name | Memo | Debit | Credit | Amount (credit positive) |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09 | 2026-09-19 | Invoice | INV20931 | 4100 Services | Income | Harbor & Pine Co. | September milestone | 7,600 | 7,600 | |
| 2026-09 | 2026-09-19 | Invoice | INV20931 | 1200 Accounts Receivable | Accounts Receivable | Harbor & Pine Co. | 8,445.20 | -8,445.20 | ||
| 2026-09 | 2026-09-15 | Bill | INV-44120 | 6310 Hosting and software | Expense | Cloudway Hosting | Production cluster, September | 12,800 | -12,800 | |
| 2026-09 | 2026-09-15 | Bill | INV-44120 | 2000 Accounts Payable | Accounts Payable | Cloudway Hosting | 14,200 | 14,200 |
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,
TO_CHAR(t.trandate, 'YYYY-MM-DD') AS tran_date,
BUILTIN.DF(t.type) AS type,
NVL(t.tranid, t.transactionnumber) AS document,
a.displaynamewithhierarchy AS account,
BUILTIN.DF(a.accttype) AS account_type,
NVL(e.altname, e.entityid) AS name,
tl.memo AS memo,
tal.debit AS debit,
tal.credit AS credit,
-tal.amount AS amount
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
LEFT JOIN entity e ON e.id = t.entity
WHERE tal.posting = 'T'
AND tal.amount <> 0
AND p.startdate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
ORDER BY t.trandate DESC, document04