This forum has been archived. All content is frozen. Please use KDE Discuss instead.

KMyMoney complains about difference when reconciling

Tags: None
(comma "," separated)
danjo
Registered Member
Posts
3
Karma
0
Hello,

I am new to this forum so please bear with me if this is not the correct way to ask for community support.

I am running KMyMoney v5.0.3 on a Gentoo Linux box (running KDE/Plasma).

I have been using KMyMoney for some years and have never had any problem like this
My problem is that when I Reconcile one of my accounts (yes, this only happens for one account) and I finish the reconciliation I get a warning that there are a difference - which there are not (In the lower right corner it says "Difference: 0.00"

What can I do to troubleshoot this (and correct it)?

Regards,
D/\N
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
No problem. It's one way of asking questions and getting help.
Which type of account does this happen with? Does it contain transactions referencing an investment account?


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
mcarpino
Registered Member
Posts
81
Karma
0
OS
You have the assistance of the best person you need to help solve your problem with wizard
danjo
Registered Member
Posts
3
Karma
0
This is happening to a Checking account with no "Investment-transactions".

D/\N
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
Well, then we can skip a rounding problem caused by investments. Here are a few steps to analyze this further. They all happen on the command line and might look strange to you in case you're not that familiar with *NIX tools. The tools should be available on standard desktop environments. <kmm-file> means the relative or full path of your data file ending in .kmy. <account-name> is any part of the name of the account you try to reconcile that distinguishes it from others. In case anything is unclear or get errors feel free to provide details and ask. Note: the commands are written in italics

Figure out the internal ID of the account you look for. We look for the id="A....." of the account in question.
Code: Select all
zgrep ACCOUNT <kmm-file> | grep '<account-name>'
This should provide at least one line with the following layout (the contents of course should differ):

<ACCOUNT currency="EUR" name="....<account-name>...." parentaccount="AStd::Asset" lastreconciled="2017-09-06" lastmodified="2019-03-01" opened="2016-01-01" type="1" institution="I000001" description="" id="A000003" number="">

The important part is the id which is A000003 here. You need in the next command. <acc-id> is the placeholder for it. The other entries might differ on your end, that does not matter.
Code: Select all
zgrep SPLIT <kmm-file> | grep '<acc-id>' | grep -E 'shares="[0-9]+/[0-9]{3}'
Note: the character to the right of the equal sign is a double-quote not two singles.

This will possibly provide a list of splits that have a denominator of /100 in their shares field. Here's an example

<SPLIT value="1859/100" account="A000003" reconciledate="2016-03-02" shares="1859/100" reconcileflag="2" payee="P000069" action="" bankid="A000001-2016-02-15-97c24d0-1" price="1/1" id="S0001" memo="some memo text" number=""/>

To check if any rounding causes your problem, we run the last command with a little addition again:
Code: Select all
zgrep SPLIT <kmm-file> | grep '<acc-id>' | grep -E 'shares="[0-9]+/[0-9]{3}' | grep -v /100
This should produce no output anymore. In case it does produce output, I am interested in the contents of the shares field. Just to be on the safe side in case the output is empty, repeat the above with the value field:
Code: Select all
zgrep SPLIT <kmm-file> | grep '<acc-id>' | grep -E 'value="[0-9]+/[0-9]{3}' | grep -v /100
This should also produce no output. In case it does, please report.

Looking forward to the results.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
danjo
Registered Member
Posts
3
Karma
0
Thanks for your feedback and time.

I have absolutely no problem with CLI (I normally prefer CLI over GUI).

The zgrep .... | grep -E 'shares/values=.... each produced three lines (same three lines), but all three lines only had '/100' and no other "strange" "/###".

D/\N
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
So we can definitely exclude a rounding problem. This was the only thing I could think of so far. Have to check. Right now I run out of ideas what could cause this.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Google [Bot], q.ignora, watchstar