Amazon settlements, FBA data, and ad reports — in one connection
Simentri imports Amazon Seller Central settlement data and Amazon Advertising reports so you can monitor profit leakage, run FBA audits, and post clean journal entries to QuickBooks.
Amazon Seller Central data
Settlement, order, and inventory data from Seller Central — used for bookkeeping, FBA reimbursement audits, and profit leakage reporting.
Settlement reports
Biweekly settlement statements parsed line by line — sales, fees, refunds, reimbursements, advertising charges, and net deposit.
FBA & FBM orders
Gross product sales and shipping revenue, separated by fulfillment type for reconciliation and reporting.
Fees & deductions
Referral fees, FBA fulfillment, storage, subscription, refund administration, and other Seller Central charges.
Refunds & returns
Product and shipping refunds tracked separately so return rates stay visible in your books and reports.
FBA inventory & reimbursements
Inventory events, lost and damaged unit discrepancies, and reimbursement history for FBA audit workflows.
Amazon Advertising reports
Simentri imports Amazon Ads report data for PPC leakage analysis, weekly insight summaries, and advertising spend visibility alongside your settlements.
Performance reports
Campaign performance
Spend, sales, orders, ACOS, and ROAS by campaign — including budget and status context.
Ad group performance
Ad group-level spend, conversion, and efficiency metrics across active campaigns.
Advertised product (ASIN) reports
Product-level ad efficiency — which ASINs drive ad-attributed sales and which underperform.
Targeting & search reports
Search term reports
Customer search queries with clicks, spend, orders, and sales — including terms with spend but no conversions.
Targeting reports
Keyword, product target, and category target performance with bid and match-type context.
Placement reports
Top of search, rest of search, and product page placement performance for bid and budget decisions.
Metrics used in profit leakage analysis
Spend, sales & orders
Weekly and rolling-window totals used to rank leakage issues by estimated dollar impact.
ACOS, ROAS & TCOS
Efficiency metrics compared against your targets and prior periods.
Week-over-week trends
Campaign drift, worsening targets, and budget-constrained segments surfaced for review.
Report coverage includes Sponsored Products. Sponsored Brands and Sponsored Display support may vary by account — contact us if you need a specific ad type confirmed.
QuickBooks account mapping
Settlement line items from Seller Central map to dedicated QuickBooks accounts — including Amazon Advertising as an expense line. See QuickBooks integration details →
| Settlement line item | QuickBooks account type |
|---|---|
| Product Sales | Income |
| Shipping Revenue | Income |
| FBA Inventory Credits | Other Income |
| FBA Liquidation Proceeds | Other Income |
| Product Refunds | Income (contra) |
| Amazon Referral Fees | Expense |
| Refund Administration Fees | Expense |
| FBA Fulfillment Fees | Expense |
| FBA Storage & Service Fees | Expense |
| Amazon Advertising | Expense |
| Professional Selling Plan Fee | Expense |
| A-to-Z Claims & Chargebacks | Expense |
| Marketplace Facilitator Tax | Other Current Liability, passthrough |
| Net Payout | Bank Account |
How Amazon connection works
Connect Amazon securely
Authorize Seller Central and Amazon Advertising access. Simentri uses read-only data import — we do not change listings, orders, or campaigns without your approval.
Simentri imports your reports
Settlements, FBA inventory events, and Amazon Ads reports are synced for profit leakage analysis, reimbursement audits, and optional QuickBooks posting.
Review insights and post to QuickBooks
See PPC and FBA findings in your leakage report. Settlement journal entries can post to QuickBooks with accounts you configure.
Amazon PPC
Amazon PPC Profit Leakage
Search term waste, high ACOS targets, placement issues, and campaign drift — ranked by estimated dollar impact.
Find PPC Leakage →FBA Reimbursements
Amazon FBA Reimbursements
Lost and damaged inventory audits with claim-ready details for review and submission.
Start Free FBA Audit →