Skip to main content
The invoice lines report allows you to generate a detailed report of all individual line items from invoices in your project. This report is useful for detailed financial analysis and accounting purposes.

​
Parameters

The report accepts the following parameters: Invoiced after - Filter to only include invoice lines from invoices created on or after this date. Defaults to one month ago. Invoiced before - Filter to only include invoice lines from invoices created on or before this date. Defaults to today.

​
Available fields

The report includes the following fields:
  • id - The unique identifier of the invoice line item
  • invoice_id - The associated invoice ID
  • invoice_number - The formatted invoice number
  • description - The line item description
  • product_id - The associated product ID (if applicable)
  • line_item_type - The type of line item
  • unit_price_cents - The unit price in cents
  • invoice_currency - The currency of the invoice
  • quantity - The quantity of items
  • tax_percentage - The tax percentage applied
  • amount_including_tax_cents - The line amount including tax in cents
  • invoiced_at - When the invoice was created
  • product_sku - The SKU of the associated product
  • product_title - The title of the associated product
  • product_supplier - The supplier of the associated product
  • amount_including_tax - The line amount including tax
  • amount_excluding_tax - The line amount excluding tax
  • total_amount_including_tax - The total amount including tax

​
FAQ

​
What invoice lines are included?

Only line items from finalized invoices are included. Line items from draft invoices or invoices without an invoice date are excluded.

​
How are invoice lines sorted?

Invoice lines are sorted by creation date in descending order, with the most recent line items appearing first.

​
Can I use this report for accounting purposes?

Yes, this report provides detailed line-item data that is useful for accounting reconciliation, tax reporting, and financial analysis.