Amazon Payment Reconciliation 2025: Step-by-Step Guide to Track Every Rupee

What is Amazon Payment Reconciliation?

Amazon Payment Reconciliation is the process of matching your Amazon settlement reports with your actual sales, returns, fees, and bank deposits. It ensures you receive every rupee you're owed and helps identify discrepancies before they become costly problems.

For Indian sellers, proper reconciliation is critical because:

• GST compliance: Accurate records for tax filing
• Profit tracking: Know your true margins
• Fee verification: Catch overcharges and errors
• Cash flow management: Predict incoming payments

Understanding Amazon's Payment Cycle

How Amazon Pays Sellers in India

Amazon India follows a specific payment schedule:

• Payment frequency: Every 7 days (weekly settlements)
• Settlement period: Covers sales from previous 7 days
• Bank transfer time: 3-5 business days after settlement
• Minimum payout: ₹1 (no minimum threshold)

Settlement Report Components

Each settlement includes these key elements:

• Product Sales: Revenue from items sold
• Shipping Credits: Customer-paid shipping fees
• Promotional Rebates: Lightning deals, coupons costs
• A-to-Z Claims: Refunds from guarantee claims
• Amazon Fees: Referral, closing, FBA fees
• Refunds: Customer return refunds
• Adjustments: Corrections and reimbursements

Step-by-Step Payment Reconciliation Process

Step 1: Download Essential Reports

Access these reports from Seller Central → Reports → Payments:

1. Settlement Report: Detailed breakdown of each settlement
2. Date Range Report: Custom period transaction details
3. All Statements: Historical settlement summaries

Additionally, download from Reports → Business Reports:

• Sales and Traffic Report: Order-level sales data
• Orders Report: Individual order details

Step 2: Create Your Reconciliation Spreadsheet

Set up a master spreadsheet with these columns:

• Order ID
• Order Date
• Product SKU/ASIN
• Sale Amount
• Shipping Charges
• Amazon Fees (itemized)
• Net Amount
• Settlement ID
• Settlement Date
• Bank Deposit Date
• Reconciliation Status

Step 3: Match Orders to Settlements

Follow this process for each settlement period:

1. Export the settlement report for the period
2. Export the orders report for the same period
3. Match each order ID from sales to settlement entries
4. Verify the amounts match (sale price - fees = settlement amount)
5. Flag any discrepancies for investigation

Step 4: Verify Fee Calculations

Check each fee type against Amazon's published rates:

Referral Fees by Category:

• Electronics: 5-12%
• Fashion & Apparel: 17-22%
• Home & Kitchen: 12-15%
• Books: 12%
• FMCG/Grocery: 8-15%

Closing Fees:

• ₹4-67 based on order value and category
• Lower for Easy Ship, higher for self-ship

FBA Fees (if applicable):

• Pick & Pack: ₹14-242 based on size/weight
• Weight Handling: ₹15-185 per unit
• Storage: ₹28-80 per cubic foot/month

Step 5: Track Returns and Refunds

Returns affect your settlements significantly:

1. Download Returns Report from Seller Central
2. Match each return to the original order
3. Verify refund amount matches sale amount
4. Check if referral fee was credited back (it should be)
5. Track restocking fees if applicable

Key points for returns reconciliation:

• Amazon refunds the referral fee for returned items
• FBA fees are NOT refunded for returns
• Customer refund appears in next settlement
• Returned inventory should appear back in stock

Step 6: Verify Bank Deposits

Match settlements to actual bank credits:

1. Note the settlement amount from Amazon
2. Add 3-5 business days for bank processing
3. Match the exact amount in your bank statement
4. Record the actual deposit date
5. Flag any amount mismatches

Common Discrepancies and How to Fix Them

1. Missing Orders in Settlement

Possible causes:

• Order in next settlement period
• Order pending shipment confirmation
• Order under A-to-Z claim investigation

Solution: Check order status in Manage Orders. If shipped and delivered, wait for next settlement or contact Seller Support.

2. Incorrect Fee Deductions

Possible causes:

• Wrong category classification
• Incorrect product dimensions
• System errors

Solution: Open a case with Seller Support with order ID and expected vs. actual fee breakdown.

3. Settlement Amount Doesn't Match Bank Deposit

Possible causes:

• TDS deduction (2% of gross sales if PAN not updated)
• Outstanding negative balance adjustment
• Multiple settlements combined

Solution: Check TDS section in Seller Central. Download 26AS to verify TDS credits.

4. Duplicate Refund Deductions

Possible causes:

• Customer refunded twice by mistake
• Replacement order also refunded

Solution: Document with order IDs and refund amounts, then open a reimbursement case.

5. Missing Reimbursements

Possible causes:

• FBA inventory lost/damaged
• Customer return not received
• Inbound shipment discrepancy

Solution: File reimbursement claims within 18 months using Inventory Adjustments Report.

Reconciliation Tools and Automation

Excel/Google Sheets Method

For sellers with fewer than 500 orders/month:

• VLOOKUP to match order IDs across reports
• Pivot tables for fee analysis
• Conditional formatting for discrepancies
• Monthly templates for consistency

Key Formulas for Reconciliation

Use these formulas in your spreadsheet:

• Expected Net: =Sale Amount - (Referral Fee + Closing Fee + FBA Fees)
• Discrepancy: =Expected Net - Actual Settlement Amount
• Referral Fee Check: =Sale Amount * Category Rate
• Match Status: =IF(ABS(Discrepancy)<1, "Matched", "Review")

Professional Reconciliation Services

Consider professional help if you have:

• 1000+ orders per month
• Multiple Amazon accounts
• FBA operations across fulfillment centers
• Significant returns volume
• Complex promotional activities

Monthly Reconciliation Checklist

Complete these tasks every month:

1. ☐ Download all settlement reports for the month
2. ☐ Export orders and returns reports
3. ☐ Match each order to settlement entries
4. ☐ Verify all fees against published rates
5. ☐ Reconcile returns and refunds
6. ☐ Match settlements to bank deposits
7. ☐ File claims for any discrepancies
8. ☐ Update GST records with reconciled data
9. ☐ Document any pending investigations
10. ☐ Prepare summary report for accounting

GST Reconciliation for Amazon Sellers

Integrate payment reconciliation with GST compliance:

GSTR-1 Filing

• Report B2C sales from settlement reports
• Match invoice numbers with Amazon order IDs
• Include credit notes for returns
• Report TCS collected by Amazon separately

GSTR-3B Filing

• Declare total outward supplies from reconciled sales
• Claim ITC on Amazon fees (they charge GST)
• Adjust for returns and credit notes

TCS (Tax Collected at Source)

• Amazon collects 1% TCS on net sales
• Reflected in Form 26AS
• Claim credit while filing income tax
• Reconcile TCS monthly with settlements

Best Practices for Accurate Reconciliation

Daily Habits

• Check order fulfillment status
• Monitor return requests
• Note any A-to-Z claims immediately

Weekly Tasks

• Download and review settlement reports
• Match high-value orders to settlements
• Track pending bank deposits

Monthly Reviews

• Complete full reconciliation
• Analyze fee trends
• File any reimbursement claims
• Update accounting records

When to Seek Professional Help

Consider hiring an Amazon account management agency for reconciliation if:

• You're losing more than 2% to unidentified discrepancies
• Reconciliation takes more than 10 hours/month
• You've missed reimbursement claims
• GST notices due to mismatch in records
• Scaling to multiple marketplaces

Professional services typically recover 2-5% of revenue through proper reconciliation and reimbursement claims—often paying for themselves many times over.

Conclusion

Payment reconciliation might seem tedious, but it's essential for running a profitable Amazon business. By following this step-by-step process, you'll catch discrepancies early, recover money you're owed, and maintain accurate financial records for tax compliance.

Start with manual reconciliation to understand the process, then consider automation or professional help as you scale. Every rupee recovered goes directly to your bottom line.