Monthly balance movement variable for Balance Sheet accounts (for % calculations)
J
Janelle Hanson
Please add a Formula Builder variable that returns the monthly net change of a Balance Sheet account (not the ending balance).
Use case: Profit First metrics such as Owner's Pay %, Profit %, and Tax % should be calculated as monthly allocation ÷ Gross Profit. Currently, referencing a Balance Sheet account returns the running balance, which causes the % to grow cumulatively rather than reflecting that month's allocation.
A variable like BalanceSheet.AccountName.Either a change or a MONTHLY_CHANGE(account) function would solve this.