Amazon Business: Fixing Missing Transaction Details in QBO Sync

Missing transaction details in the Amazon Business QuickBooks Online sync occur when orders download without essential breakdown data, such as item descriptions, line-item pricing, individual seller fees, or tax distributions. This typically happens when using summary-level bank feeds instead of itemized app connectors, when Amazon multi-order settlements bundle separate transactions into a single lump sum, or when app field mappings are unassigned. You can fix this by enabling detailed item fetching in the Amazon Business app, re-mapping your clearing accounts, or running a manual sync audit.

Fast-Fix: The 45-Second Solution

To restore missing Amazon Business transaction details in QuickBooks Online immediately: Open QuickBooks Online and navigate to Apps > My Apps > Amazon Business. Click App Settings and change the import method from Summary (Lump Sum) to Detailed (Itemized). Ensure a default expense and income account is assigned for unmapped items. Save your preferences, select the missing date range, and click Refresh Data to re-import missing order descriptions and fees.

Quick Status & Triage Snapshot

  • Data Risk Tier: Low. Missing details affect transaction reporting and receipt attachments, but do not corrupt your underlying ledger or chart of accounts.
  • Multi-User Impact: Affects accounting and purchasing personnel trying to categorize business expenses or account for Amazon seller payouts.
  • Common Trigger: Using standard bank feeds instead of the dedicated Amazon Business app, or settlement reports closing before all order line items finalize.
  • Estimated Fix Time: 15 to 30 minutes.

Diagnostic Flowchart: Amazon Sync Decision Path

  • Step 1: Are you importing Amazon transactions via the standard Bank Feed rather than the Amazon Business App?
    • Yes: Bank feeds only capture payment processor totals, not SKU-level details. Install and configure the official Amazon Business App for QBO.
    • No (Proceed to Step 2).
  • Step 2: Are transactions arriving in the app, but showing generic descriptions like “Uncategorized Item”?
    • Yes: Product categories are unmapped. Assign default expense accounts and product rules in app settings.
    • No (Proceed to Step 3).
  • Step 3: Are total payout amounts matching, but specific Amazon fees (FBA, storage, refunds) are absent?
    • Yes: Amazon’s settlement report is importing as a net deposit rather than a split transaction. Check settlement mapping rules.
    • No: The sync token may be experiencing transmission drops. Proceed to re-authorize the integration.

Is Your Data at Risk?

Encountering missing details during an Amazon sync does not compromise your existing financial records.

  • Amazon Ledger Integrity: Every invoice, packing slip, and order breakdown remains safely stored inside your Amazon Business or Seller Central account.
  • Audit Trail Visibility: Transactions imported with partial detail can be edited or supplemented with attachments without voiding the transaction history.
  • Avoiding Duplicates: Before attempting a manual re-import, verify whether payments have already been accepted from the banking feed to avoid double-counting sales or expenses. For general missing feed issues, review Missing Transactions: Why Your Bank Feed Isn’t Syncing (No Error Code).

Technical Anatomy: Why Amazon Settlements Drop Detail

Amazon processes commercial transactions through two different pathways: purchasing accounts (Amazon Business) and merchant accounts (Amazon Seller Central).

In purchasing workflows, the bank charge often occurs in split shipments, resulting in multiple small credit card charges that do not match the original purchase order total. The Amazon Business app bridges this gap by matching the bank charge to the specific line-item invoice using Amazon’s Order ID. If the app is set to summary mode, it ignores individual item lines and imports only the total dollar value.

In seller workflows, Amazon deposits funds every 14 days as a net settlement. This payout combines gross sales, promotional rebates, shipping credits, sales tax collected, and Amazon seller fees. If the integration lacks split-mapping permissions, it records the single net figure into your bank account, completely omitting the gross revenue and expense fee details.

Differential Diagnosis: Don’t Confuse This With…

Step-by-Step Repair Guide

Follow these steps to configure your Amazon sync for full itemized transaction reporting.

Step 1: Audit Unmatched Transactions in the App Center

Reviewing pending items in the app queue reveals why line-item details failed to attach. For an in-depth audit guide, see Sync Audit: How to Find Where Your QBO App Data Broke.

  1. In QuickBooks Online, go to Banking (or Transactions) and select App transactions.
  2. Click the Amazon Business tab.
  3. Review the list of transactions.
  4. If an order displays a yellow warning icon, click on the row to inspect the detail drawer.
  5. Check if the order is missing an item description, category, or payment method match.
  6. Assign the correct category directly within the drawer and click Confirm.

Step 2: Configure Detailed Import Settings

Switching your connection preferences from summary to itemized capture restores line-item visibility.

  1. Go to Apps > My Apps > Amazon Business.
  2. Select Settings (or the gear icon).
  3. Under Import Preferences, locate the setting for Transaction Detail Level.
  4. Change the setting from Summary to Detailed (Line Items).
  5. Check the option to Automatically import invoice attachments (PDFs) so that receipts are attached directly to each QuickBooks transaction.
  6. Verify that default fallback categories are assigned for both expense items and taxable sales.
  7. Click Save Changes.

Step 3: Map Fees and Tax Codes

Missing fee breakdowns occur when settlement categories do not have designated accounts in your chart of accounts.

  1. In the Amazon app settings, navigate to Accounting Mapping.
  2. Ensure you have dedicated expense accounts created for:
    • Amazon Seller Fees / Commission
    • FBA Fulfillment & Storage Fees
    • Shipping & Gift Wrap Credits
  3. Verify that tax settings match your company rules. If tax line items trigger errors, see Tax Code Mismatch: Fixing Errors in Third-Party App Integrations.
  4. Assign an Amazon Clearing Account (Bank or Other Current Asset) to hold interim settlement funds before they transfer to your checking account.

Step 4: Manually Re-Sync Historical Orders

Once your settings are updated, trigger a manual fetch to download missing line details for past orders.

  1. In the App transactions screen, click Refresh or Import historical data.
  2. Select the specific date range where details are missing (e.g., the last 30 days).
  3. Allow the app to pull the extended JSON data payload from Amazon.
  4. Review the newly populated rows in the For Review tab to verify that item descriptions, quantities, and sales tax breakdowns now appear.
  5. Add or match the transactions to complete the process.

Hard Stop: When to Call an Expert

While adjusting app settings resolves most missing detail issues, escalate the problem when:

  • Historical settlement files contain hundreds of thousands of dollars in lumped payouts across closed fiscal periods that cannot be re-opened without altering reported tax returns.
  • Amazon’s API repeatedly returns an error stating that transaction reports are archived or restricted due to account authorization tiers.
  • In these cases, consult an e-commerce accounting specialist or your ProAdvisor to run historical journal entry reconciliations using Amazon’s flat-file settlement reports.

Closing the Books

Missing transaction details from Amazon Business can make expense auditing and sales reconciliation tedious. In most cases, the information is not lost—it is simply held up by summary import preferences or unmapped clearing accounts. Switching your integration to detailed line-item mode and mapping your fee categories will restore visibility to your receipts and keep your financial records audit-ready.