Import Journal Entry from Excel File
The function is for import entries prepared by the structure of Excel. Import Journal Entry from Excel File can be found under Import/Export Data button.
|
File Path
|
File path to Excel file. |
|
Open
|
Open button will open excel file before import. |
| Transfer |
Data will be transfer into journal entry. |
| Register Overview |
Pantheon will check if prepared data match existing registers in program. |
| Fill In Missing Registers on Transfer |
This option marked will enable to add the missing entries in registers (subjects, chart of accounts, cost holders) at data transfer.
|
Excel file should contain following columns in the written order:
- Journal entry number (if we want to import data to exact number of journal)
- Period date for journal entry ((if we want to import data to exact number of journal)
- Account
- Subject
- Debit
- Credit
- Document
- Linked Document
- Document Date
- Value Date (Due Date)
- Currency
- Exchange Rate
- Department
- Cost Center
- Note
- Contra Account
- VAT Date
- External Document
- Status (can not be autofilled at transfer)
- Status name
- Value Debit (By default, the currency values are filled according to the exchange rate, if there is no value entered here)
- Value Credit (By default, the currency values are filled according to the exchange rate, if there is no value entered here)
We can use template or see the example on sample file.
 |
To import data to the journal in which we are located in the moment, we should skip columns journal entry number and date of journal entry. |