Importing bank statements in CSV format

Tim Hume tim at nomuka.com
Sun May 7 15:15:16 EDT 2017


Hi David,

It's the last point that you mention that I'm stuck on. How do I choose not 
to import a particular transaction? I can't seem to get this to work - 
there are these silly transactions in my imports for $0.00 caused by info 
lines in my bank's CSV files which GNU cash won't let me do anything with. 
I can't seem to edit them or delete them, I just have to import them and 
then delete the transactions from the account (or edit the original CSV 
file right at the beginning to get rid of the offending lines).

Tim




On 8 May 2017 12:11:46 AM David Carlson <david.carlson.417 at gmail.com> wrote:

> 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