The Invoice Details Report in the Report Builder lets you view and analyse invoice and credit note line item data with flexible filters, custom columns, display settings, and export options.
Getting Started
Navigate to Report Builder and select Invoice Details Report.
Run with default filters, or configure your own filters and columns.
Filtering the Report
Click Filters to open the report filters panel.
You can narrow your results by date range, company, invoice status, and transaction type.
Transaction Types
Use the Transaction types filter to choose which records to include in your report:
Invoices — selected by default. Includes all income and expense invoices.
Credit notes — optionally include credit notes alongside invoices.
Note: At least one transaction type must be selected to run the report.
Other Filters
Date range — filter invoices and credit notes by issue date.
Report for — select one or more companies to report on.
Account classes — filter to narrow results by account classification. You can select one or more of the following:
Asset
Liability
Equity
Revenue
Expense
Other — item-based entries where the underlying account class cannot be determined from the accounting system. This is relevant for connected accounting customers where data is synced from an external platform.
Invoice status — filter by status such as Draft, Approved, Voided, Awaiting Approval or Paid.
Include overdue only — limit results to overdue invoices.
Click Run to generate the report with your selected filters.
Customising Columns
Click Columns > Select columns.
Check the columns you want to include.
In the Arrange columns tab, drag and drop to reorder.
Click Apply Changes, then run the report.
Default Columns
The following columns are visible by default:
Company
Invoice number
Issue date
Due date
Contact
Line description
Net amount
GST rate
GST
Gross amount
Amount paid/allocated
Amount due
Chart of account
Status
Additional Columns
You can toggle on additional columns to view more detail. The following columns are hidden by default and available through Columns > Select columns:
Invoice and credit note details:
Emailed — whether the invoice or credit note has been emailed (Yes / No).
Created date — when the record was created in the system. This is distinct from the issue date.
Service date — the service date on the invoice.
Rent period from — start of the rent period the charge relates to.
Rent period to — end of the rent period the charge relates to.
Transaction type — whether the row represents an expense or income invoice, or a credit note.
Discount — any discount applied to the line item.
Payment and allocation details:
Amount paid — payments only, excluding credit allocations. Use this column if you need to distinguish cash payments from credit allocations.
Payment reference — reference text on the payment.
Allocation date — date the payment or credit was allocated.
Date processed — date the payment or allocation was processed.
Payment method — method used for payment.
Payments/Credits — itemised payment or credit amounts.
Credit note number — number of the associated credit note.
Cheque details:
Cheque number — cheque number on the payment (labelled "Check number" in some regions).
Cheque date — date on the cheque.
Cheque bank — bank name on the cheque.
Cheque branch — branch on the cheque.
Cheque drawer — drawer name on the cheque.
Other:
Chart of account code
Account class
Property
Property manager
Property group
Property owner
Lease
Tax amount
Note: The Amount paid/allocated column (visible by default) includes both payments and credit allocations. If you need to see payments only, without credit allocations, toggle on the Amount paid column. This is useful for distinguishing cash payments from credit note allocations.
Display Settings
Click Display to configure how data is grouped, displayed, and ordered.
Group by:
Display as flat list — a single list repeating data in each column, useful for further sorting and analysis in a spreadsheet.
Property — group results by property.
Account class — group results by account class.
Display rows as:
Line items — show individual line items (default).
Invoices — show one row per invoice.
Show expenses and credits as negative:
This setting is enabled by default. When turned on, amounts are adjusted so that your report totals reflect the net financial position:
Expense invoices display as negative
Income invoices display as positive
Income credit notes display as negative
Expense credit notes display as positive
You can turn this setting off if you prefer all amounts to display as positive values.
Downloading the Report
Click Download to export the report. You can download as:
Excel — for further analysis in a spreadsheet.
PDF — for sharing or printing.
The download includes all columns and filters currently applied to your report.
Saving a Custom Report
After configuring your filters, columns, and display settings.
Click Save to store your report configuration for future use.
Give your custom report a name so you can quickly return to it later.
Favouriting a Report
Favourite the Invoice Details Report to pin it to your Report Builder home screen for quick access. Click the star icon next to the report name to add or remove it from your favourites.
