Selling is the easy part. The work starts afterwards: the bank shows one deposit, the sales report shows hundreds of orders, and someone has to explain the difference before month-end. Retail shops and online stores usually sell through two or three systems at once (a POS in the shop, Shopify or WooCommerce online, Stripe for invoices or subscriptions), and none of them keeps the books.
What shop and store owners run into
- Payouts that never equal sales. Processors deposit sales minus fees and refunds, often batched across days, so the bank line never matches a single report.
- Fees buried in the deposit. If only the net payout is recorded, card fees vanish from the books and sales look lower than they were.
- Sales tax by location. Two shops and a website can mean three tax setups, and a monthly total hides which one is wrong.
- Gift cards counted as sales. A gift card is money owed until it’s redeemed; booking it as income overstates the month.
- Customers stuck in the POS. Buyers from the shop and the website live in different systems, so nobody follows up.
Connect where you sell to where you keep the books
You keep your POS and your store. Pandaflow’s AI agent maps the data, posts the entries and repairs the sync when an app changes.
| Connect | To | Status |
|---|---|---|
| Shopify | QuickBooks, HubSpot | Live: start free |
| Square | QuickBooks | Set up on request |
| Stripe | QuickBooks, Xero | Set up on request |
| WooCommerce | QuickBooks, Xero | Set up on request |
What a clean daily entry looks like
Instead of importing every order, most bookkeepers want one entry per day per channel:
- Gross sales by category or product type, so margins stay visible.
- Discounts and refunds on their own lines.
- Sales tax by rate or location.
- Processor fees as an expense, not netted out of sales.
- Gift card sales to a liability account, moved to income when redeemed.
- The payout as a transfer from a clearing account to the bank, so reconciliation is a match, not a hunt.
This is an illustrative setup, not a customer story. A shop with a Square POS and a Shopify store posts one QuickBooks entry per channel each morning. Fees sit in their own expense account, and the clearing account goes to zero when each payout lands.
Guides
- How to record Stripe payments, fees and payouts in QuickBooks
- How to record Square sales in QuickBooks Online
- Square vs QuickBooks: which does what
Run a café or restaurant? See restaurants and cafés. Ready to try it? Start free with Shopify, or see pricing.