Add a Report that shows Account Balances including scheduled transactions on a specific date

Lloyd Young

I have several bank accounts between which I am moving money continually to cover various credits and debits. Would be very nice if there was a report I could run that would show (for example) the balance of each specified account including scheduled transactions at the end of a given period (for example end of the month). There is a report that shows current balance and even if the end date on this report is extended out to the end of the month, scheduled transactions for these accounts are not included in the projected balances.

Jim_Harman

Have you looked at the Bils & Income > Projected Balances view? That gives a graphical view of your projected future balances.

You can also set account balance alerts that will notify you if your balance is approaching a preset level.

Lloyd Young

Thanks Jim. Issue is the Projected Balances view will only show the balances of an account if it has a bill or income change in the account. This view will not show the balance of a account that only has transfers to/from another account. I understand about the alerts but I want a report that show the actual balances at any given date. 

Jim_Harman

Lloyd Young said:

Thanks Jim. Issue is the Projected Balances view will only show the balances of an account if it has a bill or income change in the account. This view will not show the balance of a account that only has transfers to/from another account. 

That is not what I am seeing. I have a savings account that has no future activity other than transfers to the account, and it can be included in the projected balances. The view is limited by default to "Spending" accounts - Checking and credit cards - but if you choose Multiple accounts next to Select accounts, you can include savings accounts. 

Lloyd Young

I think I now understand the difference in what we are saying. The savings account that has only transfers in and out does show in the Projected Balance GRAPH but that is not what I want. I want to see a report that shows the projected balance as a number (not in a graph form). I want to see an Account Balance report that will show the projected balance on the date I request including all the scheduled transfer in/outs. I am requesting the projected balances in a report form not in a graph form.

Jim_Harman

Your idea will get more support in the form of votes by other users if you describe how you will use this report - how it will help you manage your finances in ways you cannot currently do.

I do see that in the "Upcoming bills and income" section below the Projected Balances graph, when there are transfers into an account, the Closing Balance column shows 0.00 instead of the running balance of the account you are viewing, which looks like a bug to me. 

Also going to File > Print > Print projected balances shows the amounts of the bills and income but not the running balance, again not very useful.

oldngrmpy1

@Jim_Harman. I want to reference this  particular Post I made. https://community.quicken.com/discussion/7893593/looking-for-tips-to-make-quicken-more-friendly-tools-for-tips