Suggestions for multi-user / multi-device finance manager software?

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

Suggestions for multi-user / multi-device finance manager software?

Christian Stimming-4
Dear all,

here's a somewhat heretical question from me as a long-term gnucash  
user and developer: Gnucash no longer fulfils my requirements as a  
personal finance manager, and I was wondering whether anyone here has  
other suggestions I should try.

Here are my requirements: (1) I want to track my daily cash expenses  
of my spouse and me, using our mobile devices (two Android phones).  
(2) Additionally I want to keep track of our bank account by using the  
transaction download function of the German online banking protocol  
HBCI, so that every few days I can check the bank account balance and  
transactions. I used to do this on my desktop PC, but it doesn't  
really matter whether I do this on the desktop PC or on some mobile  
device. (3) Additionally every few weeks I want to check the cash  
flow, balances, and expense statement in detail to have an overview of  
where the money goes.

Unfortunately gnucash doesn't fit for tracking expenses on multiple  
mobile devices, let alone for checking the current balances from  
multiple devices. The gnucash data model is great, but our  
implementation of the "engine" code everywhere assumes that all data  
is held in the current device's memory. This is an obstacle against  
implementing a multi-user or multi-device editing possibility of the  
data. I tried our SQL database backend, so that the SQL database could  
be accessed remotely from multiple places. Alas, on start-up of  
gnucash, all data from the SQL database needs to be read into memory,  
effectively making it impossible to run gnucash from anywhere else  
except localhost of the SQL database host (otherwise it takes simply  
forever). My conclusion here is that unfortunately the existing  
implementation of gnucash's data access layer makes it impossible to  
run a multi-device / multi-user service on top of the data. Hence I  
will have to switch to some different software implementation.

I tried gnucash-on-android for quite some time, using this App as  
data-entering app and importing the data into desktop gnucash  
regularly. However, this extra step of importing a file into gnucash  
sucks. Theoretically, this might work if at least the  
gnucash-on-android app has the identical account frame so that the  
entered transactions can be imported without any extra double-checking  
on the gnucash side. But to my knowledge this is not implemented and I  
will always have to run the import-dialog on the gnucash side to  
ensure the correct other accounts are chosen, but this dialog sucks.

To summarize, my requirement #1 cannot be met by gnucash, even though  
the requirement #2 and #3 are still great in gnucash. What I would  
need for the multi-user / multi-device expense tracking is some sort  
of cloud service with access from multiple locations. I'm also willing  
to pay for this, but would also be interested to invest some work into  
Open Source solutions. Maybe there is some Open Source software for  
this, and the actual data hosting service is sold for some reasonable  
subscription fee. Ideas, anyone? Thanks a lot in advance.

Regards, Christian


_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: Suggestions for multi-user / multi-device finance manager software?

Ngewi Fet
On Wed, Aug 10, 2016 at 2:20 PM, Christian Stimming <[hidden email]>
wrote:

> Dear all,
>
> I tried gnucash-on-android for quite some time, using this App as
> data-entering app and importing the data into desktop gnucash regularly.
> However, this extra step of importing a file into gnucash sucks.
> Theoretically, this might work if at least the gnucash-on-android app has
> the identical account frame so that the entered transactions can be
> imported without any extra double-checking on the gnucash side. But to my
> knowledge this is not implemented and I will always have to run the
> import-dialog on the gnucash side to ensure the correct other accounts are
> chosen, but this dialog sucks.
>

It is not as seamless as you require, but I just wanted to point that if
you import your desktop account structure into the app first, your app
exports should import seamlessly into GnuCash desktop.

The points you raise about multi device usage are valid ones, ones which
are working towards solving, albeit slowly. I hope you find something that
meets your needs in the meantime.

Regards,
Ngewi
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel