We often get asked why XYZ data in QuickBooks/Xero/Wave does not match up with the Payment Data 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 below chart reflects our attempt to map the Line Items in the Date Range Summary Report with the transaction types found on the Mappings 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.

Amazon Date Range Category

Amazon Date Range Line Item

Taxomate Transaction Type (from Amazon Settlement Report)

Income

Product sales (non-FBA)

Order ItemPrice Principal

Income

  • Product sale refunds (non-FBA)

  • FBA product sales

  • A-to-z Guarantee Refund ItemPrice Principal

  • Chargeback Refund ItemPrice Principal

  • Refund ItemPrice Principal

  • Refund ItemPrice Goodwill

Income

FBA product sales

Order ItemPrice Principal

Income

FBA product sale refunds

  • Chargeback Refund ItemPrice Principal

  • Refund ItemPrice RestockingFee

  • Chargeback Refund ItemPrice RestockingFee

  • Refund ItemPrice Principal

  • Refund ItemPrice Goodwill

Income

FBA inventory credit

All "Reimbursement" Transaction Types (excluding those in Adjustments )

Income

FBA inventory credit

All "Reimbursement" Transaction Types (excluding those in Adjustments)

Income

FBA liquidation proceeds

***

Income

Shipping credit

Order ItemPrice Shipping

Income

Shipping credit refunds

  • A-to-z Guarantee Refund ItemPrice Shipping

  • Chargeback Refund ItemPrice Shipping

  • Refund ItemPrice ReturnShipping

  • Refund ItemPrice Shipping

Income

Gift wrap credits

Order ItemPrice GiftWrap

Income

Gift wrap credit refunds

  • Chargeback Refund ItemFees GiftwrapChargeback

  • Chargeback Refund ItemPrice GiftWrap

  • Refund ItemPrice GiftWrap

Income

Promotional rebates

  • Order Promotion Principal

  • Order Promotion Shipping

Income

Promotional rebate refunds

  • Refund Promotion Principal

  • Refund Promotion Shipping

Income

A-to-z Guarantee claims

A-to-z Guarantee Refund ItemPrice Principal

Income

Chargebacks

***

Income

Amazon Shipping Reimbursement

***

Income

SAFE-T reimbursement

Commissions and Selling Fees

Expenses

FBA selling fees

Commissions and Selling Fees

Expenses

Selling fee refunds

Commissions and Selling Fees

Expenses

  • FBA transaction fees

  • FBA transaction fee refunds

Fulfillment and Warehousing

Expenses

  • Other transaction fees

  • Other transaction fee refunds

All "Other" Transaction Types

Expenses

FBA inventory and inbound services fees

All "Delivery and Transport" Transction Types

Expenses

Shipping label purchases

Other transaction other-transaction Shipping label purchase (Shipping Expense)

Expenses

Shipping label refunds

Other-transaction other-transaction Shipping label purchase for return (Shipping Expense)

Expenses

Carrier shipping label adjustments

***

Expenses

Service fees

All "Subscription and Service Fees" Transaction Types

Expenses

Refund administration fees

Refund ItemFees RefundCommission

Expenses

Adjustments

  • 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

Expenses

Cost of Advertising

  • Lightning Deal Fee LightningDealFee LightningDealFee

  • Lightning Deal Fee LightningDealFee LightningDealFee Special

  • ServiceFee Cost Of Advertising TransactionTotalAmount

Expenses

Refund for Advertiser

ServiceFee Refund For Advertiser

Expenses

Liquidations brokerage fee

***

Sales Tax

Sales, shipping, and gift wrap tax collected

  • Order ItemPrice GiftWrapTax

  • Order ItemPrice ShippingTax

  • Order ItemPrice Tax

  • Order Retrocharge ItemPrice ShippingTax

  • Order Retrocharge ItemPrice Tax

Sales Tax

Sales tax refunds

  • A-to-z Guarantee Refund ItemPrice ShippingTax

  • A-to-z Guarantee Refund ItemPrice Tax

  • Chargeback Refund ItemPrice Tax

  • Chargeback Refund ItemPrice Tax

  • Refund ItemPrice GiftWrapTax

  • Refund ItemPrice ShippingTax

  • Refund ItemPrice Tax

  • Refund Retrocharge ItemPrice ShippingTax

  • Refund Retrocharge ItemPrice Tax

Sales Tax

Amazon Obligated Tax Withheld

Any "Tax" transaction type with "MarketplaceFacilitatorTax"

*** This mapping is currently unknown. If are able to determine which transaction type this maps to in taxomate please let us know.

Did this answer your question?