Skip to main content
March 23, 2021
Question

How to enter sold and redeemed gift cards

  • March 23, 2021
  • 4 replies
  • 0 views

Hello. I work in a retail setting and am still fairly new to QB. We have started selling gift cards and I need to know how to record the sales and redemption of the gift cards. 

I set up a Deferred Revenue Gift Card account, but now I'm not sure if I needed to do that.

Can someone please help?

 

Thank you.

4 replies

katherinejoyceO
March 23, 2021

Hi there, @ndsue21

 

Thanks for choosing QuickBooks for your business. I'm delighted to help you record the sales and redemption of the gift cards when customers use them to purchase.

 

First off, you'll need to create a liability account called "Gift cards". Then, create a service item using the same account selected as the income account named gift card. With this, you can track the amount in that account.

 

After that, create a non-inventory type item called advertising expense and link it to the advertising expense account. 

 

To issue a gift card, create a sales receipt to record the sold gift card for the customer. Here's how:

 

  1. Go to the Customers menu.
  2. Select Enter Sales Receipts.
  3. Fill in the customer's info, including the Date and Sales No.
  4. Line one, Gift card item, quantity, and amount. 
  5. Click Save & Close.

 

Then, create an invoice for the redeemed Gift card. Here's how:

 

  1. In the Customers menu.
  2. Select Create Invoices.
  3. Fill the fields with the customer's info like the Date Invoice #Bill to/Sold to, and Terms.
  4. List the sold item on the first line. Then enter the gift card item on the second line with a negative amount.
  5. Select Save & Close.

 

Also, you can consult an accountant for some guidance on what account to use for the item.

 

Once done, you can create a sales receipt to record the sold gift card for the customer. Here's how:

 

  1. Go to the Customers menu, and then select Enter Sales Receipts.
  2. Fill in the customer's info, including the Date and Sales No.
  3. Line one, Gift cards item, quantity, then amount.
  4. Click Save & Close.

 

Then you can create an invoice for the redeemed Gift card. Here's how:

 

  1. In the Customers menu, select Create Invoices.
  2. Fill the fields with the customer's info like the Date Invoice #Bill to/Sold to, and Terms.
  3. List the sold item on the first line. Then enter the gift card item on the second line with a negative amount.
  4. Select Save & Close.

 

I've also attached an article to help you with the steps on running customize the financial report for your future reference: Customize company and financial reports

 

I'm always around here if you need further help with recording transactions in QuickBooks. Take care!

jghareeb777
September 2, 2021

Hi Katherine Joyce,

I am confused about the advertising expense part of these instructions!  I am new to the gift card/certificate world and want to make sure that I am doing this correctly. Also in my many many years of using quickbooks we have always created invoices (for both service work and on the spot purchases).  If I use the sales receipt for the purchase of a gift card, will that mess up any of my accounting (or just add another line)? 

 

Thank you, 

Jilisa

September 2, 2021

Hey jghareeb777!

 

Thank you for joining the QuickBooks Community! For this situation, it would be best to consult with an accountant to see if issuing a sales receipt for the purchase of a gift card will affect your accounting. If you don't have an accountant, no need to worry! QuickBooks offers a ProAdvisor service where you are able to connect with experts within your area. Here's how: 

  1. Select this link: Find an accountant.
  2.  In the Find an expert in section, choose what you're looking for, then use your search field to enter a City or ZIP code.
  3. Click Search.
  4. Look through the options and select one that suits your needs.

 

If you have any other questions, I'm just a post away. Have a wonderful day!

katherinejoyceO
March 24, 2021

Hi ndsue21,

 

Hope you’re doing great. I wanted to see how everything is going about recording the sold and redeemed gift cards you had yesterday. Was it resolved?

 

 Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

 

Looking forward to your reply. Have a pleasant day ahead!

ndsue21Author
March 24, 2021

I haven't had a chance to do anything with them yet. I am in full-day conferences and won't be able to enter them until Friday. I will check back if I have any issues.

 

MikeTLive
February 27, 2022

talk to your accountant of course, but here is how i track my gift certificates in a very simple way

we use a single customer per register Register1 to track sales at end of the day.

we have an Other Current Liability account Gift Certificates Outstanding

 

we created an item of type other charge Non Tax (its liability not a sale) which uses the Gift Certificates Outstanding account.

 

 

In daily practice here is how we record the gift certificate sale :

1) create sales receipt for customer Register 1

2) add a line item Gift Certificate and the associated QTY, RATE and/or AMOUNT.

3) save & close

 

this adds to the liability account Gift Certificates Outstanding

 

 

 

then to REDEEM a gift certificate:

1) create a CREDIT MEMO for our customer Register 1

2) add a line item Gift Certificate and the associated QTY, RATE and/or AMOUNT. being redeemed

3) save & close NOTE: no money change hands in this operation. its an accounting action only. the money is in the bank from when the Gift Certificate was purchased.

4) and also use credit to give refund (click <enter>)

5) issue the refund in the next popup. (accept defaults, click <enter>)

NOTE: I blanked out my bank account info :)

Check your liability account and it will have decreased accordingly.

February 28, 2022

Thank Mike, this looks like QBDT not QBO.  Do you have instructions for QBO?

MikeTLive
February 28, 2022

Yes for quickbooks desktop. 
ive not used QBO so can’t say the differences.  I’d imagine most of it would be similar. 

February 14, 2023

I have another query relating to gift cards. We are a non profit and there are two types of transactions we regularly encounter.

 

1. Private donors will sometimes give us gift cards to use to support the programs we run. So in this case, we didn't spend any money on them but we will use these GC's to buy groceries for the Food Bank. How would we enter GC's that are donated from a third party?

 

2. We also purchase Gift Cards to give to program participants when we have to close the Food Bank for a week. This way they can go and buy groceries themselves. So how would we enter this? And let's say we purchased 400 GC's but only gave away 370 of those GC's and decided to use the 30 leftover GC's to purchase food for our programs. How would this get accounted for?

 

Thanks for any help you can provide.