Using the “Line Items as Collected” Report
Last updated: July 5, 2025
You can use the “Line Items as Collected” report to look at transaction level details with invoice collection status.
Applies to: Accountants, Accounting Assistants
This article explains how to use the “Line Items as Collected” Report in order to look at transaction level details, such as accounting posting from and to dates, carriers, marketing companies, programs, and divisions, with invoice collection status.
You can find this report by going to the “Accounting” tab in the side navbar, then going to “Reports”, and then selecting “Line Items as Collected Report” from the Receivables tab.
You can use this report to answer the following questions:
- How can I look at transaction level details with invoice collection status?
Purpose:
The line item as a collected report can be used to understand the amount collected per line item on a filtered list of policies. The report displays how items have been allocated against line items such as premiums, taxes, and fees.
The report can be filtered to display transactions between certain dates or collected amounts between certain dates. Our team has also standardized the terms used in the column headings to clarify the types of categories which are included in the report. The default receipt posted date includes the beginning of the period and the receipt posting date defaults to today's date.
Available Filters:
Accounting Posting Date From
This filters the report to include all invoices (whether paid or unpaid) starting as of the date that you select using as a reference the Accounting Posting Date of each invoice.
Example: Selecting the start of the year will include transactions posted to the accounting ledger on January 1st.
Accounting Posting Date To
This filters the report to exclude any invoices (whether paid or unpaid) that are posted after the date that you select using as a reference the Accounting Posting Date of each invoice.
Example: Selecting the end of the year will include transactions posted to the accounting ledger no later than December 31st.
Show Invoices Collected From
This filters the report to include any amounts that are applied [or collected] to [open] Invoices starting from the date that you select. Note, you should leave this field blank if you do now want to set a starting date for amounts applied.
Example: using the first of the current month will show you amounts applied to invoices Month to Date, you can use this to calculate how much money was collected since the date selected.
Show Invoices Collected As Of
This filters the report to exclude any amounts that are applied [or collected] to [open] Invoices after the date that you select. Note, you should leave this field blank if you do now want to set an ending date for amounts applied.
Example: using the first of the current month will show you amounts applied to invoices Month to Date, you can use this to calculate how much money was collected since the date selected.
Once the report has been run, users can download the results as a CSV file using the Download CSV button located on the top right of the report.