Hey everyone, I'm back (kind of)

Since it's quite annoying, I've just made a tool to track your points at MyNintendo.

You can easily check their expiration and totals. (Expiration was the most annoying, since you couldn't really tell how many points will be expiring at the end of each month)

You only need to make sure you fill the data monthly, in order for the spreadsheet to work correctly.
Even if you earned/spent zero points, you should fill in the cell as " 0 ", otherwise you'll get wrong results.

Values have been filled in as examples, feel free to format the file as you wish, just be careful with the formulas as the file is not blocked for edition.
You should only fill the Earned and Spent fields.

Link to the file

Hope this helps.

That's pretty detailed.

The limit for gold coins was extended from 6 to 12 months today. That would also help.

Thanks.

The 12 month limit was indeed considered!

Thank you as well

If you find any inconsistencies, please let me know

FYI Nintendo just added this info in your account.

Go to https://my.nintendo.com/point/history and view when your useless coins are expiring

PLUS Welcome Back trestres

Thanks TomaTito, nice to see you again!

Oh well, looks like they finally added what was missing haha, however you can still track your points and movements just for your own reference and look further into the future than what Nintendo offers in their page.

Likewise :)

Yeah, it only covers the next three months, but that's enough for me.
I think this is less hassle than counting yourself what you gained each month.
Still it was a nice spreadsheet!