Hi. Last time I reconciled my account, I had everything ok. However, some days later, while checking some information, I figured out that I had made a mistake for an operation. A withdrawal had been entered as a transfert (or the other way, I don't remember exactly). As the operation was reconciled, it was impossible to change its type. So, to make it right, I deleted the operation, and created another one with the right attributes... And marked it as reconciled. Now I just received my last account information sheet, I marked as cleared everything that was in and tried to reconciliate my account. That's where things went wrong : the balance from the last reconciliation was wrong by the amount of the removed/added operation (60€ more than what it should be). (by the way : how should I make the amount right, now ?) Reproducible: Didn't try
On 23/01/14 14:05, tnemeth@free.fr wrote: > https://bugs.kde.org/show_bug.cgi?id=330325 > > Bug ID: 330325 > Summary: Previous reconciled amount is wrong when balancing > account > Classification: Unclassified > Product: kmymoney4 > Version: 4.6.3 > Platform: Ubuntu Packages > OS: Linux > Status: UNCONFIRMED > Severity: normal > Priority: NOR > Component: general > Assignee: kmymoney-devel@kde.org > Reporter: tnemeth@free.fr > > Hi. > > Last time I reconciled my account, I had everything ok. However, some days > later, while checking some information, I figured out that I had made a mistake > for an operation. A withdrawal had been entered as a transfert (or the other > way, I don't remember exactly). > > As the operation was reconciled, it was impossible to change its type. So, to > make it right, I deleted the operation, and created another one with the right > attributes... And marked it as reconciled. > > Now I just received my last account information sheet, I marked as cleared > everything that was in and tried to reconciliate my account. That's where > things went wrong : the balance from the last reconciliation was wrong by the > amount of the removed/added operation (60€ more than what it should be). > > (by the way : how should I make the amount right, now ?) > > > Reproducible: Didn't try > I'm not sure about this, but I think that reconciliation looks to reconcile only unreconciled transactions. If you've marked this item as reconciled, I think it may not be taken into account. Try changing it to Cleared. Allan
> I'm not sure about this, but I think that reconciliation looks to > reconcile only unreconciled transactions. I hope so :) > If you've marked this item as reconciled, I think it may not be taken > into account. I don't want it taken into account. Well... I don't want it taken into account for the current reconciliation, but for the last one. Not only that, but I think that the operation I deleted should have been removed from the amount of the previous reconciliation and the added operation should have been added to it. Here is what I think should have happened : - Clearance of operations #1 - Reconciliation #1 - oops error -> deleted 1 operation (should substract its amount from the reconciliation amount) -> added 1 operation + marked it reconciled (should add its amount to the reconciliation amount) -> reconciliation balance should be right here... - Clearance of operations #2 - Reconciliation #2 (should show the "newly" computed reconciliation amount). However here is what I think happened : - Clearance of operations #1 - Reconciliation #1 - oops error -> deleted 1 operation (did not substract its amount from the reconciliation amount) -> added 1 operation + marked it reconciled (added its amount to the reconciliation amount) -> reconciliation balance is wrong by the amount of the added operation - Clearance of operations #2 - Reconciliation #2 -> here I cannot correct the amount of the last reconciliation and the total is wrong :( > Try changing it to Cleared. The thing is... I don't remember which one. There are _a lot_ of transactions on this account :( I tried to look at the XML file but it's a bit complicated to read :) However I found pit that the account section indicates the right amount for the reconciliation. So there should be another computation that makes it wrong in the reconciliation window... Thomas.
I think you don't understand what KMM actually does for reconciliation. Most important, it does not "lock" anything. If you alter (edit or delete) a transaction already marked as reconciled, then balances will be wrong unless you fix them yourself. KMM does not adjust the reconciled balance when you change a reconciled transaction. In fact, I am not sure that it actually stored the reconciled balance - only the date of the last reconciliation. In addition, the "previous balance" shown on the reconciliation window is mainly for convenience - it is not really used in the process. To do the current reconciliation, you just need to be sure any transactions that are on the current or any previous statement are marked either as reconciled or cleared. For now, I would start by making sure that all transactions on your current statement are entered and marked as cleared, and that any more recent transactions are not marked. At that point, you can start the reconciliation process. If the final balance shown on the reconciliation dialog is not correct, the amount by which it differs should lead you to the missing or incorrectly marked transaction. To go back to the original issue - I think you could have just changed the transaction from reconciled to cleared, then change the type of transaction, then return it to reconciled. If the amount of the transaction did not change, then all the balances would have stayed unchanged.
> I think you don't understand what KMM actually does for > reconciliation. Most important, it does not "lock" anything. At least the last reconciliation amount... > If you alter (edit or delete) a > transaction already marked as reconciled, then balances will be wrong > unless you fix them yourself. How can one do that ? > KMM does not adjust the reconciled balance when you > change a reconciled transaction. In fact, I am not sure that it > actually stored the reconciled balance - only the date of the last > reconciliation. Yes it does. It's in the XML section of the account. > In addition, the "previous balance" shown on the reconciliation > window is mainly for convenience - it is not really used in the process. > To do the current reconciliation, you just need to be sure any transactions > that are on the current or any previous statement are marked either as > reconciled or cleared. That's a sure thing : triple-checked what's cleared on the current statement => the total of what should be marked as reconciled is right however as the previous reconcilation amount is wrong, the current reconciliation amount is wrong by the same number. If I tell KMM what the amount at the end of the current statement is really, KMM tells me that I cleared 60€ more than what should be cleared... > For now, I would start by making sure that all transactions on your current > statement are entered and marked as cleared, and that any more recent > transactions are not marked. At that point, you can start the reconciliation > process. If the final balance shown on the reconciliation dialog is not > correct, the amount by which it differs should lead you to the missing or > incorrectly marked transaction. The error has been introduced during the modification of the previous reconciliation and there is no way to fix it... > To go back to the original issue - I think you could have just > changed the transaction from reconciled to cleared, then change the type of > transaction, then return it to reconciled. If the amount of the transaction did > not change, then all the balances would have stayed unchanged. Good to know for the next time... Thanks. Thomas.
As suggested mark as 'Cleared' the transaction that you added afterwards as 'Reconciled' if you don't know which one is that use the transaction state filter in the ledger of the 'Find transaction' dialog to find it. That should fix the offset in your cleared balance. Please report back if this solved your problem.
Created attachment 88067 [details] attachment-18463-0.html Actually, the problem has been resolved without my understanding how it happened. My son downloaded and installed a new version of Linux; conceivably that played some part. I had made up my mind to reconcile the account with a make-believe bank statement that would be for a two day period and would include whatever fictitious deposit or withdrawal was necessary to reach the actual start-of-month balance. Then I would reconcile again to the end of the month. Much to my surprise, I discovered when I was preparing to enter the end-of-"month" value, that there was no discrepancy! I was able to reconcile the month against the actual bank statement without any error or difficulty. I've had no problem since. Thanks for your response; I'll save it in case of a future problem. *Dick Oakland* 200 W Packard Street Apt 122 Appleton WI 54911-6701 On Thu, Jul 31, 2014 at 9:41 AM, Cristian Oneț <onet.cristian@gmail.com> wrote: > https://bugs.kde.org/show_bug.cgi?id=330325 > > Cristian Oneț <onet.cristian@gmail.com> changed: > > What |Removed |Added > > ---------------------------------------------------------------------------- > CC| |onet.cristian@gmail.com > Status|UNCONFIRMED |NEEDSINFO > Resolution|--- |WAITINGFORINFO > > --- Comment #5 from Cristian Oneț <onet.cristian@gmail.com> --- > As suggested mark as 'Cleared' the transaction that you added afterwards as > 'Reconciled' if you don't know which one is that use the transaction state > filter in the ledger of the 'Find transaction' dialog to find it. That > should > fix the offset in your cleared balance. Please report back if this solved > your > problem. > > -- > You are receiving this mail because: > You are on the CC list for the bug.
Thanks for the feedback.