Note: You'll only be able to import your own company card statement if your company Finance team have enabled you to do so. If you don't have this option, your Finance team will be importing your card statements for you.
Importing card statements is only available via the web portal and not on the mobile app.
Before you get started with importing card statements, you'll need to already have your statement downloaded to your computer in either CSV, OFX or QIF format.
1. Go to My Expenses > Overview or Draft (under the Expenses heading).
2. Click Add Expense and select Import Statement from the drop-down options.
3. Click Browse to select the statement from your computer.
4. Add a Statement Date to track which statement the expenses belong to.
5. Select the Purchase Method.
6. Check the mapping of your columns. If these need to be amended you can assign the column fields from the drop-downs.
Date - The column containing the date of the transaction. This will be imported as the expense date.
Merchant - The column containing the name of the Merchant.
GBP Amount - The column containing the base currency amount e.g. GBP.
Local Amount - The column containing the local or transaction currency. If provided along with a currency code, the expense will be created in this currency.
Currency Code - The column containing the transaction currency code. If populated, must be the 3-letter ISO currency code i.e. USD or EUR.
Category - The column containing the name or reference of the associated expense category.
User Identifier - This column is not applicable when importing your own statement and should be left as "Not Present".
Note: If you've used your company card abroad, you'll want to import the foreign amount and currency code. This will ensure expenses are recorded in the local currency and any existing draft expenses or unattached receipts can be matched correctly.
7. Tick Save Mapping if you'd like to save the column mapping to use for future imports. Give your saved mapping a useful Name and click OK.
You'll then be able to select your mapping from the Available Mappings drop-down and manage your mapping settings during future imports.
8. In the preview area, you'll see a preview of up to 10 of the expenses. If all your expenses are showing as a negative, be sure to tick the Switch amount sign.
9. Click Import to upload your statement.