---
title: "Comparing with Amazon's Payment Date Range Summary Report"
description: "How to compare Amazon's Payment Date Range Summary report with the settlements Taxomate imports."
url: https://docs.taxomate.com/en/articles/6180566-comparing-with-amazon-s-payment-date-range-summary-report
collection: "Reports"
updated: 2026-10-20
language: en
---

# Comparing with Amazon's Payment Date Range Summary Report

How to compare Amazon's Payment Date Range Summary report with the settlements Taxomate imports.

We often get asked why XYZ data in QuickBooks/Xero/Wave does not match up with the Payment Date Range Summary in Amazon. We use the Payment Settlement Report since this contains the most detailed financial report and coincides with the timing of your payouts.

To find this report in Amazon Seller Central, select Reports > Payments > Date Range Reports. You will then want to select Generate Report and then pick the summary and the respective month.

Unfortunately, these reports do not match up directly, and to cause more confusion, Amazon sometimes assigns different meanings for the same terms.

The chart below reflects our attempt to map the Line Items in the Date Range Summary Report with the transaction types found on the **Accounts and taxes** page. If you would like to have the information in your accounting software match up to this Summary Report, you may want to create additional accounts in your Chart of Accounts.

<table style="min-width: 75px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><th colspan="1" rowspan="1"><p style="text-align: left;">Amazon Date Range Category</p></th><th colspan="1" rowspan="1"><p style="text-align: left;">Amazon Date Range Line Item</p></th><th colspan="1" rowspan="1"><p style="text-align: left;">Taxomate Transaction Type (from Amazon Settlement Report)</p></th></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Product sales (non-FBA)</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Order ItemPrice Principal</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Product sale refunds (non-FBA)</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">A-to-z Guarantee Refund ItemPrice Principal; Chargeback Refund ItemPrice Principal; Refund ItemPrice Principal; Refund ItemPrice Goodwill</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">FBA product sales</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Order ItemPrice Principal</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">FBA product sale refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Chargeback Refund ItemPrice Principal; Refund ItemPrice RestockingFee; Chargeback Refund ItemPrice RestockingFee; Refund ItemPrice Principal; Refund ItemPrice Goodwill</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">FBA inventory credit</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">All "Reimbursement" Transaction Types (excluding those in Adjustments)</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">FBA liquidation proceeds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">\<em>\</em>\*</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Shipping credit</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Order ItemPrice Shipping</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Shipping credit refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">A-to-z Guarantee Refund ItemPrice Shipping; Chargeback Refund ItemPrice Shipping; Refund ItemPrice ReturnShipping; Refund ItemPrice Shipping</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Gift wrap credits</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Order ItemPrice GiftWrap</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Gift wrap credit refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Chargeback Refund ItemFees GiftwrapChargeback; Chargeback Refund ItemPrice GiftWrap; Refund ItemPrice GiftWrap</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Promotional rebates</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Order Promotion Principal; Order Promotion Shipping</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Promotional rebate refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Refund Promotion Principal; Refund Promotion Shipping</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">A-to-z Guarantee claims</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">A-to-z Guarantee Refund ItemPrice Principal</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Chargebacks</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">\<em>\</em>\*</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Amazon Shipping Reimbursement</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">\<em>\</em>\*</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Income</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">SAFE-T reimbursement</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Commissions and Selling Fees</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">FBA selling fees</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Commissions and Selling Fees</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Selling fee refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Commissions and Selling Fees</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">FBA transaction fees; FBA transaction fee refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Fulfillment and Warehousing</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Other transaction fees; Other transaction fee refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">All "Other" Transaction Types</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">FBA inventory and inbound services fees</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">All "Delivery and Transport" Transaction Types</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Shipping label purchases</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Other-transaction other-transaction Shipping label purchase (Shipping Expense)</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Shipping label refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Other-transaction other-transaction Shipping label purchase for return (Shipping Expense)</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Carrier shipping label adjustments</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">\<em>\</em>\*</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Service fees</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">All "Subscription and Service Fees" Transaction Types</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Refund administration fees</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Refund ItemFees RefundCommission</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Adjustments</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Other-transaction Other-transaction Adjustment; Other-transaction Other-transaction BalanceAdjustment; Other-transaction FBA Inventory Reimbursement COMPENSATED CLAWBACK; Other-transaction FBA Inventory Reimbursement General Adjustment; Other-transaction FBA Inventory Reimbursement MISSING FROM INBOUND CLAWBACK; Other-transaction FBA Inventory Reimbursement PAYMENT RETRACTION ITEMS; Other-transaction FBA Inventory Reimbursement Return Adjustment</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Cost of Advertising</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Lightning Deal Fee LightningDealFee LightningDealFee; Lightning Deal Fee LightningDealFee LightningDealFee Special; ServiceFee Cost Of Advertising TransactionTotalAmount</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Refund for Advertiser</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">ServiceFee Refund For Advertiser</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Expenses</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Liquidations brokerage fee</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">\<em>\</em>\*</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Sales Tax</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Sales, shipping, and gift wrap tax collected</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Order ItemPrice GiftWrapTax; Order ItemPrice ShippingTax; Order ItemPrice Tax; Order Retrocharge ItemPrice ShippingTax; Order Retrocharge ItemPrice Tax</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Sales Tax</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Sales tax refunds</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">A-to-z Guarantee Refund ItemPrice ShippingTax; A-to-z Guarantee Refund ItemPrice Tax; Chargeback Refund ItemPrice Tax; Refund ItemPrice GiftWrapTax; Refund ItemPrice ShippingTax; Refund ItemPrice Tax; Refund Retrocharge ItemPrice ShippingTax; Refund Retrocharge ItemPrice Tax</p></td></tr><tr><td colspan="1" rowspan="1"><p style="text-align: left;">Sales Tax</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Amazon Obligated Tax Withheld</p></td><td colspan="1" rowspan="1"><p style="text-align: left;">Any "Tax" transaction type with "MarketplaceFacilitatorTax"</p></td></tr></tbody></table>

\\_\\_\\\* This mapping is currently unknown. If you are able to determine which transaction type this maps to in Taxomate, please let us know.