Debt Planner: Payoff Month Not Calculating Correctly

It’s really hard for me to imagine how the payment model is running in your sheet, @mmgalliv, without seeing the inputs. Can you share a screenshot of your sheet? Feel free to simplify the example (with fewer accounts that still result in the failed behavior) or to redact account descriptions like @branadonshutter.

Also, I don’t know what you mean by “now the other account cannot be found”. The accounts in the dropdowns in column A populate from your Balance History sheet where the Class is marked as Liabilitythis requirement is documented here. (You can override the Class using the Accounts sheet.) If you aren’t seeing an account in the dropdown then:

  • It doesn’t exist in Balance History.
  • It is not properly setup with an Account Id in Balance History.
  • It is not marked as a Liability in Balance History.

Thanks,
Randy