Comparing Which Rewards CC Has The Best Return as of Today (Spreadsheet)

Lbot on 23/04/2023 - 14:02
Last edited 23/04/2023 - 14:14 by 1 other user

I've gone over all the Air New Zealand Airpoints reward cards listed on their site and created this spreadsheet to compare them.
I've also added other reward cards that I could find (excluding Westpac's points card, because they're too complicated to get an equivalent $)

If there are any other rewards cards I've missed, let me know and I'll add it.

The spent columns calculate what your monthly reward would be if that much was spent, minus the card fee's (calculated from the yearly fee / 12), this means the rewards you see there, are rewards you'd get, taking into account the cost of having the card.

Feel free to make a copy if you want to test a specific monthly spend (that's what col L is for, just change L1 and sort it)
By default I have it sorted on the 1k spend column.
https://docs.google.com/spreadsheets/d/1FeE08nUdGA-qR_lUS0rY…

Obviously there is more to picking a CC then just rewards, this is just meant as a basic guide. Though I suspect most of us here already know which card/s perform best. I was just curious to see how all the banks stack up currently at various spend levels.

Looking at this data it seems these are the best cards for each range of monthly spend.

• $0 - $1.7k: American Express Airpoints Card or Dosh PrePaid Visa Card
• $1.8k - $3.2k: TSB Platinum Mastercard
• $3.3k+ spend: American Express Airpoints Platinum Card

* Please note that I've done my best to make sure the numbers are all correct, but I may have made mistakes. If you see any, let me know.

• 

  Grandma on 23/04/2023 - 15:02

  +1

  Spent $1700 today but dosh would only let me load $700. So something to watch for

  • 

    bot on 23/04/2023 - 15:21

    Yeah, they have a $700 daily limit for Windcave topups. I usually do it via bank transfer for larger amounts, usually completes in 1-2 hours. But being a weekend, it'd probably not complete till tomorrow.

    They go into details on the limits here:
    https://intercom.help/dosh-nz/en/articles/6412057-dosh-accou…

    (I have no links to Dosh, I just asked them about it a few weeks ago, as was curious)

    PS, my unpublished comment below, is just this comment, I accidentally put it in the main feed.

• 

  Lampefir on 23/04/2023 - 17:21

  Thanks, this is useful in confirming it's time to move on from ANZ…

  • 

    bot on 23/04/2023 - 18:26

    Good hear. (but also sucks you gotta move)

• 

  conradb42 on 24/04/2023 - 09:43

  Thanks, this is great work!

  • 

    bot on 24/04/2023 - 11:02

    No probs.

• 

  blindbandit on 24/04/2023 - 11:00

  This is very helpful! Thanks for your mahi and for sharing it

  • 

    bot on 24/04/2023 - 11:02

    👍

• 

  Huntakillaz on 24/04/2023 - 23:35

  +1

  Been using BNZ classic

  it's not the best but for students and low spenders, $500-$2000 vs its low fee, its was best until Dosh arrived.
  Though flybuys you can double dip in some places too like new world

• 

  Delta117 on 30/04/2023 - 18:45

  +2

  This is really useful, thank you for sharing this.
  I was looking a the BNZ Advantage Visa Platinum and noticed you can also choose to earn Flybuys instead of "BNZ Rewards". You get 1 FB point for every $15 spent. If you choose fuel rewards as your Flybuys reward type I think this equates to 5c/l discount for every $100 spent which on a 50L fill is the equivalent of $2.5 return for every $100 spent (or $40 spend to get $1 back to use the same terminology as the spreadsheet). This would make it the highest return assuming you could use fuel discounts and didn't mind filling up at Z or Caltex. I could be wrong in my calculations though!

  • 

    adengappa on 01/05/2023 - 10:16

    Thanks for sharing. I'm with BNZ Advantage Visa Platinum as well and i always wanted to derive these numbers but didnt get to work that around. And I see the insurances that come with the card as bonus. Especially the car insurance for reducing the excess when renting!

• 

  Robbert on 13/05/2023 - 07:21

  +1

  Looks like pbtech have dropped amex. Only last year they did a cash back promo with amex

• 

  Wakrak on 06/06/2023 - 04:28

  +1

  There's a good post over on r/PersonalFinanceNZ
  https://www.reddit.com/r/PersonalFinanceNZ/comments/141512l/…