Desperate GnuCash user

[Paul Schwartz]

The Import CSV function is new to me [haven't used it]. My method is to open the CSV file with a spreadsheet [OpenOffice or similar] and then use the calc2qif macro to make a QIF file. This file then imports nicely into GnuCash.

HTH

Paul




>________________________________
> From: Yawar Amin <yawar.amin at gmail.com>
>To: Lombard Steyn <lombard.steyn at gmail.com> 
>Cc: gnucash-user at gnucash.org 
>Sent: Wednesday, April 4, 2012 5:59 AM
>Subject: Re: Desperate GnuCash user
> 
>
>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>
>
>
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-----
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>
>
>