|
TL;DR
|
Shopify accounting gets harder to reconcile in QuickBooks when three common transactions aren’t captured with enough detail: payment fees, custom discounts, and refunds. Each one changes what actually happens to the money, and each needs to be reflected clearly in the books.
Webgility, an ecommerce accounting automation platform, is introducing three Shopify accounting improvements that remove extra steps and preserve more order-level detail:
Selling on Shopify is easy to start. Keeping the books accurate as volume grows is the harder part.
|
Example: Take one $150 order. The customer applies a loyalty discount. Shopify deducts a payment fee. Two weeks later they return the item and get a refund. That single sale now carries three separate financial events, and each one has to land correctly in QuickBooks. Multiply it across a few hundred orders a month and small gaps turn into hours of reconciliation. |
This guide walks through where those gaps come from and how to close them.
|
Workflow |
Before |
Now |
|
Refunds in QuickBooks Desktop |
Credit Memo plus Refund Check: two entries per refund |
One Check that debits expense and credits bank |
|
Payment fees on a new store |
Missing until you manually re-triggered a fee sync |
Included in the first order download at onboarding |
|
Custom discount codes |
One lumped discount total, no breakdown |
A separate line item per code with title, amount, and type |
These changes solve three small but repetitive accounting gaps: extra refund entries, missing fee detail at setup, and limited visibility into promotions.
What changes: For new Shopify customers, payment fees and net payable are pulled during the very first order download at onboarding. There is no separate fee sync to re-trigger after connecting the store.
Why it matters: Shopify sales and Shopify payouts are not the same number. Payment fees reduce the amount the merchant ultimately receives.
Having the fee and net payable available from the first download gives the accounting team the complete payment picture from the start instead of adding that detail later. It also makes the first reconciliation cleaner because the gross order, fee, and net amount can be reviewed together.
|
Example: Say an apparel brand connects Shopify and downloads 320 orders. If each $52 order carries roughly a $1.80 payment fee, that’s about $576 in fees across those orders. Previously, those fees and the net payable might not be available with the first order download until the fee sync was triggered separately. Now they come in from the first download, so the team starts with a more complete picture for reconciliation. |
How to use it. Connect your Shopify store, finish your Shopify and accounting configuration, then run the first order download. Open a downloaded order, check the payment fee and net payable against Shopify, and continue with your normal posting workflow. Nothing extra to enable.
Suggested read: Shopify Fees Explained: What You’ll Actually Pay in 2026
What changes: Webgility now downloads and syncs custom Shopify discount codes individually, retrieving the discount title, amount, and type through the Shopify GraphQL API. Instead of one lumped discount, each code appears on its own line.
Why it matters: A final order total tells you how much the customer paid. It does not always tell you why the selling price changed.
When custom discount codes retain their individual detail, accounting and ecommerce teams can see which promotion contributed to the reduction without returning to Shopify to reconstruct the order. That improves transaction transparency and gives reporting more context around promotional activity.
|
Example: A beauty brand runs WELCOME10, LOYALTY20, and FLASH15 during the same weekend sale. Across 200 orders, customers receive $3,400 in discounts. Instead of seeing only the final discounted order values, the accounting team can retain the individual discount title, amount, and type on each order. That makes it easier to trace which promotions contributed to the discount total without going back to Shopify. |
How to use it. When an order containing a custom discount code downloads, each code appears as its own line item with title, amount, and type. Review those lines against the original Shopify order, then continue with your configured accounting workflow. The detail carries through to QuickBooks with the rest of the order, that means no manual breakout.
What changes: Posting a Shopify refund used to require two entries: a Credit Memo followed by a Refund Check. You can now post the refund as a single Check, one transaction that debits the expense account and credits the bank account directly.
Why it matters: A seller processing refunds weekly used to carry twice as many refund transactions as actual refunds, each Credit Memo shadowed by a Refund Check. Now the refund line on the bank statement maps to one entry in QuickBooks. Nothing to pair, nothing to untangle.
|
Example: Say a Shopify seller processes 40 refunds a month. With a Credit Memo and Refund Check for each refund, that meant 80 refund-related entries to review and reconcile. With the new workflow, those same 40 refunds can be posted as 40 Checks in QuickBooks Desktop. That’s 40 fewer entries to work through, with each bank refund mapping to a single QuickBooks transaction |
How to use it: Set your refund posting workflow to the Check option and select the expense and bank accounts it should hit. After your first refund posts, open it in QuickBooks Desktop and confirm the accounts and amount match your intended accounting treatment. Every refund after that follows the same path.
Suggested read: How to Post Shopify Refunds to the Right QuickBooks Account
At every stage, the accounting record stays closer to the Shopify activity behind it. That matters because reconciliation gets expensive the moment your accountant has to reconstruct a transaction after the fact.
Suggested read: 5 Best Ecommerce Payment Reconciliation Software in 2026
Accurate ecommerce accounting is not about pushing more data into QuickBooks. It's about bringing across the details that explain what actually happened to the money.
With single-Check refunds in QuickBooks, Shopify fees available from the first order download, and custom discount codes retained as individual line items, Webgility reduces manual cleanup while keeping the accounting record closer to the Shopify transaction behind it.
Want to see how your Shopify-to-QuickBooks workflow can be automated at the order level? Talk to our ecommerce accounting experts or start your free trial.
In QuickBooks Desktop, Webgility can post a Shopify refund as a single Check that debits your expense account and credits your bank account, replacing the previous Credit Memo and Refund Check pair.
Webgility can download Shopify payment fees and show both gross and net order amounts. For the new onboarding enhancement, confirm the exact first-download behavior before stating that no separate fee trigger is required.
Once your store is connected and authorized in Webgility, orders containing custom discount codes download with each code as its own line item.
Yes. Webgility supports downloading Shopify custom discount and reward codes as individual line items, helping merchants retain more detail about discounts applied to each order.