We’re making some improvements to the statement and transaction activity CSV download. The first round of changes occurred in March and are detailed in the second half of this page.
We'll be making more changes in August, these are detailed below. Please note this will change the structure of the download, so any custom automations your business may have set up will need review if they relied on the old CSV structure. Please look through the changes carefully if you think this might apply to you.
Changes coming in August 2025
Additional columns
New column: Group transaction ID column for auto exchanges
Related card and auto exchange transactions will now have the same ID in the group transaction ID field. This will help to identify linked transactions.
New column: Team information has been added
If a person is in a team, the team name will be shown on the transaction row. If a person is in multiple teams, all teams will be listed in alphabetical order separated by a comma.
If a person is not in a team, it will be empty. The "Team(s)" column will be after the “Name” column.
Removed columns
Removed the created date and completed date, as they have been replaced by the new UTC date fields that are Excel-friendly.
Removed the "Total credited / debited" and "Total credited / debited excluding fees" columns. These have already been split into separate columns for credits and debits.
Changes to existing columns
Internal transfer improvements
The description for internal transfers will show the “To” balance on the debit leg, and the “From” balance on the credit leg. They will also show the name of the person who actioned the internal transfer.
More clarity for card and auto exchange
Auto exchange descriptions will include the description of the related card transaction.
When there is a card transaction that has one auto exchange (two currencies total), we will add the exchange information to the “Exchange rate”, “Payment / Exchange currency” and “Payment / Exchange amount” fields of the card transaction row.
When a card transaction involves two or more auto exchanges (3+ currencies involved in the transaction) some columns will contain different information:
- In the “Exchange rate” column instead of a rate (e.g. 1.34), you’ll see “Multiple currencies”.
- In the “Payment/exchange currency” column instead of a currency (e.g. USD), you will see “Multiple exchanges”.
- In the “Payment / Exchange amount” column instead of an amount (e.g. 400), you will see “Multiple amounts”.
Transactions are sorted by "Created date"
Previously, all transactions were grouped by Balance, then sorted by created date/time. We’re going to update this so that all transactions are sorted by "Created date (UTC)" column, with the oldest transactions at the top.
If your download has no transactions, we'll make this clear
If you request a file and there are no transactions, you’ll see a message confirming this. This will reduce confusion over whether there was an error or simply no transactions to display.
Renamed fields
We’ve renamed some fields to improve the clarity:
Existing name
|
New name
|
Currency
|
Balance currency
|
Local currency
|
Payment / Exchange currency
|
Local amount
|
Payment / Exchange amount
|
Name of sender / beneficiary
|
Name of sender / recipient
|
Bank identifier of sender / beneficiary
|
Bank identifier of sender / recipient
|
Account identifier of sender / beneficiary
|
Account identifier of sender / recipient
|
Address of sender / beneficiary
|
Address of sender / recipient
|
Bank of sender / beneficiary
|
Bank of sender / recipient
|
Bank address of sender / beneficiary
|
Bank address of sender / recipient
|
Changes that occurred in March 2025
Simplified date format
For easier filtering by transaction date, we have added columns in YYYY-MM-DD HH:MM:SS format. This is recognised as a date by Excel.
Separated credit and debit columns
We've added separate columns for credited and debited amounts, rather than just the combined column.
“Reference” column moved
This has been moved to after the “Description” column.
"Running balance" column moved
This is now after the "Debited excluding fees" column and before "Exchange rate". This means you can easily view this with the other amounts.
"Description" for payments
We’ve made this simpler, so that the payment network (SWIFT, Faster Payment etc.) is only shown in the “Type” column.
Improved information for exchanges
The “Description” column for credits and debits will be enhanced to show the currency exchanged. For example, if funds are being taken from your GBP balance and exchanged into USD, the description for the debit from the GBP balance would show “To USD” and the description for the credit column will show “From GBP”. Similarly, for auto exchanges (currency alignment), we now show the currency exchanged. For example, “To GBP for Auto exchange” and “From USD for Auto exchange”.
Columns for “Local currency” and “Local amount” will show the other side of an exchange, in the same row to allow you to understand the exchange at-a-glance.
ExchangeAuto exchange
“Balance Hierarchy” corrected
This now displays accurately. For example, if a transaction took place on the LinkedIn Balance, you might see “Marketing/Socials". Balance hierarchy does not show for the Account Balance or the Balances directly under it (the first two rows in the example below).
Header improvement
Headers no longer repeat above each Balance. Column headers only appear on the first row.
BeforeAfter