Hunting end-of-month for Retail Delivery Fees in Colorado & Minnesota manually?
Automate in QuickBooks Online instead!
weintegrate tracks the RDF automatically and creates every sale as a real Sales Receipt / Invoice instantly with line-item accuracy to the penny and Shopify Payouts automatically reconciled as QuickBooks Online (QBO) bank deposits linked to real QBO documents — never batched summary journals. Balance Sheet, P&L, A/R, and inventory reports always current, not just after close.
For Colorado & Minnesota Shopify Merchants
Stop tracking the Retail Delivery Fee (RDF) by hand. weintegrate is the only Shopify-to-QuickBooks Online integration with native, automatic RDF tracking — every qualifying Sales Receipt or Invoice routes straight to the dedicated account you choose, from order one. No journal entries. No month-end cleanup. Ever. Read the deep-dive →
Heads up: not based in Colorado or Minnesota?
The Retail Delivery Fee triggers on the destination address, not the seller's location. If your Shopify store ships more than $500,000/year of retail sales into Colorado — or more than $1,000,000/year into Minnesota — you're on the hook for the fee, no matter where your business is. Same compliance burden as in-state merchants. Same one-setting fix in weintegrate.
Sources: Colorado Department of Revenue — RDF for Retailers · Minnesota Department of Revenue — Retail Delivery Fee
Merchants Who Stopped Doing It by Hand
From our reviews on the Shopify App Store — rated 5.0 by every reviewer
“I can't believe we were manually matching all of our transactions between Shopify and Quickbooks for so long.”
“The integration is remarkably intuitive, making tasks like matching deposits and analyzing discrepancies straightforward and hassle-free.”
“I am amazed at how much time this integration has saved me in my day to day data entry and processing.”
The Manual RDF Workaround Has Been Required Since 2022
Colorado merchants have managed the Retail Delivery Fee by hand since July 2022. Minnesota since July 2024. Every other integration left the gap open. weintegrate closes it.
Manual Journal Entries Every Month
Pulling RDF amounts out of Shopify exports, posting offsetting entries to a liability account by hand, then maintaining a separate balance of what's been collected and what's been remitted. Recurring monthly work since July 2022 in Colorado and July 2024 in Minnesota.
Other Integrations Hide the Fee
Every other Shopify-to-QBO integration either lumps the Retail Delivery Fee into income, buries it in the net payout deposit, or rolls it into a summary journal entry. None give the RDF automatic native integration on the actual transaction. Phantom sales from payouts
Reconciliation That Never Ties Out
When the RDF lives inside revenue or inside an aggregated deposit, the liability balance can't be verified at month-end. You either trust your manual workaround or rebuild it from Shopify export files every close. Month-end without detective work
Clearing Accounts That Prove Nothing
A lump sum washed through a clearing account to $0.00 only proves the totals cancel. It can't show which Colorado or Minnesota orders carried the fee — or how much you owe the state when it's time to file. Why clearing accounts aren't needed
Four years of manual RDF entries end with one setting.
Start Free Trial15-day free trial · No credit card required · 10-minute setup
How weintegrate Records the RDF Correctly — Every Time
One setting in Destination Fees & Surcharges. Every qualifying order recorded automatically thereafter.
Per-Order RDF Line on Every Sales Receipt or Invoice
Every qualifying Sales Receipt or Invoice in QuickBooks Online includes a dedicated Retail Delivery Fee (RDF) line — posted to your designated Other Current Liability account, in the exact amount Shopify recorded for that order. The three-way payout report
Audit-Ready Per-Order Trail
Every RDF amount is tied directly to its Shopify order — visible on the Sales Receipt or Invoice line itself, not buried inside a monthly summary or rebuilt from a separate spreadsheet at close. Pull any QBO transaction and the originating order is one click away. Trace any order in seconds
No Clutter on Unaffected Orders
Orders shipped outside Colorado or Minnesota, orders with no taxable items, orders Shopify didn't assess the fee on — none get a stray RDF line. No placeholders, no zero-amount entries, no noise.
QBO Class Assignment Supported
Multi-location merchants can assign QuickBooks Classes to RDF lines for per-store, per-channel, or per-department reporting — without manual journal entries to slice the obligation by location.
Future-Proof for New States
Colorado and Minnesota aren't the only states evaluating retail delivery fee frameworks. weintegrate's account-level RDF infrastructure is ready for whichever state lights up next — no integration upgrade required.
One Setting, One Time
Configure the RDF account in weintegrate's Destination Fees & Surcharges settings once. Every qualifying order from that moment forward records the fee correctly — automatically — for as long as you're a customer.
Three Steps to Automated RDF Tracking
From manual workaround to fully automated in under 10 minutes
Pick Your QBO Liability Account
Open weintegrate's Destination Fees & Surcharges settings and choose the QuickBooks Online Other Current Liability account that will hold every Retail Delivery Fee Shopify collects.
Sync as Normal
That's it on the configuration side. Every new Colorado or Minnesota order Shopify assesses the RDF on now creates a Sales Receipt or Invoice in QBO (depending on your sync configuration) with a dedicated RDF line — posted to the account you picked, for the exact amount Shopify recorded.
Reconcile and Remit With Confidence
The liability account balance shows exactly what's been collected, exactly what's been credited via refunds, and exactly what remains outstanding. When remittance time arrives, the supporting documentation has been accumulating in QBO — order by order — since day one.
Ready to Stop Tracking RDF by Hand?
15-day free trial. No credit card required. Setup takes less than 10 minutes.
Used by Shopify merchants and accounting practices across Colorado & Minnesota
weintegrate vs Every Other Shopify-to-QuickBooks Integration
The Retail Delivery Fee (RDF) is a quick proxy for whether an integration was built for the full complexity of Shopify's fee and tax structure — see the full write-up in our deep-dive blog post
| Retail Delivery Fee (RDF) Capability | weintegrate | Other Tools |
|---|---|---|
| RDF posted to dedicated Other Current Liability account | ✓ Yes | Manual workaround |
| Per-order RDF line on each Sales Receipt / Invoice | ✓ Yes | No — buried in summary |
| RDF accounted for on every Refund Receipt / Credit Memo | ✓ Yes | Manual journal entries |
| No clutter on non-RDF orders | ✓ Yes | Varies |
| QBO Class assignment on RDF lines | ✓ Yes | No |
| Setup time for RDF tracking | ✓ One setting | Ongoing manual work |
| Works the same way for Colorado and Minnesota | ✓ Yes | Manual either way |
Who This Solves a Real Problem For
If any of these describes you, the RDF setting alone is reason enough to switch
Colorado Shopify Merchants
You've been recording Colorado's Retail Delivery Fee by hand since July 2022 — every qualifying order, every month, every close. weintegrate resolves four years of manual workaround with one setting.
Minnesota Shopify Merchants
The Minnesota RDF kicked in July 2024 and the workaround landed in your lap on day one. Per-order liability recording, automated from the first qualifying delivery — no monthly cleanup.
Accountants & Bookkeepers
Manage Shopify clients in Colorado or Minnesota? Correctly classified RDF entries on every qualifying Sales Receipt or Invoice mean the balance sheet reflects the actual outstanding obligation at every point — month-end close skips the RDF reconciliation pass entirely.
Retail Delivery Fee FAQ
Click any question below to expand the answer
“If you're using QBO and Shopify, this app is a must have.”
— Randy Baudendiste, Flush Packaging · Shopify App Store
Stop Tracking RDF by Hand. Switch to the Only Integration That Doesn't Make You.
15-day free trial. No credit card required. Connect Shopify and QuickBooks Online in under 10 minutes.
Start Free Trial