Total outstanding
Record grain: invoice
Date basis: As of latest refresh
Rules: One contributing record per typed ID
Payments & invoices · Google Sheets sample
GoHighLevel Invoice Aging report template
Work an invoice-aging register of outstanding balances, from not-yet-due invoices to the oldest overdue bucket. This is a table-first report for collection work.
Invoice Aging
Invented sample · Fixed as of October 13, 2026 · USD · America/Chicago
Change filters to explore the sample locally. No account connection.
Total outstanding$1,400.00As of latest refresh
Not due$0.00As of latest refresh
1–30 days overdue$500.00As of latest refresh
31–60 days overdue$900.00As of latest refresh
61–90 days overdue$0.00As of latest refresh
91+ days overdue$0.00As of latest refresh
| Invoice | Customer | Due date | Days overdue | Status | Balance |
|---|---|---|---|---|---|
| Invoice i2 | Ethan Brooks | 2026-09-01 | 42 | Partially paid | $900 |
| Invoice i1 | Ava Wilson | 2026-10-05 | 8 | Unpaid | $500 |
What the metrics mean
Not due
Record grain: record
Date basis: As of latest refresh
Rules: One contributing record per typed ID
1–30 days overdue
Record grain: invoice
Date basis: As of latest refresh
Rules: One contributing record per typed ID
31–60 days overdue
Record grain: invoice
Date basis: As of latest refresh
Rules: One contributing record per typed ID
61–90 days overdue
Record grain: record
Date basis: As of latest refresh
Rules: One contributing record per typed ID
91+ days overdue
Record grain: record
Date basis: As of latest refresh
Rules: One contributing record per typed ID
Required data and boundaries
- Invoices and current balances
- Contacts
Balances describe the latest snapshot. Historical balance trends require actual snapshots; the sample does not invent a line chart from today’s balances.
Current receivables only. No past-date balance reconstruction. Draft, void, paid and zero-balance records excluded.
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 Line Items
Invoice line amounts, quantities and customer detail.
Explore sample →Customer accounts
Customer Payments
Customer collections, current balances and linked payment records.
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.