Add a Report that shows Account Balances including scheduled transactions on a specific date
edited May 2021 in Reports (Windows)
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.
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.QWin Premier subscription0
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.0
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.QWin Premier subscription0
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.
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.QWin Premier subscription0
@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-tips0