Personal accounting app

fabi1 · June 1, 2018, 9:16pm

could you please precise what you mean?

lachmanfrantisek · June 1, 2018, 9:17pm

e.g. photo of the receipt

Schmu · June 4, 2018, 7:59am

An accounting app sounds interesting. While I’m not sure what this app would be capable of in detail, I can’t tell if I will definitely use it, but I’m interested so far! So looking forwarding to seeing the first version

powerpaul · June 6, 2018, 9:37am

I started a similar project a while ago but unfortunately because of lack of time I never got to finish it. You might want to check it out at:

blizzz · June 6, 2018, 2:14pm

I had the same intention last year and started a little (really little) bit last year, but didn’t touch it for more than half a year unfortunately. No time sadly. I found https://github.com/mschindler83/fints-hbci-php/ as HBCI lib.

Krischan · July 18, 2018, 9:22pm

If anyone is considering implementing something like this, PLEASE consider making it a complementary web-version to Money Manager EX: https://www.moneymanagerex.org/
MMEX is fully open-source, cross-platform, has a great android client and already syncing with dropbox etc.

But it really lacks a web-interface and nicer sync.
A while ago they experimented with something, but it was abandoned again:

So that could be a start as reference.

gladed · August 6, 2019, 6:57pm

@Krischan what would it mean to interoperate with MMEX? Support import/export?

Also curious if anyone made further progress on this concept yet.

powerpaul · August 7, 2019, 1:34pm

I checked it out when @Krischan pointed it out, but in my opinion it has a horrible 90’s user interface and is not really compatible with what I want to create.

Unfortunately I am stuck with work and in the process of rewriting everything to Vue.js (as that’s what nextcloud is using right now and they have a lot of components ready)

Tobiko · April 19, 2020, 9:35am

Hello everybody
Has the financial tool already made progress?
I am a quaestor at a scout division and would be very interested in such a solution. I would have the following needs:

Upload receipts by mobile phone
Double-entry bookkeeping with the option to save receipts behind the bookings
budget
Group-dependent read access to accounts with the stored budget
Multi-tenancy

nice to have:

Project accounting (for scout camps or other occasions, simple accounting for billing so that it can be easily integrated into the overall accounting)
Automated invoicing (for membership fees)
Create DME files for outgoing payments
Automatic posting of incoming payments

Michael_Plotegher · March 10, 2021, 11:35pm

Any development?

ryanb · April 24, 2021, 10:39pm

I’m working on an app that integrates a personal accounting tool called HLedger into Nextcloud. If you’re still looking for something and you find it interesting, let me know.

powerpaul · September 14, 2022, 9:31am

Hey, in case anyone is still interested, I finally managed to publish the app in the Nextcloud app store. It’s still not finished but it should work basically and I’ll keep working on it…

Cookies · September 17, 2022, 11:02pm

Wow @powerpaul great idea!

Thank you for publishing your work for the community!

I am a single person NC user and this addon works perfect for me. Cospend is great, but i was looking for a personal basic income/expense & Balance sheet. Boom… NC Money!

I wanted to share the error log that my NC is showing for NC Money:
-ubuntu 20.04
-nginx
-php8.1
-redis
-postgreSQL

Thank you for developing NC Money! Great icon as well!

error might be my PostgreSQL?

[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR:  function round(double precision, integer) does not exist
LINE 1: SELECT a.*, ROUND(SUM(b.value), 2) AS balance FROM oc_money_...
                    ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. at <<closure>>

 0. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1780
    Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
 1. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1719
    Doctrine\DBAL\Connection->handleDriverException()
 2. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Statement.php line 193
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /usr/share/nginx/nextcloud/lib/private/DB/PreparedStatement.php line 87
    Doctrine\DBAL\Statement->execute()
 4. /usr/share/nginx/nextcloud/apps/money/lib/Controller/AccountController.php line 33
    OC\DB\PreparedStatement->execute()
 5. /usr/share/nginx/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 225
    OCA\Money\Controller\AccountController->getAccounts()
 6. /usr/share/nginx/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 133
    OC\AppFramework\Http\Dispatcher->executeController()
 7. /usr/share/nginx/nextcloud/lib/private/AppFramework/App.php line 172
    OC\AppFramework\Http\Dispatcher->dispatch()
 8. /usr/share/nginx/nextcloud/lib/private/Route/Router.php line 298
    OC\AppFramework\App::main()
 9. /usr/share/nginx/nextcloud/lib/base.php line 1030
    OC\Route\Router->match()
10. /usr/share/nginx/nextcloud/index.php line 36
    OC::handleRequest()

GET /apps/money/accounts
from myip by username at 2022-09-17T22:38:22+00:00

powerpaul · September 18, 2022, 11:40am

Hello. Thanks for the kind words.

I published an update yesterday, maybe the error is fixed already. Otherwise it should have to be related to PostgreSQL as I use only Mysql and therefore only test with it.

Also note that the app is still not finished and code integrity check is also broken (in case you’re wondering)…

Cookies · September 19, 2022, 9:14pm

Hi @powerpaul

I updated but still not working on PostgreSQL. I totally understand that your addon is alpha/Beta but I still think it is a great addon!
Thank you again for sharing your addon with the NC community . Maybe a PostgreSQL NC user (smarter than me) will be able send you a pull request for code to include for PostgreSQL to work I think your addon idea is amazing and I am sure a lot of NC users will benefit from your work!

Bravo

Thank you!

log

[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR:  function round(double precision, integer) does not exist
LINE 1: SELECT a.*, COALESCE(ROUND(SUM(b.value), 2), 0) AS balance F...
                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. at <<closure>>

 0. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1780
    Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
 1. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1719
    Doctrine\DBAL\Connection->handleDriverException()
 2. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Statement.php line 193
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /usr/share/nginx/nextcloud/lib/private/DB/PreparedStatement.php line 87
    Doctrine\DBAL\Statement->execute()
 4. /usr/share/nginx/nextcloud/apps/money/lib/Controller/AccountController.php line 57
    OC\DB\PreparedStatement->execute()
 5. /usr/share/nginx/nextcloud/apps/money/lib/Controller/AccountController.php line 85
    OCA\Money\Controller\AccountController->getAccount()
 6. /usr/share/nginx/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 225
    OCA\Money\Controller\AccountController->addAccount()
 7. /usr/share/nginx/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 133
    OC\AppFramework\Http\Dispatcher->executeController()
 8. /usr/share/nginx/nextcloud/lib/private/AppFramework/App.php line 172
    OC\AppFramework\Http\Dispatcher->dispatch()
 9. /usr/share/nginx/nextcloud/lib/private/Route/Router.php line 298
    OC\AppFramework\App::main()
10. /usr/share/nginx/nextcloud/lib/base.php line 1030
    OC\Route\Router->match()
11. /usr/share/nginx/nextcloud/index.php line 36
    OC::handleRequest()

POST /apps/money/accounts
from myip by myuser at 2022-09-19T20:38:29+00:00

powerpaul · September 20, 2022, 10:16am

I looked around and potentially fixed the error. I’ll have to look into testing the backend with various databases but it will take some time. I’ll also prepare a new patch release soon… hope your problem will be fixed then and you can continue to check out the app…

Cookies · September 20, 2022, 11:16pm

Hi @powerpaul

Thank you so much!!! Very Cool!!!

I can keep testing for you , sorry I wish I could help with the code side as well.

NC_Money 0.4.2 log

Nginx
PHP8.1
PostgreSQL
Redis
NC_Money 0.4.2

[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR:  function round(double precision, integer) does not exist
LINE 1: SELECT a.*, COALESCE(ROUND(SUM(b.value), 2), 0) AS balance F...
                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. at <<closure>>

 0. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1780
    Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
 1. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1719
    Doctrine\DBAL\Connection->handleDriverException()
 2. /usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/src/Statement.php line 193
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /usr/share/nginx/nextcloud/lib/private/DB/PreparedStatement.php line 87
    Doctrine\DBAL\Statement->execute()
 4. /usr/share/nginx/nextcloud/apps/money/lib/Controller/AccountController.php line 57
    OC\DB\PreparedStatement->execute()
 5. /usr/share/nginx/nextcloud/apps/money/lib/Controller/AccountController.php line 85
    OCA\Money\Controller\AccountController->getAccount()
 6. /usr/share/nginx/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 225
    OCA\Money\Controller\AccountController->addAccount()
 7. /usr/share/nginx/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 133
    OC\AppFramework\Http\Dispatcher->executeController()
 8. /usr/share/nginx/nextcloud/lib/private/AppFramework/App.php line 172
    OC\AppFramework\Http\Dispatcher->dispatch()
 9. /usr/share/nginx/nextcloud/lib/private/Route/Router.php line 298
    OC\AppFramework\App::main()
10. /usr/share/nginx/nextcloud/lib/base.php line 1030
    OC\Route\Router->match()
11. /usr/share/nginx/nextcloud/index.php line 36
    OC::handleRequest()

POST /apps/money/accounts
from myip by myuser at 2022-09-20T22:42:09+00:00

powerpaul · September 21, 2022, 7:37am

Hey, it seems your server is still using a cached version of the account controller. I removed all of the “ROUND” statements in 0.4.2…

Cookies · September 21, 2022, 9:10pm

NC Money

Hi @powerpaul

You are 100% correct, NC Money 0.4.2 update corrected the issue for postgresql. i restarted php8.1-fpm and NC Money started to work 100%. It is great to see the addon in action! This is a must have app! Thank you so much for the update

i was wondering about a noob question, why does the github code not update but the release version does?

I really appreciate all your work. Big thanks from the NC community

No log, working 100%

I wonder if you qualify for the NC supercon trip in October? I think the deadline was August but i haven’t seen any new news or the 5 apps they selected from NC 2022 Contest

powerpaul · September 22, 2022, 7:51am

You are 100% correct, NC Money 0.4.2 update corrected the issue for postgresql. i restarted php8.1-fpm and NC Money started to work 100%. It is great to see the addon in action! This is a must have app! Thank you so much for the update

I don’t exactly know if this is an error on my side but you might want to check your php cache settings, I think Nextcloud recommends 2 minutes or so…

i was wondering about a noob question, why does the github code not update but the release version does?

I currently develop on the complete_rework branch so if you look into github you have to change the branch there. I plan to merge it to master soon though.

I wonder if you qualify for the NC supercon trip in October? I think the deadline was August but i haven’t seen any new news or the 5 apps they selected from NC 2022 Contest

I already got invited but unfortunately I cannot attend. But it is a great honor for me…