Convert Quickbooks to GnuCash
Hi, Has anyone had a experience migrating from quickbooks to gnucash? I have been google'ing for the past couple of hours looking for solutions but have not really found one that works for me. The only one I have found requires Excel (xl2qif Excel Macro). -mike
Michael Long wrote:
Hi, Has anyone had a experience migrating from quickbooks to gnucash? I have been google'ing for the past couple of hours looking for solutions but have not really found one that works for me. The only one I have found requires Excel (xl2qif Excel Macro). -mike _______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
I regularly import qib's into gnucash, but they're from my bank. Have you tried to make a copy of the data and just do a straight import?
Eric> I regularly import qib's into gnucash, but they're from my bank. Eric> Have you tried to make a copy of the data and just do a straight Eric> import? Has anyone had success in having Gnucash talk directly to the Bank and/or Credit Card company to pull down information, and (ideally) push transactions to the bank? I'm getting sick in tired of my banks web interface, mostly because it's such a damn manual process to actually pull down the transactions in QIF format. I'm thinking of moving from BoA to DCU completely, if I can make it work. Or to another bank (within reason) to make my life simpler. Another goal is to be able to download my Credit Card statements automatically each time I fire up GnuCash so I can track those expenses better. John
Eric> I regularly import qib's into gnucash, but they're from my bank. Eric> Have you tried to make a copy of the data and just do a straight Eric> import?
What do you mean by a straight import? Quickbooks does not support exporting to IIF format. I can save a report to a csv format but have not figured out how to import that into gnucash.
Has anyone had success in having Gnucash talk directly to the Bank and/or Credit Card company to pull down information, and (ideally) push transactions to the bank?
I'm getting sick in tired of my banks web interface, mostly because it's such a damn manual process to actually pull down the transactions in QIF format.
I'm thinking of moving from BoA to DCU completely, if I can make it work. Or to another bank (within reason) to make my life simpler. Another goal is to be able to download my Credit Card statements automatically each time I fire up GnuCash so I can track those expenses better.
I started looking at the AqBanking wizard for gnucash but get stuck with bank code when creating a new PIN/TAN user. I could not find any information with google that allowed me to make sense of how the interface works with BofA. It looks like it will be a manual process for now.
"Eric" == Eric Martin <freak4uxxx@gmail.com> writes:
Eric> What bank do you use? GnuCash has a bunch of resources on their wiki I use Bank of America. I tried getting GnuCash to work, but they (BoA) wanted $10/mon to turn on the support for this stuff. Needless to say, I'm starting to move all my banking elsewhere to get better support. John
I started looking at the AqBanking wizard for gnucash but get stuck with bank code when creating a new PIN/TAN user. I could not find any information with google that allowed me to make sense of how the interface works with BofA. It looks like it will be a manual process for now.
What bank do you use? GnuCash has a bunch of resources on their wiki
I found some useful information on the wiki for configuring BOA along with many others to automatically download the files. It requires setting up OFXDirectConnect as the backend. http://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings I have just installed opensuse 11 and am not able to get gnucash and aqbanking3-ofx to play well together. When I attempt to install aqbanking3-ofx yast tells me that I must uninstall gnucash. Hopefully this will be fixed in the near future. gnucash 2.2.4-27.1 aqbanking3-ofx 3.8.0.pm.1 -mike
John Stoffel wrote:
Has anyone had success in having Gnucash talk directly to the Bank and/or Credit Card company to pull down information, and (ideally) push transactions to the bank?
I'm getting sick in tired of my banks web interface, mostly because it's such a damn manual process to actually pull down the transactions in QIF format.
I'm thinking of moving from BoA to DCU completely, if I can make it work. Or to another bank (within reason) to make my life simpler. Another goal is to be able to download my Credit Card statements automatically each time I fire up GnuCash so I can track those
I have successfully configured GNUCash to pull down my data from discover card. Additionally, I download my data from my bank in M$ format (OFX) and it imports perfectly.
"Eric" == Eric Martin <freak4uxxx@gmail.com> writes:
Eric> John Stoffel wrote:
Has anyone had success in having Gnucash talk directly to the Bank and/or Credit Card company to pull down information, and (ideally) push transactions to the bank?
I'm getting sick in tired of my banks web interface, mostly because it's such a damn manual process to actually pull down the transactions in QIF format.
I'm thinking of moving from BoA to DCU completely, if I can make it work. Or to another bank (within reason) to make my life simpler. Another goal is to be able to download my Credit Card statements automatically each time I fire up GnuCash so I can track those
Eric> I have successfully configured GNUCash to pull down my data from Eric> discover card. This si good to know. How finiky was it? I'm still dealing with ice storm stuff (power only out for 12 hours thank god) but it's relatively minor. Eric> Additionally, I download my data from my bank in M$ format (OFX) Eric> and it imports perfectly. That's fine, but I don't want to have to: open browser login to bank click to download section pick right stuff to get download close browser open gnucash import data I just want to open GnuCash and have it do the work for me! :]
participants (3)
-
Eric Martin -
John Stoffel -
Michael Long