Gift Certificates and Quickbooks

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Gift Certificates and Quickbooks

Post by compunerdy » Sun Jan 30, 2011 11:22 am

When I sell a $100 gift cert it comes through as a $100 sale..

When the customer uses the gift cert to buy a $100 part the order comes through as a $100 sale..

I do not see any way with the current setup to have this be corrected automatically since the gift cert is done as a line item when purchased but not when used. How is everyone else handling this? Should I just make it so all the gift cert end up going towards a expense instead of sales? I know that is a half assed way of doing it but I am looking for a quick and easy solution.

User avatar
calvis
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 710
Joined: Tue Jan 27, 2004 3:57 pm
Location: Redmond, WA

Re: Gift Certificates and Quickbooks

Post by calvis » Sun Jan 30, 2011 12:37 pm

When you sell a gift certificate it should be a liability.

This is the way I do it:

Create an item for Gift Certificates. When sold, it would go to an unearned income (liability account). When redeemed, it would be a method of payment received and you'd record the sale and reduce the unearned income account.

If someone purchases a gift certification you would not charge tax in your nexus. Only when they redeem the gift certificate.
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: Gift Certificates and Quickbooks

Post by compunerdy » Sun Jan 30, 2011 1:05 pm

Which would all have to be done manually I take it.

So basically once a gift cert has been used I could just delete the sales reciept where it was purchased and it would have the same results in quickbooks..

User avatar
calvis
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 710
Joined: Tue Jan 27, 2004 3:57 pm
Location: Redmond, WA

Re: Gift Certificates and Quickbooks

Post by calvis » Mon Jan 31, 2011 2:14 am

I don't know if I would delete the sales receipt as you want to have some record of the sale. I would just set the payment method to gift certificate and at certain intervals (quarterly or yearly) do a search by payment method and them make the appropriate GL entries to reduce the liability account as needed.
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.

Post Reply