actual icon indicating copy to clipboard operation
actual copied to clipboard

[Bug]: Report budget rollover spend summary wrong?

Open mk-french opened this issue 1 year ago • 2 comments

Verified issue does not already exist?

  • [X] I have searched and found no existing issue

What happened?

Is it just me or do the summary values make little sense when a category has rollover spend enabled in the 'Report budget'?

No rollover enabled - summary values are correct. Screenshot 2024-01-10 at 7 13 14 am

Rollover enabled on 'Food' and summary values are misleading? Screenshot 2024-01-10 at 7 13 57 am

I would expect the summary to show exactly what happened that month, as is shown in the group summary. I.e. What was spent = SUM of all category spends for that month. I can see how we get to -850 (250 + -1,100), it's offsetting the spend in the current month with the rollover balance, which to me doesn't really make sense.

Following that, the summary figures in Feb are also odd... $250 budgeted, $250 rolled over, $500 spent = balance of $0 (okay) but spend = $0 of $250? I see this is because rollover is also enabled for Feb and the 0 floor is preventing the $-250 from summing up: return carryover ? Math.max(0, safeNumber(number(budgeted) + number(sumAmount))) : sumAmount;

Removing the rollover in Feb results in a more correct summary: Screenshot 2024-01-10 at 8 39 33 am But the January rollover is excluded...

So where should the rollover be included? As a deduction on the spend in the subsequent month or an increase to the budget? Or perhaps neither - should it just remain in the balance column and not affect the summaries at all?

Thoughts?

What error did you receive?

No response

Where are you hosting Actual?

None

What browsers are you seeing the problem on?

No response

Operating System

None

mk-french avatar Jan 10 '24 00:01 mk-french

In my opinion rollover should be disabled in report budget. The docs do say that this will happen, but it's still really confusing.

youngcw avatar Jan 10 '24 01:01 youngcw

Ah yes! Is this what you're referring to @youngcw?:

If you utilize the Rollover Overspending feature on a category that is not over spent, the entire spent amount will be forwarded to the next month and the Saved amount will increase for the current month.

Here's the effect on the summary expense (and therefore the saved amount) when rolling over: Category Overspent - Entire expense is ignored in summary Category Underspent - Expenses are decreased by the amount budgeted for that category

In both cases the balance is carried onto the balance of the next month, but does not affect the next month summary in any way...

Is this true to the docs? And more importantly, does it make sense to anyone?

I take your point that rollover in report budgeting is confusing but I do find it handy in some instances! It gives the ability to track a budget over a few months when the transactions are a bit more inconsistent.

Personally, in the summary I would like to see the expenses as it was in the month and any rollover just be carried onto the next months balance for that category. That makes the most sense to me... This way the summary is still accurate for that month and rollover affects only the rolling balance for that category.

mk-french avatar Jan 19 '24 12:01 mk-french