Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

File specifications

Invoice spreadsheet file specifications - Invoice Data (part 1) allocations and rows

Refer to the following table for invoice spreadsheet file specifications for Invoice Data (part 1), including allocation and row information for each field:
Field Name
Simple accounting code allocations
Enhanced accounting code allocations
Single row format
Multi-row format
General setup, delimiters, or inv. inclusion
File header or file tailer
Invoice header or invoice trailer
Allocation header or allocation trailer
Standard rows
Allocation rows
Date of Invoice
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Invoice Currency
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Invoice Number
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Number of Allocations
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Adjustment to Expenses
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Adjustment to Fees
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Adjustment to Tax
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Amount of Expenses Paid by 3rd Party
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Amount of Fees Paid by 3rd Party
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Amount of Tax paid by 3rd Party
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Approved Expenses
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Approved Fees
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Approved Tax
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Billed Expenses
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Billed Fees
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Billed Tax
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Discount to Expenses
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Discount to Fees
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Discount to Tax
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Expenses Withheld
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Fees Withheld
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Other Invoice Amounts - Tax Withheld
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Row Number
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Total Approved
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Tracker Invoice ID
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes

This article applies to:

  • PRODUCT: Legal Tracker
  • Audiences: Company