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 |