Gift card reconciliation is one of the least visible parts of a reward, loyalty, employee benefit, or ecommerce program. When it works, nobody notices. When it breaks, finance teams lose time, operations teams chase suppliers, and managers cannot trust the numbers behind the program.
For B2B teams, the challenge is rarely one missing report. It is usually a mismatch between several systems: supplier invoices, purchased stock, issued codes, customer or campaign orders, redemptions, refunds, expired balances, and internal accounting records.
This guide explains how gift card reconciliation should work, where it usually fails, and how companies can build a cleaner process for supplier data, stock visibility, reporting, and finance controls.
What is gift card reconciliation?
Gift card reconciliation is the process of matching gift card activity across operational and financial records. In practice, it means checking whether supplier invoices, stock records, issued codes, order data, redemption activity, failed deliveries, refunds, and remaining balances agree with each other.
A simple program might only reconcile what was purchased and what was sent. A larger B2B program usually needs a deeper process: supplier balance movements, stock reservations, campaign ownership, ecommerce order references, accounting periods, unused balances, and exception handling.
The purpose is not only to close the books. Good reconciliation helps the business understand what was bought, what was used, what remains available, what failed, and what needs follow-up.
Why gift card reconciliation becomes difficult
Gift card operations often grow faster than the controls around them. A team starts with a supplier portal and a spreadsheet. Then more suppliers are added, multiple departments start requesting rewards, ecommerce or loyalty flows need automation, and finance needs monthly reporting.
At that point, the program may have several versions of the truth:
- The supplier invoice shows total purchased value, but not the internal campaign or customer order that used it.
- The spreadsheet shows available codes, but not whether some codes are reserved for pending orders.
- The ecommerce platform shows an order, but not the supplier fulfilment status.
- Finance sees a payment, but not the unused balance, failed delivery, or replacement workflow behind it.
- Operations sees a delivery issue, but not whether it has been credited, resent, refunded, or written off.
These gaps create reconciliation work. They also create business risk: duplicate fulfilment, unclear liabilities, unused stock, poor supplier accountability, and reporting that cannot be trusted without manual checking.
The data every reconciliation process needs
A useful gift card reconciliation process depends on clean transaction-level data. Without it, teams end up comparing totals without understanding the differences behind those totals.
At minimum, B2B teams should try to capture:
- Supplier name and supplier transaction ID.
- Internal order, campaign, customer, or cost-center reference.
- Brand, country, currency, denomination, and face value.
- Purchase date, issue date, delivery date, and redemption or status date where available.
- Stock source: pre-purchased code, supplier balance, API order, or manual purchase.
- Order status: requested, approved, reserved, issued, delivered, failed, cancelled, refunded, replaced, or expired.
- Remaining stock or balance after each transaction.
- Invoice number, payment reference, and reconciliation period.
The more these fields are standardized, the easier it becomes to reconcile across suppliers and internal systems. If every supplier report uses different labels and every team uses different campaign names, reconciliation becomes a manual translation exercise.
Common reconciliation failure points
1. Supplier invoices do not match internal orders
A supplier invoice may show total value purchased during a month, but internal teams may need to know which campaign, country, client, cost center, or ecommerce order consumed that value. If the supplier data does not carry internal references, finance has to reconstruct the story later.
2. Stock is available on paper but already committed
Gift card stock can be physically available in a file or dashboard while operationally unavailable because it is reserved for pending orders. Without reservation logic, teams may double-allocate codes or overestimate what is still usable.
3. Failed deliveries are not closed properly
A failed delivery does not always mean no cost was incurred. Some suppliers may still issue the code, some orders may need replacement, and some cases may require credit or refund follow-up. Reconciliation should track the final resolution, not only the initial failure.
4. Redemptions and remaining balances are not visible
For programs that need balance or redemption visibility, missing redemption data creates uncertainty. Finance may need to understand outstanding value, while operations may need to identify unused rewards, expired stock, or customer support issues.
5. Manual corrections are not audited
Manual adjustments are sometimes necessary, but they need an audit trail. If codes are replaced, stock is written off, supplier credits are applied, or orders are manually changed, the reason and owner should be visible.
A practical gift card reconciliation workflow
The right workflow depends on the company, but a strong process usually follows the same structure.
Step 1: Define the source of truth
Decide which system owns each part of the process. Supplier portals may own fulfilment status. An internal platform may own campaign or customer references. Finance may own payment and invoice records. The reconciliation process should connect those sources rather than let each team maintain its own version.
Step 2: Standardize supplier and order references
Every order should carry a reference that can be traced across supplier data, internal reporting, and finance records. This might be a campaign ID, order ID, client ID, cost center, or unique transaction reference. Without this, reconciliation depends on dates, amounts, and manual interpretation.
Step 3: Separate stock, orders, and balances
Purchased stock, issued rewards, reserved codes, supplier balances, and redeemed value are related but not the same. Reporting should show each layer separately so teams can understand why totals differ.
Step 4: Track exceptions, not only totals
The most valuable reconciliation report is often the exception list: missing supplier reference, unmatched invoice, failed delivery, duplicated order, expired code, unassigned stock, unresolved refund, or balance movement without an internal owner.
Step 5: Review regularly
Monthly reconciliation may be enough for a small program, but active ecommerce, loyalty, or rewards programs often need more frequent operational checks. Waiting until month-end can turn small mismatches into large investigations.
What a gift card reconciliation report should include
A useful report should help operations and finance answer clear questions. It should not be a raw export that requires another spreadsheet to interpret.
Recommended views include:
- Supplier invoice vs internal order totals.
- Purchased stock, reserved stock, issued stock, failed stock, and unused stock.
- Supplier balance opening value, additions, usage, adjustments, and closing value.
- Orders by status, campaign, brand, country, currency, and team owner.
- Failed, cancelled, refunded, replaced, or expired rewards.
- Unmatched supplier transactions and unmatched internal records.
- Outstanding balances or unused value requiring follow-up.
These reports give finance a cleaner reconciliation process and give operations a practical way to improve the program.
How technology helps
A gift card management platform or operational layer can reduce reconciliation effort by connecting suppliers, stock, order workflows, and reporting in one structure. This does not always mean a large system replacement. Sometimes the first step is standardizing data fields, supplier workflows, and reporting logic.
Technology becomes especially useful when a company needs API ordering, real-time stock reservation, supplier balance tracking, automated status updates, or finance-ready exports. The key is to design the process before choosing the tool: what needs to be reconciled, who owns it, and what data is needed to close each period confidently.
Where Glavrio can help
Glavrio helps companies improve gift card operations, supplier setup, stock visibility, ecommerce flows, reporting, and platform-enabled workflows. For teams struggling with gift card reconciliation, we can help map the current process, identify data gaps, structure supplier reporting, define stock controls, and design a cleaner operating model.
Where a platform approach is needed, Glavrio can also support requirements, partner setup, API workflow planning, and reporting logic around systems such as UCP and related partner workflows.
The outcome should be practical: less manual checking, clearer supplier accountability, better visibility into unused value, and reporting that finance and operations can trust.
FAQ: gift card reconciliation
How often should gift card reconciliation be done?
For small programs, monthly reconciliation may be enough. For active ecommerce, rewards, benefits, or loyalty programs, teams should monitor exceptions more frequently and still perform a formal monthly close.
What causes most gift card reconciliation problems?
The most common causes are missing internal order references, inconsistent supplier reports, unclear stock reservations, failed deliveries without final status, and manual spreadsheet adjustments without audit history.
Is gift card reconciliation only a finance task?
No. Finance needs accurate totals, but operations controls the supplier, stock, order, and status data that makes reconciliation possible. The process works best when finance and operations use the same source of truth.
Can Glavrio help improve our gift card reconciliation process?
Yes. Glavrio can review current supplier workflows, stock controls, reporting files, ecommerce processes, and platform requirements, then help design a clearer reconciliation model. Contact Glavrio to discuss your current setup.