GnuCash 2.6.10 Free Accounting Software Squashes Over 15 Bugs, Adds Improvements

I use GNUCash.

There are a few issues however...

Data at Rest remains unencrypted.

The DB features are quite difficult to work through and need to be enabled at compile time - It's SQL lite -- I haven't figured out how to use my goto DB, psql...

The default config is flat unencrypted text files which is a truly horrific way to store very sensitive financial data.

I personally find the program somewhat opaque as far as what happens when... xyz needs to occur.

And then there is some weirdness to scheduled transactions. Many times I end up with double scheduled transactions for no apparent reason, and the documentation is kinda sh*tty.

But... It's FOSS and your data remain your data. And that's what's important to me.

Does GNUCash have the ability to keep track of GST sums and produce Business Activity Statements in the same way that Quicken Cash does ? I use an antique version of Quicken from about 1998 that was designed to run on Win98SE, but since it does EXACTLY what I want, I've never upgraded or altered it, and the Crossover Bottles allow me to save an installed software package of Quicken "ad infinitum". It's simple, easy and I've always found it to be excellent.

Just as a quick throwaway.......have you ever noticed how some of the earlier versions of software are so much simpler, easier to use........and faster ? It's not a hard and fast rule, but in my experience it often does happen that way.

While I'm not up on Aussie tax forms and requirements, this thread:

http://comments.gmane.org/gmane.comp.gnome.apps.gnucash.user...

seems to discuss the matter.

dotmatrix wrote:The default config is flat unencrypted text files which is a truly horrific way to store very sensitive financial data.

In regard to encrypting financial data, here is what I do: First, the gnucash files are not the only pieces of financial data that are sensitive, I also have scanned receipts, tax filings, balance sheet reports, emails with accountant, etc, etc. So I've created an encrypted directory using encfs in which all this is stored including all the gnucash files. That system has worked well for me for years and gives gnucash the encryption it needs as well as providing a safe storage for all the thousands of ancillary documents.

In a way this falls in line with the "unix philosophy" of making each program small and making each program do its job well. encfs is a fine encryption tool and gnucash is a fine double entry ledger system.

Maybe this tip will help someone.

hmmm, maybe I should contribute an LXer article describing how to set up "secure gnucash" if anyone is interested in the details.

Thanks jdixon, but although there is a discussion, the real "killer" is Quicken's ability to produce a quarterly report each three months with calculated totals coded in such a way that they can be matched to the Australian Taxation Offices's BAS quarterly report form.

All one has to do is take the figures at the coded points in the Quicken output and place them straight into the same coded points on the ATO report form. There's no calculations involved as far as I am concerned - it's all been done for me and I could not do my quarterly reporting without this piece of software. Unless GNUCash can do this as well, on a quarterly summary basis, then Quicken (even this old clunker of a program from the late 1990's) wins on this particular matter.

@penguinist:

>So I've created an encrypted directory using encfs in which all this is stored including all the gnucash files.

Yeah -- that sorta works. However, there are very useful database encryption functions which would be really nice to be able to just use out of the box.

For example:

1. Store an X509 cert or PGP on a smart card.

2. Encrypt column data with smart card public key.

3. Remove smart card... and not even 'root' can unencrypt.

In your encfs scenario, if your machine is compromised all your data are gone too.

Quoting:In your encfs scenario, if your machine is compromised all your data are gone too.

Actually, the way I have encfs set up root has no access to it, only the designated user. The data is protected by an encfs password and physical access to the machine does not give access to the data. No password = no access.

Just make sure you use a nice strong password and you should be good.

We are running a photography business. We have recruited an AIPB qualified bookkeeper for our accounting services. At first we thought about quickbooks. We need to have Manage and pay bills, Track inventory, full service payroll, Instant sales and profit reports in our bookkeeping output. For these services quickbooks charges more than $100 a month. As we are new in business and we've already spent a lot we want to spend less for software purpose. We are lucky our bookkeeper suggested us to try Zipbooks.

It has a double entry ledger system and a very good interface. The double entry system of bookkeeping is based on the fact that every transaction has two parts, which therefore affects two ledger accounts. Also, if you are need a climate controlled storage area in the Utah area (we use them to store lightboxes, etc) Neighbor is about half as much as brick and mortar locations. Definitely worth checking out.

edit: these prices are for the bookkeeping service, not for zipbooks itself

not exactly cheap either, starting at $100/month, going to $245, and at that level it still only supports one bank account? even as a freelancer i'd have at least 2-3 accounts. with gnucash i can have track many bank accounts as i want. and of course gnucash supports double entry too.

(this site is a strange place to complain about the cost of quickcash and then suggest a $100 service as cheaper alternative. the more i think about it the more i feel like that comment is just an ad.)

greetings, eMBee.

GnuCash is also a full double entry accounting system. We switched our businesses over to GnuCash a decade ago and have never looked back. It has handled all our needs but the big plus is that the data belongs to you and not the vendor (are you listening QuickBooks).

while we are on the subject, the only downside with gnucash last i checked was lack of multi user support. it seemed difficult to have two people in remote locations work with the same account, and we had to track expenses separately and then merge them somehow by sending gnucash datafiles to each other.

has that improved yet?

greetings, eMBee.

mbaerlxer: Yes GnuCash does support multiuser. By default it comes up in a single user configuration for simplicity, however you can configure GnuCash to ride on top of a mysql database. That configuration supports record locking and multiuser concurrent access.

The other side benefit of setting up a mysql backend is that you then have all your data in a format that can be queried with custom realtime sql queries. The possibilities of this level of open access and control are endless.

hmm, nice, but opening up direct network access to a database is not very healthy, but at least it's a start. maybe someone is working on a webinterface for it too...

greetings, eMBee.

eMBee: iptables is your friend.

that assumes a static ip.

a better solution is to use sshuttle with a network address that matches the server network, so that requests for the server network are tunneled through ssh.

greetings, eMBee.

Sounds to me like thomas_casey was hoping to use this thread to drive some Google App ads.

@gus3 - Guilty as charged! My only defense is that it is free and there are very few accounting software options that work well on Linux. Plus we are building it on Elixir so our nerd cred checks out.

April 18th is coming quick and your CPA will be so impressed if you have a nice tidy income statement for your business. :) Here's an income statement template for any tax and accounting DIYers out there. Basically you sign up and put all your transactions in or connect your bank account and then you go to reports and it will run the numbers on any transactions that have been confirmed.

ooops, i apologize for complaining about the price, turns out i was looking at the wrong page: https://zipbooks.com/bookkeeping-services/

greetings, eMBee.

> Guilty as charged!

Does LXer still use text based ads? I haven't seen one in quite a while, but then I run with an adblocker.

@mbaehrlxer You can have more than one bank account connected but our bookkeeper is only going to manually reconcile what's listed in the pricing. There's nothing to stop you from going into ZipBooks and doing the other accounts yourself. Most people have one main business checking account, for example.