KmyMoney - Cannot correct an entry in checking that is reconcilled and has an F in the reconcile column

Help
1

Discuss KDF,

I currently use Windows 11 and have used Quicken for years.

I am attempting to transition to KmyMoney.

I put all the entries for this year in a checking account.

Then I went back to the beginning January to start reconciling the account.

On the first month at the bottom of the account I had a balance difference of -3.07.

I checked my quicken account and my bank statement against the KmyMoney entries.

Everything balanced except for the -3.07 balance.
Finally I decided to finish reconcile to see if that would flush out the discrepancy.

It did not.
Finally I did a search with quicken for the 3.07 and found an entry with that amount.

On KmyMoney I found the entry as one of the last entries that I had made for the month of June, which had an “F” in the reconcile column. I am reconciling for January
I found out the “f” means “flag” - there is something wrong with it.

Since the entry is reconcilled I cannot change it, howver all the information looks right.

Nor can I delete and re-enter the transaction.

I have looked across the internet but can find nothing to resolve this issue.

I cannot figure out how un-reconcile and start the reconcile process over.

How can I correct this? Or do I have to just let it slide until I get to June’s reconciliation?

Will that in-balance show up at every month to month reconciliation?

Then will the June’s reconciliation even balance since that entry is already reconciled.

Look forward to hearing from you,

John

2

I know for sure that “F” means “Frozen” - and there is nothing wrong that you cannot change it anymore. At least not by using the UI.

Here’s how you can modify that. It’s a manual process directly on the file, but not that hard to follow. Steps 4 and 5 require to be run in a command terminal (CMD) and you need a copy of the 7z tool in your search path.

  1. Select the frozen transaction in the ledger and select Transaction/Show transaction details from the menu
  2. Remember the transaction ID (a T followed by an 18 digit number)
  3. Close KMyMoney
  4. Rename your file data.kmy (replace data with the actual filename) into data.kmy.gz
  5. Use 7z to uncompress that file with 7z e data.kmy.gz. That should leave a file called data.kmy
  6. Open data.kmy using an editor (not a word processor). NotePad++ is a good choice for that but the system editor (Notepad) will do as well.
  7. Search the transaction ID that you remembered in step 2. You should see a line that starts with <TRANSACTION id="T000..... Following that line you should see a line containing <SPLITS> followed by lines starting with <SPLIT.
  8. In these lines starting with <SPLIT look for reconcileFlag="3" and change that part to reconcileFlag="0" which removes the mark.
  9. Save the file
  10. Start KMyMoney and check that the Frozen mark is gone and you can edit the transaction again.

Note: You don’t need to compress the file before you open it. KMyMoney reads the uncompressed version and will store it compressed again once you save the file from within the application.

Hope that helps.

3

Thomas,
Thank you for your response.
I started following your directions through Step 3. Close Kmymoney.
Now for step 4 - I do not know where to find file “data.kmy”.
I looked in the KmyMoney files under the “Program Files” directory.
I tried to do a search for “data.kmy” but did not find it.
Can you help me on this step.

John

4

Do not look literally for “data.kmy.” You need to look for your actual data file. That name should appear in the title bar of the KMyMoney main window. Note #4 says "(replace data with the actual filename).

5

Jack,
Thank you for responding.
I seem to be a bit dense on this, KmyMoney is new to me, I am attempting to transition from Quicken.
Step 3 from Thomas said to close KmyMoney.
Now you seem to indicate that for step 4 I should reopen KmyMoney to find the “data.kmy”.
When I open KmyMoney up, in the top left corner, I have named this account “King-2026.kmy”
Is that what you are referring to?
Or is “data.kmy” found in a drop down menu?

Thank you.
John

6

Yes, that is what I am referring to. Simply replace my data with your King-2026.

7

Thomas,
Thanks!
When I click on the name “King-2026.KMyMoney”, at the top left corner of the program, the drop down menu has no way to change the name. So how do I change it?
I tried to look at Youtube to see if there is a video on how to do this. There was stuff on Quicken but not on this subject with KmyMoney.
John

8

John, this cannot be performed within KMyMoney. You will have to do that using Windows tools. When using File Explorer to modify the name, please make sure to show the file extensions (see screenshot, sorry Windows does not allow to switch languages)

image
image1059×153 23.9 KB

If you don’t set this option, you would not see the file extension .kmy which needs to be modified as outlined in step 4 above (btw, hiding the file extension is the worst feature ever on Windows). Hope that helps.