Spend file specification
Version 1.0. For spend and card providers.
What it is for
A business using PactTax brings in its card transactions from its spend provider each month. Each line carries what the provider knows: the account it is coded to, the VAT, tracking, the receipt, the currency it was spent in, and whether the person paid it themselves and is owed it back. The card is kept as a clearing account in the business's books, and the month is checked against your total.
The file
CSV in UTF-8, comma separated, with one header row naming the fields below in any order (other columns are ignored); or JSON, as {"lines": [ ... ]} with the fields below as keys. Give the business your total of the card lines for the period, so the month can be reconciled.
| Field | Required | What it holds |
|---|---|---|
reference | Yes | Your own id for the transaction, unique and unchanging. A line already brought in is skipped. |
date | Yes | YYYY-MM-DD. |
amount | Yes | In the card account's currency, as a decimal: positive for money spent, negative for a refund. |
currency | Yes | ISO 4217 code of the amount: the card account's. |
spent_amount | No | What was spent in the currency of the purchase. |
spent_currency | No | ISO 4217 code of the purchase. |
merchant | Yes | Who was paid. |
description | No | Free text. |
account | No | The PactTax category it is coded to (for example office_costs, car_van_travel). Left out, the line waits to be sorted. |
vat_rate | No | 20, 5 or 0, or exempt or outside (outside the scope). |
vat_amount | No | The VAT on the receipt, as a decimal. |
tracking | No | Your tag, team or project. |
receipt | No | A link to the receipt image, or its file name. |
reimbursable | No | true where the person paid and is owed it back (not on the card); false or empty otherwise. |
card_holder | No | Whose card. |
A live connection
A connection that sends transactions as they happen needs PactTax and the provider to agree it. Contact us to build one; until then, the business exports the file from you and brings it in.