Jump to content
mika2012

Failed Import Journal Transactions from CSV

Recommended Posts

Hello,

 

I made with success the import of items (1711 rows) and the import of sales invoices.

 

I have now a problem to import Journal Transactions. I do not understand what I missed this time.

I copied my csv test file below.

DATE Journal type Reference Description (Journal Memo) Account number Account Description Debit amount Credit amount 10/02/2013 GJ GJ1 Journal Entry AC ADMIN FEE 6900 Bank Charges 48.77 - 10/02/2013 GJ GJ2 Journal Entry AC ADMIN FEE 1100 HSBC - 48.77

 

I got the following window:

 

"Required Information Missing"

1. Journal type

2. Reference

3. Description (Journal Memo)

4. Account Number

5. Debit or Credit amount

 

I will appreciate any assistance in the matter.

 

Thanks

Mike

Share this post


Link to post
Share on other sites

Looking at your data, I can see following issues where it could go wrong and display that message:

1) Do you have commas (,) in the csv file? Try opening your csv file in notepad.

2) 'Journal type' field for ex-accounts should have one of these: "Payments", "Receipts", "Sales", "Purchases", or "General"

3) 'Reference' number should be same for a debit-credit pair of transaction.

4) Check and match date format settings in Options -> Regional (,and also system date in Control Panel, regions and languages.)

5) Check 'Charts of Accounts' to see if account numbers 6900 and 1100 exist.

6) When importing, start from row 2

 

Your csv file in notepad editor should look something like:

 

"DATE","Journal type","Reference","Description (Journal Memo)","Account number","Account Description","Debit amount","Credit amount"

"2013-10-02","General","GJ1","Journal Entry AC ADMIN FEE","6900","Bank Charges","48.77","-"

"2013-10-02","General","GJ1","Journal Entry AC ADMIN FEE","1100","HSBC","-","48.77"

 

Hope this helps!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...