Shopify QuickBooks integration: fixing Shopify and Stripe payouts
A Shopify QuickBooks integration was posting gross sales, fees and refunds inconsistently, so the bank never reconciled.
The challenge
A connector posted net payouts as income, refunds were entered manually and processor fees were missing, so revenue was understated and the bank account would not reconcile.
Our approach
- Replaced the connector with one that posts gross sales, fees and refunds separately
- Introduced a payout clearing account
- Corrected six months of history with journals agreed with the accountant
- Documented a weekly reconciliation routine
What was delivered
- Integration audit: A review of your current apps, connectors, sync errors and how each one posts to QuickBooks.
- Connector selection: Native app, middleware or custom API, chosen for reliability, cost and the detail you need.
- E-commerce integration: Shopify, WooCommerce, Amazon and eBay orders, fees, refunds and payouts.
- Payment integration: Stripe, PayPal, Square and Razorpay settlements matched to bank deposits through clearing accounts.
- CRM integration: Zoho CRM, HubSpot or Salesforce customers, quotes and invoices synced with QuickBooks.
- Payroll, expenses and bills: Payroll journals, expense claims and supplier bills posted to the right accounts.
- Custom QuickBooks API integration: Your in-house system, portal or ERP connected through the QuickBooks API, Zoho Flow, Make or Zapier.
- Account and tax mapping: Sales, discounts, shipping, fees, refunds and sales tax, GST or VAT mapped to your chart of accounts.
- Testing and go-live: Real transactions tested in a sandbox or a controlled live run before the full switch-on.
- Monitoring and support: Error alerts, a written runbook and monthly support so the sync keeps running.
The result
Payouts now match bank deposits line by line and the accountant can see gross revenue and fees separately.
How the project ran
- Discovery. We document how money moves through your business: sales, purchases, payroll, tax and reporting.
- Design. Chart of accounts, tax set-up, approval flows and user roles are agreed before configuration starts.
- Configuration. We configure the platform, templates, automations and integrations in a test environment first.
- Data load. Opening balances, contacts, items and open transactions are imported and checked.
- Training. Role-based sessions for owners, accountants and staff, recorded for later use.
- Go-live support. We stay on hand through your first month-end close.
Planning a similar move? Read about our quickbooks app integration service or book a free 30-minute call.
How the Shopify QuickBooks integration was rebuilt
The old Shopify QuickBooks integration posted some orders twice and netted fees against sales. We replaced it with a connector that posts daily summaries and routes every payout through a clearing account.
Stripe and Shopify Payments payouts now match bank deposits exactly. Shopify supports several QuickBooks connectors; the right one depends on order volume and inventory needs.
A reliable Shopify QuickBooks integration also needs a monthly check of the clearing account balance, which we documented for the bookkeeper.
For your own Shopify QuickBooks integration, see our QuickBooks integration services and the ecommerce page.
This is a sample case study that shows how such a project typically runs.
Before any work starts, you get a written scope that lists the data, the systems, the timeline and the price. We agree on test checkpoints, so you can review results at each stage and stop if something does not look right.
Our team has delivered projects for clients in India, the United States, the United Kingdom, Canada, Australia and the UAE. You can reach us on +91 9990827699 or at Info@publishpoint.in, and we usually reply within one business day.
After go-live we stay available for questions, small changes and training refreshers, so your staff are never left on their own with a new system.
Have questions about Shopify QuickBooks Integration Case Study? Book a free scoping call and we will review your current set-up, your data and the best next step.
Talk to a specialist about your move
In a free 30-minute call we review your current set-up, tell you what can be migrated, and send a fixed quote afterwards.