Hello apmuthu,
Thanks for the suggestions; they have helped me do a successful trial import of a receipt and a payment.
My data is in the templates/bank_en_GB.csv format where there are 11 commas per line. Whilst counting commas in the CSV file in my last post I noticed there was a space between the commas representing the empty payment and receipt field on the 2 data lines. When I removed the spaces as below it imported fine:
reference,date,memo,payment,receipt,accountcode,taxtype,dim1ref,dim2ref,person_type_id (supplier=1 customer=2),person_id,Branch_id
Test001,03/02/2015,Boris_accom,,75,4010,,,,2,1,
Test002,03/02/2015,Creme_de_La_pmt,50,,5013,,,,1,1,
as compared to my earlier test file with a space between the commas before the "75" in line 2 and after "50" in line 3, which failed:
reference,date,memo,payment,receipt,accountcode,taxtype,dim1ref,dim2ref,person_type_id (supplier=1 customer=2),person_id,Branch_id
Test001,03/02/2015,Boris_accom, ,75,4010,,,,2,1,
Test002,03/02/2015,Creme_de_La_pmt,50, ,5013,,,,1,1,
Here is the response for the receipt processing (payment response was also successful):
Skipped header. (line 1 in import file 'AD import Mar 15 test1.csv')
--------------------------------------------------------------------------------------------Line 2 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 12, 03/02/2015, Test001, 4010, 0, 0, 75 (line 2 in import file 'AD import Mar 15 test1.csv')
Added to table 'gl_trans Credit:': 12, 03/02/2015, 4010, 0, 0, -75, Boris_accom (line 2 in import file 'AD import Mar 15 test1.csv')
Added to table 'debtor_trans Credit: Payment from customer': 75 (line 2 in import file 'AD import Mar 15 test1.csv')
Added to table 'gl_trans' Debit bank account: 12, 03/02/2015, 1060, 0, 0, 75, Boris_accom (line 2 in import file 'AD import Mar 15 test1.csv')
--------------------------------------------------------------------------------------------Line 3 ------------------------------------------------------------------------------------------
Ignoring payment. Use same csv under payment processing.(line 3 in import file 'AD import Mar 15 test1.csv')
1 Deposits would have been successful if imported. Uncheck Trial check before importing.
The offending spaces were introduced during my formatting of the CSV file my bank lets me download. It comes in the form Date, Memo and and Amount. The Amount value is in one column with positive values for receipts and negative values for payments. I used an IF-THEN-ELSE spreadsheet function in order to create two positive valued columns from the combined +/- column. For payments: =IF(C2<0,-C2," ") took a negative payment value and made it positive or left what I thought was a blank cell but I suppose must have resulted in a space because of the space I had left between the pair of double inverted commas, " ". This went on as a space between the commas.
To answer your last question: I'm using the FA default CoA with a few custom codes that are numerically close to similar categories in the default set up. This seems to suit my purposes fine.