Desperate GnuCash user (CSV import into GnuCash)

[Lombard Steyn]

Good Day

Thank you for the replies so far.

My bank does not support OFX or QFX, unfortunately, or the online web
connect options.

Hoping someone can sure with me the exact CSV import file format GnuCash
requires for CSV import to work properly. I can then myself change the file
I get from my bank inline with the GnuCash CSV expected file format or
specification.

Thank you.
Lombard

-----Original Message-----
From: Dustin Henning [mailto:The00Dustin at gmx.net] 
Sent: 04 April 2012 02:07 PM
To: 'Yawar Amin'; 'Lombard Steyn'
Cc: gnucash-user at gnucash.org
Subject: RE: Desperate GnuCash user

I am not familiar with importing from CSV.  Does your bank offer an OFX or
QFX option you could use instead?  Note that one of my banks only "supports"
older versions, but that is for direct connections, they offer a web connect
option that allows you to download these files.  The support at said bank
wasn't able to tell me this when I told them it was what I wanted to do, I
just managed to figure it out on my own after talking to them.
	Dustin

-----Original Message-----
From: gnucash-user-bounces+the00dustin=gmx.net at gnucash.org
[mailto:gnucash-user-bounces+the00dustin=gmx.net at gnucash.org] On Behalf Of
Yawar Amin
Sent: Wednesday, April 04, 2012 07:59
To: Lombard Steyn
Cc: gnucash-user at gnucash.org
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.