Join over 6,000 people who are subscribed to receive a once daily email with all of our posts. Never miss out! Click here to subscribe.
Learn how to maximize your points & miles! Join Our Facebook Group!
Want to learn more? Make sure to visit our Million Dollar Reseller archives.
Last week I covered how and why it is so important to get organized when selling gift cards. After that post several people reached out asking if I could provide a template or copy of the spreadsheet I use to track gift cards. While I won’t share my actual spreadsheet, I actually created a template for everyone to use. It has all of the same info I track on my spreadsheet.
Gift Card Reselling Spreadsheet Template
At the end of the post I’ll provide a link to the spreadsheet, however let me walk you through it a bit. I’ll try to explain what everything means and why I included that information.
The Basic Card Info
The first part of the spreadsheet tracks the card information. Included in this section are the Source, the date of purchase, card identifying info, the value of the card along with the purchase price. I also track the buy discount so I can quickly look back.
As you would expect this information is pretty self explanatory.
The second section of the spreadsheet is where I put in all of the information relating to sales.
In this part I track common sense stuff like the date sold and the discount off face value but I also track a few other things. First, I use formulas to track the profit both by percentage and dollar amount. I also track who I sold the card to and put in any info I can so I can quickly reference that sale. I also have a notes area for other general info. You will see I have some credit card rewards info in the sample, however I don’t actually track that personally.
The one area I want to focus on is Sold Price and Net Proceeds. I use this so I can track what price a card sold at while also tracking what I receive. Some of you may sell cards to a reseller in which case that number will probably be the same. Some others however may sell on a marketplace where you pay a fee. If that is the case you can have both numbers tracked.
As many of you might know spreadsheets are very powerful and from here you could extract data to help you run your reselling business better. There are also a ton of other things you could track if you wanted. I admit that I struggle to keep all of this up to date and thus haven’t taken it further, although I suspect it would be beneficial to do so.
The link to the spreadsheet template is below. Please let us know in the comments what information you track? Am I missing anything on this spreadsheet that you feel should be included?
This post may contain referral, affiliate or sponsor links that provide Miles to Memories compensation. Thank you for your support.