First use - Employee
How do I send a report in Expensya?
How to create an Expensya account?
The different statuses of a report
How to create a report?
How do I add or delete an invoice?
How do I add and delete my mileage expense?
How to add a guest on an invoice?
Managing my vehicles for my mileage expenses
How to assign an invoice to a report?
Exports reports and invoices
Personal settings
Validate my Expensya trial account
My report is still a draft, what does that mean?
Advances Management
Mission order requests and management
Automatic import of bank card statement
Professional payment instruments
Personal payment instruments
Manage your password
Source of Exchange Rate on Expensya
SSO Login
Creation and management of credit notes and expense cancellations on Expensya
First use - Company
How do I add or delete a user or adminisrator?
Company Settings
Can I change the export format?
Importing bank statements
Banks supported by Expensya
How to create user groups in Expensya?
Assign an administrator or accountant to user group
How to give or receive access delegation on Expensya?
How to create a project in Expensya?
How to assign my collaborators and groups to a project ?
Manage professional vehicles in Expensya
How to fill the project import template
How to create a category and configure my chart of accounts?
Customize the expense form fields
Customize category recognition for fast scan
How to configure expense rules
How to set up bank accounts in Expensya
How to manage mileage expenses in Expensya?
Change my offer
How to export all company’s expense reports
How to deactivate compensation for mileage expenses?
Difference between global admin and restricted admin
Grant or receive an access delegation on Expensya
Add a lump sum - The German perdiem
How to enter mileage expense with a professional vehicle
An invoice's statuses
Customize mileage expenses rates
Custom Fields - The Basics
Additional receipt compliance check
Custom select list field
Category accounting data by Group
Import of bank statements by the Administrator
How to set up a mileage rate by period?
Understand the parameters for calculating mileage expenses
Password management by the administrator
Custom fields: linking to an expense rule
Identification of the @expensya domain
First use - Expert Portal
Frequently asked questions and announcements
Privacy Policy and Data Storage
Technical Support
Legal archiving
Archiving with probative value by country
Legal archiving in Spain
How can clients recover data following archiving?
How to calculate mileage charges according to URSSAF scale?
Does the mileage scale apply to electric vehicles?
How to view reports and invoices in calendar mode?
How to collect my invoices from different merchant sites?
What does "to validate" mean?
How to use Expensya’s fast scan?
Understanding my mileage compensation.
How do I update my payment method ?
Manager or accountant can’t see a report
Can I pay in the currency of my choice?
Is reimbursement made through Expensya?
How to refer a contact?
How to modify invoices of other employees in Expensya
Calculating mileage expenses by applying the principle of compensation - case study
E-mail notifications sent by Expensya
Integrations and API
Accounting
Quadratus Export
Standard Cegid Export
How to activate accounting export formats?
Standard SAP Export
Banking
Payment
Connect to QuickBooks from Expensya
How to configure the Expensya-QuickBooks integration?
How do I send my invoices from Expensya to QuickBooks?
Associate a bank account with non-reimbursable expenses
How to see the data exported on Quickbooks?
How to activate payment exports
Our APIs
How to use Expensya's OCR + APIs?
How to use Expensya Partner's public APIs?
How to use Expensya's public APIs?
How to use public APIs to retrieve Expensya customer data as a VAT recovery partner?
Travel
How to integrate Uber to Expensya
Refund management
Inexweb integration
Subscription and Billing
- All Categories
- Integrations and API
- Accounting
- Standard SAP Export
Standard SAP Export
Updated
by Chaïma Bnina
This export format corresponds to the standard accounting entry for the SAP accounting software.
This document will detail the data generated.
File format :
File type | CSV |
Separator | ; |
File name format | CompanyName_yyyy-MM-ddThh-mm-ss-ms.csv |
Software | SAP |
Encoding | UTF8 |
File content:
- Lines:
Group | By report |
Credit lines | One line per report |
Debit lines | One line per VAT rate |
Currency | Employee currency |
- Columns :
Column Name | Type | Content | Example |
Company Code | Alphanumerical | Company code (Analytical axis 1) | Paris |
Document Number | Numerical | Report chronological number | 1 |
Fiscal year | Numerical | Fiscal year | 2019 |
Doc Type | Alphabetical | Fixed Value : KB | KB |
Document Date | Date | Report submission date Default value : dd.MM.yyyy Configurable by Expensya support | 24.12.2019 |
Posting Date | Date | Export generation date Default format: dd.MM.yyyy Configurable by Expensya support | 24.12.2019 |
Fiscal Period | Numerical | Fiscal year month number | 12 |
Reference Document Number | Numerical | Report reference in Expensya | 716 |
Currency Key | Alphabetical | Employee local currency in three characters | EUR |
Ledger |
| Empty | Empty |
Document header text | Alphanumerical | Report name in Expensya | My December 2019 Report |
Fiscal year | Numerical | Fiscal year | 2019 |
Company Code | Alphanumerical | Company code (Analytical axis 1) | Paris |
Document Number
| Numerical | Report chronologic reference | 1 |
Posting Key
| Numerical | · Invoice: Debit: 40 Credit: 31 ·Invoice credit : Debit: 50 Credit: 21 | 40 |
Tax Code
| Alphanumerical | Code corresponding to VAT rate in debit lines. Empty credit line. VAT codes configurable by Expensya support | Empty |
Document Amount
| Numerical | Amount per line type: · Debit Line: Tax-free invoice amount in employee's currency by rate of VAT · Credit Line: reimbursable value to the employee of the report in employee's currency Value format configurable by Expensya support | 400.0 |
Local cur Amt
| Numerical | Same as Document Amount Amount per line type: · Debit Line: Amount of the base HT of the expenditure in employee's currency (Amount TTC - VAT recoverable) by rate of VAT · Credit Line: reimbursable value to the employee of the Note in employee's currency Value format configurable by Expensya support | 400.0 |
Item Text
| Alphanumerical | Report name | My december 2019 report |
Account Number
| Alphanumerical | Account corresponding to the line Debit line: Expense category expense account · Credit Line: Employee Number | 625100 |
Cost center
|
| Empty | Empty |
Profit Center |
| Empty | Empty |
Order Number |
| Empty | Empty |
WBS Element |
| Empty | Empty |
Trading Partner |
| Empty | Empty |
Calculate Tax Indicator |
| Fixed value · Debit Line: · X: if Recoverable VAT · Credit Line: Empty | X |
Quantity |
| Empty | Empty |
Base unit of measure |
| Empty | Empty |
Transaction Type |
| Empty | Empty |
Business Area |
| Empty | Empty |
Reference Key 1 |
| Empty | Empty |
Local Currency 2 |
| Empty | Empty |
Assignment |
| Empty | Empty |
Special G/L indicator |
| Empty | Empty |
SAP CSV export file example :