Skip to main content
File specifications

Invoice spreadsheet file specifications - Tax Details allocations and rows

Refer to the following table for invoice spreadsheet file specifications for Tax Details, 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
Client Tax ID
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
GST - Total Amount Approved
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
HST - Total Amount Approved
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
Other Tax - Total Amount Approved
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
PST - Total Amount Approved
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
Sales Tax - Total Amount Approved
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
Tax Currency
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
Tax Total Amount Approved
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT - Total Amount Approved
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT #1 - %
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT #1 - Amount
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT #2 - %
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT #3 - %
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT #3 - Amount
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT #4 - %
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT #4 - Amount
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
VAT#2 - Amount
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
Vendor GST ID
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
Vendor HST ID
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
Vendor PST ID
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No
Vendor VAT ID
Yes
Yes
Yes
Yes
No
No
No
No
Yes
No

This article applies to:

  • Product: Legal Tracker
  • Audiences: Company