register, cash, money, shop, business, retail, store, cashier, shopping, pay, checkout, credit, financial, bank, purchase, register, retail, cashier, cashier, cashier, cashier, cashier, checkout, checkout
Photo by ClickerHappy on Pixabay

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.

This is an editorial pen name used by the publication, not a claim of an independently verified personal identity. Original editorial credit: Desk Returns Operations.

Why refunds drift between the shopfront and the books

A refund is two events, not one. The store records it when the customer returns goods or the refund is processed. The money moves later, when the processor deducts it from your balance or charges your linked bank account. Between those dates, the shopfront and the ledger disagree.

Tender decides whether money moves. Card and Afterpay refunds flow through the processor and appear in payouts. Cash, cheque and other tender refunds are recorded in Square for balancing only, because Square doesn't process funds for those payment types.

Fees don't come back. Processing fees charged on the original payment aren't refunded when you refund it. A fully refunded sale still leaves a cost in the accounts with no sale attached.

Refund type changes the report. Square's refunds measure excludes partial refunds and refunds of gift card sales. Gross sales aren't adjusted for refunds, so a transaction-level refund list is larger than the refunds figure in the sales reports.

Pull the full refund record before you touch the ledger

Start with the original sale, not the refund. Square lets you find the payment by card number, phone, customer name, receipt, notes or item; Shopify returns are tied to a specific order. Without that link, you can't raise a credit note against the right invoice.

Record the refund's shape: full, partial or itemised. Square supports Select All Items, selected items only, or a specific amount. Shopify lets you process some or all return items at once. A refund can't be cancelled once issued, so confirm the order and items first.

Capture the reason and tender when you issue the refund. Square asks for a reason. The tender type decides whether the refund ever appears in a payout.

Note fees and extras before processing. Shopify calculates the restocking fee from the number of items you choose to process. It applies the return shipping fee the first time you process the return, and allows an optional refund of shipping.

Flag the timing. Shopify lets you issue a refund now or later. If the return leaves an amount to collect, you can invoice the customer during processing or charge the card on the order afterwards.

Map each refund to a credit note, invoice adjustment or bank entry

Every refund needs a home in the ledger. There are three candidates: a credit note against the original invoice, an adjustment that reverses a discount or adds a fee, or a bank entry that matches the payout the refund landed in.

Integration platforms show the pattern. Webgility describes a BigCommerce and Xero setup where orders sync into Xero and create invoices automatically. Payments are paired with Xero's bank feed to create entries that align with those invoices, and credit notes are generated to handle returns, refunds, discounts, fees and partial payments.

Discounts complicate the match. Square applies discounts at the time of sale, before tax, as a percentage or a dollar amount of the whole sale or a specific item. Refunding a discounted item therefore means reversing the discount on that line as well as the price paid.

If a refund sits in a payout alongside other sales, the bank entry is a net figure. Match the payout to the batch it belongs to first, then work down to the individual refunds inside it.

Reconcile card refunds across payout batches and settlement dates

Refunds rarely sit in the same payout as the sale they reverse. Webgility's worked example is 500 March orders settling in three batches. The first covers 28 to 31 March but does not hit the bank until 3 April. Each payout deducts different transaction fees, carries February refunds and shows reserve adjustments.

Reconcile by payout batch, not by trading day. Take the batch total, list the sales and refunds the processor says it contains, and accept that a refund may appear in a later settlement than its sale.

Fees sit inside the payout net. Processing fees aren't refunded when a payment is refunded. A batch containing refunds still shows fee deductions for the original sales, which the refunds can't offset.

If the balance can't absorb the refund, Square charges the linked bank account instead. That produces a separate debit, which must be tied back to the refund rather than treated as a new expense.

Multi-currency adds another layer: conversions require rate calculations, and a cross-currency refund won't match the original sale at the same rate. Record reserve adjustments as their own line rather than leaving them inside the payout total.

Refund Handling Across Payment Methods

  • Card & Afterpay RefundsProcessed via payment provider; appear in payouts; fees not refunded.
  • Cash, Cheque & Other TenderRecorded in store system only; no payout; matched to petty cash or bank withdrawal.
  • Gift Card RefundsExcluded from refunds measure; adjust gift card balance separately.

Handle partial refunds, exchanges and return fees without losing the trail

Partial and itemised refunds break the simple match. Square's refunds measure excludes partial refunds, so take the refunded amount for a partly returned sale from the transaction record, not the summary report.

Shopify processes returns in pieces. You can process a return partially or all at once, and the restocking fee is calculated by how many items you choose to process. Each processing run adds its own lines to reconcile.

Return shipping is applied the first time you process the return. Refunding shipping is a separate decision from refunding the item.

Exchanges create two movements: items released to the customer and, if the customer owes money, an invoice sent during processing or a charge to the card on the order afterwards. Exchange items awaiting payment are put on hold until you release fulfilment.

Both systems must agree on every line: item refund, restocking fee, return shipping, shipping refund and any amount collected from the customer. Reconcile line by line rather than on the net figure.

Reconcile cash, cheque and other tender refunds separately

Cash, cheque and other tender refunds can be recorded in Square within one year of the original transaction date. Square doesn't process any funds for these payment types and functions only as an organisational tool.

There are no fees for recording other tender payments, and you won't receive email notifications for these refunds. They never appear in a payout, so you can't find them by matching bank deposits.

Match them to the source of the cash instead: petty cash, a bank withdrawal or a manual journal entry. The store record gives the amount, date and original sale; the accounting entry needs the corresponding cash movement to agree.

Use store reports to trace refunds into net sales and tax lines

The report definitions decide what matches. Gross sales are overall product sales including modifiers, not adjusted for refunds or discounts. They exclude taxes, tips and the sale of Square gift cards, while including products paid for with those gift cards.

The refunds measure is the amount of product refunded in a period, excluding partial refunds and refunds of gift card sales. Net sales are gross sales minus discounts and refunds. Gift card sales are themselves adjusted for refunds and discounts applied to them.

Tax is calculated on a per-transaction basis. Where multiple tax rates apply in a single sale, the taxable sales and total tax collected on the tax report may not add up.

The payment methods report summarises total collected and the associated fees by tender type. It is the natural starting point for matching card refunds to payouts rather than to daily sales.

Run a short month-end routine. Export the period's refunds, match each to a credit note and to the payout it landed in, and investigate anything unmatched. Then confirm net sales and the tax lines agree with what you reported.

Reduce manual matching with e-invoicing and accounting integrations

E-invoicing exchanges invoice data directly between systems over the Peppol network rather than by email, PDF or paper. The receiving system reads the details itself, removing manual data entry and the copy-and-paste errors that come with it.

In Australia the ATO manages Peppol: it sets the rules, accredits providers and ensures e-invoicing meets GST standards. It doesn't monitor or store the invoices themselves, because data passes straight from seller to buyer.

E-invoices sent through Peppol must follow the PINT A-NZ format. That format carries the ABN, GST and payment terms in a structure both countries' systems understand.

Accounting integrations do comparable work on the refund side. Webgility's BigCommerce and Xero setup syncs orders, payments, inventory and taxes, and generates credit notes for returns, refunds, discounts, fees and partial payments. It pairs payments with the bank feed and runs scheduled batches for bulk updates.

The payoff is fewer errors. Webgility reports a manual data entry error rate of roughly 1.6% per transaction, and a 1 to 4% error rate in manual transaction recording, with those errors compounding into tax issues and inventory mismatches.

More from Refund Operations