Through the eTASK.FM portal, you can export the following data records to an ASCII file, which you can then import into external financial accounting systems such as DATEV:
Incoming invoices
Outgoing invoices
Payment assignments
Rent invoices
The generated format is uniform for all exports. It always has the same structure. The following table shows which fields of the respective data records are written to which location in the export and into which fields they should be entered in the respective financial accounting system during import.
Position in export file | Type | Text Length | Incoming invoice | Outgoing invoice | Rental Invoice | Payment allocation | DATEV |
|---|---|---|---|---|---|---|---|
1 | Number | Amount (gross) | Amount (gross) | Amount (gross) | Amount (gross) | Revenue | |
2 | Text | 1 | S/H | S/H | S/H | D/C | Debit/Credit Indicator |
3 | Text | 3 | Tax key | Tax key | -empty- | -empty- | BU key |
4 | Text | 15 | G/L account | Vendor | Customer | Vendor or Customer | Account number |
5 | Text | 50 | Invoice number | Invoice number | Month-Year | Month-Year | Document field 1 |
6 | Text | 50 | Document number | Document number | -blank- | -empty- | -empty- |
7 | Date | 10 | Invoice Date | Service date | Posting date | Bank date | Document date |
8 | Text | 50 | Vendor | G/L account | G/L account | G/L account bank | Offsetting account (without BU key) |
9 | Text | 30 | Cost center | Cost center | Cost center | -empty- | Cost field 1 |
10 | Text | 60 | Posting text | Posting text | tMV number | Posting text | Posting text |
11 | Date | 12 | Payment due date | Payment due date | Payment term | -empty- | -empty- |
12 | Text | 6 | Payment terms | Payment terms | Payment term | -empty- | -empty- |
13 | Amount | 1 | Spelling | Spelling | Fixed-point | Fixed-point | Fixed-point |
14 | Date | 10 | Posting Date | Service date | -empty- | -empty- | -empty- |
Note: No tax code is passed if the account is an automatic account or if no tax code was specified for the applicable VAT rate.
The following general formatting is used in the file:
No thousands separator
No decimal separator
Date format: DD.MM.YYYY
The following CSV settings are applied in the file:
No header row
ASCII
Delimiter: ; (semicolon)
No delimiter at the end of the record
" (quotation marks) enclose text fields, amounts, and dates
The sign is part of the amount
IC2077