There are actually three states allowed in the reconciled column: N (Not cleared), C (Cleared), and R (Reconciled). I didn't like the built in budgeting so I just wrote my own external budget system that automatically updates from the GnuCash database.įor the review of incoming transactions, have you worked with the reconciled column in the register? This is not a database thing. I have used LibreOffice base, Crystal Reports, Jasper reports, and php/html/javascript to get data out of GnuCash any way I want. If my wife is entering transactions on her computer I can still open the file and look around without any issues.Ī database back end also allows you to do use any reporting tool you want to. You can still have only one person using the system at a time to WRITE transactions, but many people can open the data simultaneously for READ ONLY transactions. This is especially true if you are sharing with another person/people. I always recommend doing the work and setting up GnuCash with a database back end, either MySQL/MariaDB or PostGre. I kind of want something in the middle - a nicer UI than the old-skool-clunky-looking GnuCash, but still zippy.

It's got a nicer UI, which is nice, but it's also slower-feeling than GnuCash.

You can't store or version your own data (I version my GnuCash data in Git).You have to write an 'app' that does oauth in order to touch the data, and it's a pain. While Quickbooks supports all of those things I mentioned, it has other pains: I started looking into using Quickbooks to manage everything, and I think it can support all of these things, but I hate to leave GnuCash and its awesome community and APIs, so I thought I'd do a check here to make sure I'm not missing something.Ĭan any of those things I mentioned above be done with GnuCash?

There's no way to auto sync to my bank accounts.This is a nice feature because you can import all the latest bank transactions, and different people can come do a pass on approving and categorizing each one. It doesn't seem to have the notion of incoming bank transactions 'for review'.

It's hard to share with a spouse because you can't concurrently access it, and there's no server anyway.Generally I've liked it while doing it myself, but I'm starting to share the books with my spouse and starting to hit some limits. I've been using GnuCash for years to manage the complete personal finance picture: personal income and expenses, business summaries, bank accounts, and investments.

Import quickbooks to gnucash