How to Reconcile Amazon Business Split Shipments Against Credit Card Bank Feeds
The single greatest cause of confusion in small business bookkeeping is the Amazon Split Shipment Syndrome. A client places a single order totaling $342.50 containing 6 items. But when you look at the QuickBooks credit card bank feed, you don't see $342.50.
Instead, you see three separate, mysterious charges across different days: $112.45, $84.18, and $145.87. Because Amazon only charges the credit card when items physically ship from individual fulfillment centers, the bank feed splits the transaction unexpectedly.
Step 1: Match the Shipment Date & Amount
1 In your QuickBooks bank feed, click on the unmatched charge (e.g. $112.45 on Sep 12). Note the date and payment card last 4 digits.
Step 2: Open the Amazon Business Shipment Invoice
2 In Amazon, open the completed order invoice. Look for the sub-invoice labeled "Shipment 1 of 3: Shipped on Sep 12".
Step 3: Auto-Itemize with CartItemizer
3 Open CartItemizer. The extension isolates that specific shipment's line items, attributes the exact tax charged by that fulfillment warehouse, and balances the split lines to equal $112.45 down to the penny.
Need to verify independent tax math? Use our Free Sales Tax Proportional Split Calculator.
Step 4: Review the export in QuickBooks
4 Export the reviewed lines or click Copy TSV Grid for a matching QuickBooks expense screen that supports paste. Check the account mapping and total before saving. A balanced item split does not guarantee that QuickBooks will match a bank-feed charge; matching depends on the statement transaction and account details.
Stop Wasting Hours on Amazon Split Charges
CartItemizer runs 100% in your browser for total client privacy. Approved on the Google Chrome Web Store.
Install CartItemizer Free on Chrome →