Invoice Line Export
What the Invoice Line export contains and the meaning of each field.
Overview
The Invoice Line export contains the individual lines of invoices you have issued to your customers. Each row represents one invoice line, together with details of the parent invoice, the customer contact and addresses from the related purchase order line, the invoiced item, quantities, pricing and tax.
Use this export for accounts receivable reconciliation, tax reporting, and importing invoice data into your finance systems.
Generating the Export
Navigate to Settings → Files → Exports and create a new export with the type Invoice Line.
You can optionally set a row limit to cap the size of the export.
Fields
| Column | Description |
|---|---|
Invoice ID | Unique identifier of the invoice this line belongs to. |
Invoice Identifier | Human-readable invoice number of the parent invoice. |
Invoice Date | Date the invoice was issued (YYYY-MM-DD), or empty if not set. |
Due Date | Date the invoice is due for payment (YYYY-MM-DD), or empty if not set. |
Invoice Status | Current status of the parent invoice. One of draft, sent, cancelled, rejected, approved, partially_paid, paid. |
Customer Name | Name of the user who created the related purchase order line (the requestor). |
Customer Email | Email address of the user who created the related purchase order line. |
Bill To Address Name | Name on the billing address of the related purchase order line. |
Bill To Address Line One | First line of the billing address. |
Bill To Address Line Two | Second line of the billing address. |
Bill To Address City | City of the billing address. |
Bill To Address Province | Province or state of the billing address. |
Bill To Address Postal Code | Postal code of the billing address. |
Bill To Address Country Code | Country code of the billing address. |
Ship To Address Name | Name on the shipping address of the related purchase order line. |
Ship To Address Line One | First line of the shipping address. |
Ship To Address Line Two | Second line of the shipping address. |
Ship To Address City | City of the shipping address. |
Ship To Address Province | Province or state of the shipping address. |
Ship To Address Postal Code | Postal code of the shipping address. |
Ship To Address Country Code | Country code of the shipping address. |
Currency Code | Currency code of the line's monetary values. |
Line ID | Unique identifier of the invoice line. |
Line Identifier | Line reference (line number) of this line within the invoice. |
Parent Line ID | Identifier of the parent line this line belongs to, if any, taken from the line's item details. |
Item Type | Type of the invoiced item, taken from the line's item details. |
Item ID | Identifier of the invoiced item, taken from the line's item details. |
Item Code | Code or SKU of the invoiced item, taken from the line's item details. |
Item Name | Name of the invoiced item, taken from the line's item details. |
Item Description | Description of the invoice line. |
Quantity | Invoiced quantity, as a decimal (defaults to 1.00 when not set). |
Unit Of Measure | Unit of measure of the invoiced item, taken from the line's item details. |
Unit Price Excluding Tax | Price per unit excluding tax, as a decimal in the currency shown in Currency Code. |
Tax Rate Percent | Effective tax rate for the line as a percentage, or empty when no tax applies. |
Line Subtotal Excluding Tax | Line total excluding tax (quantity multiplied by unit price), as a decimal. |
Line Tax Amount | Total tax amount for the line, as a decimal. |
Line Subtotal Including Tax | Line total including tax, as a decimal. |
Item Details | Full details of the invoiced item, as a JSON object. |
Created At | Date and time when the invoice line was created (ISO 8601). |
Updated At | Date and time when the invoice line was last updated (ISO 8601). |