Desperate GnuCash user
Paul Schwartz
pmjs1115 at yahoo.com
Wed Apr 4 10:05:43 EDT 2012
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.
>
>
>
More information about the gnucash-user
mailing list