How to reconcile refund tax entries and catch tax refunded twice

When a refund is partly calculated by the store and partly adjusted by hand, the same tax amount can end up recorded twice. This guide shows a simple, repeatable way to find those refunds.

Updated 2026-10-17 · Venture Lab 10

Not tax advice. This guide is about bookkeeping hygiene: finding entries worth a second look. Your accountant decides what the right tax treatment is.

Why it happens

A refund rarely has just one amount. In Shopify's Admin GraphQL API, for example, a Refund holds refunded line items, refunded shipping lines, duties and order adjustments.

• Each refunded line item carries its own totalTaxSet.
• An OrderAdjustment has its own taxAmountSet. Shopify describes it as the difference between a calculated and an actual refund amount.

So tax can show up in more than one place on the same refund. If someone also enters a manual tax adjustment for an amount the system already refunded, your ledger carries it twice.

1. Build one row per tax entry

Whatever your store or ledger exports, reshape it into four columns:

order_id,refund_id,source,tax_amount
1001,R-1,automatic,4.50
1001,R-1,manual,4.50
1002,R-2,automatic,3.10

• source is automatic for tax the platform calculated, and manual for anything entered or adjusted by hand.
• Keep amounts as plain numbers. Leave out currency symbols and thousands separators.

2. Compare within each refund

For every order_id and refund_id pair, compare the manual amounts with the automatic amounts. A manual entry that exactly matches an automatic entry on the same refund is a candidate double count.

It is not proof. A legitimate correction can have the same amount, so treat a match as a reason to open the refund.

3. Review each candidate

• Open the refund in your store admin. Check whether the manual entry was a correction or a duplicate.
• Check your accounting system for both entries, and whether one was already reversed.
• Write down the outcome, so next month's run only shows new refunds.

Do step 2 in your browser

The free RefundTally refund tax check applies exactly this rule. Paste the four-column CSV and it lists every refund where a manual and an automatic tax entry share an amount.

The data stays on your device. The tool does not connect to any store, and you may need to rename your export's columns first.

Venture Lab 10 is independent. Other product and service names are used only to describe compatibility or for comparison, and are trademarks of their owners.

← All guides