The Invoice Details and Payments Report provides a line-item breakdown of invoices and payments within a chosen date range — useful for financial period closing, auditing, and year-end reviews.
How to Access the Report
Navigate to Reporting > General.
Click Invoice Details and Payments Report (Client/Trust Accounting) under Financial.
Filters
Report For — company or companies to report on, filtered by type.
Account Types — accounting category for line items to include.
Status — filter by invoicing status.
Date Filter Applied To — apply date range to invoice issuance or payment dates.
Start/End Date — date range for the report.
Transaction Types Included — invoices, credit notes, or both.
Run Report By — by owner or ledger (Trust Accounting), or by owner or property (non-Trust).
Bank Account — account for which to run the report.
Include Archived Ledgers (Trust Accounting only) — include transactions from archived ledgers.
Property, Tenancy, and Owner Tags to Include — filter by assigned tags.
Property Managers to Include — limit to specific property managers.
Owners/Ledgers/Properties to Include — focus on selected owners, ledgers, or properties.
Generating and Exporting
Click Generate Report on Screen to view immediately.
Click Download as CSV or PDF (Portrait / Landscape) to export.
Column Reference
Column | Description | Optional |
Issue Date | Issue date on the invoice | No |
Created Date | Date the invoice was created/generated | Yes |
Due Date | Due date on the invoice | No |
Service Date | Budget period the invoice is attributable to | Yes |
Invoice | Unique invoice identifier number | No |
Credit Note | Unique credit note identifier number | No |
Reference | Reference on the invoice or credit note | Yes |
Ledger | Ledger assigned to the line item | No |
Property Manager | Property manager of the related property | Yes |
Related Property | Related property on the invoice | Yes |
Area Occupied | Area/s occupied by the related tenant | Yes |
Related Tenancy | Related tenant on the invoice | Yes |
Contact | Name of the related contact | Yes |
Description | Line item description | No |
Account | Account assigned to the line item | No |
Net Amount | Net amount on the line item | No |
GST Rate | GST rate assigned to the line item | No |
GST | Amount of GST charged | No |
Gross Amount | Gross amount charged on the invoice | No |
Date Paid/Allocated | Date a payment was made or credit note allocated | Yes |
Date Payment/Allocation Processed | Date a payment or credit allocation was processed | Yes |
Amount Paid/Allocated | Amount paid or allocated to the invoice | No |
Outstanding | Outstanding amount still to be paid | No |
Status | Approved or paid | Yes |
Emailed? | Has the invoice been emailed? (Yes/No) | Yes |
Source | Transaction type (Income Invoice, Credit Note, etc.) | Yes |
In Asia-Pacific, "Trust Account" is the standard term; European customers refer to it as "Client Account". Client/Trust Accounting functionality does not apply to customers in North America. For more information on regional terminology, see our Glossary of Regional Terminology.