[BUG] Subtract Upcoming Transactions from Available Balance not subtracting Scheduled Transactions

[numeralnathan]

Describe the bug
I enabled "Subtract Upcoming Transactions from Available Balance" and it didn't change a category's available balance. I have several "Scheduled Transactions" that should significantly reduce the category's available balance.

To Reproduce
Steps to reproduce the behavior:

1. Go to the Budget tab
2. Pick a category and note the available balance
3. Enable Subtract Upcoming Transactions from Available Balance
4. Go to the All Accounts tab
5. Add a transaction with account, payee, and outflow.
6. Set the category to that picked in step 2.
7. Set the date to days or months in the future.
8. Note: That YNAB marks this transaction as a Scheduled Transaction with a gray background
9. Go to the Budget tab
10. Scroll to the category
11. Note that the available balance did not change

Expected behavior
I expect the category's balance to reduce by the outflow amount in the transaction

Desktop (please complete the following information):

• OS: Windows 11 version 22H2 build 22621.963
• Browser: Firefox 108.0.1
• Toolkit Version: 3.5.0

Setting Export

[{"key":"AccountsDisplayDensity","value":false},{"key":"AccountsEmphasizedInflows","value":false},{"key":"AccountsEmphasizedOutflows","value":false},{"key":"AccountsStripedRows","value":false},{"key":"AccountsStripedRowsColor","value":"#fafafa"},{"key":"AccountsStripedRowsDarkColor","value":"#1e1e1f"},{"key":"AutoDistributeSplits","value":false},{"key":"AutoEnableRunningBalance","value":false},{"key":"AutomaticallyMarkAsCleared","value":false},{"key":"BetterScrollbars","value":false},{"key":"BottomNotificationBar","value":true},{"key":"BudgetProgressBars","value":false},{"key":"BulkEditMemo","value":true},{"key":"BulkManagePayees","value":false},{"key":"CalculateIRR","value":false},{"key":"CalendarFirstDay","value":false},{"key":"CategoryActivityCopy","value":false},{"key":"CategoryActivityPopupWidth","value":false},{"key":"ChangeEnterBehavior","value":false},{"key":"ChangeMemoEnterBehavior","value":false},{"key":"CheckCreditBalances","value":false},{"key":"CheckNumbers","value":false},{"key":"ClearSelection","value":false},{"key":"CollapseInspector","value":false},{"key":"CompactIncomeVsExpense","value":false},{"key":"ConfirmEditTransactionCancellation","value":false},{"key":"CreditCardEmoji","value":false},{"key":"CtrlEnterCleared","value":false},{"key":"CurrentMonthIndicator","value":false},{"key":"CustomAverageBudgeting","value":false},{"key":"CustomizeColourScheme","value":true},{"key":"DateOfMoney","value":false},{"key":"DaysOfBuffering","value":"6"},{"key":"DaysOfBufferingExcludeCreditCards","value":false},{"key":"DefaultCCToCleared","value":false},{"key":"DeselectTransactionsOnSave","value":false},{"key":"DisableToolkit","value":false},{"key":"DisplayTargetGoalAmount","value":false},{"key":"DisplayTotalMonthlyGoals","value":false},{"key":"DisplayTotalOverspent","value":true},{"key":"DisplayUpcomingAmount","value":false},{"key":"EasyTransactionApproval","value":false},{"key":"EditAccountButton","value":false},{"key":"EnlargeCategoriesDropdown","value":true},{"key":"FilterCategories","value":true},{"key":"GoalIndicator","value":false},{"key":"GoalWarningColor","value":true},{"key":"GoogleFontsSelector","value":false},{"key":"HideAccountBalancesType","value":false},{"key":"HideAgeOfMoney","value":false},{"key":"HideClosedAccounts","value":false},{"key":"HideDebtRatio","value":false},{"key":"HideHelp","value":false},{"key":"HideReferralBanner","value":false},{"key":"HighlightNegatives","value":true},{"key":"HoveredBudgetRows","value":true},{"key":"ImportNotification","value":false},{"key":"IncomeVsExpenseHoverHighlight","value":true},{"key":"LargerClickableIcons","value":false},{"key":"LiveOnLastMonthsIncome","value":false},{"key":"MasterCategoryRowColor","value":true},{"key":"MasterCategoryRowColorSelect","value":"#e3e3e6"},{"key":"MasterCategoryRowDarkColorSelect","value":"#636366"},{"key":"MemoAsMarkdown","value":false},{"key":"MonthlyNotesPopupWidth","value":false},{"key":"NavDisplayDensity","value":false},{"key":"NotesAsMarkdown","value":false},{"key":"POSStyleCurrencyEntryMode","value":false},{"key":"Pacing","value":false},{"key":"PrintingImprovements","value":true},{"key":"PrivacyMode","value":false},{"key":"QuickBudgetWarning","value":false},{"key":"ReconcileAssistant","value":true},{"key":"ReconcileBalance","value":true},{"key":"ReconcileConfetti","value":true},{"key":"ReconciledTextColor","value":false},{"key":"RemovePositiveHighlight","value":false},{"key":"RemoveZeroCategories","value":false},{"key":"ResetColumnWidths","value":true},{"key":"RightClickToEdit","value":true},{"key":"RowHeight","value":false},{"key":"RowsHeight","value":false},{"key":"SavingsRatio","value":"0.10"},{"key":"ScrollableEditMenu","value":false},{"key":"ShowAvailableAfterSavings","value":false},{"key":"ShowCategoryBalance","value":false},{"key":"SpareChange","value":false},{"key":"SplitTransactionAutoAdjust","value":false},{"key":"SplitTransactionAutoFillPayee","value":false},{"key":"SplitTransactionTabExpand","value":false},{"key":"SquareNegativeMode","value":true},{"key":"StealingFromFuture","value":false},{"key":"StripedBudgetRows","value":false},{"key":"SubtractUpcomingFromAvailable","value":"1"},{"key":"SwapClearedFlagged","value":false},{"key":"TargetBalanceWarning","value":false},{"key":"ToBeBudgetedWarning","value":false},{"key":"ToggleAccountColumns","value":true},{"key":"ToggleMasterCategories","value":false},{"key":"ToggleSplits","value":false},{"key":"ToggleTransactionFilters","value":false},{"key":"ToolkitReports","value":true},{"key":"UnclearedAccountHighlight","value":false},{"key":"ViewZeroAsEmpty","value":false}]

[numeralnathan]

This feature works for transactions coming up in 19 days. It doesn't work for transactions coming up in 2 or more months.

[mxr]

Which month is the transaction created for in step (5) and which month are you viewing in step (9)?

[numeralnathan]

The transaction is in March and I am viewing January.

[numeralnathan]

I would like future 1-time scheduled transactions to be deducted from the current month. This way I can see how much I have today to spend.

Let's say I have a category called Big Ticket Items and it has $10,000 on 1/27. Let's say I have a scheduled transaction for $9,000 for 4/15 to pay taxes. If I look at the Big Ticket Items category today, I will see that I have $10,000 and I may decide to buy a $5,000 couch. That would leave $5,000 in Big Ticket Items. When 4/15 rolls around, I will see that Big Ticket Items doesn't have enough money. I really couldn't afford that $5,000 couch.

If the $9,000 4/15 pending transaction were deducted from the current month, then Big Ticket Items would show $1,000. I would immediately know that I don't have enough money for the $5,000 couch.

[michaelcmelton]

This feature works as intended. This is not a bug, but an enhancement request to the existing feature.

Could you please elaborate more as to why this particular use case is needed and why it would be useful to the user base as a whole? Moreover, please explain why you think this should be implemented when YNAB is not intended to be used like this.

[numeralnathan]

@michaelcmelton I am assuming you haven't read my previous comment. If you have, please refine your question.

Without a code change, what are the ways to track future transactions and know how much I can spend today?

[mmirate]

I would make a completely new category, "Income Tax payment", set a "Needed for Spending" goal of $9k for April 15th, and fund it by moving $9k out of "Big Ticket Items".

[michaelcmelton]

I would make a completely new category, "Income Tax payment", set a "Needed for Spending" goal of $9k for April 15th, and fund it by moving $9k out of "Big Ticket Items".

@numeralnathan This is a good alternative. My point is what your asking for is a particular use case, that is contrary to the intended use of the feature. And frankly, contrary to the way YNAB intended to be used.

[numeralnathan]

I already setup separate categories. When the payments go out, I would like to get rid of the categories because I won't have any further use for them. These are one-off transactions I am dealing with. Setting up and getting rid of the categories is cumbersome. If I could create a single transaction to track the expenditure and have it reflect in the category, this would be much easier.

contrary to the way YNAB intended to be used.

Please enlighten me. I am fairly new to YNAB but not envelope budgeting.