Import invoices as entry in accounting service wit
Import invoices as entry in accounting service with postings
See users manual Import invoices only as entry in accounting service without postings for the first part and then continue with instructions bellow.
Excel file need the columns in the following sequence on tab 2 (Posts):
| A |
Key |
Key number define to which invoice entries belong. |
| B |
Position |
Position from the invoice. |
| C |
Account number |
Account numbers marked red are missing in chart of account register. Missing account need to be set in chart of accounts before Posting (import) invoices. |
| D |
Subject |
|
| E |
Document number |
|
| F |
Link document |
|
| G |
Foreign document |
|
| H |
Debit |
|
| I |
Credit |
|
| J |
Currency |
|
| K |
Exchange rate |
|
| L |
Date of document |
|
| M |
Due date |
|
| N |
Date of VAT |
|
| O |
Department |
|
| P |
Cost center |
When cost center is missing (marked red) in register, entries will be done without it. |
 |
Be sure to have all registers up to date before import invoices and entries. This is the only way to get satisfied result.
|
|
Data import starts from line 2.
|
We can use template and sample file:
- template and sample file for import of invoices with entries.