Each order in Shopify is automatically created a Sales Receipt in QBO via integration with SOS.
The current process of reconciling the Shopify and TikTok payouts to the sales receipts in QBO is by matching them to each sales receipt. However, a surge in Retail orders has made the reconciliation very difficult since you have to identify many sales receipts included in one payout.
What is the best way to match or reconcile the Shopify payouts with the Sales Receipts for each order in QBO?
We would love to explore plug-ins or any process to streamline this concern.
We use a service from Bookkeep.com that enters the payout into QBO and then when the payout deposits to the bank, QBO matches it to the Bookkeep entry. It’s really helped us. We don’t use QBO in quite the normal fashion though because of the sheer volume of transactions. We make summary entries only. Check Bookkeep out. I don’t work for them or get a commission. I’ve just been very impressed with their service and support.
Stop matching each payout directly to individual sales receipts in your bank feed. Instead, use the Undeposited Funds workflow in QuickBooks Online (QBO) to streamline the process.
Here’s how to set it up:
Configure your integration to sync all sales receipts to QBO’s Undeposited Funds account (a special clearing account used to temporarily hold funds).
When a payout hits your bank, use QBO’s Bank Deposit feature. From there, select all the sales receipts included in that payout, and then add a line to account for Shopify fees.
The total deposit should now match exactly what was deposited into your bank account. This makes reconciliation fast and accurate.
If your order volume is growing and syncing each sale individually becomes unmanageable, consider switching to a daily summary or payout-level sync. Tools are available that automatically post Shopify payouts (net of refunds and fees) into QBO while still keeping all your order-level data safe in Shopify.
This workflow gives you a clean accounting process without the hassle of matching every transaction by hand.
One way to make this less painful is to reconcile at the payout level first, not the individual order level.
For each Shopify payout, I would line up:
payout id and payout date
gross sales included in that payout
refunds / chargebacks
Shopify fees
tax collected
net payout
matching bank deposit and deposit date
Then the QBO side can use a summary entry or clearing-account workflow that your bookkeeper approves, instead of trying to manually match every order receipt to a deposit. The important review check is whether the Shopify net payout equals the bank deposit, and if not, whether the difference is timing, duplicate import, missing deposit, refund, chargeback, or fee treatment.
Not accounting advice, but this structure usually gives the bookkeeper a cleaner packet to review.
Same boat, and the surge is exactly when this breaks. The clearing-account / payout-level approach people mention above is the right structure and I’ve moved to it too. But the part that still eats my time is the last mile: when the net payout doesn’t equal the bank deposit, figuring out WHY. Is it a refund from a prior period, a chargeback, a reserve being held, a fee change. The transactions CSV technically has it all, but I still end up eyeballing it line by line every month.
Curious for anyone who switched to payout-level reconciliation: roughly how long does month-end take you now, and do you catch the odd mismatch (refund / reserve / FX) by hand, or does something actually flag it for you? Trying to work out if this is just the cost of doing business or if there’s a cleaner way.
We enter a daily sales summery into our financial software, not each order due to our volume. But each company is different. The other replies here are spot on. We have set up an excel sheet for our journal entry. Line items include Shopify Payments uses UTC (universal time) so look to see when your cut off time is. Ours is 7p. For our monthing reconcilation we loook at orders about 2 days before the EOM (depending on which day of the week it falls) starting at 7p to midnight of the last day of the month. That number should match to the outstanding (credit card receivables or whatever you call it) payout. When funds are deposited into our account is when we recognize the fees. We do the same for PayPal.