Does anyone know if a retail PS+ subscription card counts towards the total?
I wonder because it shows up as $0 in the transaction record
I don't think so. Your wallet has to have money/credit put into it, then you have to spend it.
If you had gotten a regular PSN gift card, then bought a Plus subscription off the PSN store it would have counted. I think.
Exactly this.
The money has to have been spent in the PS Store.