Desperate GnuCash user (CSV import into GnuCash)

Lombard Steyn lombard.steyn at gmail.com
Sat Apr 7 06:02:02 EDT 2012


Hi Bob

Thank you for this detailed description. It works perfectly now.

Much appreciated.

All the best
Lombard

-----Original Message-----
From: Bob Taylor [mailto:philologos at mindspring.com] 
Sent: 06 April 2012 05:24 PM
To: gnucash-user at gnucash.org
Cc: lombard.steyn at gmail.com
Subject: Desperate GnuCash user (CSV import into GnuCash)

Hi Lombard,

After cleaning up the data you posted (which had been quoted and wrapped) and saving as a csv file, I was able to import it into a credit card account.  Judging from the error message you got, I think you may not have mapped the fields by selecting from the dropdowns at the top of each column.  I selected Date for Transaction Date, Description for Description and Deposit for Amount. (A payment is considered a Deposit and a charge is treated as a withdrawal).  These are the only fields needed and the other fields I left as "None".  You have two opportunities to choose the expense account to post to.  You can double click on the line and select from an account list, or let it default to Imbalance and then change the transaction in the register for the credit card account.

I hope this helps you.

Regards, Bob Taylor




Desperate GnuCash user (CSV import into GnuCash) Lombard Steyn lombard.steyn at gmail.com Wed Apr 4 08:45:41 EDT 2012

    Previous message: Desperate GnuCash user
    Next message: Retrieving account data
    Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.


    Previous message: Desperate GnuCash user
    Next message: Retrieving account data
    Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the gnucash-user mailing list

http://lists.gnucash.org/pipermail/gnucash-user/2012-April/044220.html





More information about the gnucash-user mailing list