Split shipments are one of the most common sources of QuickBooks accounting errors for growing ecommerce businesses. When a single customer order ships from two different locations, or in two separate packages on two different days, QuickBooks doesn't automatically know how to treat it. The result is often duplicated revenue, misapplied freight charges, and reconciliation headaches that take hours to untangle.
We see this constantly with mid-market sellers who fulfill from a mix of their own warehouse and a third-party logistics provider (3PL). The order is one transaction in the customer's mind, but the fulfillment side looks completely different.
This post answers the five questions we hear most often about split shipments and QuickBooks, in plain terms.
What you'll find here:
Yes, it can be done without breaking your QuickBooks accounting, but only if your invoicing workflow is built to handle it deliberately. QuickBooks itself does not have native awareness of fulfillment locations, so the burden falls entirely on how you structure the invoice and whether your integration (if you use one) maps shipments back to the right transaction.
Here is what has to be true for this to work cleanly:
One invoice, one customer, one order total. The customer placed one order and expects one invoice. QuickBooks should reflect that. Do not create two separate invoices just because the order shipped from two locations. That is the single fastest way to double your reported revenue.
Inventory adjustments need to reflect the correct location. If you use QuickBooks inventory tracking or sync with an inventory system, each item needs to be decremented from the correct location, whether that is your warehouse or the 3PL. Pulling everything from a single default location creates phantom inventory discrepancies that surface at month-end.
Fulfillment status must be tracked outside QuickBooks. QuickBooks is not a warehouse management system. It does not know that half the order shipped on Tuesday from your 3PL and the other half shipped Thursday from your warehouse. That tracking lives in your shipping software (like ShipStation) or your 3PL's portal. The integration between those systems and QuickBooks is what keeps everything aligned.
Key point: The accounting stays intact when there is one invoice tied to one order, and the fulfillment events (from wherever they originate) are reconciled back to that single transaction. The problem starts when each shipment event triggers its own invoice or sales receipt.
When businesses run this manually, they almost always end up creating duplicate records. Automation that understands fulfillment location context, and maps each shipment back to the originating order, is what makes the warehouse/3PL split sustainable at scale.
Split Shipment Reconciliation Errors in QuickBooks: How to Spot Them
Split shipment errors tend to hide in plain sight. They do not always trigger an obvious alert in QuickBooks. Instead, they accumulate quietly until your books and your actual bank deposits stop matching. Here is where to look.
Revenue that does not match your order management system. If your ecommerce platform (Shopify, Amazon, WooCommerce) shows $X in sales for the month and QuickBooks shows a different number, split shipment handling is one of the first places to investigate. Each partial shipment that generated its own invoice inflates QuickBooks revenue without a matching payout.
Duplicate invoices for the same order number. Pull a transaction report in QuickBooks filtered by customer and look for the same order reference appearing on two invoices in the same period. This is the clearest signal that a split shipment triggered two invoice creation events.
Open invoices that should be closed. When a split shipment is handled correctly, the invoice closes when the final shipment is confirmed. If you see invoices sitting open for orders you know shipped in full, it often means the second shipment event did not reconcile back to the original invoice.
Accounts receivable aging that does not resolve. A customer who paid in full but still shows a balance in AR is a classic symptom. The original invoice was created, a payment was applied, but then a second invoice was created for the second shipment, and no payment was applied to it.
Run these three reports in QuickBooks and compare them side by side:
|
Report |
What to look for |
|
Sales by Customer Detail |
Duplicate order references in the same period |
|
Open Invoices |
Orders marked fully shipped but still open |
|
A/R Aging Summary |
Customers with balances who have paid in full |
If any of these show inconsistencies that trace back to multi-shipment orders, you have a split shipment reconciliation problem. The fix is not just correcting the existing records; it is building a workflow that prevents the same errors from recurring.
Double-counted revenue from split shipments almost always comes down to one root cause: the integration or manual process treating each shipment event as a new sale instead of a fulfillment update on an existing sale.
Here is how it happens in practice.
Most ecommerce integrations work by listening for a trigger. When a shipment is confirmed, the integration creates a transaction in QuickBooks. For a normal order, this works fine. One shipment confirmation, one invoice, done.
For a split shipment, there are two shipment confirmations. If the integration is not built to recognize that both confirmations belong to the same original order, it creates two invoices, each for a portion of the order total. Now QuickBooks has recorded the order twice.
Example: A customer orders $500 worth of product. The first shipment (items A and B, $300 value) ships Monday. The second shipment (item C, $200 value) ships Thursday. If each shipment triggers a separate invoice, QuickBooks shows $500 in revenue. But if the integration does not link them to the original order correctly, it may record $300 + $200 = $500 on two separate invoices, which a controller will correctly flag as $500 in recognized revenue, but the issue compounds when payments, tax, and COGS are applied independently to each.
Double-counted revenue is bad on its own. It gets worse when you factor in:
The core issue: QuickBooks records what it is told to record. If your integration or manual process sends it two invoice creation events for one order, it creates two invoices. It has no way to know they represent the same sale unless the workflow is explicitly designed to prevent that.
The only reliable fix is an integration that tracks order state, knows whether an invoice already exists for a given order, and updates that invoice rather than creating a new one when a second shipment ships.
Freight on split shipments is one of the most debated topics in ecommerce accounting, and there is no single universal answer. The right approach depends on how you charged the customer and how your business recognizes shipping revenue or expense.
Here are the three scenarios we see most often, and how to handle each one.
This is the most common case for direct-to-consumer orders. The customer paid $15 for shipping. It does not matter to them that the order shipped in two packages.
How to handle it in QuickBooks: Record the full freight charge on the original invoice as a single line item. Do not split it across two invoices. When the second shipment ships, you are updating the fulfillment status, not creating a new freight charge. Splitting the freight creates a discrepancy between what the customer was charged and what QuickBooks records.
Some wholesale or B2B orders calculate freight based on actual shipment weight and carrier cost. If the order splits into two shipments, two separate freight charges are legitimate.
How to handle it in QuickBooks: Add each freight charge as a separate line item on the invoice, clearly labeled by shipment (e.g., "Freight - Shipment 1" and "Freight - Shipment 2"). Keep it on one invoice. This gives the customer a clear accounting of what they were charged and keeps your QuickBooks record clean.
If you offer free shipping and the freight cost is an internal expense, you are tracking it as a cost of fulfillment, not a revenue line.
How to handle it in QuickBooks: Record each shipment's freight cost as an expense against the appropriate cost account. The invoice to the customer has no freight line. Your actual carrier costs from the 3PL and your warehouse need to be reconciled separately against the order to understand true margin.
The rule of thumb: Freight on a customer-facing invoice should match what the customer was actually charged. Freight as an internal cost should be tracked as an expense tied to the order. Never add a freight line to a second invoice for the same order unless the customer agreed to pay it separately.
One practical note: if you use ShipStation or a similar shipping platform, your actual carrier costs per shipment are available in your shipping reports. Those numbers are your source of truth for internal freight expense reconciliation, not the invoice.
The short answer: one order, one invoice, updated as each shipment ships. Here is what that looks like in practice.
When an order is going to ship in multiple packages, the invoice should be created for the full order at the point of sale or order confirmation. Not when the first package ships, not when the last one ships. At the time the order is placed.
The invoice includes:
As each shipment ships, you update the invoice with tracking information and mark the relevant line items as fulfilled. You do not create a second invoice. You do not create an invoice for the second shipment. The original invoice is the record of the sale.
In QuickBooks, updating an invoice for a partial shipment typically means:
QuickBooks does not have a native "partial fulfillment" status on invoices. That tracking lives in your ecommerce platform or shipping software. What QuickBooks tracks is the financial transaction: the sale, the payment, and the outstanding balance.
If you use an ecommerce-to-QuickBooks integration, the workflow needs to be configured to:
Common misconfiguration: Many out-of-the-box integrations default to "create invoice on shipment." For single-shipment orders, this works fine. For split shipments, it creates a new invoice every time a shipment is confirmed. If your integration has this setting, you either need to override it or use a platform with conditional logic that checks for an existing invoice before creating a new one.
Some businesses, particularly B2B sellers, recognize revenue at the point of shipment rather than at the point of sale. If that is your policy, you need to decide upfront how you handle partial shipments. The most defensible approach is to recognize revenue proportionally, meaning the first shipment recognizes revenue for the items in that shipment, and the second shipment recognizes the remainder, all on the same invoice with memo notes documenting the shipment dates.
This is a conversation worth having with your accountant, especially if your orders regularly split across accounting periods.
All of the above is manageable when you are handling a handful of split shipments a month. It becomes a serious operational problem when you are processing hundreds of orders, fulfilling from multiple locations, and trying to close your books accurately every month.
The pattern we see with growing ecommerce businesses is consistent: they manage split shipments manually for a while, the errors accumulate, and by the time they notice, they are looking at weeks of cleanup work and financial statements they cannot fully trust.
The three things that prevent this:
If your current setup does not do all three, split shipments will continue to create accounting errors. The question is just how long before they become material.
If you are dealing with this now, or want to build a workflow that handles it correctly from the start, talk to a Connex integration expert. We have helped businesses with exactly this problem, from small operations running a warehouse plus one 3PL to enterprise sellers with five fulfillment nodes and QuickBooks Enterprise.