Don't include current month in 'Last 6 Months' for Planned Spending expenses (edited)
mrzoops
Member ✭✭
Where it lists average spending for a category over the last 6 months is currently incorrect. It is taking into account the current month which will never be a true estimate until the month is over. So the current month should not be factored into this average.
You can see in the picture below that it says the average is $755 but really it should be around $860.
You can see in the picture below that it says the average is $755 but really it should be around $860.
Tagged:
11
Comments
-
Hello @mrzoops,
Thank you for reporting this to the Community!
Since this is by design and I'm not seeing any calculation errors in the data provided in your screenshot, I have gone ahead and turned this into an Idea post requesting to not include the current month in this area of the program so that other users can vote on it and our Product Team can review it. Please be sure to add your vote as well!
-Coach Natalie0 -
Got my vote! Makes sense!
Chris
Spreadsheet user since forever.
Quicken Desktop user since 2014.
Quicken Simplifi user since 2021.0 -
I noticed this with the start of the new month and now I better understand the importance of this idea post. I'm following back up with these two screenshots and some more information to help illustrate the problem.
On the iOS Mobile App, my Spending Plan shows an average of $922 for the "Last 6 months". This is accurate when you average all the months in the screenshot INCLUDING the $0.On the iOS Mobile App, my Watchlist shows an average of $1,025 for the "Last 6 months". I'm not sure how this number is achieved - I can't replicate it - but it is seems closer to being accurate.
The Problem:
When a person is looking at the average on the Spending Plan, it is because they are most likely trying to set their budget for that specific category their Spending Plan. Including a $0 (or artificially low) amount in the average gives us an inaccurately rosy picture of our finances that isn't based in reality. Meaning, I won't set my budget amount accurately...having larger, long-term ramifications.
For Background:- June 2022 = $1,337.13
- May 2022 = $1,084.89
- April 2022 = $1,274.43
- March 2022 = $886.10
- February 2022 = $950.41
- January 2022 = $923.47
- December 2021 = $912.73
- November 2021 = $1,148.01
- October 2021 = $810.28
- September 2021 = $841.41
- August 2021 = $702.06
Chris
Spreadsheet user since forever.
Quicken Desktop user since 2014.
Quicken Simplifi user since 2021.2 -
I just ran into this. I can't think of any use case for the current implementation.
0 -
Agree, the last six month average is always understated with the current calculation.
Simplifi User Since Nov 2023
Minter 2014-2023
Questionable Excel before 2014 to present
0 -
Never noticed this somewhat major issue before, agree, and voted yes.
—
Rob Wilkens0