Debt Planner: Payoff Month Not Calculating Correctly

Google Sheets
, ,
50

I didn’t see these updates. I will try the new updates and see if it’s a substitute for vertex!

51

8 posts were split to a new topic: Debt Planner: Current Period Actuals Not Listed

52

3 posts were split to a new topic: Debt Planner: Wrong Order for Snowball Model

59

Hey guys, one last remaining item: One of my items doesn’t have a value for the March Budget. Column S just shows a blank value for this item. The item does have a value assigned in the Categories sheet.

60

Budgets are filled from an ARRAYFORMULA() in K8 with the following mapping:
vlookup($A8:$A32,{$O$8:$O,$S$8:$S},2,false)

If you look in the hidden area, do you see an exact match for the account name in column A to column O? Can you see a value in that row for the budget in column S?

Hope this helps, @branadonshutter.

61

Hey Randy. Column A matches Column O. There is no value in Column S.

Double checking the Categories Sheet, a budget is set there. That budget is also viewable in the Monthly Budget sheet.