Gift Certificate Reporting Question

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
LauraNichols
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 28
Joined: Tue Sep 27, 2011 2:11 pm

Gift Certificate Reporting Question

Post by LauraNichols » Fri Apr 06, 2012 12:44 pm

I'm looking into enabling Gift Certificates on my site and have found that when a customer purchases say, a $50 gift certificate, it is recorded as a sale for $50, which I would expect. Then when that gift certificate is redeemed for a $75 sale, it is recorded as a $75 sale, I would expect it to be recorded as a $25 sale since the original $50 has already been recorded. So it's reporting double numbers which will skew our reports with false profits.

What is everyone else doing to compensate for this?

Thanks,
Laura

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

Re: Gift Certificate Reporting Question

Post by compunerdy » Fri Apr 06, 2012 2:50 pm

I agree that it is strange.. I just try to fix it when it all gets to quickbooks.

LauraNichols
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 28
Joined: Tue Sep 27, 2011 2:11 pm

Re: Gift Certificate Reporting Question

Post by LauraNichols » Fri Apr 06, 2012 3:15 pm

Ugh, we don't use quickbooks, and I did read the posts about fixing it in quickbooks. We have a packaged software system that all our websales go into, and really don't want to have to modify numbers in there. I wonder if I can write a customization in the code that will subtract gift card amounts from the final order amount when it's inserted into the order table.

sloDavid
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 92
Joined: Thu Feb 25, 2010 12:34 pm

Re: Gift Certificate Reporting Question

Post by sloDavid » Thu May 24, 2012 4:43 pm

If a GC purchase is $50, I would think that the "cost of goods sold" of the GC would be recorded as the same amount, $50, to avoid marking any profit.

Post Reply