Can anyone confirm that there's no way to calculate Refund Administration Fees, reported in the Summary Report (*.pdf), from any data that can be found in the Transaction Report (*.csv)?

Both reports are found in the Reports Repository, accessible on the Payments Dashboard page of Seller Central.

Here is how we calculate values that match the Summary Report (*.pdf), using values in the Transaction Report (*.csv), filtered by date.

We'd appreciate any comments or corrections:

• Product Sales: sum of 'product sales' values that are > 0
• Product Sale Refunds: sum of 'product sales' values that are < 0
• FBA Inventory Credit: sum of 'other' values that are > 0
• Shipping Credits: sum of 'shipping credits' values that are > 0
• Shipping Credit Refunds: sum of 'shipping credits' values that are < 0
• Gift wrap credits: sum of 'gift wrap credits' values that are > 0
• Gift wrap credit refunds: sum of 'gift wrap credits' values that are < 0
• Promotional Rebates: sum of 'promotional rebates' values that are < 0
• Promotional Rebate Refunds: sum of 'promotional rebates' values that are > 0
• FBA Selling Fees: sum of 'selling fees' values that are < 0
• Selling Fee Refunds (Less Refund Administration Fees): sum of 'selling fees' values that are > 0
• FBA Transaction Fees: sum of 'fba fees' values that are < 0
• FBA Transaction Fee Refunds: sum of 'fba fees' values that are > 0
• FBA Inventory and Inbound Service Fees: sum of 'other' values with 'type' that is "FBA Inventory Fee"
• Service Fees: sum of 'other' values with 'type' that is "Service Fee"
• Refund Administration Fees: (Debited from Selling Fee Refunds, not reported separately)
• Adjustments: sum of 'other' values with 'type' that is "Adjustment"
• Cost of Advertising: sum of 'other transaction fees' with 'description' that is "Cost of Advertising"
• Product, shipping, gift wrap taxes and regulatory fee collected: sum of 'product sales tax' values that are > 0, plus sum of 'shipping credits tax' values that are > 0
• Product, shipping, gift wrap taxes and regulatory fee refunded: sum of 'product sales tax' values that are < 0, plus sum of 'shipping credits tax' values that are < 0
• Amazon Obligated Tax and Regulatory Fee Withheld: sum of 'marketplace withheld tax' values

We use Excel to calculate and chart our planning metrics based on these values, along with internal numbers like Cost of Goods Sold.

Thanks in advance.