Overview
V2 of the Filing transactions export introduces three key improvements over V1:
- Configurable detail levels — choose from three levels of detail depending on your needs.
- Expanded transaction data — new columns for customer address, jurisdiction, return status, exempt reasons, and functional currency.
- Jurisdiction-level detail — an optional second CSV that breaks down tax amounts by sub-jurisdiction and line item.
Detail levels
V1 always produced a single CSV file. V2 lets you choose from three detail levels:
| Detail level |
Output format |
What's included |
transactionsOnly
|
Single CSV |
Transaction-level data (similar to V1) |
includeJurisDetails
|
ZIP with two CSVs |
Transaction CSV + a jurisdiction details CSV |
includeJurisDetailsWithAuditColumns
|
ZIP with two CSVs |
Same as above, plus audit columns on both CSVs |
Column changes in the transaction CSV
Removed columns
The following V1 columns have been removed in V2:
| Removed column |
Notes |
Country of sale |
Replaced by individual address fields (see new columns below) |
Time |
Removed; use Invoice date or Anrok created date instead |
Transaction currency taxable sale amount |
Removed |
Transaction currency non-taxable sale amount |
Removed; use Exempt reasons for exemption detail |
Renamed columns
These columns carry the same data but have updated names:
| V1 column name |
V2 column name |
Valid VAT IDs for reverse charge |
Valid VAT IDs |
Date |
Invoice date |
Transaction currency sale amount |
Transaction currency sales amount |
Filing currency sale amount |
Filing currency sales amount |
New columns
V2 adds the following columns to the transaction CSV:
| New column |
Description |
Overall VAT ID validation status |
Aggregated validation status of the customer's VAT IDs |
Exempt reasons |
Reasons a transaction or portion of a transaction is exempt from tax |
Void |
Whether the transaction has been voided (TRUE / FALSE) |
Customer address line 1 |
Street address of the customer |
Customer address city |
City |
Customer address region |
State, province, or region |
Customer address postal code |
Postal / ZIP code |
Customer address country |
Country code |
Jurisdiction |
Name of the filing jurisdiction (e.g., "Texas") |
Jurisdiction ID |
Anrok's unique identifier for the jurisdiction (e.g., us-TX) |
Return ID |
Identifier for the return this transaction is associated with |
Return status |
Current status of that return (e.g., "Open") |
Functional currency |
Your company's functional (home) currency |
Functional currency conversion rate |
Exchange rate used to convert to functional currency |
Functional currency sales amount |
Sales amount in functional currency |
Functional currency tax amount |
Tax amount in functional currency |
Functional currency invoice amount |
Invoice amount in functional currency |
Audit-only columns
These columns appear only when using the includeJurisDetailsWithAuditColumns detail level:
| Audit column |
Description |
Source system |
The system that originated the transaction |
Anrok created date |
Timestamp when the transaction was first created in Anrok |
Anrok last updated date |
Timestamp when the transaction was last updated in Anrok |
Valid VAT ID validation types |
Types of VAT ID validation performed |
New: jurisdiction details CSV
When you select includeJurisDetails or includeJurisDetailsWithAuditColumns, the export includes a second CSV file (jurisdiction-details.csv) inside a ZIP archive. This file provides one row per line item per sub-jurisdiction and includes:
- Line number, product ID, and product name (plus product tax category in audit mode)
- Sub-jurisdiction ID and name
- Sales, non-taxable, exempt, taxable, and tax amounts — in transaction, filing, and functional currency
- Tax rate and exempt reasons per line item
This is useful for reconciliation, detailed tax reporting, and audits where you need to see exactly how tax was computed at each jurisdictional level.
Functional currency support
V1 only included amounts in the transaction currency and the filing currency. V2 adds a full set of functional currency fields — conversion rate, sales amount, tax amount, and invoice amount — to both the transaction CSV and the jurisdiction details CSV. This is especially helpful if your home currency differs from the currency you file in.
Quick reference: full column mapping
The table below lists every column in the V1 export alongside its V2 counterpart, grouped by status. Use the search bar to find a specific column quickly, or expand a single status group to scan only the changes that matter to you.
| V1 column |
V2 column |
Status |
|
▼
Unchanged
(13 items)
|
| Transaction ID | Transaction ID | Unchanged |
| External ID | External ID | Unchanged |
| Customer ID | Customer ID | Unchanged |
| Customer name | Customer name | Unchanged |
| Other VAT IDs | Other VAT IDs | Unchanged |
| Tax date | Tax date | Unchanged |
| Transaction currency | Transaction currency | Unchanged |
| Transaction currency invoice amount | Transaction currency invoice amount | Unchanged |
| Transaction currency tax amount | Transaction currency tax amount | Unchanged |
| Conversion rate | Conversion rate | Unchanged |
| Filing currency | Filing currency | Unchanged |
| Filing currency invoice amount | Filing currency invoice amount | Unchanged |
| Filing currency tax amount | Filing currency tax amount | Unchanged |
|
▼
Renamed
(4 items)
|
| Valid VAT IDs for reverse charge | Valid VAT IDs | Renamed |
| Date | Invoice date | Renamed |
| Transaction currency sale amount | Transaction currency sales amount | Renamed |
| Filing currency sale amount | Filing currency sales amount | Renamed |
|
▼
Removed
(4 items)
|
| Country of sale | — | Removed |
| Time | — | Removed |
| Transaction currency taxable sale amount | — | Removed |
| Transaction currency non-taxable sale amount | — | Removed |
|
▼
New
(17 items)
|
| — | Overall VAT ID validation status | New |
| — | Exempt reasons | New |
| — | Void | New |
| — | Customer address line 1 | New |
| — | Customer address city | New |
| — | Customer address region | New |
| — | Customer address postal code | New |
| — | Customer address country | New |
| — | Jurisdiction | New |
| — | Jurisdiction ID | New |
| — | Return ID | New |
| — | Return status | New |
| — | Functional currency | New |
| — | Functional currency conversion rate | New |
| — | Functional currency sales amount | New |
| — | Functional currency tax amount | New |
| — | Functional currency invoice amount | New |
Showing 0
of 0
entries
Migration tips
- If you parse the CSV programmatically, reference columns by header name rather than position — the column order has changed in V2.
- If you relied on "Country of sale", switch to the new address fields (
Customer address country, Customer address region, etc.) which provide more granular location data. - If you need taxable vs. non-taxable breakdowns, use the
includeJurisDetails detail level, which provides exempt, non-taxable, taxable, and tax amounts per line item in the jurisdiction details CSV. - If you need audit trails, use
includeJurisDetailsWithAuditColumns to get created/updated timestamps and source system information.
