Huh there's a Balance Forecast report which does exactly this. It considers the Scheduled Transactions applicable to your accounts, and shows the forecasted balances.