Integrate Amazon with QuickBooks Online
Amazon sends settlement summaries. QuickBooks expects structured journals. NeonPanel maps every line type, posts settlement-sized summaries with true FIFO COGS, and keeps detail in NeonPanel for audit.
Unified system
- Accounting
- Inventory
- Forecasting
- AI access
Trusted by 200+ ecommerce teams
What your books look like without a proper integration
Native sync moves data; it rarely lands in accounts you can defend. NeonPanel closes each gap before the journal hits QuickBooks Online:
Native sync
- Amazon settlements arrive as lump sums — no fee breakdown, no category mapping.
- FBA fees, referral fees, and refunds land in a catch-all account.
- COGS are either missing or estimated using averages.
- Inventory values in QuickBooks do not reflect what is actually in your warehouse.
- Your accountant spends the first hour of every month untangling the same problems.
With NeonPanel
- Every settlement line type maps to the Chart of Accounts you configure.
- FBA, referral, storage, ads, and refunds each post to their own account.
- True FIFO COGS from purchase price plus landed cost rides with each sale.
- FBA, AWD, and removal movements update inventory asset in real time.
- One deposit-sized journal clears bank rules — detail stays in NeonPanel for audit.
Clean entries, every time
Integrate Amazon with QuickBooks Online the way finance expects — mapped settlements, FIFO COGS, fee accounts, and inventory journals on every close.
How it works
Connect Your Accounts
OAuth Seller Central and QuickBooks Online. No shared passwords.
Configure Your Mapping
Point fees, refunds, COGS, tax, and revenue types at the right accounts.
Automate & Sync
Each settlement posts payouts, fees, inventory moves, and COGS on the schedule Amazon closes.
Most sellers discover the rest after they see the P&L
Clean Amazon → QuickBooks is the foundation. Same ledger supports multi-warehouse inventory, replenishment, FBA shipment automation, and SKU-level margin. Start with accounting; add modules as you scale.
Multi-warehouse inventory
FBA, AWD, 3PL, and FBM stock on one transaction layer that feeds COGS and valuation.
Replenishment
Reorder points and PO planning against real stock, including what is still inbound.
Ecommerce accounting on NeonPanel
How Accounting & Finance, inventory resolution, and the cost engine fit together.
Reconciliation-only tools
Compare settlement parsers that stop at the bank deposit vs a full operating ledger.
Amazon Seller Central to QuickBooks Online — the actual integration
Goal: each Seller Central settlement becomes one mapped QuickBooks Online journal (plus COGS), sized to the bank deposit, with line detail retained in NeonPanel. Steps below match how operators and accountants set this up.
-
Step 1 — Connect Seller Central via SP-API
OAuth through Seller Central to Selling Partner API (SP-API). NeonPanel ingests settlements, orders, FBA fees, ads, tax, refunds, reimbursements, and inventory movements.
-
Step 2 — Map the Seller Central transaction set to your QuickBooks Chart of Accounts
Typical QuickBooks Online mapping for the Seller Central set:
- Sales → revenue accounts split by SKU group, product line, or marketplace.
- Referral fees, FBA fulfilment fees, FBA storage, long-term storage, removal, return processing, inbound placement → separate fee accounts so each is reportable.
- Advertising spend → marketing expense, optionally split by campaign type.
- Refunds & reimbursements → contra-revenue and other-income accounts respectively.
- Marketplace-collected sales tax → held separately from seller-collected tax to keep liability accounts clean.
- FBA inventory movements → inventory asset adjustments and COGS entries.
-
Step 3 — Post one summary journal per settlement
One summary journal per settlement period keeps QuickBooks Online fast. Line items stay in NeonPanel. The journal total matches the Amazon deposit so bank rules clear in one step.
-
Step 4 — Attach true FIFO COGS
COGS on each summary uses true FIFO from purchase price plus landed cost (freight, duties, insurance), so margin tracks batches instead of a static average.
-
Step 5 — Backfill history, then run continuously
Backfill from a chosen go-live date, then let new settlements post on their own cadence.
One deposit, one journal — detail stays in NeonPanel
Summary journals keep QuickBooks Online fast while NeonPanel retains every settlement line for audit. The posted total matches the Amazon deposit so bank reconciliation clears in one step.
Pair this with multi-warehouse inventory tracking, forecasting & replenishment, and ecommerce accounting on NeonPanel for the full operating picture.
Sync Everything
Catalogs
Including Products, Services, Customers, Vendors, and Currencies
Charts of Accounts
Use the default Chart of Accounts tailored for Amazon sellers or customize your own
Bills
Bills, purchase orders, and expenses synced in real-time
Invoices & FIFO COGS
Sales invoices sync alongside true Cost of Goods Sold calculated with the FIFO method
Eight specialists for your business
NeonPanel ships domain agents for replenishment, supply chain, accounting, forecasting, market intel, and more — on the same FIFO ledger and shipment-level inventory your ops and finance already use. Ask in Claude, Slack, or your own MCP client; the numbers stay one conversation.
- Dorian Replenishment PO timing, reorder points, and stockout risk from live velocity
- Nina Supply chain Shipment ETAs, warehouse balances, and inbound reconciliation
- Mark Marketing research Listing audits, keyword research, and PPC waste checks
- Marta Accounting P&L, COGS accuracy, and settlement reconciliation
- Kio Forecasting Demand scenarios, coverage gaps, and sell-through outlook
- April Market intel Share shifts, keyword gaps, and competitive moves
- Sanjay Financial analysis Cash planning, margin drivers, and portfolio roll-ups
- Neon Onboarding & CS Setup, Chart of Accounts mapping, and day-to-day help Also in site chat ↓
Recommendations land on real FIFO batch costs, not industry averages.
Essentials vs Professional
Both plans run Accounting & Finance on the same ledger into QuickBooks or Xero. The difference is inventory resolution — single-location on Essentials, shipment-level on Professional.
Essentials
Multi-channel journals into QuickBooks or Xero, with inventory modeled as one location and costs at the PO average.
Professional
Shipment-level inventory across FBA, AWD, and 3PL, true FIFO at the batch, and multi-entity consolidated P&L.
Amazon Seller Central to QuickBooks — Frequently Asked Questions
Authorise NeonPanel against Amazon Seller Central via the Selling Partner API and against QuickBooks Online via OAuth. Choose how Amazon transaction types should map to your QuickBooks Chart of Accounts, then enable the sync. NeonPanel posts one summary journal per Amazon settlement, with true FIFO COGS attached, sized to match the bank deposit.
Every FBA fee type — fulfilment, storage, long-term storage, removal, return processing, inbound placement — is categorised separately and posted to its own account in QuickBooks Online. That makes channel-level and SKU-level margin analysis meaningful instead of dumping everything into a single 'Amazon fees' bucket.
Customer refunds are posted as contra-revenue against the original sales account so net revenue stays accurate. Amazon reimbursements (lost or damaged inventory) are posted to a dedicated other-income account so they are not confused with sales.
Yes. Marketplace-collected sales tax (where Amazon remits on your behalf) is held in a separate liability account from seller-collected tax to keep your QuickBooks liability records clean and audit-ready.
NeonPanel calculates COGS on a true FIFO basis using actual purchase costs and landed costs (freight, duties, insurance) for each inbound batch. The COGS posted alongside each Amazon settlement reflects what the inventory really cost — not an average.
Yes. Multiple Seller Central marketplaces (US, UK, EU, CA, etc.) and multiple seller accounts can be connected and rolled up into a single QuickBooks Online company. Channel-level reporting is preserved using QuickBooks classes or locations.
Yes. Settlements post in their native currency and respect QuickBooks Online's multi-currency configuration so foreign currency gain/loss is handled inside QuickBooks rather than estimated in spreadsheets.
Yes. NeonPanel can backfill historical Amazon Seller Central data into QuickBooks Online from a chosen start date so books are complete from day one of the integration.
Yes. Professional plans include onboarding calls. The team works alongside your accountant to configure NeonPanel, the Amazon connection, and the QuickBooks Chart of Accounts mapping so the integration matches your business structure.