Send customer orders and payments to QuickBooks
Related guides
- Connect QuickBooks OnlineSettings and integrations · 6 min
- Choose what syncs to QuickBooksSettings and integrations · 5 min
- Collect a paymentPayments and signatures · 9 min
- Refund a paymentPayments and signatures · 7 min
- Manage your subscription and covered locationsSettings and integrations · 7 min
Post customer orders to QuickBooks as invoices, with the payments and deposits applied to them. Refunds, cancellation credits and store credit follow the same sale.
Customer-order posting is optional. Set it up separately from purchasing and cost of goods, and check that another connection is not already posting the same sales.
Plan: Growth
QuickBooks Online is included in Growth and Professional and is rolling out.
Before you start
Connect the company
Follow Connect QuickBooks Online. Check the company and its currency.
Check settings access
Setup and the sync log need Manage purchasing settings.
Avoid posting sales twice
Check Intuit's Shopify connector and any other app that sends sales to this company.
Check the location
Customer orders at an unbilled location wait. Subscription and locations explains which staff actions need coverage.
The order card needs permission to view the order. Retry and Sync now also need Create and edit quotes and orders within your change access.
Set up customer-order posting
Step 1: Open Customer orders
Go to SettingsPurchasing and accountingQuickBooks. Find Customer orders and Post customer orders and payments.
The card shows On or Off and the sequence Order first paid, Invoice, dated that day, Each payment or deposit applied to it.
Step 2: Choose the starting date
Set Start date to the first payment date you want included. Orders first paid that day or later can post. Moving it earlier includes the orders between the old and new dates.
The date is about the first payment, not when staff created the quote. Review older sales already in QuickBooks before moving it earlier.
Step 3: Map where sales post
Under Where sales post, choose the accounts your bookkeeper uses.
Field What posts there Sales income Required. Products, warranty plans and fees. Sales tax payable Required. Tax collected for the government goes to a liability account, not income. Delivery income Delivery charges. Empty uses Sales income. Discounts given Discounts. Empty uses Sales income. Customer payments go to The account receiving customer payments. Store credit The liability account for store credit used or refunded. Step 4: Turn posting on and check duplication
Click Turn on on Post customer orders and payments. Tick No other app posts these orders to this company only after checking the other connections.
If QuickBooks contains recent sales receipts, Another app posts sales into this company warns that both connections could post each sale. The check covers sales receipts from the last 30 days.
Step 5: Include other Shopify sales if needed
Turn on Also post online-store orders only when another connector no longer posts those orders. It includes Shopify online-store orders and POS sales made outside OrderPilot.
Customer orders must be on first; both choices can be saved together. Only the last 60 days of those Shopify orders can be read. Older ones need to be posted in QuickBooks separately.
Step 6: Save and check the status
Click Save in the page's save bar. QuickBooks settings saved confirms it. Discard drops unsaved changes; leaving offers Stay or Discard and leave.
The Customer orders tile summarizes the saved state. Post now starts an immediate check once the setup is saved and the control is available.
Understand what posts
| Event | QuickBooks record |
|---|---|
| An eligible order is first paid | One invoice for the full order, dated that day |
| A payment or deposit is received | A received payment dated its own day, applied to the invoice oldest first |
| A payment is removed from the order | Its QuickBooks payment is removed |
| Money is refunded | A refund receipt |
| A refund becomes store credit | A journal entry for the store-credit refund |
| An order is cancelled | A credit memo for its unpaid balance |
| Store credit is spent | A credit memo applied to the invoice, using OrderPilot store credit |
Customers are matched by name, with email helping identify the match, or created in QuickBooks. Orders without a customer use Walk-in customer (OrderPilot). The invoice uses the order document's rows; they must add up to the order's Total.
A posted invoice keeps the accounts it was first posted with. Later mapping changes apply to new orders. Changes dated inside a closed accounting period post on the first open day.
Automatic checks normally run every 10 minutes, after changes have settled for 5 minutes. Use the card's status to confirm completion; pressing Post now does not mean the invoice has already arrived.
Check an order and retry
Step 1: Open its QuickBooks card
Open the order and find QuickBooks. The card appears only while customer orders are set to post.
Read Not posted, Syncing, Synced, Waiting or Failed. Open Details to see the invoice, applied documents and any explanation; Hide details folds them again.
Step 2: Resolve the reason
A quote, pending Shopify tax or an unbilled location can leave the record Waiting. Orders first paid before Start date do not post.
Read the displayed reason before changing anything. A total mismatch names the figures; an account error needs its mapping corrected. Waiting records are checked again when they change or on a later daily recheck.
Step 3: Retry after correcting it
Click Retry for a failed order, or Sync now to request an update. While Syncing, the card says Already syncing. This updates when QuickBooks answers.
Wait for the status to settle and check the document details. A role that can only view the order cannot retry it.
Read the sync log
N things need you near the top of QuickBooks settings lists failed and waiting orders with Retry. PO failures direct you to the individual PO; other entries identify online-store and cost-of-goods failures.
At the bottom, Recent activity lists Posted, Document, From, QuickBooks ref and Amount, newest first, 25 rows per page.
The Document filter includes invoices, received payments, refunds, refunds to store credit, credit memos, purchase orders, bills, vendor credits, extra bills, vendor deposits, bill payments and cost-of-goods entries.
Order rows follow your order access. Purchasing rows follow purchase-order access, and their amounts need View costs. Shopify sales made outside OrderPilot are visible only to people who can see every order.
What happens next
Eligible orders continue to post as their payments and invoice change. Customer-order posting does not collect money, pay a vendor or change Shopify stock quantities.
Use Vendor payments, costs and purchase-order sync for the purchasing side of the connection.
Example: Olivia pays a sofa deposit
Example · Harlow & Finch Interiors
One invoice, then separate payments
Nora Ellis has mapped Harlow & Finch's sales accounts and checked the other connectors.
- Olivia Bennett pays a deposit on her Linden Sofa order.
- The order posts as one invoice for its full total, dated the deposit day.
- The deposit posts as a received payment applied to that invoice.
- Nora opens the order's QuickBooks card and checks Synced.
- Olivia's later balance payment posts separately against the same invoice.
If something goes wrong
The QuickBooks card is missing
Check whether customer-order posting is enabled and the order is saved.
The order is Waiting
Read the reason: quote status, pending Shopify tax or location coverage may need resolving.
The order is older than Start date
Change the date only after checking whether those sales are already in QuickBooks.
A store-credit payment or refund is not posted
Map Store credit, or account for it in QuickBooks, then follow the displayed retry guidance.
The sale appears twice
Check whether another connector is posting it before continuing.
Retry is missing or greyed
Check Create and edit quotes and orders, your record scope and the displayed reason.
Was this guide helpful?
Thanks. Tell us what was missing at [email protected].