Menu

Payments & invoices · Google Sheets sample

GoHighLevel Invoice Line Items report template

Inspect invoice line amounts, quantities, and customer detail at invoice-line grain. Use this when header totals are too coarse for the question.

Invoice Line Items

Invented sample · Fixed as of October 13, 2026 · USD · America/Chicago

Change filters to explore the sample locally. No account connection.

Recorded invoice line amount$5,850.00Parent invoice issue date; line amount before tax
Invoice lines3Recorded date in selected period
Invoiced units4Recorded date in selected period
Invoices with lines2Recorded date in selected period

Invoice line amounts by item

Invoice line amounts by itemService packageService package: $2,000.00$2,000.00ConsultationConsultation: $200.00$200.00Support agreementSupport agreement: $3,650.00$3,650.00

View chart data
Invoice line amounts by item values
GroupValue
Service package$2,000.00
Consultation$200.00
Support agreement$3,650.00

Invoiced units by item

Invoiced units by itemService packageService package: 22ConsultationConsultation: 11Support agreementSupport agreement: 11

View chart data
Invoiced units by item values
GroupValue
Service package2
Consultation1
Support agreement1
Invoice line records
InvoiceItemQuantityLine amountCustomer
i1Service package2$2,000Ava Wilson
i1Consultation1$200Ava Wilson
i2Support agreement1$3,650Ethan Brooks

What the metrics mean

Recorded invoice line amount

Record grain: invoiceLine

Date basis: Parent invoice issue date; line amount before tax

Rules: No sum of repeated invoice-header totals

Invoice lines

Record grain: invoiceLine

Date basis: Recorded date in selected period

Rules: One contributing record per typed ID

Invoiced units

Record grain: invoiceLine

Date basis: Recorded date in selected period

Rules: One contributing record per typed ID

Invoices with lines

Record grain: invoice

Date basis: Recorded date in selected period

Rules: One contributing record per typed ID

Required data and boundaries

  • Embedded invoice lines
  • Invoices and current balances
  • Contacts

Do not repeat the invoice header total on every line when calculating a sum. Embedded lines are bundled with the parent invoice under the planned transfer-counting rules.

Invoice items are a child grain. Partial item coverage is not a full invoiced-business total. Header balances are never repeated across item rows.

CRM coverage only · USD; other currencies excluded. Financial units and relationship namespaces are simulated, not provider-validated.

Early access · These public previews use invented records. Join early access to discuss connecting your own GoHighLevel account.

From this sample to a connected report

Choose the template

Use the report whose definitions match the decision you need to make.

Check required inputs

Confirm source access, relevant mappings, history, and any configured goals.

Create the worksheet

The early-access design reuses compatible imports and creates a report worksheet.

Choose freshness

Select source refreshes deliberately. New executions transferring records add usage.

Related report samples

Payments & invoices

Invoice Aging

Open balances, overdue invoices and aging buckets.

Explore sample →
Payments & invoices

Payment Collections

Successful collections, transaction counts and payment types.

Explore sample →
Commerce

Product Sales

Sold quantities and line amounts by sale-time product.

Explore sample →

Bring your own reporting question.

Make this your reporting workflow.

Explore the samples now. Join the existing waitlist to request connected early access, or discuss a predictable subscription for larger workloads.

Analytics preferences

Optional analytics require your consent before any analytics requests are sent. Hosted forms have their own provider controls.