Every time I get a new credit card, I change all my automatic payments to the new credit card. To keep track of all of the autopays, I made a Google sheet to remember all those autopay bills. You can download a copy here.
You can enter the card name and the Required spend amount along with number of months to earn at the top of the sheet.
Due Date
Enter the date each bill is due.
Bill
Edit any of the bill names for your own bills.
Amount
Add the approximate value for each bill, and you can see how much your bills are per month, and the number of months needed to reach the spend requirement ($5000 in 2.79 months in this example).
Best Default Card
There is a column to note the best credit card to use if you aren’t working on a miniumum spend. You can check the benefits of your cards to know the multipliers (for example, Chase Ink Cash offers 5x on phone and internet).
Website
Add the website to easily link up the location of the autopay.
Yearly Bills
Not pictured above, is a Yearly Bill section. This section can help estimate if you can earn a card with a bigger minimum spend.
Checkboxes
Use the checkboxes when you have successfully changed the autopay. When you use the sheet again for a new card, you can uncheck the boxes, and enter your new card information in. (Tip: on a computer you can select all the checkboxes and press spacebar to uncheck).
