A few years ago I posted a similar topic on the old forums, see Spreadsheet replacement for budget ? • KDE Community Forums
Basically I use an OpenOffice spreadsheet (with numerous sheets within) for budgetting purposes. I asked if KMM can do that type of processing. “ipwizard” replied …
KMyMoney budgeting feature will probably not help here as the detail is not as fine grained as you want it. I would go and create scheduled transaction for all those income and expense transactions. Then you simply increase the preview period in the ledger (see KMyMoney manual for the exact description) and should see the information you want at a glance.
and “aperali” replied …
Or you could use crystal reports with a connection to your kmm mysql db
So, as this actually 5 years ago, and as I have still use/need of the spreadsheet as a secondary means of obtaining budgeting, cash flows, etc, are there now any easier methods , so that I can replace the OOffice spreadsheet ?
I’m very familiar with db connections, code, various programming, so can do that. As I use KMM daily and want to ensure data is not corrupted in any form by any sort of add-on’s, what is the best approach, with that in mind ?
- Develop a KMM plugin ?
- Export the KMM data via a ‘save as’ to XML/SQL, then code to produce reports ?
- Investigate the use of Crystal reports ?
- Add all the extra scheduled trans and see if that fits ?
- Other ??