You've tried to import a statement but you can't see the result or the information is incorrect. What did you do wrong?
You are making use of cards that don't support a data feed with SRXP. Due to this reason you are uploading a file with transactions in your account (on a monthly basis) .
First read the article 'How can I import credit card transactions?' to be sure that you've followed all the steps correct. It is an extensive article but make sure you apply all the instructions that are mentioned!
Were you still unable to import the document successfully? In this article we provide you with tips & tricks and will tell you what can go wrong. In this article we describe the following topics:
- General tips & tricks
- I can't select any columns/fields at the section 'Column mapping', why not?
- How can I see that my import is failed?
- The import mentions failed due to 'Country', but why?
- The amount is incorrect. The cents are missing.
1. General tips & tricks
When you try to import a file in SRXP, make sure you apply the following steps:
1.1. Make use of Notepad or 'Kladblok'
Always open the document in Notepad or Kladblok! You can see the real formatting that is used in the document. Excel changes it sometimes. An example:
The first screenshot is from Excel, the other from Notepad. You see that a different amount format is used. You have to apply the real format, which is always visible in Notepad. Make sure you always apply the correct format for the amount and date!
1.2. Apply a general currency
Make sure you always apply a general currency at the settings. When there's no currency given in the import document, this general currency will be used.
This is important because otherwise there is no currency filled in at the transaction. The currency of the transactions can not be edited after the import! The currency is a mandatory field to be able to submit the expense. This means that the Submitter will never be able to submit the report with expenses!
2. I can't select any columns/fields at the section 'Column mapping', why not?
You've upload a file, chosen a separator and applied the settings. When you are at the the section 'Column mapping' you can't select any columns/fields at the different rows
This happens when you've selected the wrong separator. Always open the document in Notepad/Kladblok to see the separator that has been used. Go back to the first step and change the chosen separator.
3. How can I see that my import is failed?
You've done an import but you can't see the result. When you've done an import and it's completed, you will receive an email. In this email you will find how many transactions are created, updated, deleted or failed. You can also check the status via the Admin Panel (gear) > Imports
When you click on status you will see the same information as mentioned in the email. You will see how many transactions are created, updated, deleted or failed.
4. The import mentions failed due to 'Country', but why?
An import will fail when the field 'Country' is mapped with the country information in the document whereby some information in this document is incorrect. Some examples:
- The countries are written incorrect (German instead of Germany)
- If the countries are written in different languages in the same document (one row says Nederland and another row Germany). Make sure the document consists of one language only. The transaction import supports a lot of different languages for the country, not only Dutch country names.
- Make use of a hyphen when this is the official name of the country (South-Africa instead of South Africa)
Be careful while editing the document! Most probably you will edit the document in Excel, but Excel might apply a different formatting and changes the layout. Preferable you make changes with Notepad++, this tool makes sure that the layout won't change.
5. The amount is incorrect. The cents aren't filled in.
You've done an import and the cards are already assigned to users. The transactions can be found (in reports) in the 'All reports' overview, but when you check some transactions you notice that all the transactions ends with ,00 and that the cents aren't filled in!
This happens when you don't apply the correct amount format at step 2 'Settings' while importing the file. Go back to part 1.1. of the General Tips & Tricks of this article. Please note: Are you going to do a new import? Make sure you delete the previous imported transactions and reports first! Otherwise you have double records! Read it here how you can delete the (incorrect) transactions.