Exporting Eurécia expenses to my accounting software
Setting up a custom export
From the Expense Analysis page, click the Accounting Export button on the right of the screen then Create a custom export.
You can configure the options and columns to export based on the data expected by your accounting software.
General
Export format:
- CSV: Text file with a column separator
- Position: Text file with fixed width columns
|
New ! A set of options allows you to define how to export your text file with fixed size columns.
|
- XLS: Excel file before 2007
- XLSX: Excel file since 2007
Separator:
- Option only available for CSV format. Allows you to define the character that separates the columns of the exported file
File extension:
- Option available for text formats (CSV and position)
|
New ! It is now possible to define the extension of your files if your accounting application needs a particular extension such as pnm or other.
|
Example :
Enter txt if your file should be called "MyExport.txt"
- Surround each field with quotes: Option only available for CSV format.
- Add the export time in the file name: In the format YYYYMMDDHHMMSS.
- Export column headers: Allows you to export a first line containing the description of the columns to export.
Accounting options
The Accounting Options block allows you to define the accounting rules to be respected to carry out the export:
- Management of VAT lines:
- Do not extract: There will be no line dedicated to VAT within the file.
- Extract one line per expense: One line per VAT entered will be written to the file.
- Credit line management:
- Do not extract: Only the flow lines will be written to your file.
- Extract credit lines: The lines associated with the third-party account will appear.
- Log code:
- Free field: Allows you to enter the journal code of your accounting directly in the export configuration.
- Department Code: Allows you to have a different journal code between the departments of your company. These codes can be defined in the organization tab of the company file.
- Company journal code: Exports the journal code defined in the company file settings tab > Expense Report Settings block.
- Structure code: Allows you to have a different journal code between the structures of your company. These codes can be defined in the organization tab of the company file.
- Part Type: Value exported when you select the "Part Type" field in the columns to export.
- Built Analytical Code: Value exported when you select the "Built Analytical Code" field in the columns to export.
Note: Find out how to define this field on this page . |
- Date format: If nothing is selected, the date is exported in the format of the user's language.
Example: DD/MM/YYYY for a French user
- Decimal separator: Decimal separator used for numbers.
- Number of decimal places: Number of digits after the decimal separator. If the field is empty, the number of decimal places will be the number of useful digits.
Example: By leaving blank the following numbers can be exported: 10.5, 15.22 or 9
- Label Construction (Credit) - Value exported on credit lines when you select the "Label" field in the columns to export.
- Label Construction (Debit) - Value exported on debit lines when you select the "Label" field in the columns to export.
- Description Construction (Credit) - Value exported on credit lines when you select the "Description" field in the columns to export.
- Description Construction (Flow) - Value exported on flow lines when you select the "Description" field in the columns to export.
Note: Find out how to define the “Label” and “Description” fields on this page . |
- Type of entry (General account)
- Value exported on the general account lines when you select the "Entry type" field in the columns to export
- Type of entry (Analytical account)
- Value exported on analytics lines when you select the "Writing Type" field in the columns to export
- Group by expense account and VAT account
- Allows to have a single line with the total amount of all expenses of an expense report having the same expense account and the same VAT account
- Only one line of credit per expense report
- Allows you to have a single line of credit per expense report corresponding to the total amount of credits
- Extract a row by analytical axis
- Allows you to have a line corresponding to the analytical axis selected by expense
- Payment method
- Value exported based on the reimbursement method selected in the expense report when you select the "Payment method" field in the columns to export
Export construction
Position
This column allows you to find your way around the exported file.
In the case of XLS, XLSX or CSV files, it indicates the column of the file as you see it when you open the file with your spreadsheet application.
In the case of a position file, it indicates at which character the start of the column is located. It is calculated based on the lengths of the previous columns.
Values
- Fixed value
- Allows you to set a value that will always be the same in the file
- If the text box is left blank, the column will be empty
- Arrival address
- Starting address
- Axis 1, 2, 3, 4 and 5
- Label of the account selected in the expense
- Mileage scale
- Analytical code built
- See paragraph Accounting options
- Axis code 1, 2, 3, 4 and 5
- Analytical code of the account selected in the expense
- Grouping code axis 1, 2, 3, 4 and 5
- Grouping code of the account selected in the expense
- Payment method code
- See paragraph Accounting options
- Refund profile code
- Department code
- Log code
- Company code
- Structure code
- Comment
- Comment entered in the expense
- Account
- Accounting account corresponding to the line written in the file
- VAT account
- VAT account of the line
- Centralizing account
- Centralizing account linked to the line
- Accounting account
- Charge account on charge account lines only
- Third party account
- Third party account of the means of payment on credit lines only
- Empty if the Account column is exported and there is no centralizing account
- Credit
- Amount to credit
- Date
- Date of expense
- Accounting entry date
- Date entered at the time of export
- Period start date
- Expense report start date
- Period end date
- Expense report end date
- Refund date
- Expense report reimbursement date
- Marking date
- Expense report marking date
- Description
- See paragraph Accounting options
- If the configuration is empty: expense label
- Reimbursement profile description
- Currency of the expense
- Expense report currency
- Speed
- Amount to be debited
- Restaurant voucher deduction
- Yes, if the type of expense deducts a restaurant voucher
- No, if it does not deduct a restaurant voucher
- Department
- Department: company code
- Department: establishment code
- Dept ref
- Expense reference
- Employee record: BIC
- Employee record: IBAN
- Employee record: fields 1, 2, 3, 4 and 5
- Employee record: analytical code
- Employee record: analytical code 2
- HT Treated
- Takes into account the percentage of recoverable VAT
- External guests
- Internal guests
- KM
- Label
- See paragraph Accounting options
- If the configuration is empty
- Description of expenditure on HT lines
- Description of the expense + VAT in hard copy on the VAT lines
- Journal + Employee name + period on the lines including tax
- Brand
- Registration number
- Payment method
- See paragraph Accounting options
- Reimbursement method
- Description of the reimbursement method used for the expense report
- Empty expense lines with a company card
- Amount
- Amounts processed (taking into account recoverable VAT and reimbursement ceilings)
- Amount excluding VAT
- Amount including tax
- Net amount to be repaid
- Means of transport
- Ndf ref
- Net to be reimbursed.
- Net to be reimbursed after employer contribution deducted
- Name
- Expense report
- Part No.
- Expense Report Profile
- Refund profile: additional code
- Reimbursement profile: expense type code
- First name
- Presence of proof
- With supporting evidence
- With supporting documents without probative value
- Without proof
- Qty
- Expense quantity field
- 1 if the field is not displayed for the expense
- Rebillable
- Sense
- C for credit lines
- D for flow lines
- Company
- Expense report status
- Structure
- Structure: company code
- Structure: establishment code
- VAT
- VAT indicated on receipt
- VAT processed
- Depends on the percentage of recoverable VAT
- Total processed
- Depends on the VAT recovery percentage and the amount refunded
- Type of expense
- Expense report type
- Room type
- See paragraph Accounting options
- Type of writing
- See paragraph Accounting options
- A part is not subject to VAT
- Vehicle (tax horsepower)
- Geographic area
Stubborn
Value exported on the header line.
If the header column is empty, the exported value is the name of the selected value.
Length
Column length for position format.
If data is longer than the allowed length for the column, it is truncated.
Alignment
For position format.
Data alignment side if the data is shorter than the length defined for the column.
Filling
For position format.
Data padding character if the data is shorter than the length defined for the column.
Example :
Padding 0 with a length of 10 characters and right alignment: 0000015.95
Line type
- Default behavior - See description of values
- Expense accounts (HT) - The value will only be present on the HT lines of expenses
- VAT accounts
- The value will only be present on lines associated with VAT
- The "VAT line management" option must be set to "Extract one line per expense"
- Third Party Accounts (TTC)
- The value will only be present on the lines associated with the third-party account
- The "Credit Line Management" option should be set to "Extract Credit Lines"
- Analytical
- The value will only be present on the analytics lines
- The box "Extract one line per analytical axis" must be checked"
Terms
The "Add a condition" button allows you to define a condition for which the exported value will not be the one defined in the "Values" column.
The first list allows you to define which information the condition will apply to.
The first input box allows you to define the value that serves as the condition.
The second list allows you to define what information will be used if the condition is met.
Example :
In the example above, the default exported value is the code of the account selected in axis 1 of the expense.
If the account associated with the expense type is equal to 626200, the exported value will be OTHER.
Note: Multiple conditions can be defined for the same column and the condition is an equality. It is not possible to define a greater than or less than condition. |
Keywords associated with this article:
Export - customizable - configurable - accounting - personal - personalized - flat file - file - position - csv - Excel - personal export - accounting - accounting
Comments
Please sign in to leave a comment.