I have been using KmyMoney since version 0.9x and it is (was?) one of my favorites apps. But since a couple of years …
Currently I’m having troubles because the ledgers in KmyMoney, make impossible to compare / adjust bank accounts in KmyMoney with the real Bank account.
It depends on the version used, but in general balance values are not shown or, if they are, the book entries are not sort correctly (as put in ledger settings or/and in the ledger account sort options). Apparently this only regards accounts containing different reconcile state entries.
PICTURE 1 - entries well sorted but no balance values:
5.2.0 (openSUSE repository) - no balance values at all in bank accounts
5.2.2 (openSUSE repository) - no balance values at all in bank accounts
5.2.2-843e483 (stable Appimage)
5.2.70-e5313d9 (Master-5862 Appimage) - book entries sorted correctly but no way to get balance values
Switching between different versions of KMyMoney sometimes may have a negative impact on the settings. This can be the case here. To resolve this, some settings need to be cleared out and set afresh from within the application. Here’s the command sequence to do that. Before you run this exit all instances of KMyMoney.
# keep a copy, just in case
cp -p ~/.config/kmymoney/kmymoneyrc ~/.config/kmymoney/kmymoneyrc.bak
# now clear out the necessary entries
for i in InvestmentLedger KAccountsView KBudgetView KCategoriesView KInstitutionsView KInvestmentView_Equities KInvestmentView_Securities KOnlineJobOutboxView PayeeLedger SplitEditor StandardLedger; do \
echo $i; \
kwriteconfig6 --file ~/.config/kmymoney/kmymoneyrc --group $i --key ColumnsSelection --delete; \
kwriteconfig6 --file ~/.config/kmymoney/kmymoneyrc --group $i --key HeaderState --delete; \
done
At first I decided to not change versin at least while launching your workaround and obviously I closed all KmyMoney instances.
At second I tried the the workaround as single lines in a terminal:
~> for i in …
~> kwriteconfig6 … --key ColumnSelect …
~> kwriteconfig6 … – key HeaderState …
It did not helps, but because I was surprised, the terminal did not give out any feedback after put the single line nor at the and after done, I wrote an executable sh-file with your commands.
Unfortunately it does not help too.
Before I used the workaround I worked a lot with KmyMoney and I noticed the sort sequence in ledger does not consider the Reconcilie State.
Another question correlated to this issue - a terminology question:
Is the Post Date the date when the book entry has been put in or the receipt date (better the booking date used by the bank = value date = valuta)?
You might try to remove the whole kmymoneyrc file which will definitely clear out everything.
The postdate should reflect the date the bank is using. Then entrydate (usually not visible) is the date the transaction was entered into KMyMoney.
Here’s an example where the transaction was executed by the bank on June 8th but I downloaded and entered the transaction on June 9th. The other ones are on the same date as I usually do the download every day.
Thanks for the Data definition explanation. BTW: at least in the bersion 5.2.2-843e483 (stable Appimage) the entrydate is visible per default. I did it hide and after the workaround it became visible.
I will try to restart KmyMoney after deleting `kmymoneyrc’.
Should I try the work around again after that before starting KmyMoney?
I only asked for precaution. So I tried it already yesterday, but no improvement, the entries sort ignors the both the general ordering setting and the account one. You only get the right sort after an entry change, but in this case you don’t see the balance values.
I presume it is an issue in the stable version. Can you test it?
At the Moment I’m downloading KDE Neon. On it (live or installed version) I’d like to test, if there are the same issue I’ve experencied on openSUSE Leap 16.0.
I have tested the version 5.2.2-0neon24.04+noble+release+build29 on fresh installed KDE neon n(6.7.0): no difference noticed.
Strange, because I thought KDE offers tested apps over Discovery …
I don’t think, it make sense at this time testing the AppImage versions.
Another understanding question: Which kind of fields contains the coloumn “No.”?
Is it formatted to give in only number or alphanumeric character (as in the more ther 3 years older KmyMoney versions)? Could be this the reason for confused oder in sorting by No.?
Much probable, thi is the cause.
It was so designed on purpose?
Anyway I think thi is not always right.
At first I set the Reconcile state in oder to get the reconciated entry on the top.
At second the Number. For this I use not the recipt no. but a number referred to the bank: year-bank statement no.-statement-line-no.
At third the booking date.
I do it so, because the booking order in bank statement does not always conform to the date order. Further there are often entries correponding to payments (mostly made with credit card in foreign countries), which come to the bank much later the the other.
Similar it happens with debits in favour collection office. I know the amount and the reason (-> booking category) but I can only estimate the date of its direct debit. But also the same monthly payments for phones, internet connection and others direct debits.
It can suddendly happen theyr direct debits are booked by the bank in the next month as expected …
Anyway my sort priority order did run well up to and inckuding KmyMoney 5.1
It is the first time I’m experiencing sorting problems with KMyMoney …
Obviously there is a workaround: changing the booking date of entries, in order they respect the KMyMoney entry order. It that the right way? I don’t think so.
