@Seller_D4vk0AXyR6aWw

Following up on your post. I understand your need to reconcile Amazon fees between invoices and payment reports. Let me break this down into a practical approach:

-Understanding the Timing Difference

• Amazon fee invoices in the Tax Document Library are typically issued monthly
• Payment reports show fees as they occur throughout the month
• This timing difference is the first key to reconciliation

-Recommended Reconciliation Process:

Step 1: Document Gathering

• Download your monthly invoice from Tax Document Library
• Export your Payment reports for the corresponding period
• Ensure you have your Order Reports for the same timeframe

Step 2: Basic Reconciliation

• Total all fees from your Payment reports for the month
• Compare this with your monthly invoice total
• They should match, though timing differences at month-end might cause small variations

Step 3: Detailed Order Matching

• Use your Order ID as the key identifier: you can create a spreadsheet with columns for Order ID, Fee Type, Fee Amount and Invoice Reference.

Many sellers find it helpful to maintain their own tracking system, whether through spreadsheets or accounting software, to match fees to specific orders as they occur rather than trying to reconcile everything retrospectively.

For detailed fee breakdowns, you can:

• Use Order Reports to see individual order fees
• Cross-reference with Transaction Reports for specific fee types
• Utilize the Fee Preview Report for estimated fees

I hope this helps provide a structured approach to your reconciliation process. Any assistance, don’t hesitate to reach out to our support channel.

Regards,

JiAlex