Importing expenses paid for with business cards
To automate the process of entering expense claims relating to the use of business cards, Eurécia offers the option of creating them automatically by importing business card statements provided by banks.
Who is this article for?
The administrator, as the person responsible for configuring the Eurécia platform.
This article covers:
How expense importing works
The import is carried out using an encrypted file, of which only the last four characters are visible if the import fails.
Employees make payments using their business card
The bank receives information about these payments
It automatically creates statements, which are stored on an FTP server
The platform administrator or accountant receives an import file
The file is integrated into Eurécia, which automatically creates the expense claims
Prerequisites
To carry out this type of import, 4 settings are essential.
Enter a business card in the employee record of the relevant users
Access: Admin area > General settings > Open Employees and users
- I open the record of each relevant employee
- In the ‘Employment’ tab, I go to the ‘Payment method’ section
- I click the
button to add a business card, or edit the information and tick the box corresponding to the ‘Company card’ column
Set a default expense claim profile
Access: Admin area > General settings > Open Employees and users
- I open the record of each relevant employee
- In the ‘Rules’ tab, I go to the ‘Expense claim’ section
- I assign a default profile to the employee
Allow multiple entries per day
Access: New Admin area > Expenses > Open Expense types
If I wish, I can enable the option to enter the same expense type several times per day. This can prevent blocks when there are multiple expense claims
- I open the relevant expense claim profile
- For each expense, I go to the ‘Entry control’ section
- I tick the ‘Allow this expense type several times per day’ box
Request activation of the ‘Import business card statements’ menu
Access: Admin area > General settings > Manual data import
|
Support This menu should only be activated for the person who will carry out the import (usually the administrator or accountant). To activate it, contact Customer Support.
|
Start the ‘Business card’ expense import
Access: Admin area > General settings > Manual data import
I click the ‘New import’ button
I select the ‘Business card statement’ import. We also have import templates specific to each bank. Please do not hesitate to contact us for further information.
I click the ‘Import a file’ button
I select an import template if one has already been created
I upload my import file by clicking ‘Choose a file’
I click the ‘Upload file’ button
I choose the import mode: more information is provided in the following section 😊
I check that the mapping is correct: each column in my file must be linked to the correct Eurécia field to be populated
If the result is correct, I click the ‘Start import’ button
If it is not, I correct it by selecting the correct column from my file in the drop-down menus, then click ‘Update template’ and finally ‘Start import’.
The different ‘Business card’ import modes
Depending on the import mode selected, the way existing expense claims are created or updated will differ.
-
Creation of expense claims: the import will not add any expenses to an existing expense claim. One or more new expense claims will be created automatically.
- 1- A single expense claim : A new expense claim will be created for each user, containing all the expenses included in the import. The expense claim created for each user will be dated from the earliest to the latest expense date.
- 2- Based on the frequency defined in the reimbursement profile : One or more expense claims will be created based on the frequency defined in the reimbursement profile (flexible, weekly or monthly).
Example for import mode no. 2: Creation of expense claims based on the frequency defined in the reimbursement profile (flexible, weekly or monthly).
Example: Importing a file containing expenses from 15/05 to 15/06, where there is no new expense claim corresponding to the expense dates:
If the frequency in the reimbursement profile is “flexible”. Creation of an expense claim dated from 15/05 to 15/06.
If a weekly frequency is defined in the reimbursement profile. Creation of an expense claim for each week containing expenses (Monday to Sunday).
If a monthly frequency is defined in the reimbursement profile. Creation of 2 expense claims: one for May and another for June.
Example for import mode no. 4: Importing a file containing expenses from 15/05 to 15/06, where there is no new expense claim corresponding to the expense dates:
If the frequency in the reimbursement profile is “flexible” and there is no new expense claim corresponding to the expense dates, an expense claim dated from 15/05 to 15/06 is created.
If a weekly frequency is defined in the reimbursement profile. Creation of an expense claim for each week containing expenses (Monday to Sunday).
If a monthly frequency is defined in the reimbursement profile. Creation of 2 expense claims: one for May and another for June.
|
Our advice: We recommend using import mode no. ‘4’: ‘Creation or updating of ongoing expense claims > Add to expense claims based on expense dates or create claims based on the frequency defined in the reimbursement profile’. |
Expense claims are created automatically through the import. Users must then open them and enter the expense types and any missing information before submitting them for approval.
If there are other expenses made using personal payment methods, it is possible to add expenses to the same expense claim or create an additional one.
Keywords associated with this article:
Expense claim - Reimbursement - business expenses - Business expenses - Expense sorting - reimburse - Mileage expenses - Business Card Import - Expense import - Payment by Business Card
Comments
Article is closed for comments.