• ion
  • Member
  • Offline
  • From: Canada
  • Registered: 07/06/2013
  • Posts: 17

Topic: Import Transaction issue

I am trying to import journal entries in FA with no luck.
I have installed the module, activated successfully, however whenever I run the import I always receive this error:

Skipped header. (line 1 in import file 'import-test-3.csv')
Error: Debits do not equal credits.
1

I have tried on my installation as well as the UK demo site with the sample file.

Here is the file I have used:

"reference","date","memo","amount","accountcode","taxtype","dim1_ref","dim2_ref","person_type_id (supplier=1 customer=2)","person_id"
"JNL2",02/12/2014,"Rent outstanding",122.25,7100,1,"D1","D2",,
"JNL2",02/12/2014,"Accruals",-122.25,2109,0,"D1","D2",,

Can you share a sample that is working?
Any help would be appreciated.
TIA
Ion

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Import Transaction issue

Working example:

reference,date,memo,amount,accountcode,taxtype,dim1_ref,dim2_ref,person_type_id (supplier=1 customer=2),person_id
JNL1,01/12/2014,Bad debts using account 8100,222.24,8100,0,D1,D2,,
JNL1,01/12/2014,Debtors Control using account 1100,-222.24,1100,0,D1,D2,2,2
JNL2,02/12/2014,Rent outstanding,122.25,7100,1,D1,D2,,
JNL2,02/12/2014,Accruals,-122.25,2109,0,D1,D2,,
JNL3,03/12/2014,Prepayments,322.26,1103,0,D1,D2,,
JNL3,03/12/2014,Rent Prepaid,-322.26,7100,1,D1,D2,,
JNL4,04/12/2014,Prepayments,400,1103,0,D1,D2,,
JNL4,04/12/2014,Prepayments,400,1103,0,D1,D2,,
JNL4,04/12/2014,Rent Prepaid,-800,7100,1,D1,D2,,

Do not use double quotes (or any quotes) in the file and use commas as the separateor - do not use it in the description / content of any of the fields. Make sure that the CR/LF is proper and does not occur within a field.

apmuthu's Website

  • ion
  • Member
  • Offline
  • From: Canada
  • Registered: 07/06/2013
  • Posts: 17

Re: Import Transaction issue

CR/LF did it for me. I am using a Mac and the lines in the file were terminated by CR.
Import works after I changed the line terminations.
Both Windows termination, CR/LF or Unix termination, LF worked for me.
Thanks for your help.
Ion

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Import Transaction issue

@rossaddison, @joe: wherever csv files are used in FA, we need to take care of line endings making it OS agnostic. Just replace all CRLF with LF and start to work.

apmuthu's Website