Balance is not calculating properly -- else I just don't understand how KMM does it...

[samalex]

Hi,

I've pulled transactions from 8/30 through today into my checking account through KMM 1.0.1 but the balances are way off.  I then setup a test account and entered some dummy info and it's doing the same thing there.  Below is what is in the register of the test account (don't want to post actual transactions [grin]):
Trans Date Payment Deposit Balance
10/01/09 - 100 100
09/01/09 - 44.65 144.65
08/31/09 - 12.32 156.97
08/31/09 - 11.12 168.09
08/31/09 22.23 - 145.86
08/31/09 123 - 22.86
08/30/09 - 123 145.86
08/30/09 63 - 82.86
08/01/09 - 1000 1082.86

The 1000 on 8/1/2009 is the opening balance and all transactions are cleared.  Can someone explain to me how the balance works?  Because below is how it looks like it should be presented to me:
Trans Date Payment Deposit Balance
10/01/09 - 100 1082.86
09/01/09 - 44.65 982.86
08/31/09 - 12.32 938.21
08/31/09 - 11.12 925.89
08/31/09 22.23 - 914.77
08/31/09 123 - 937
08/30/09 - 123 1060
08/30/09 63 - 937
08/01/09 - 1000 1000

Thanks for any insight...  Is this a bug?  Do I have something marked incorrectly?  Or am I just reading it wrong?  If I have the opening balance set at $1000 then why does it have $1082.86 in the balance at that point?

Thanks for any insight or suggestions, and take care -

Sam Alex

EDIT: I edited the columned data to add dashes to the fields with no data since it looks like the form strips out white space.  Hopefully this looks correct.  Thanks and sorry for any duplicate email.

[Thomas Baumgart]

Hi,

on Saturday 03 October 2009 samalex wrote:

> Hi,
>
> I've pulled transactions from 8/30 through today into my checking account
> through KMM 1.0.1 but the balances are way off.  I then setup a test
>  account and entered some dummy info and it's doing the same thing there.
>  Below is what is in the register of the test account (don't want to post
>  actual transactions [grin]):
> Trans Date Payment Deposit Balance
> 10/01/09 - 100 100
> 09/01/09 - 44.65 144.65
> 08/31/09 - 12.32 156.97
> 08/31/09 - 11.12 168.09
> 08/31/09 22.23 - 145.86
> 08/31/09 123 - 22.86
> 08/30/09 - 123 145.86
> 08/30/09 63 - 82.86
> 08/01/09 - 1000 1082.86
>
> The 1000 on 8/1/2009 is the opening balance and all transactions are
> cleared.  Can someone explain to me how the balance works?  Because below
>  is how it looks like it should be presented to me:
> Trans Date Payment Deposit Balance
> 10/01/09 - 100 1082.86
> 09/01/09 - 44.65 982.86
> 08/31/09 - 12.32 938.21
> 08/31/09 - 11.12 925.89
> 08/31/09 22.23 - 914.77
> 08/31/09 123 - 937
> 08/30/09 - 123 1060
> 08/30/09 63 - 937
> 08/01/09 - 1000 1000
>
> Thanks for any insight...  Is this a bug?  Do I have something marked
> incorrectly?  Or am I just reading it wrong?  If I have the opening balance
> set at $1000 then why does it have $1082.86 in the balance at that point?

It took me a moment to figure out what the problem is. You're sorting the
transactions in descending date order. That's interesting (I have never seen
someone doing it that way) because KMyMoney's balance display algorithm cannot
(currently) cope with that. The balance column *always* starts with 0 at the
top and shows the most recent balance at the bottom, and since this column is
calculated you can see different results depending on the sort order.

> Thanks for any insight or suggestions, and take care -

The above was the insight part. The suggestion is to reverse date sorting
order.

> EDIT: I edited the columned data to add dashes to the fields with no data
> since it looks like the form strips out white space.  Hopefully this looks
> correct.  Thanks and sorry for any duplicate email.

p.s. Using a fixed space font for such tables (e.g. Courier) would make it
even more readable.


--


Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
We had joy, we had fun, we had Linux on our Sun -- anonymous source
-------------------------------------------------------------


------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[samalex]

Thomas Baumgart wrote:

Hi,

on Saturday 03 October 2009 samalex wrote:


> Hi,
>
> I've pulled transactions from 8/30 through today into my checking account
> through KMM 1.0.1 but the balances are way off.  I then setup a test
>  account and entered some dummy info and it's doing the same thing there.
>  Below is what is in the register of the test account (don't want to post
>  actual transactions [grin]):
> Trans Date Payment Deposit Balance
> 10/01/09 - 100 100
> 09/01/09 - 44.65 144.65
> 08/31/09 - 12.32 156.97
> 08/31/09 - 11.12 168.09
> 08/31/09 22.23 - 145.86
> 08/31/09 123 - 22.86
> 08/30/09 - 123 145.86
> 08/30/09 63 - 82.86
> 08/01/09 - 1000 1082.86
>
> The 1000 on 8/1/2009 is the opening balance and all transactions are
> cleared.  Can someone explain to me how the balance works?  Because below
>  is how it looks like it should be presented to me:
> Trans Date Payment Deposit Balance
> 10/01/09 - 100 1082.86
> 09/01/09 - 44.65 982.86
> 08/31/09 - 12.32 938.21
> 08/31/09 - 11.12 925.89
> 08/31/09 22.23 - 914.77
> 08/31/09 123 - 937
> 08/30/09 - 123 1060
> 08/30/09 63 - 937
> 08/01/09 - 1000 1000
>
> Thanks for any insight...  Is this a bug?  Do I have something marked
> incorrectly?  Or am I just reading it wrong?  If I have the opening balance
> set at $1000 then why does it have $1082.86 in the balance at that point?

It took me a moment to figure out what the problem is. You're sorting the
transactions in descending date order. That's interesting (I have never seen
someone doing it that way) because KMyMoney's balance display algorithm cannot
(currently) cope with that. The balance column *always* starts with 0 at the
top and shows the most recent balance at the bottom, and since this column is
calculated you can see different results depending on the sort order.

> Thanks for any insight or suggestions, and take care -

The above was the insight part. The suggestion is to reverse date sorting
order.

> EDIT: I edited the columned data to add dashes to the fields with no data
> since it looks like the form strips out white space.  Hopefully this looks
> correct.  Thanks and sorry for any duplicate email.

p.s. Using a fixed space font for such tables (e.g. Courier) would make it
even more readable.


--


Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
We had joy, we had fun, we had Linux on our Sun -- anonymous source
-------------------------------------------------------------

Hi Thomas,

I thought it could have something to do with sorting as well, but I never changed the sorting, at least not intentionally, and I can't find any options to change it.  Where can I change this?  i tried clicking the column headings but that didn't do it.  

Thanks again for your help...

Sam Alex

[Thomas Baumgart]

Hi,

on Sunday 04 October 2009 samalex wrote:

> Thomas Baumgart wrote:
> > Hi,
> >
> > on Saturday 03 October 2009 samalex wrote:
> >> Hi,
> >>
> >> I've pulled transactions from 8/30 through today into my checking
> >> account through KMM 1.0.1 but the balances are way off.  I then setup a
> >> test account and entered some dummy info and it's doing the same thing
> >> there. Below is what is in the register of the test account (don't want
> >> to post actual transactions [grin]):
> >> Trans Date Payment Deposit Balance
> >> 10/01/09 - 100 100
> >> 09/01/09 - 44.65 144.65
> >> 08/31/09 - 12.32 156.97
> >> 08/31/09 - 11.12 168.09
> >> 08/31/09 22.23 - 145.86
> >> 08/31/09 123 - 22.86
> >> 08/30/09 - 123 145.86
> >> 08/30/09 63 - 82.86
> >> 08/01/09 - 1000 1082.86
> >>
> >> The 1000 on 8/1/2009 is the opening balance and all transactions are
> >> cleared.  Can someone explain to me how the balance works?  Because
> >> below is how it looks like it should be presented to me:
> >> Trans Date Payment Deposit Balance
> >> 10/01/09 - 100 1082.86
> >> 09/01/09 - 44.65 982.86
> >> 08/31/09 - 12.32 938.21
> >> 08/31/09 - 11.12 925.89
> >> 08/31/09 22.23 - 914.77
> >> 08/31/09 123 - 937
> >> 08/30/09 - 123 1060
> >> 08/30/09 63 - 937
> >> 08/01/09 - 1000 1000
> >>
> >> Thanks for any insight...  Is this a bug?  Do I have something marked
> >> incorrectly?  Or am I just reading it wrong?  If I have the opening
> >> balance
> >> set at $1000 then why does it have $1082.86 in the balance at that
> >> point?
> >
> > It took me a moment to figure out what the problem is. You're sorting the
> > transactions in descending date order. That's interesting (I have never
> > seen
> > someone doing it that way) because KMyMoney's balance display algorithm
> > cannot
> > (currently) cope with that. The balance column *always* starts with 0 at
> > the
> > top and shows the most recent balance at the bottom, and since this
> > column is
> > calculated you can see different results depending on the sort order.
> >
> >> Thanks for any insight or suggestions, and take care -
> >
> > The above was the insight part. The suggestion is to reverse date sorting
> > order.
> >
> >> EDIT: I edited the columned data to add dashes to the fields with no
> >> data since it looks like the form strips out white space.  Hopefully
> >> this looks
> >> correct.  Thanks and sorry for any duplicate email.
> >
> > p.s. Using a fixed space font for such tables (e.g. Courier) would make
> > it even more readable.
>
> Hi Thomas,
>
> I thought it could have something to do with sorting as well, but I never
> changed the sorting, at least not intentionally, and I can't find any
> options to change it.  Where can I change this?  i tried clicking the
>  column headings but that didn't do it.

Use the right mouse button. That'll do it.  That will only change the sort
order for the current account. If you want to change it for all, visit the
settings dialog. The register page has a sorting tab.

http://kmymoney2.sourceforge.net/online-manual/details.settings.register.html

Double clicking the arrow changes the order.

--


Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
There are two rules for success in life:
Rule 1: Don't tell people everything you know.
-------------------------------------------------------------


------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user