Importing bank statements in CSV format

David Carlson david.carlson.417 at gmail.com
Sun May 7 10:11:44 EDT 2017


When a csv file is opened by a spreadsheet application, the transactions
appear in a nice table format which makes it almost trivial to use a mouse
to cut and paste either wanted information or unwanted information.  Then
save to the same CSV format instead of the spreadsheet format.  If that is
not helpful for your case...

I may be wrong about this as I am just now learning how it works in GnuCash
release 2.6.15...
I think that the CSV importer that is available in most of the versions of
GnuCash except the next one which will be much easier to use and has not
been officially released yet allow you to select which lines to import
while you are defining the format of the data file and assigning the
columns to GnuCash columns.  Then, when you get to the last stage where you
can edit the account assignments, you can also choose not to import each
transaction similarly to how it is done in with the OFX import.  Or you can
choose to assign unwanted transactions to a special account to be deleted
later.

David C

On Sun, May 7, 2017 at 7:30 AM, Tim Hume <tim at nomuka.com> wrote:

> I'm using the latest version of GNU Cash in Debian - I'm not at the
> computer now so not sure what number this is.
>
> Of course I can edit the CSV file by hand before importing it, but it
> would be nice if I could simply click on the transactions I want to import
> rather than being forced to import all the transactions in the file. The
> import screen allows me to edit transactions which the importer thinks it
> has matched with transactions already entered in the accounts. It also
> allows me to assign accounts to unmatched transactions. But it doesn't seem
> to allow me to totally ignore a transaction in the CSV file. However the
> help information kind of hints that this is possible (but doesn't say how
> to do it as far as I can tell).
>
> Cheers,
>
> Tim.
>
>
>
> On 7 May 2017 1:30:17 PM Greg Feneis <mfeneis at gmail.com> wrote:
>
> Hi Tim,
>>
>> You might want to mention your GnuCash version.  Your OS may not be
>> necessary but doesn't hurt.
>>
>> I don't know about importing into GunCash via CSV so I can't help you
>> there.  I do know CSV files are text files and you can open them with
>> various word processing programs or spreadsheet programs and edit prior to
>> import.  Hope that helps.  I'm sure somebody else who knows GnuCash better
>> will be along shortly
>>
>>
>>
>>
>>
>> Kind regards,
>>
>> Greg Feneis
>>
>>
>>
>>
>>
>> On Sat, May 6, 2017 at 7:09 PM, Tim Hume <tim at nomuka.com> wrote:
>>
>> Hi everyone,
>>>
>>> I might be missing something obvious. I import my bank statements in CSV
>>> format. Sometimes there are transactions I don't want to import (because
>>> they're not really transactions - just information lines in the CSV that
>>> my
>>> bank inserts). How can I get GNU Cash to just ignore some of the
>>> transactions?
>>>
>>> At present I have to import the non-transactions, and then go and clean
>>> things up in the various accounts.
>>>
>>> Cheers,
>>>
>>> Tim.
>>>
>>> _______________________________________________
>>> 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.
>>>
>>> _______________________________________________
>> 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.
>>
>
>
> _______________________________________________
> 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