When a refund is issued in Shopify, LedgerPort can automatically create the corresponding transaction in QuickBooks. Depending on how your orders are synced, that transaction will be either a Credit Memo or a Refund Receipt.
Getting refund syncing set up correctly keeps your QuickBooks balance accurate and saves you from creating refund entries manually.
Before You Start
- Refund syncing requires that the original order was synced to QuickBooks first. LedgerPort links the refund to the original transaction.
- The type of refund transaction created in QuickBooks depends on your order sync method:
- Sales Receipt orders produce a Refund Receipt in QuickBooks.
- Invoice orders produce a Credit Memo in QuickBooks.
- If you are not sure which sync method you are using, go to Sync Config » Orders and check the Sync Method setting. See Understanding Order Sync Methods for a full explanation.
How Refund Syncing Works
When a refund is processed in Shopify, LedgerPort detects the refund and creates the matching transaction in QuickBooks:
- A full refund creates a Refund Receipt or Credit Memo for the full order amount.
- A partial refund creates a Refund Receipt or Credit Memo for the refunded amount only. The original transaction in QuickBooks stays unchanged.
Line items, tax amounts, and shipping refunds are broken out on the QuickBooks transaction to match what was refunded in Shopify.
Enabling Refund Syncing
Refund syncing is controlled through your payment status trigger settings.
- From the left sidebar, click Sync Config.
- Click the Orders tab.
- Scroll to the Sync Triggers section.
- Under Payment Status, check Refunded to sync fully refunded orders, Partially Refunded to sync partial refunds, or both.
- Click Save.
Once enabled, refunds issued in Shopify will be picked up on the next sync cycle and the corresponding transaction will be created in QuickBooks automatically.
Note: Most stores should enable both Refunded and Partially Refunded if they want all refund activity reflected in QuickBooks. If you leave these off, refunds will not sync and your QuickBooks balance will not match Shopify.
Credit Memos (Invoice Orders)
If your orders sync as Invoices, refunds create a Credit Memo in QuickBooks.
The Credit Memo is linked to the original Invoice and reduces the outstanding balance. If the invoice was already paid, QuickBooks will show the credit as available against the customer’s account.
What gets created:
- A Credit Memo under the same customer as the original Invoice.
- Line items matching what was refunded in Shopify.
- Tax and shipping adjustments if those were part of the refund.
Refund Receipts (Sales Receipt Orders)
If your orders sync as Sales Receipts, refunds create a Refund Receipt in QuickBooks.
The Refund Receipt records the money going back to the customer and reduces your income for that transaction.
What gets created:
- A Refund Receipt linked to the original Sales Receipt.
- Line items matching what was refunded in Shopify.
- Tax and shipping adjustments if applicable.
Checking Refund Sync Status
After a refund is processed in Shopify, you can confirm it synced correctly from your logs.
- From the left sidebar, click Sync Logs.
- Use the Entity Type filter and select Order (or Refund if listed separately).
- Look for the order number associated with the refund.
- The log entry will show Synced if the refund transaction was created successfully, or Error with a reason if something went wrong.
Syncing Refunds Manually
If a refund did not sync automatically, or if you need to push one through on demand:
- From the left sidebar, click Manual Sync.
- Click Orders.
- Use the Status filter to find the order, or search by order number.
- Select the order and click Sync Selected.
LedgerPort will re-process the order and create the refund transaction in QuickBooks if one is missing.
Common Issues
Refund synced but no transaction appeared in QuickBooks – Check that the original order was synced successfully before the refund was issued. If the original order is missing from QuickBooks, LedgerPort has nothing to attach the refund to. Sync the original order first, then re-sync the refund.
Partial refund created a Credit Memo for the wrong amount -This usually happens if the refund in Shopify was edited after it was first created. Check the refund details in Shopify to confirm the correct amount, then re-sync from Manual Sync » Orders.
Refund is not appearing in sync logs at all – Confirm that Refunded or Partially Refunded is enabled in your sync triggers under Sync Config » Orders. If neither is checked, refunds are excluded from syncing entirely.
If you run into any issues, contact us and our support team will be happy to help.
