Graph values for "Account Balances"
My account balances graph reports balances that i never had in that period. for example, it says my february 2012 (not hear yet) credit card balance is something like $-1,300. But the actual current balance is about $-900.
i'm doing a last 365 day view, grouped by month, for a credit card.
Is it possible it's giving me an average over the previous month as opposed to the balance as of that month?
Thanks in advance
Comments are currently closed for this discussion. You can start a new one.
2 Posted by ljb on 26 Jan, 2012 12:59 AM
Yes, the account balance graph shows your Average Daily Balance, which can in fact produce values that do not match any actual balance, unless you use Group by Day, because the average is taken over the group-by period.
So with Group by Month, you get the average daily balance for the month. (But not really. It actually averages over the given grouping period before and including the report point. So with Group by Month, for January you get an average daily balance for the 31 days from December 2 through January 1. Yes, it's a bit odd. With Group by Week, you get a point for each Sunday showing the average daily balance for the previous Monday through that Sunday.)
3 Posted by robwilkens on 26 Jan, 2012 01:15 AM
That sort of makes sense to do, and now that i know that i'm ok with it. It would've made more sense to me if i were charging significantly on that credit card month to month, but i've been focusing on paying down my debt over the past year, should be out of credit card debt in a couple of months (pending no surprises), it was just a little shocking to me initially when i saw my balance on the graph was higher than my actual balance - I thought i was missing a transaction/reminder somewhere.
I'd close the issue, but i'm not sure how.
-Rob p.s. If this isn't in documentation (I didn't see it when i looked, but i just skimmed) perhaps someone could add it.
Ethan Tupelo closed this discussion on 26 Jan, 2012 01:03 PM.