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.

 

UZoH.gif

 

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.

  1. Employees make payments using their business card

  2. The bank receives information about these payments

  3. It automatically creates statements, which are stored on an FTP server

  4. The platform administrator or accountant receives an import file

  5. 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 bouton_plus.png button to add a business card, or edit the information and tick the box corresponding to the ‘Company card’ column

Image_11.jpg

 

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

Image_12.jpg

 

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

 

 

Contact_Support.png

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

 

EA_NDF_import_carte_affaire.jpg

 

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.

 

 

  • Creation or updating of ongoing expense claims: the import will create new expense claims or add the imported expenses to existing expense claims.
    • 3- Add to the latest ongoing expense claim or create a single expense claim : The expenses will be added to the most recent expense claim with the status “New”. If no expense claim with the status “New” exists, a new expense claim will be created for each user, dated from the earliest to the latest expense date.
    • 4- Add to ongoing expense claims based on expense dates or create claims based on the frequency defined in the reimbursement profile : The expenses will be added to any existing expense claims with the status “New”, based on the expense dates.
      For expenses whose dates are not covered by an existing expense claim with the status “New”, new expense claims will be created based on the frequency defined in the employee’s reimbursement profile (flexible, weekly or monthly).

 

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

Was this article helpful?

5 out of 7 found this helpful

Comments

Article is closed for comments.