Bug 330325 - Previous reconciled amount is wrong when balancing account
Summary: Previous reconciled amount is wrong when balancing account
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.6.3
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-23 14:05 UTC by tnemeth
Modified: 2014-08-01 06:24 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
attachment-18463-0.html (3.10 KB, text/html)
2014-07-31 19:45 UTC, Dick
Details

Note You need to log in before you can comment on or make changes to this bug.
Description tnemeth 2014-01-23 14:05:52 UTC
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
Comment 1 allan 2014-01-23 14:22:43 UTC
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
Comment 2 tnemeth 2014-01-23 17:52:31 UTC
> 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.
Comment 3 Jack 2014-01-23 18:11:42 UTC
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.
Comment 4 tnemeth 2014-01-23 19:09:44 UTC
> 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.
Comment 5 Cristian Oneț 2014-07-31 14:41:45 UTC
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.
Comment 6 Dick 2014-07-31 19:45:24 UTC
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.
Comment 7 Cristian Oneț 2014-08-01 06:24:13 UTC
Thanks for the feedback.