Refund Operations
Part of Refund processing operations
Reconciling refunds between store and accounting systems
Refund reconciliation is a bridge between three views: the store order, the payment-provider movement and the accounting entry.
Compare each refund across the store record, payment-provider transaction or settlement report, accounting ledger and bank deposit. Trace the refund by its reference and amount, keeping its transaction date separate from its payout date; totals alone can hide a missing or duplicated entry.
Build a transaction-level list
Export or record each store refund’s refund ID, amount, reason, method, submission date, provider status and accounting reference. Keep partial refunds separately: Square’s period Refunds measure excludes partial refunds and refunds of gift card sales.
Use transaction-level detail to check the provider movement. Square Dashboard’s Transactions view shows individual payments, while its payment methods report summarises collections and associated fees by tender; Square’s tax reports show tax applied to transactions.
Map the refund into the accounting records separately from fees and GST. Product sales revenue is after relevant discounts and returns and excludes GST, so keep sales, refunds, GST and fees distinct rather than recording only a net payout. Use transaction-level tax information: Square calculates tax per transaction, and a sale can involve multiple tax rates.
Compare the provider settlement details with the bank deposit. Shopify payout details and transaction exports distinguish charges, refunds, fees and other adjustments; a net payout can therefore differ from the refund amount. Use settlement reports and fee invoices to explain the difference, with a clearing account for amounts still held by the platform.
Record the refund transaction date and payout date separately. If they fall in different accounting periods, keep the refund recorded against its transaction date and carry the unsettled amount as an open timing item in the clearing account until it appears in a payout and bank deposit.
For each unmatched line, check the report date range, refund reference and amount across the store record and ledger, then check the provider movement and tender. Classify the difference as a missing record, duplicate entry or timing item, correct only the confirmed record, and retain the explanation. On Shopify, a return can be processed with the refund issued later, so distinguish the return record from the refund actually issued.
Square may deduct a refund from its balance or charge the linked bank account if the balance is insufficient. For cash, cheques and other tender, Square records the refund but does not process the funds, so compare it with the store’s recorded cash or other-tender resolution rather than expecting a provider payout.
Key Reconciliation Metrics
- Partial Refunds ExcludedSquare’s period Refunds measure does not include partial refunds or gift card refunds
- Tax Per TransactionSquare applies tax at transaction level; multiple rates possible per sale
- Net Payout vs Refund AmountMay differ due to fees, adjustments, or platform holdbacks
- Timing DifferencesRefund recorded on transaction date, payout may occur in a different accounting period
Preserve the audit trail
Keep the original exports and a separate worksheet with one line per refund. Include the refund ID, amount, method, transaction date, provider status and reference, payout date, accounting reference, tax detail, notes, owner and resolution date.
Restrict detailed files to staff who need customer data. Close the period when every material difference has a documented explanation, not merely when aggregate totals coincide.
