Manual Journal Import

Manual Journal Import can be used for automated uploading and processing of manual journal entries from CSV file.  Depending on the selection of the "Approve" checkbox all uploaded journals can be either approved automatically or can be left in the "Waiting for approval" status. 

Manual Journal Import is available by going to Accounting -> New Operation and selecting Import Manual Journals  

Required fields (columns):

1) Reference - the unique journal reference that should be identical for all lines of the same journal. This value will be saved in the Document number field of the created journal.
2) AccountCode - journal entry G/L account code 
3) DebitAmount - journal entry debit amount
4) CreditAmount - journal entry credit amount

Both DebitAmount and CreditAmount can not be filled in for the same line. If the DebitAmount exists then the CreditAmount will be ignored.

All other fields (columns) are optional.
The columns order does not matter but the headers are important and should be the same as in the template

JournalDate can be in the one of the following formats: dd/MM/yyyyy, dd.MM.yyyyy, yyyy-MM-dd. (For US and PH based business accounts MM/dd/yyyy will be used instead of dd/MM/yyyyy). If left blank or the column does not exist the current date will be used by default.

JournalType - the name of any available journal types (My Company -> Settings -> Accounting -> Journal Types). If left blank or the column does not exist the default journal type will be selected.

PartnerName - the name of a business partner.

Narration - journal narration

Currency is required only if it differs from the balance currency. In that case DebitBalanceAmount and CreditBalanceAmount can be used to pass the amounts in balance currency but it is not required. If balance amounts are not present they will be recalculated automatically based on the available rate.

TaxKeyName - tax key name. If the tax key is provided then the tax line will be generated automatically and it should not be added to the file.

Description - journal entry description 

Still need help? Contact Us Contact Us