Desperate GnuCash user

[Yawar Amin]

On 2012-04-04, at 05:07, Lombard Steyn wrote:

> Good Day,
> 
> Thank you very much for a great application, docs and tutorial.
> 
> I am trying to import the following credit card bank CSV down load into the
> liability.credit card account in GnuCash without success.
> 
> "Transaction date","Date posted","Card holder","Description","Type","Amount"
> "03-03-2012","05-03-2012","L STEYN                   ","WOOLWORTHS SUNSET
> BEACH SUNSET BEACH    ","Purchase","-124.10"
> "02-03-2012","06-03-2012","L STEYN                   ","I numetro.co.za
> ROSEBANK        ","Purchase","-59.00"
> "05-03-2012","07-03-2012","L STEYN                   ","SUNSET BEACH SERVICE
> ST SUNSET BEACH    ","Purchase","-113.30"
> "08-03-2012","09-03-2012","L STEYN                   ","AMAZON MKTPLACE PMTS
> AMZN.COM/BILL   ","Purchase","-99.27"
> "08-03-2012","09-03-2012","L STEYN                   ","AMAZON MKTPLACE PMTS
> AMZN.COM/BILL   ","Purchase","-118.41"
> "08-03-2012","09-03-2012","L STEYN                   ","AMAZON MKTPLACE PMTS
> AMZN.COM/BILL   ","Purchase","-209.73"
> "08-03-2012","09-03-2012","L STEYN                   ","AMAZON MKTPLACE PMTS
> AMZN.COM/BILL   ","Purchase","-261.12"
> "12-03-2012","12-03-2012","L STEYN                   ","#LATE PAYMENT FEE
> ","Other Transaction Fee","-210.00"
> "14-03-2012","14-03-2012","L STEYN                   ","I/BANK PAYMENT-THANK
> YOU                ","Payment","10000.00"
> "13-03-2012","14-03-2012","L STEYN                   ","WOOLWORTHS SUNSET
> BEACH SUNSET BEACH    ","Purchase","-111.90"
> "16-03-2012","16-03-2012","L STEYN                   ","INTEREST
> ","Finance Charge","-374.25"
> "16-03-2012","17-03-2012","L STEYN                   ","PLI*DRIPABLE
> Plimus,Inc      ","Purchase","-526.42"
> "17-03-2012","19-03-2012","L STEYN                   ","S*SUNSET BEACH WINE
> &   TABLE VIEW   ZA ","Purchase","-212.50"
> 
> All I really need is Transaction Date, Description (Payee) & Amount. How can
> reformat this for it to work with the import CSV function, or what format
> must the CSV function be exactly to be able to import successfully. I have
> tried many different options but every time get the same results (it says
> "no date, no balance, no withdrawal, no deposit column) every time.... see
> below for some examples. 
> 
> Our bank does not maintain a balance column in statements only
> 
> Please help?!
> 
> Thank you.
> Kind Regards
> Lombard
> 
> 
> 
> 
> 
> 
> 
> <winmail.dat>