> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firmhouse.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Invoice lines report

> Generate a detailed invoice lines report in Firmhouse with individual line items from every invoice, useful for financial analysis and accounting.

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.