[GNC] Problems importing credit card transactions via CSV formatted file.

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] Problems importing credit card transactions via CSV formatted file.

GnuCash - User mailing list
One of the problems I’ve found with gnucash is in the area of importing CSV formatted transactions. I figured out how to do it reasonably well for my
bank statements, and now I’m turning my attention to my credit card accounts.

I’m trying to enter in data that spans several years, and I have a collection of CSV files. In most cases I don’t have the ability to go back and get
the data in a different format, such as some sort of Quicken file.

When I import the translations, I use the following selection for columns.

DATE, DESCRIPTION, DEPOSIT (or WITHDRAWAL, I’ve done both)

After the file has been processed, and the screen comes up to commit the transactions, there are lines that are Green and Yellow. Some have the “Liability:Credit Card:XXX” some have “unbalanced USD” designation.

But worse, there are some numbers that are negative, and some which are positive. And when I do import the results, the numbers, negative or positive, end up scattered between Payment and Credit columns.

Since I’m trying to import 100s of transactions it is very tedious to even think about going through each item and correcting the negative sign, etc.

Since there does not seem to be a ‘bulk’ process for selecting a large number of transactions and happing the same transaction assignment on all of the selected items, this is a major hiccup in
using gnucash for me.

Any assistance would be appreciated.

John Clark.

_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Problems importing credit card transactions via CSV formatted file.

David Carlson-4
John,

I have been told that the current release 3.1 of GnuCash has a greatly
improved CSV importer compared to the importer in the release 2.6.x series.
However, some of us have not updated because of certain regressions in that
release.  We are stuck with a cumbersome CSV importer.  I have noticed that
if I consistently assign the amount column of credit card accounts to
WITHDRAWAL the numbers come in with the correct sign, except for one rogue
account that does not follow the same format.

There is a list of a number of tools posted here <
https://wiki.gnucash.org/wiki/Published_tools> which includes a CSV to QIF
converter which you might find useful.

David C

On Wed, Jun 13, 2018 at 2:14 PM, John Clark via gnucash-user <
[hidden email]> wrote:

> One of the problems I’ve found with gnucash is in the area of importing
> CSV formatted transactions. I figured out how to do it reasonably well for
> my
> bank statements, and now I’m turning my attention to my credit card
> accounts.
>
> I’m trying to enter in data that spans several years, and I have a
> collection of CSV files. In most cases I don’t have the ability to go back
> and get
> the data in a different format, such as some sort of Quicken file.
>
> When I import the translations, I use the following selection for columns.
>
> DATE, DESCRIPTION, DEPOSIT (or WITHDRAWAL, I’ve done both)
>
> After the file has been processed, and the screen comes up to commit the
> transactions, there are lines that are Green and Yellow. Some have the
> “Liability:Credit Card:XXX” some have “unbalanced USD” designation.
>
> But worse, there are some numbers that are negative, and some which are
> positive. And when I do import the results, the numbers, negative or
> positive, end up scattered between Payment and Credit columns.
>
> Since I’m trying to import 100s of transactions it is very tedious to even
> think about going through each item and correcting the negative sign, etc.
>
> Since there does not seem to be a ‘bulk’ process for selecting a large
> number of transactions and happing the same transaction assignment on all
> of the selected items, this is a major hiccup in
> using gnucash for me.
>
> Any assistance would be appreciated.
>
> John Clark.
>
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> 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
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.