Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Setting Transaction Amount Based on Average of Past Transaction Amounts

I want to be able to set scheduled transaction amounts based on the average of past transactions amounts over a user specified range of transactions.

Here are some examples of what I mean:

~ Utility bill payments scheduled into the future...

1. Being equal to the average of a specified range of past utility bill payments

Example: The scheduled power bill for April 2020 being equal to the average of all past power bills starting from August 2019.

2. Being equal to the average of a given month based on past year utility bill payments

Example: The scheduled power bill for April 2020 being equal to the average of the power bills paid in April 2019, April 2018, etc. starting from April 2015.
1
1 votes

New · Last Updated

Comments

  • jmine83
    jmine83 Member ✭✭✭
    Also consider that if any past transaction amounts are changed within the specified range of transactions being monitored, the upcoming scheduled transaction amounts should automatically update themselves to reflect the change of the past transaction amount.
Sign In or Register to comment.