Use Cases:
Outstanding Balances and Overdue Invoices: The report provides a summary of outstanding balances for unpaid invoices due before today, as well as overdue invoice totals. This helps the business identify clients with overdue payments and prioritize follow-ups to ensure timely collections.
Payment Due Dates: The report includes the average number of days until unpaid invoices are due and the total revenue due within the next 30 days. This information allows the business to manage cash flow effectively and plan for upcoming payments.
Client-Specific Overdue Balances: The report lists overdue balances by client, providing a clear view of which clients have outstanding payments. This helps the sales team focus their efforts on clients with the highest overdue amounts and develop strategies to address payment delays.
Invoice Payments by Week: The report shows invoice payments due by week, allowing the business to track payment schedules and ensure that invoices are paid on time. This helps in maintaining a steady cash flow and avoiding potential financial issues.
Detailed Invoice Information: The report includes detailed information on each invoice, such as invoice number, client name, account manager, invoice status, total amount, date sent, date due, and date paid. This comprehensive data helps the sales team monitor the status of each invoice and take necessary actions to resolve any issues.
Field Information:
Field Name | Data Type | Filter | Description |
Invoice Number | String | Y | Invoice Number is the Unique Identifier for the LASSO Invoice. Invoice Numbering can be configured in Company Inventory Settings |
Invoice Name | String |
| Invoice Name is the name given by the user generating the Invoice version in the UI |
Invoice Status | String | Y | Invoice Status indicates the stage that an invoice is in. Statuses include Saved, Paid, Void, Sent |
Invoice Total | Currency |
| Invoice total is the billable total of an invoice |
Date Invoiced | Date |
| Date Invoiced is the date an invoice was initially generated |
Date Due | Date | Y | Due Date is generated based on Date Invoiced + Invoice Term |
Date Paid | Datetime | Y | Date Paid is the date that an invoice was marked Paid in the system |
Date Sent | Date | Y | Date Sent is the date that an invoice changed to a 'sent' status |
Date Saved | Date |
| Date Saved is the date the invoice was Saved as a version |
Event Name | String |
| The Event Name or "Event" field is the common title of an Event; visible in calendar views, orders, reservations, and crew-facing communications |
Event Code | String |
| The Event Code or "Event ID" is a system-generated or customer-generated identifier for events. There can only be one Event Code/ID per Event. Settings for the Event Code/Event ID are located in Company Settings>General>Event Settings |
Event Type | String |
| Event Type is a Customer-generated list used to classify events for filtering and reporting purposes; examples include "Corporate, Concert, TradeShow" etc. |
Event End | Date |
| The Event End Date is the last date listed for the event in "Event Dates" the 'General Info' Spoke in an Event |
Account Manager | String | Y | Event Account Manager is the resource listed in the "Account Manager" field on the event. |
Client | String | Y | Event Client Name is the Client listed on the 'General Info' Spoke in an Event. This is primarily the name of a company, not the primary contact |
Client Contact Email | String |
| Event Client Email is the Email Address for the Primary Client Contact on an Event |
Invoice Type | String | Y | Invoice Type indicates whether an invoice is of Type Deposit, Additional Payment, or Reconciliation |
Invoice Term | String |
| Invoice Term indicates how long a customer has to pay an invoice, which will generate an appropriate Due Date. Options include NET 7, 10, 15, 30, 45, 60, Due on Receipt |
Invoice Paid | Boolean | Y | Invoice Paid is either True or False indicating the current payment status of an invoice |
Invoice Overdue | Boolean |
| Invoice Overdue is either True or False indicating the current overdue status of an invoice based on the Due Date |
Days Until Due | Integer |
| Days Until Due represents the current number of days until an invoice is due to be paid |