All Collections
My Expenses
Web Portal
Import your company card statements from My Expenses
Import your company card statements from My Expenses

Import your own company card statements from the My Expenses area.

Written by Jack
Updated over a week ago

Please note: You will only be able to import your own company card statement if your Finance team have enabled this for you. Importing card statements is only available via the web portal and not on the mobile app.

If you do not have this option, your Finance team will be importing your card statements for you.

Before you get started with importing card statements, you will need to already have your statement downloaded to your computer in either CSV, OFX or QIF format.

1. Within your My Expenses area, click Draft.

2. Click on the Import Card button found at the top of the page.

3. Click Browse to select the statement from your computer.

4. Add a Statement Date to track which statement the expenses belong to.

5. Choose 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 i.e. 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".

Please note: If you have used your company card abroad, you will 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 would like to save the column mapping to use for future imports. Give your saved mapping a useful name and click OK.

You will 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 can see a preview of up to 10 of the expenses. If your expenses are showing as a negative, be sure to tick Switch amount sign.

9. When you are happy, click Import to upload your statement.

Related Articles

Did this answer your question?