Send customer orders and payments to QuickBooks

6 min readUpdated 19 Nov 2026Advanced

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

  1. 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.

  2. 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.

  3. Step 3: Map where sales post

    Under Where sales post, choose the accounts your bookkeeper uses.

    FieldWhat posts there
    Sales incomeRequired. Products, warranty plans and fees.
    Sales tax payableRequired. Tax collected for the government goes to a liability account, not income.
    Delivery incomeDelivery charges. Empty uses Sales income.
    Discounts givenDiscounts. Empty uses Sales income.
    Customer payments go toThe account receiving customer payments.
    Store creditThe liability account for store credit used or refunded.
  4. 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.

  5. 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.

  6. 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

EventQuickBooks record
An eligible order is first paidOne invoice for the full order, dated that day
A payment or deposit is receivedA received payment dated its own day, applied to the invoice oldest first
A payment is removed from the orderIts QuickBooks payment is removed
Money is refundedA refund receipt
A refund becomes store creditA journal entry for the store-credit refund
An order is cancelledA credit memo for its unpaid balance
Store credit is spentA 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

  1. 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.

  2. 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.

  3. 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.

  1. Olivia Bennett pays a deposit on her Linden Sofa order.
  2. The order posts as one invoice for its full total, dated the deposit day.
  3. The deposit posts as a received payment applied to that invoice.
  4. Nora opens the order's QuickBooks card and checks Synced.
  5. 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?