Amazon FBA Profit Reconciliation: Match Settlements, Fees, Refunds & Bank Deposits by SKU
Sean Travis
Founder · Kaldon
Amazon FBA profit reconciliation means matching every settlement transaction, fee, refund, inventory adjustment, and bank deposit to the correct SKU and order. Most sellers track revenue but skip the reconciliation step that connects Seller Central reports to actual cash in the bank. This guide walks through a five-step workflow: pull settlement and transaction reports, match orders to payouts, reconcile fees and refunds by SKU, trace inventory movements and reimbursements, and verify bank deposits against settlement totals. The goal is to identify missing transactions, reversed reimbursements, fee variances, and unexplained shrinkage before they compound into invisible margin leaks.
TLDR. Amazon FBA profit reconciliation means matching every settlement transaction, fee, refund, inventory adjustment, and bank deposit to the correct SKU and order. Most sellers track revenue but skip the reconciliation step that connects Seller Central reports to actual cash in the bank. This guide walks through a five-step workflow: pull settlement and transaction reports, match orders to payouts, reconcile fees and refunds by SKU, trace inventory movements and reimbursements, and verify bank deposits against settlement totals. The goal is to identify missing transactions, reversed reimbursements, fee variances, and unexplained shrinkage before they compound into invisible margin leaks.
What is Amazon FBA profit reconciliation?
Amazon FBA profit reconciliation is the process of verifying that every sale, fee, refund, inventory adjustment, and reimbursement in your Amazon account matches the cash deposited into your bank account, at the SKU level. It connects three data sources: Seller Central transaction reports, settlement statements, and bank deposits. Without reconciliation, you are tracking revenue, not profit, and you cannot explain discrepancies between what Seller Central says you earned and what your bank received.
Reconciliation answers three questions: Did every order generate the expected deposit? Are fees accurate and complete? Where did the missing units or dollars go? Most sellers download the All Statements report, see a payout total, and move on. Reconciliation verifies the line items inside that total. If Amazon removed a unit from inventory, you should see a transaction. If a reimbursement was reversed, you should know which SKU and why. If a fee changed mid-month, your profit model should reflect the new rate.
As of November 2026, Amazon announced that average FBA fulfillment fees will rise by $0.19 per unit, roughly 0.8 percent of the average item selling price, beginning January 15, 2027. Seasonal peak fulfillment fees added an estimated $0.32 per unit during the October 15, 2026 to January 14, 2027 window. Fee volatility makes stale per-unit profit assumptions unreliable. Reconciliation catches the difference between your forecast and what Amazon actually charged.
Why most sellers skip reconciliation and what they miss
Sellers skip reconciliation because it is slow and Seller Central does not automate it. The Business Reports tab shows revenue. The All Statements report shows payouts. The two numbers never match because revenue includes advertising spend, refunds that have not yet cleared, and inventory adjustments that do not appear in the sales report. Connecting revenue to cash requires pulling five or six reports, matching transactions by order ID or shipment ID, and identifying the gap.
What you miss when you skip reconciliation:
- Fee errors: Amazon occasionally misclassifies an ASIN, applies the wrong referral fee tier, or double-charges a fulfillment fee. The error is visible in the transaction report but hidden in the aggregated payout total.
- Reversed reimbursements: Amazon may reimburse you for a lost or damaged unit, then reverse the reimbursement weeks later if they locate the inventory or reject your claim. The reversal appears as a negative transaction. Without reconciliation, your profit dashboard still shows the original reimbursement as income.
- Inventory shrinkage: Units removed, destroyed, or marked as unsellable reduce your inventory count but do not always generate a visible sale or removal transaction. Reconciliation flags the missing units so you can file a reimbursement claim or adjust your COGS.
- Payout timing gaps: A sale that closed on the 28th may settle on the 3rd of the next month. If you close your books on the 30th, the revenue and the deposit land in different periods. Reconciliation matches the order to the correct settlement date.
- Refund accruals: Amazon extended the 2026 holiday return window through January 31, 2027 for purchases made between November 1 and December 31. December sales may generate January refunds. Without reconciliation, December profit looks inflated and January shows unexplained losses.
Reddit sellers report that Seller Central sales figures stay stable while actual profit drops after fee changes, storage charges, return costs, and advertising increases compound. The only way to detect the margin leak is to reconcile transaction-by-transaction, SKU-by-SKU.
Five-step FBA reconciliation workflow
This workflow connects settlement statements, transaction reports, inventory movements, fee charges, and bank deposits. You will need Seller Central report access, your bank statement, and a spreadsheet or reconciliation tool. The output is a line-by-line match between Amazon activity and cash received, with any discrepancies flagged for review.
Step 1: Pull settlement and transaction reports
Log into Seller Central and navigate to Reports > Payments > All Statements. Download the settlement statement for the period you are reconciling. The statement shows the total payout, but not the detail.
Next, go to Reports > Payments > Transaction View (or the equivalent report name in your Seller Central interface). Set the date range to match your settlement period. Download the full transaction CSV. This file contains every order, refund, fee, adjustment, and reimbursement that contributed to the settlement total.
If you also use FBA Inventory reports, download the Inventory Ledger report from Reports > Fulfillment. This shows inbound receipts, customer orders, removals, returns, adjustments, and inventory found or lost. The Inventory Ledger connects quantity movements to dollar movements in the transaction report.
Step 2: Match orders to settlement lines
Open your transaction report and filter by transaction type. Start with Order transactions. Each order line includes an order ID, SKU, quantity, selling price, and the settlement ID it belongs to. Group all orders by settlement ID. Sum the order revenue for that settlement. This is your gross sales figure before fees and refunds.
Compare the summed order revenue to the settlement statement total. They will not match because the settlement total is net of fees, refunds, advertising charges, and other adjustments. The goal here is not to make them match, but to confirm that every order in the transaction report ties to a settlement ID and that no orders are missing.
If you see orders in Seller Central Business Reports that do not appear in your transaction report, you have a data export issue or a reporting delay. Resolve that before continuing.
Step 3: Reconcile fees, refunds, and advertising by SKU
Filter the transaction report to show FBA fees, Refund, Advertising, and Service Fee lines. Each fee or refund should reference an order ID or SKU. Match each fee to the corresponding order. Verify that the fee amount matches Amazon’s current fee schedule. If a fulfillment fee is $0.19 higher than expected, check whether the peak fulfillment fee or updated January 2027 rates apply.
Refunds should appear as negative revenue. Confirm that each refund also reversed the associated FBA fee. If the customer received a refund but you were still charged the fulfillment fee, file a reimbursement case.
Advertising charges come from Sponsored Products, Sponsored Brands, and Sponsored Display. The transaction report shows the total ad spend for the settlement period. Cross-reference this with your Advertising Console report. If the transaction report shows $500 in ad spend but your console shows $485, investigate the $15 difference. It may be a currency rounding issue, a delayed charge, or an error.
For each SKU, calculate:
SKU net revenue = (Order revenue) - (FBA fees) - (Refunds) - (Allocated ad spend) - (Other fees)
This is your settlement-level contribution before COGS, inbound shipping, and inventory adjustments.
Step 4: Trace inventory movements and reimbursements
Open the Inventory Ledger report. For each SKU, sum the quantity changes by event type: customer orders, customer returns, warehouse damage, lost inventory, removal orders, and inventory found. Each event should correspond to a transaction in your settlement report.
If the ledger shows five units removed but you see no removal fee transaction, you may be missing a charge. If the ledger shows two units marked as damaged but you received no reimbursement, file a claim.
Reimbursements appear in the transaction report as positive adjustments. Match each reimbursement to the inventory event that triggered it. If a reimbursement was reversed, you will see a second transaction with a negative amount. Reversed reimbursements are a common source of phantom profit. Your dashboard shows the original reimbursement as income, but Amazon took the money back weeks later.
Reddit sellers who quit third-party reimbursement services cite perpetual percentage fees and reversed claims that were not tracked. The recommended workflow is to maintain a case log linking each discrepancy to shipment ID, SKU, Amazon’s ruling, and the resulting cash or inventory adjustment. This log becomes your audit trail.
Step 5: Verify bank deposits against settlement totals
Pull your bank statement for the same date range. Identify every Amazon deposit. Each deposit should match a settlement statement total. If the settlement statement says $3,427.16 and your bank shows $3,427.16, that settlement is verified.
If the deposit amount does not match the settlement total, check the settlement date and deposit date. Amazon transfers funds on a schedule, and the deposit may land one to three business days after the settlement closes. If the amounts still do not match after accounting for timing, you have a payout discrepancy. Contact Seller Support with the settlement ID and bank transaction ID.
Once every settlement is matched to a bank deposit, sum all deposits for the period. This is your actual cash received. Compare it to the sum of all settlement totals in Seller Central. If they match, your payout reconciliation is complete. If they do not, identify which settlement has no corresponding deposit or which deposit has no corresponding settlement.
Tools and methods: spreadsheet vs software
You can reconcile FBA settlements in a spreadsheet or use software that automates the matching process. The trade-off is time versus cost.
Spreadsheet reconciliation requires downloading five or six reports, using VLOOKUP or XLOOKUP to match transactions by order ID or SKU, summing fees and refunds, and flagging unmatched lines. The workflow takes two to four hours per month for a single-account seller with 500 to 2,000 orders. It is free except for your time. The advantage is full control and transparency. The disadvantage is that every fee change, new transaction type, or inventory adjustment requires updating your formulas.
Reconciliation software imports settlement and transaction reports, matches orders to fees, refunds, and payouts automatically, and flags discrepancies. As of November 2026, tools positioned around payout-to-bank-to-books reconciliation include A2X (approximately $85 per month for 5,000 orders, price increase effective November 14, 2026), Link My Books (approximately $68 per month), and Taxomate (approximately $44 per month). These tools push journal entries to QuickBooks or Xero, so your bookkeeping software reflects Amazon activity without manual entry.
Profit analytics tools such as Sellerboard (starting at $19 per month for up to 3,000 orders) and Sellerise (starting at $19.99 per month) track daily per-ASIN profit, including COGS, fees, and advertising. However, seller-focused commentary explicitly states that analytics tools are not replacements for bookkeeping software or an accountant. The key question is whether you need a profit dashboard, a settlement connector, or both.
For sellers managing multiple Amazon accounts, Shopify, Walmart, or other channels, tools such as Nova Analytics and ManageByStats offer consolidated P&L views by SKU, brand, supplier, marketplace, and account. The positioning is less “Amazon reporting” and more “one reconciled source of truth across channels.”
Kaldon includes SKU-level profit calculation and margin tracking as part of its five-phase platform. The all-in cost calculator walks through FBA fees, referral fees, PPC, COGS, and inbound shipping to calculate true unit economics before launch. The multichannel profit reporting framework extends reconciliation across Amazon, Shopify, Walmart, and TikTok Shop, surfacing discrepancies that single-channel tools miss. Sign up for Kaldon to automate SKU-level reconciliation and margin tracking in one platform.
Common reconciliation discrepancies and how to resolve them
Missing transactions
A transaction appears in Seller Central but not in your downloaded report, or vice versa. This usually results from report date range mismatches, delayed transaction posting, or filtering errors. Re-download the transaction report with a wider date range. If the transaction still does not appear, contact Seller Support with the order ID or transaction ID.
Fee variances
The FBA fee charged does not match the fee schedule or your forecast. Amazon occasionally reclassifies ASINs, moving them from one fee tier to another. Check the Fee Preview report in Seller Central for the ASIN in question. If the fee tier changed, update your profit model. If the fee is incorrect, open a fee dispute case with the order ID and expected fee calculation.
Reversed reimbursements
You received a reimbursement for lost or damaged inventory, but weeks later Amazon reversed it. The reversal appears as a negative transaction in the settlement report. Your profit dashboard may still count the original reimbursement as income. Flag all negative reimbursement transactions and link them to the original claim. If the reversal is incorrect, reopen the case with evidence.
Inventory shrinkage
Your Inventory Ledger shows fewer units than expected, but no removal, damage, or lost-inventory transaction appears. This is unexplained shrinkage. File a reimbursement case for each missing unit, citing the shipment ID, expected quantity, and ledger discrepancy. Amazon may reimburse you or provide documentation explaining the reduction.
Payout timing gaps
A sale closes on the 28th but settles on the 3rd of the next month. Your bank deposit lands on the 5th. If you close your books on the 30th, the revenue and cash appear in different months. Reconciliation matches the order to the settlement date, not the order date. Accrual accounting records revenue when earned, cash accounting records it when deposited. Choose one method and apply it consistently.
When to reconcile: monthly, weekly, or real-time
How often you reconcile depends on order volume, margin pressure, and whether you are managing cash flow or preparing financial statements.
Monthly reconciliation works for sellers with stable SKUs, predictable fees, and low return rates. Close reconciliation at month-end, verify that settlements match bank deposits, and pass the reconciled totals to your bookkeeper or tax preparer. This is the minimum frequency for accurate financial reporting.
Weekly reconciliation suits sellers with high order volume, frequent promotions, or thin margins. Weekly reconciliation catches fee errors, reversed reimbursements, and inventory discrepancies before they accumulate. It also improves cash-flow forecasting because you know which settlements are pending and which have deposited.
Real-time reconciliation requires software that imports transactions daily or hourly. Tools such as A2X, Taxomate, and accounting-focused integrations sync Amazon activity to your bookkeeping system continuously. Real-time reconciliation is overkill for most sellers, but it eliminates month-end data crunches and provides up-to-date profit visibility.
Choose the frequency that matches your reporting needs and margin risk. If a $0.19 fee increase per unit changes your SKU from profitable to breakeven, weekly or real-time reconciliation is worth the effort.
Reconciliation for multi-account and multichannel sellers
Sellers with multiple Amazon accounts, Walmart Marketplace, Shopify, or TikTok Shop need consolidated reconciliation that matches settlements and deposits across all channels to a single source of truth. Each marketplace uses different fee structures, settlement schedules, and transaction report formats. Reconciling by channel and then consolidating by SKU is the most reliable workflow.
For each marketplace:
- Download settlement and transaction reports
- Match orders to settlements
- Reconcile fees, refunds, and advertising by SKU
- Trace inventory movements and adjustments
- Verify bank deposits
Then consolidate all channels into a master SKU-level P&L. Calculate:
Total SKU profit = (Amazon net revenue) + (Walmart net revenue) + (Shopify net revenue) - (Shared COGS) - (Shared inbound shipping) - (Shared ad spend across channels)
This consolidated view reveals which SKUs are profitable across the portfolio and which are only profitable on one channel. It also surfaces cross-channel inventory issues, such as a SKU that is out of stock on Amazon but overstocked on Shopify.
Kaldon’s multichannel profit reporting framework automates this consolidation, pulling data from Amazon, Walmart, Shopify, and TikTok Shop into a single reconciled view. The risk-adjusted margin calculator extends reconciliation to include return rates, stockout risk, and cash tied up in inventory, giving you a complete picture of SKU-level profitability.
What to do when reconciliation reveals a margin leak
Reconciliation surfaces problems. Once you identify a discrepancy, the next step is deciding whether to fix the process, dispute the charge, or cut the SKU.
Fee errors and misclassifications: Open a fee dispute case in Seller Central. Provide the order ID, expected fee, actual fee charged, and a link to Amazon’s fee schedule. Amazon will review and issue a credit if the fee was incorrect. If the fee is correct but higher than expected, update your profit model and decide whether the SKU remains viable.
Reversed reimbursements: Reopen the reimbursement case with evidence. If Amazon’s reversal is incorrect, provide shipment documentation, photos, or tracking that supports your claim. If the reversal is correct, adjust your inventory records and remove the phantom income from your dashboard.
Unexplained shrinkage: File a reimbursement claim for each missing unit. If Amazon denies the claim, review your shipment documentation and consider whether the loss is a one-time event or a pattern. Repeated shrinkage for a single SKU may indicate packaging damage, warehouse handling issues, or theft.
Margin compression from fee increases: Recalculate unit economics with the new fee schedule. If the SKU is no longer profitable, you have three options: raise the price, reduce COGS by renegotiating with your supplier or switching manufacturers, or discontinue the SKU. Do not assume you can absorb the fee increase without action. Fee increases compound over time, and a $0.19 per-unit increase on a $15 product is a 1.3 percent margin hit that may flip a profitable SKU to breakeven.
Cash-flow gaps from payout timing: Adjust your cash-flow forecast to account for the settlement schedule. Amazon settles every two weeks by default, but you can request daily payouts if you meet eligibility requirements. If a payout timing gap is creating cash-flow stress, consider a line of credit or factoring service to bridge the gap. Do not rely on settlements to arrive on a specific date without verifying the schedule.
Reconciliation as competitive advantage
Most sellers track revenue. Fewer reconcile settlements. Even fewer reconcile by SKU. Reconciliation is not exciting, but it is the difference between knowing your revenue and knowing your profit. It catches fee errors, reversed reimbursements, inventory shrinkage, and margin leaks before they compound into invisible losses.
Reconciliation also builds trust with your bookkeeper, accountant, and bank. When you apply for a loan or prepare for acquisition, buyers and lenders want to see reconciled financials. A profit dashboard that does not tie to bank deposits is not sufficient. They want to see the audit trail: order to settlement to deposit, SKU by SKU, month by month.
Kaldon automates the reconciliation workflow by pulling Amazon data, calculating SKU-level profit, flagging discrepancies, and connecting settlements to deposits. The platform replaces the six-plus tools most sellers stack to track profit, fees, inventory, and cash flow. The Kaldon Discover phase identifies products with unmet demand that the market is paying for but nobody is shipping yet. The Build and Create phases calculate all-in costs and generate listings. The Launch and Grow phases track profit, reconcile settlements, and surface margin leaks in real time. Start your free trial to reconcile FBA profit by SKU and eliminate the gap between Seller Central revenue and actual cash in the bank.
Frequently asked questions
How often should I reconcile Amazon FBA settlements?
Monthly reconciliation is the minimum for accurate financial reporting. Weekly reconciliation is better if you have high order volume, frequent promotions, or thin margins. Real-time reconciliation requires software but eliminates month-end crunches and provides daily profit visibility.
What is the difference between revenue and reconciled profit?
Revenue is the total you sold. Reconciled profit subtracts FBA fees, referral fees, refunds, advertising spend, and inventory adjustments, then verifies that the result matches your bank deposit. Most sellers track revenue but skip the reconciliation step that connects Seller Central reports to actual cash.
Can I reconcile FBA settlements in a spreadsheet or do I need software?
You can reconcile in a spreadsheet using VLOOKUP to match orders, fees, and payouts, but it takes two to four hours per month. Software such as A2X, Link My Books, or Kaldon automates the matching and flags discrepancies, saving time and reducing errors.
What should I do if a reimbursement was reversed?
Flag the negative transaction and link it to the original claim. If the reversal is incorrect, reopen the case with evidence. If it is correct, remove the phantom income from your profit dashboard and adjust your inventory records.
How do I reconcile FBA profit across multiple marketplaces?
Download settlement and transaction reports for each marketplace, reconcile fees and deposits by channel, then consolidate by SKU into a master P&L. Calculate total SKU profit by summing net revenue across Amazon, Walmart, Shopify, and TikTok Shop, then subtracting shared COGS and advertising.
Sources & citations
- https://www.reddit.com/r/FulfillmentByAmazon/comments/1xu86y7/question_for_amazon_sellers_how_do_you_reconcile/
- https://www.reddit.com/r/AmazonFBA/comments/1x48xqu/amazon_fba_sellers_whats_your_biggest_challenge/
- https://www.reddit.com/r/AmazonFBA/comments/1xsqotu/looking_for_help/
- https://www.reddit.com/r/AmazonFBA/comments/1x5njlp/45_years_selling_on_amazon_fbafbm_from_4kmonth_to/
- https://www.reddit.com/r/AmazonFBA/comments/1xrgkag/experienced_amazon_fba_sellers_how_did_you_go/
- https://www.reddit.com/r/amazon/comments/1xrnsr5/weekly_help_and_discussion_thread_for_the_week_of/
- https://www.reddit.com/r/AmazonFBA/comments/1xbdeij/new_seller_and_a_very_quiet_seller_central/
- https://www.reddit.com/r/AmazonFBA/comments/1xsc6z6/amazon_wholesale/
- https://www.reddit.com/r/AmazonFBA/comments/1xtp9gf/issues_finding_profitable_products/
- https://www.reddit.com/r/AmazonFBA/comments/1xs8zby/new_to_fba/
- https://www.sellerforge.ai/blog/is-sellerboard-worth-it
- https://sellersonar.com/blog/compare/sellersonar-vs-sellerise/
- https://www.sellerforge.ai/blog/best-amazon-accounting-software
- https://www.lilachbullock.com/best-accounting-software-for-ecommerce/
- https://sellercentral.amazon.com/selling-partner-appstore/dp/amzn1.sellerapps.app.b7aae386-89f7-499f-8ad4-9b7572b71cb5?ld=ASHISPAPIDirect&pageName=US:SPDS:SPAPI-BRIGHTSPOT-grow/amazon-business-b2b-api-sp-api-%E0%A4%95-%E0%A4%B8-%E0%A4%A5-%E0%A4%AC-%E0%A4%9A
Last updated Nov 12, 2026
See the pipeline for yourself.
Start with 2 free analyses. No credit card required.