Skip to main content
File specifications

Invoice spreadsheet file specifications - AP Exchange Data allocations and rows

Refer to the following table for invoice spreadsheet file specifications for AP Batch Data, 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
AP Batch Date
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
AP Batch Date and Time
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
AP Batch Run By
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
AP Batch Time
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
AP Batch Unique ID
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Number of Invoices
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Total - All Invoices - Approved
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Total - All Invoices - Billed
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Total - Credit Invoices Only - Approved
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Total - Credit Invoices Only - Billed
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Total - Debit Invoices Only - Approved
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Total - Debit Invoices Only - Billed
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes

This article applies to:

  • Product: Legal Tracker
  • Audiences: Firm