QuickBooks Shopify Connector Setup Experts

The settings chosen at set-up decide how every later payout lands in your books, and most of them are accounting calls.

Accounts and auto-posting. Choosing the deposit account that receives Shopify payouts, the payment account, and whether imported transactions post automatically. Get the deposit account wrong and payouts won't match the bank feed.

Mapping sales, taxes and fees. Sending each to the right category, refunds included, so the profit and loss report reads properly and the tax figures agree with what Shopify collected. This is the step worth slowing down for.

Product and customer tracking. Both are optional. With product tracking on, the app matches Shopify products to existing QuickBooks items by SKU and name, then keeps inventory quantities and costs in sync as you sell. A careful expert tidies SKUs before switching it on.

B2B and wholesale. Shopify B2B orders arrive as invoices carrying customer details, products and payment terms. Someone has to check those invoices sit correctly in receivables and get matched when the customer pays.

History and clean-up. Importing up to a year of past transactions, reconciling them against bank deposits and correcting whatever an earlier setup coded wrongly.

Switching from another sync. The connector asks for an import start date. Set it to follow the old tool's last posting, and switch the old tool off, so no sale lands twice.

Two things decide how hard a QuickBooks connector project gets: the state of your SKUs and how far behind the books are. Good candidates ask about both before they quote.

Ask how they map fees and refunds. A good answer names the accounts and explains how a net payout ties back to gross sales.

Ask about SKUs before product tracking. The right person looks at your product list and tells you whether to turn product tracking on at all. Some stores are better off leaving it off.

Ask about wholesale. If you sell B2B, they should describe how connector-created invoices get matched to customer payments in QuickBooks.

Ask about the years before. If your books are more than twelve months behind, they should explain how the older period gets handled outside the connector, and price it separately.

Red flags. Promising to pull in more than a year of history through the connector, or switching on product tracking before anyone has looked at your SKUs.

Start with a single month. Pay for one month imported with product tracking off, reconciled to the bank, with the mapping written down. You see their working before the full year changes hands.

Cost depends on who you ask. Intuit says the connector is included with a QuickBooks Online subscription. The App Store listing shows it as free to install but adds that additional charges may apply. Check your own subscription before budgeting.

History stops at one year. You pick the date imports start from, and it can be at most one year back. A store with two unreconciled years needs a plan for the older period before the connector goes in.

Have the right store name. Setup asks for the original myshopify.com address, not your custom domain, and the person installing needs permission to install apps in Shopify.

The first import takes a while. Intuit puts it at between 10 minutes and 3 hours, depending on transaction volume. Don't judge the mapping until it finishes.

Duplicates come from SKUs. Product matching relies on SKU and name. Two products sharing a SKU, or one product spelled two ways, produces duplicate items in QuickBooks that then need merging.

B2B changes what you reconcile. Because B2B and wholesale orders arrive as invoices rather than paid sales, a store selling both ways reconciles two different streams. An expert sets up the receivables side before the first wholesale order imports.

Most connector work falls into one of these jobs. The one-year history limit decides how big the second one gets.