Why are balances unreconciled?

Unreconciled balances usually stem from mismatched identifiers, timing differences between settlement and GL posting, or missing processor reports. Cross-check batch IDs, review settlement dates, and request missing detail from the processor to clear exceptions.

How should breakage be recognized?

Apply a documented, consistent breakage policy aligned with GAAP. Document the method and rationale, and retain supporting calculations and approvals so auditors can verify the timing and amount of recognized breakage revenue.

When must I report unclaimed gift card funds?

Unclaimed property rules vary by state; many states require escheat reporting after a dormancy period. Consult state unclaimed property statutes and treasury guidance to determine reporting triggers and deadlines.

What supporting documents are required?

Include POS exports, processor ledgers, GL trial balances, exception logs, and approval evidence. Retain originals or immutable copies to support audit requests and tax positions.

Can reconciliations be electronically signed?

Yes. Electronic signatures are legally valid under ESIGN (15 U.S.C. ch. 96) and UETA where adopted. Ensure intent, consent, attribution, and record retention are demonstrable for enforceability.

How long must I keep reconciliation records?

Keep reconciliation workpapers for at least three years for IRS purposes (IRC §6501(a)), longer if state or industry rules apply, and six years for HIPAA-covered records per 45 CFR §164.530(j).

Electronic Signature
Templates
Finance
Financial Gift Card Reconciliation

Financial Gift Card Reconciliation

This template is fully customizable. Edit the text, fill out the fields, and send it for signature. Give it a try!

FINANCIAL GIFT CARD RECONCILIATION

Company and Reconciliation Identifiers

Company Name Business Unit / Store Address

Reconciliation ID:

Period Start:

Period End:

Summary Totals

Complete the summary totals below. Values should be expressed in the currency used for accounting records and rounded to two decimal places. Supporting transaction detail must be attached.

Opening Gift Card Liability Balance
Total Issued (sold/activated)
Total Redeemed
Total Voided/Cancelled
Net Adjustments (fees, corrections)
Expected Closing Balance (calc.)
Actual Closing Balance (per ledger/till)
Variance (Actual - Expected)

Itemized Gift Card Activity (Detail)

Provide batch-level or card-level detail for all gift card activity during the period. Use additional pages if necessary; indicate attachment reference in the Notes column.

Batch / Card No.	Opening Balance	Issued Value	Redeemed	Adjustments / Fees	Ending Balance	Notes / Status

Variance Explanation and Corrective Action

If variance is non-zero, provide a detailed explanation of root cause, corrective actions taken, and expected timeline for resolution. Indicate any journal entries required to reconcile ledger balances.

Supporting Documents Checklist

Attach or reference all supporting exports and reports used to prepare this reconciliation. Mark items included.

Sales reports / POS export included

Gift card issuance/activation log included

Transaction export (redemptions) included

Journal entries referenced / attached

Other supporting documentation (describe in Notes)

Certification

By signing below, the preparer certifies that the reconciliation was prepared in accordance with company accounting policies, that all material gift card activity has been recorded and disclosed, and that supporting documentation is retained in accordance with record retention policy. Any unresolved variances are identified above and will be escalated for corrective action. False or intentionally misleading entries may result in disciplinary action.

Prepared By:

Printed Name:

Signature:

Title:

Date:

Approved By:

Printed Name:

Signature:

Title:

Date:

What Financial Gift Card Reconciliation Covers

A Financial Gift Card Reconciliation is an internal accounting record that matches issued gift card balances, redemptions, returns, and fees against the general ledger and point-of-sale records. It documents outstanding liabilities for unredeemed cards, adjustments for voided transactions, and any breakage revenue. The reconciliation supports accurate financial reporting, tax preparation, and compliance with unclaimed property rules. For multi-location or multi-channel merchants, it aggregates data by store, channel, card batch, and expiration status to reveal discrepancies and aging of outstanding balances.

Why a Formal Reconciliation Matters

A structured reconciliation reduces misstated liabilities, detects fraud or processing errors, and clarifies breakage recognition for accounting and tax purposes. It also supports audit readiness and helps organizations meet state unclaimed property and revenue recognition requirements.

Who Prepares and Reviews These Reconciliations

Teams typically responsible include accounting, finance operations, and store management; external accountants may review for tax reporting.

Corporate accounting teams reconcile balances across GL and POS systems monthly and prepare adjusting entries.
Store managers provide batch reports and investigate point-of-sale discrepancies or customer refund claims.
Internal audit or external CPA firms validate controls and confirm compliance with tax and escheat rules.

Assign clear ownership for data collection, exception tracking, and corrective actions to ensure timely monthly close and regulatory readiness.

Step-by-Step: Complete a Monthly Reconciliation

Follow these steps in order to prepare a consistent reconciliation for approval and posting.

01

Gather Data: Export GL, POS, and issuer activation reports for the period.
02

Match Transactions: Reconcile activations to cash receipts and sales entries.
03

Investigate Variances: Research exceptions and collect supporting documentation.
04

Record Entries: Post adjusting journal entries with approvals and notes.

Typical Reconciliation Workflow

A standard workflow ties reporting systems to approval and posting steps to create an auditable trail.

Extract Data: Pull exports from POS, gift card processor, and ERP.
Automate Matching: Use scripts or reconciliation tools to compare identifiers and amounts.
Exception Review: Route discrepancies to store or operations for resolution.
Approval & Post: Finance approves adjustments and posts them to the ledger.

Digital Workflow Settings for eSubmission

Configure your electronic reconciliation workflow for repeatable data capture, review, and approval routing.

Field	Configuration
Data Sources	Connect POS, gift card processor, and ERP exports.
Matching Rules	Set key fields: card batch, transaction ID, and amount tolerance.
Approval Sequence	Specify preparer, reviewer, and finance approver roles.
Retention Policy	Set automatic archival and versioning for audits.

Technical and Security Requirements for eSubmission

Ensure the platform supports secure uploads, controlled access, and a tamper-evident audit trail.

File Formats: Accept PDF, CSV, XLSX for raw exports.
Access Controls: Role-based permissions and SSO support required.
Audit Trail: Capture timestamps, user IDs, and IP addresses.

Integrations with accounting systems and cloud storage streamline reconciliation and secure long-term retention.

Essential Elements of a Professional Reconciliation

A complete reconciliation combines source data, matching logic, exception handling, and sign-off details to support accounting, tax, and audit needs.

Source Data Mapping

Clearly document where each balance line comes from (POS totals, issuer ledger, refund logs) and map fields to GL accounts for traceability.

Matching Rules

Define exact-match and tolerance criteria, including how to handle partial redemptions, multi-item transactions, and chargebacks to ensure consistent automated matching.

Exception Log

Maintain an exceptions register with case IDs, investigation notes, responsible party, and resolution date to support audit queries and root cause analysis.

Adjusting Entries

Record each adjustment with a description, supporting docs, journal entry number, and approver to ensure proper financial statement presentation.

Breakage Policy

Document the method and timing for recognizing breakage revenue and align it with GAAP and company policy to reduce tax and audit risk.

Approval Trail

Capture preparer and reviewer signatures or electronic approvals, including timestamps and version history for internal control and external audit evidence.

Supporting Documents to Include with the Reconciliation

Include source extracts and approvals to ensure the reconciliation is verifiable and auditable.

POS Sales Export

Attach raw daily sales and refund exports covering activations and redemptions, annotated with matching transaction IDs and totals for the reconciliation period.

Gift Card Processor Ledger

Include the processor's issued and redeemed ledger report showing card numbers, activation amounts, fees, and settlement statuses for reconciliation to bank deposits.

General Ledger Trial Balance

Provide the GL account activity and ending balance that the reconciliation will adjust or confirm, with clear links to journal entries.

Exception Documentation

Attach evidence for adjustments, such as voided receipts, customer refunds, or chargeback notifications to substantiate reconciling items.

Security and Compliance Items to Track

Encryption: AES-256 at rest

In-Transit: TLS 1.2/1.3

Access Logs: Immutable audit trail

HIPAA BAA: When PHI involved

SOC 2: Availability report

SSO/SAML: Enterprise authentication

Common Preparation Challenges to Watch For

Mismatched identifiers between POS and processor exports causing unreconciled items that require manual investigation.
Timing differences between activation, settlement, and GL posting that produce apparent variances near month end.
Unclear policy on breakage recognition leading to inconsistent revenue treatment across locations and audit findings.
Failure to retain supporting documentation, which prolongs audits and increases risk of regulatory inquiries.

Regulatory and Financial Risks of Inaccurate Reconciliations

Tax Exposure: Incorrect reporting

Escheat Liability: Unclaimed property risk

Audit Findings: Adjustments and penalties

Fraud Risk: Undetected diversion

Financial Misstatement: Revenue recognition errors

Operational Delay: Extended close

Timing and Deadlines to Keep in Mind

Track periodic and statutory deadlines that affect recognition, reporting, and escheat obligations.

Monthly Close Schedule:

Complete reconciliations within the month-end close cycle to post accurate journal entries on a timely basis.

Tax Reporting:

Maintain records for at least three years to support filings and positions for IRS reviews.

Unclaimed Property:

State dormancy periods vary; prepare to report per-state when cards are considered abandoned.

Audit Retention:

Keep reconciliation workpapers and supporting docs for audit periods specified by policy.

Quarterly Reviews:

Perform deeper variance analysis quarterly to identify trends and systemic issues.

Key Milestones in a Reconciliation Cycle

Numbered milestones in the month provide a repeatable cadence from data extraction through final posting and review.

01

Data Extraction

Export POS and processor reports early in the close period for timely matching.

02

Initial Matching

Run automated matching and flag exceptions within two business days of extraction.

03

Exception Resolution

Investigate and clear items within five business days; escalate unresolved items.

04

Final Approval

Obtain finance approval and post adjusting entries before the ledger is closed.

Practical Tips for Accurate and Efficient Reconciliations

Adopt controls and automation that reduce manual steps and improve traceability across systems.

Standardize Export Formats and Naming

Create templates for POS and processor exports, and enforce consistent naming conventions to make imports predictable and reduce mapping errors across locations.

Automate Matching with Clear Tolerances

Implement automated matching rules with documented tolerances for rounding and partial redemptions; log automated matches to reduce manual work.

Maintain an Exception Register

Track unresolved items with owner, priority, and target resolution date; review aging exceptions weekly to prevent backlog growth.

Document Breakage Policy and Apply Consistently

Have written policy for breakage recognition aligned with GAAP; apply consistently across entities and document journal entries and rationale.

Industry Examples of Reconciliation Use

Real-world examples illustrate typical issues and how reconciliations provide evidence for accounting and tax positions.

Retail Chain Reconciliation

A national retailer standardized batch IDs across POS systems to improve matching accuracy.

This reduced exceptions by over 60% within three months.
The standardized process shortened monthly close and provided clear audit trails for breakage recognition and unclaimed property reviews.

Online Marketplace

An e-commerce operator centralized processor reports to reconcile gift card settlements.

The change enabled automated GL posting.
Centralization improved visibility into dormant balances, helped calculate breakage, and simplified state unclaimed property assessments.

Electronic Signing Pricing Comparison for Reconciliation Workflows

Compare common eSignature vendor pricing and capabilities relevant to recurring reconciliation approvals and high-volume workflows.

	signNow	DocuSign	Adobe Sign	PandaDoc	HelloSign
Starting Price	$8/user/mo	$15/user/mo	$14/user/mo	$19/user/mo	$15/user/mo
Free Trial	7‑day free trial	Varies by plan	Varies by plan	Varies by plan	Varies by plan
Bulk Send	Yes	Yes	Yes	Yes	No
Audit Trail	Yes	Yes	Yes	Yes	Yes
HIPAA Compliant	Yes	Yes	Yes	No	No
Envelope Cap	No envelope cap	100 envelopes/user/year	Varies	Varies	Varies

Frequently Asked Questions About Financial Gift Card Reconciliations

Answers to common questions that arise during reconciliation, eSubmission, and audit preparation.

Need help? Contact support

Why are balances unreconciled?
Unreconciled balances usually stem from mismatched identifiers, timing differences between settlement and GL posting, or missing processor reports. Cross-check batch IDs, review settlement dates, and request missing detail from the processor to clear exceptions.
How should breakage be recognized?
Apply a documented, consistent breakage policy aligned with GAAP. Document the method and rationale, and retain supporting calculations and approvals so auditors can verify the timing and amount of recognized breakage revenue.
When must I report unclaimed gift card funds?
Unclaimed property rules vary by state; many states require escheat reporting after a dormancy period. Consult state unclaimed property statutes and treasury guidance to determine reporting triggers and deadlines.
What supporting documents are required?
Include POS exports, processor ledgers, GL trial balances, exception logs, and approval evidence. Retain originals or immutable copies to support audit requests and tax positions.
Can reconciliations be electronically signed?
Yes. Electronic signatures are legally valid under ESIGN (15 U.S.C. ch. 96) and UETA where adopted. Ensure intent, consent, attribution, and record retention are demonstrable for enforceability.
How long must I keep reconciliation records?
Keep reconciliation workpapers for at least three years for IRS purposes (IRC §6501(a)), longer if state or industry rules apply, and six years for HIPAA-covered records per 45 CFR §164.530(j).

be ready to get more

Join over 28 million airSlate SignNow users

Sign Now