Gift Card Accounting for Black Friday and Thanksgiving Weekend

Track gift cards sold, redeemed and still outstanding. Use the free gift card reconciliation calculator and worked journal entry examples for a holiday close.

LiveFixPro

11/16/20265 min read

A shopkeeper checks holiday gift card sales and redemptions against the register.
A shopkeeper checks holiday gift card sales and redemptions against the register.

A customer buys a $100 gift card at a neighborhood bookshop on Black Friday. On Saturday, the recipient spends $65 of it. Cash arrived on Friday, merchandise left on Saturday, and $35 of that card remains available to spend. A holiday sales summary, a bank deposit and a gift card balance report each answer a different question about the same weekend.

Open the gift card reconciliation calculator to roll forward a store-issued gift card balance and compare it with the closing outstanding balance reported by your point-of-sale system. Use totals in U.S. dollars. You do not need card numbers, customer names or a connection to QuickBooks. Entries stay in your browser.

How to reconcile gift cards after Thanksgiving weekend

Use the same start time, end time, time zone, stores and currency for every report. Start with the opening outstanding gift card balance. Add paid gift card value issued and any approved increases to existing card balances. Subtract value redeemed and approved decreases. Compare the result with the POS closing outstanding balance. Investigate the difference before making an adjustment.

Expected closing liability = opening balance + paid value issued + other documented increases − value redeemed − other documented decreases. The calculator shows expected closing less reported closing. A positive difference means your roll-forward is higher than the POS report. A negative difference means it is lower. Matching totals are a useful control, but offsetting errors can still cancel each other out.

Worked gift card liability example

A fictional U.S. bookshop starts Thanksgiving weekend with $1,200 outstanding. Customers purchase $850 in new paid gift cards. Staff return $40 to existing cards with documented authorization. Shoppers redeem $470. A documented cancellation reduces an outstanding balance by $20. The expected closing liability is $1,600. If the POS reports $1,575, the calculator returns +$25 to investigate.

That $25 tells the owner where to start looking. It does not identify the culprit. For example, a $25 online redemption that happened before the cutoff but appeared on a later export could explain the difference. Test that explanation against a timestamp and transaction reference. An unsupported entry made solely to force the totals to agree leaves the next person with the same mystery.

Gift card accounting journal entries for a simple sale and redemption

For an ordinary paid, store-issued gift card, the issuer generally records the obligation when the card is sold. In the $100 example, the illustrative entry is a $100 debit to cash or processor clearing and a $100 credit to gift card liability. Use the clearing account if the processor has collected the payment and the bank has yet to receive the payout.

On a later $65 merchandise redemption, assuming no sales tax for this simplified example, the illustration is a $65 debit to gift card liability and a $65 credit to sales. The card still carries $35. A separately recorded inventory and cost-of-goods entry may also apply. If sales tax applies, use the actual receipt breakdown and your configured tax accounts. A POS integration may already have recorded the sale or redemption. Inspect the posting before entering anything manually.

Intuit’s U.S. guide for QuickBooks Online describes using a liability account and setting up items for gift certificate sales and redemptions. Your setup depends on what the POS, payment processor and accounting integration each post. If a bank rule categorizes every processor deposit as sales, compare the clearing activity first so the same gift card purchase is not counted twice.

Separate the reports before you start matching

Save the opening and closing outstanding balance reports. Export paid issuances, redemptions, refunds to cards, voids and manual adjustments for the same period. Keep the processor payout report alongside them so you can explain how cash reached the bank. A payout can contain ordinary merchandise sales, gift card purchases, fees and refunds in one transfer.

Agree who owns the export for each channel. A store manager may have the register report while a different employee controls the online store. Check orders around midnight and after the holiday closing shift. A Sunday register close and a Monday bank deposit can both be correct even though they appear on different days.

Three differences worth investigating first

A promotional bonus got mixed into paid value. A shopper pays $100 and receives a separate $10 promotional voucher. The two amounts can have different terms and accounting treatment. Keep promotional instruments in their own records until your accountant confirms the policy. The worked calculator covers paid, store-issued cards and documented changes within that same population.

A refund changed the tender. A customer who originally paid cash may receive a refund to a store card. If your POS reports that balance as store credit outside the gift card program, do not mix the two balances. If it is inside the very same report population, include the documented increase once and match its reference to the return.

A void affected a different reporting period. Find both the original issue and the reversal. If both are already netted in the issuance report, entering the reversal again as a decrease duplicates it. Document which report provides gross amounts and which provides net amounts. Keep the source exports with the close.

Follow a split-tender sale through the register

Suppose the bookstore rings up $80 of merchandise and the customer uses $35 from a paid gift card plus $45 on a debit card. In this simplified example before tax, the redemption report should include $35. The merchandise sales report contains $80, and the processor activity includes the $45 card tender before fees. Entering $80 as a gift card redemption would understate the expected outstanding balance by $45. Look at the tender breakdown before comparing the transaction with a bank payout.

When the daily export lists several registers, group by tender and channel first. Save one receipt as an example of the mapping for whoever closes the next shift. This turns a Black Friday investigation into a repeatable weekly check.

A Thanksgiving-to-Cyber-Monday close checklist

On Wednesday, November 25, 2026, save the opening report and the exact cutoff your team will use. On Black Friday and Small Business Saturday, note system outages, manual cards and unusual returns. After Cyber Monday, November 30, export the closing population. Run the calculator, compare its expected balance with the POS, and then compare the supported POS balance with the gift card liability account in your ledger.

Keep a short exception list with the date, amount, channel, reference, owner and next step. A question like “Which register recorded the $25 redemption after Friday close?” is easier to resolve than a note saying “gift cards off.” Leave private card identifiers in your secure operating system. The calculator only needs aggregate totals.

Questions from store owners

Does selling a gift card mean the whole amount is income today? For a simple store-issued card, the initial sale creates an obligation to supply goods or services later. The worked example shows how redemption reduces that liability. Processor fees, third-party cards, promotional cards and unusual contracts need their own review.

What about unused or expired balances? Leave them out of manual decreases unless a qualified adviser has confirmed the basis and applicable rules for your situation. This calculator does not estimate breakage, determine tax treatment or decide unclaimed-property obligations.

What if the POS and ledger agree but the deposit is different? Reconcile the payout by settlement batch, fees and timing. The daily payout reconciliation calculator addresses that separate question. For recurring differences, compare monthly bookkeeping and cleanup services or book a free bookkeeping consultation with a summary of the affected channels and months.

Sources: Intuit’s U.S. gift card workflow and Journal of Accountancy on gift card liabilities.

Mailing address: 701 Tillery Street Unit 12-1904, Austin, Texas 78702, United States

Get in touch

LiveFixPro Bookkeeping & Accounting Services LLC is an independent firm. Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. used with permission under the QuickBooks ProAdvisor Agreement.