See below for columns that are available to build charts using the Invoice Level Spend dataset in Enhanced Reporting. This dataset is useful for reporting on upcoming spend (e.g., spend under review) and on approved or paid spend. The table below includes the data type and definitions for each column name for reference.
If you are looking for a specific column name or keyword, press Ctrl+F (Windows) or Cmmd+F (Mac OSX) on your keyboard and enter the name or keyword.
| Column Name | Data Type | Description |
|---|---|---|
| Account ID | Numeric | ID assigned to a customer in Unity. Account IDs are numeric-only and system-generated. |
| Adjustments | Numeric | Sum of all deductions made to an invoice’s line items, either manually by a SimpleLegal user (reviewer) or automatically by the system based on billing rules. As opposed to flagging an invoice, system-based adjustments are automatically made based on specific rules or conditions in Unity. |
| Billed Expenses | Numeric | Sum of charges only (i.e., type IE or type E line items) prior to adjustments or deductions made by a Unity invoice reviewer or automatically by the system based on billing rules. |
| Billed Fees | Numeric | Sum of Billed Flat Fees and Billed Hourly Fees (i.e., types F and IF) on an invoice. Includes discounts or other adjustments made by a vendor but excludes final adjustments or deductions made by a Unity invoice reviewer or automatically made by the system based on billing rules. |
| Billed Flat Fees | Numeric | Sum of fixed or flat fee line items labeled as type IF on invoice. Includes discounts or other adjustments made by the vendor but excludes final adjustments or deductions made by the reviewer or system. |
| Billed Hourly Fees | Numeric | Sum of hourly fee line items labeled as type F on invoice. Includes discounts or other adjustments made by vendor but excludes final adjustments or deductions made by the reviewer or system. |
| Billed Hours | Numeric | Sum of hours (or “units”) billed for all line items labeled as type F (fee) on a vendor invoice prior to any adjustments made by a reviewer or the system. See Billed Hourly Fees. |
| Client Default System Currency (Code) | Text | 3-letter code that indicates the default currency used at the system level in Unity by a customer (e.g., USD, CAD, etc.). |
| Data Refresh Date | Date | Date the database/data source was most recently refreshed. |
| Discounts | Numeric | Sum of discounts added by the vendor on an invoice. Applied as a negative adjustment to a fee or as a separate negative line item by the vendor. Reduction is most often applied prior to the invoice being received in SimpleLegal. |
| Entity | Text | Name of the legal entity associated with the invoice for billing purposes (e.g., allocations). The list of legal entities is defined at the system level. The term Legal Entity may appear differently depending on custom label settings. |
| Entity (URL Attribute) | Function | Vendor name with the URL attribute that links the value to the relevant vendor record. |
| Entity ID | Numeric | ID assigned to a legal entity record in Unity. Entity IDs are numeric-only and system-generated. |
| Final Expenses | Numeric | Sum of charges only (i.e., type IE and type E line items), including final adjustments or deductions made by the reviewer or system. |
| Final Fees | Numeric | Sum of Final Flat Fees and Final Hourly Fees on an invoice, including final adjustments or deductions made by the reviewer or system. |
| Final Flat Fees | Numeric | Sum of fixed or flat fee line items labeled as type IF on an invoice, including final adjustments or deductions made by the reviewer or system. |
| Final Hourly Fees | Numeric | Sum of hourly fee line items labeled as type F on an invoice, including final adjustments or deductions made by the reviewer or system. |
| Final Hours | Numeric | Sum of hours (or “units”) attached to line items labeled as type F (fee), including final adjustments or deductions made by a SimpleLegal invoice reviewer or automatically by the system based on billing rules. This refers to hours worked by timekeepers. |
| Final Spend | Numeric | Sum of invoice amount paid (i.e., fees & expenses) after final adjustments or deductions made by a SimpleLegal invoice reviewer or automatically by the system based on billing rules. This is the amount sent to AP for payment from SimpleLegal. |
| Final Spend No Tax | Numeric | Sum of invoice amount paid (i.e., fees & expenses) after final adjustments or deductions made by a SimpleLegal invoice reviewer or automatically by the system based on billing rules but without tax deductions. |
| Invoice Approved Date | Date | Date invoice was most recently changed to “approved” by a reviewer in SimpleLegal or automatically approved by the system based on billing rules. |
| Invoice Billing End Date | Date | Last possible date for line items on an invoice. This date is specified by a vendor to indicate that line items fall between the Billing Start Period / Period Start and the end of the monthly billing cycle. This is a LEDES e-billing standard; whether this is required or validated depends on customer billing guidelines for vendor invoices. |
| Invoice Billing Start Date | Date | Earliest possible date for line items on an invoice. This date is specified by a vendor to indicate that line items fall between the start of the monthly billing cycle and the Billing End Period / Period End. This is a LEDES e-billing standard; whether this is required or validated depends on customer billing guidelines for vendor invoices. |
| Invoice Date | Date | Date invoice was generated or created by a vendor (e.g., entered into vendor’s billing software or manually entered into CounselGO). This is typically a few days or weeks after the Billing End Period / Period End date. |
| Invoice ID | Numeric | Backend system-generated number assigned to an invoice. Not the same as the Invoice Number assigned to an invoice by the vendor. |
| Invoice Level Adjuster's Full Name | Text | First and last name of the user who adjusted the invoice's total. |
| Invoice Level Adjustment Comments | Text | General comments entered when adjusting the total for an invoice. For auto-adjusted invoices, this displays the default comment specified for an AI-Powered Invoice Validation Rule (if applicable). |
| Invoice Native Currency (Code) | Text | 3-letter code that indicates the original currency used by the vendor when submitting the invoice. May be different than the Client Default System Currency used by the customer in Unity. |
| Invoice Number | Text | Number or ID entered by a vendor for an invoice in CounselGO; this number is not system-generated but should be unique per billing guidelines. Also referred to as Invoice ID in some instances. |
| Invoice Number (URL Attribute) | Function | Invoice Number with the URL attribute that links the value to the relevant invoice record. |
| Invoice PO Number | Text | Purchase Order number under a matter’s attributes, if applicable (i.e., must be listed as a field in the associated matter template). Also referred to as Invoice PO ID. |
| Invoice Received Date | Date | Date an invoice was loaded and received in SimpleLegal. This typically refers to the date the vendor uploaded the invoice into CounselGO. Also appears as Invoice Received Date or inv_received_date in some Enhanced Reports. |
| Invoice Rejection Date | Date | Date an invoice was rejected in Unity. If the invoice was un-rejected and later rejected again, this displays the most recent rejection date. |
| Invoice Status | Text | Refers to the states an invoice goes through from the time it is received in SimpleLegal until it is approved or paid (e.g., Open, On Hold, Rejected, Approved, or Paid). |
| Invoice Subject | Text | Brief description that outlines the general context of work or expenses for a submitted invoice. |
| Invoice Total Base | Numeric | Sum of all billed item amounts on an invoice prior to any adjustments or deductions made by a Unity invoice reviewer or automatically by the system based on billing rules. |
| Invoice Total Submitted (Native) | Numeric | Sum of all billed line items amounts an invoice as submitted in the vendor's native/original currency. May be different than the Invoice Total Base depending on the currency. |
| Invoice Vendor Notes | Text | General comments added to an invoice by a vendor before it was submitted from the vendor portal (if any). |
| Last Resubmitted Invoice | Text | Invoice Number of the invoice that was most recently resubmitted against an invoice. This is determined by the Invoice Received Date. |
| Last Resubmitted Invoice (URL Attribute) | Function | Last Resubmitted Invoice with the URL attribute that links the value to the relevant invoice record in Unity. |
| Last Resubmitted Invoice Amount | Numeric | Total amount for the most recently resubmitted invoice. Includes any adjustments made by a reviewer or automatically by the system, if applicable. |
| Last Resubmitted Invoice Currency | Text | 3-letter code that indicates the currency of the most recently resubmitted invoice. |
| Line Item Adjustments | Numeric | Amount deducted from an invoice line item, either manually by a reviewer or automatically by the system based on billing rules. |
| Line Item Total Submitted Sum | Numeric | Amount for a line item submitted by vendor prior to any final adjustments made by a reviewer or automatically by system based on billing rules. |
| Line Item Native Billed Amount | Numeric | “Native” refers to the Line Item Billed Amount in a vendor’s originating currency (if different than the default currency used by the customer in SimpleLegal). |
| Paid Date | Date | Date an invoice was paid. Invoices are set to Paid status manually by a user or automatically depending on customer integrations. This also includes invoices marked as Partially Paid or Over Paid. |
| Resubmitted Invoice ID | Numeric | Backend system-generated number assigned to a resubmitted invoice. Not the same as the Last Resubmitted Invoice. |
| Sent to AP Date | Date | Date an invoice was sent to AP for payment. Invoices are set to Sent to AP status manually by a user or automatically upon approval depending on customer settings/integrations. |
| Vendor Attribute: [Name] | Custom Attribute | Naming convention of custom attributes scoped to vendor records, if applicable (e.g., Vendor Attribute: Office Location). |
| Vendor City | Text | City under address field in vendor record. |
| Vendor Country | Text | Country under address field in vendor record. |
| Vendor Created Date | Date | Date vendor record was created. |
| Vendor End Date | Date | Date vendor record was deactivated. |
| Vendor | Text | Name entered for a vendor record in Unity (i.e., business, firm, or individual providing and billing for services on a matter). |
| Vendor (URL Attribute) | Function | Vendor name with the URL attribute that links the value to the relevant vendor record. |
| Vendor Group | Text | Name of group used to categorize a vendor based on location, region, or other criteria. Shows 'N/A' or 'null' if no group is assigned or if this option is disabled at the system level. This is not enabled by default in all environments. |
| Vendor Group ID | Numeric | ID assigned to a vendor group when it is created. Vendor Group IDs are numeric-only and system-generated. |
| Vendor ID | Numeric | ID assigned to a vendor record in Unity. Vendor IDs are numeric-only and system-generated (e.g., 1505). |
| Vendor Number | Text | Optional number assigned to a vendor record in SimpleLegal, such as an existing ID used by a customer for a specific vendor. This is not the same as the system-generated Vendor ID assigned to a vendor when the record is created in SimpleLegal. |
| Vendor Postal Code | Text | Postal code or zip code under address field in vendor record. |
| Vendor Start Date | Date | Date the record was created in Unity (or most recently set to ACTIVE). |
| Vendor State/Province | Text | State or province under address field in vendor record. |
| Vendor PO ID | Numeric | Purchase Order number or ID assigned to a vendor record, if applicable. Also referred to as Vendor PO Number. |
| Vendor Status | Text | Whether a vendor record is ACTIVE or INACTIVE in Unity. |