Customers often wonder why their Amazon financial data doesn't align with what they see on QuickBooks, Xero, or Wave compared to Amazon's Financial Dashboard.
We use the Payment Settlement Report for our data because it has the most comprehensive financial details and matches the payout amount. Taxomate organizes these transaction types in the Payment Settlement Report in a way that's easy to understand, especially for tax preparation. However, our organization method is different from Amazon's method on their dashboard.
Below, we've provided charts that show how we've matched Taxomate's transaction categories to the Amazon Dashboard categories.
If you want your accounting software to show the same data as the Amazon Dashboard, you should set up new accounts corresponding to each Amazon Dashboard category. After that, map these accounts to their respective transaction types on the Accounts and taxes page in Taxomate.
Note: The charts below do not include all transaction types but should cover most. If you have any issues in getting the profit and loss report to match with the Amazon Dashboard, feel free to reach out to us.
Amazon Dashboard Category | Taxomate Settlement Data | Taxomate Category |
|---|---|---|
Product Charges | Order ItemPrice Principal | Sales |
Tax and Regulatory Fee | Order ItemPrice Tax | Sales Tax Collected |
Shipping | Order ItemPrice Shipping | Shipping Income |
Other (Sales) | Order ItemPrice GiftWrap | Gift Wrap |
Other (Sales) | Other-transaction Other-transaction NonSubscriptionFeeAdj | Subscription and Service Fees |
Other (Sales) | Other-transaction FBA Inventory Reimbursement WAREHOUSE DAMAGE | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement REVERSAL REIMBURSEMENT | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement WAREHOUSE LOST | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement COMPENSATED CLAWBACK | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement CRETURN WRONG ITEM | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement CS ERROR ITEMS | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement CS ERROR NON ITEMIZED | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement Customer Return | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement Damaged:Warehouse | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement FREE REPLACEMENT REFUND ITEMS | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement FREE REPLACEMENT REFUND NON ITEMIZED | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement General Adjustment | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement INBOUND CARRIER DAMAGE | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement INCORRECT FEES ITEMS | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement INCORRECT FEES NON ITEMIZED | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement Lost:Inbound | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement Lost:Outbound | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement Lost:Warehouse | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement MISSING FROM INBOUND | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement MISSING FROM INBOUND CLAWBACK | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement MULTICHANNEL ORDER DAMAGED | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement MULTICHANNEL ORDER LATE | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement MULTICHANNEL ORDER LOST | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement PAYMENT RETRACTION ITEMS | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement PREPFEE REFUND | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement REMOVAL ORDER DAMAGED | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement REMOVAL ORDER LOST | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement RE EVALUATION | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement Return Adjustment | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement WAREHOUSE DAMAGE EXCEPTION | Reimbursements |
Other (Sales) | Other-transaction FBA Inventory Reimbursement WAREHOUSE LOST MANUAL | Reimbursements |
Amazon Dashboard Category | Taxomate Settlement Data | Taxomate Category |
|---|---|---|
Refunded Expenses | Refund ItemFees RefundCommission | Commissions and Selling Fees |
Refunded Expenses | Refund ItemFees Commission | Commissions and Selling Fees |
Refunded Expenses | Refund ItemPrice RestockingFee | Commissions and Selling Fees |
Refunded Expenses | Refund ItemFees ShippingChargeback | Shipping Expense |
Refunded Expenses | Refund Promotion Shipping | Shipping Expense |
Refunded Expenses | Order ItemWithheldTax MarketplaceFacilitatorVAT-Principal | Sales Tax Remitted |
Refunded Sales | Refund ItemPrice Principal | Refunds |
Refunded Sales | Refund ItemPrice Shipping | Shipping Income |
Amazon Dashboard Category | Taxomate Settlement Data | Taxomate Category |
|---|---|---|
Promo Rebates | Order Promotion Shipping | Shipping Income |
FBA Fees | Other-transaction Other-transaction RemovalComplete | Fulfillment and Warehousing |
FBA Fees | Other-transaction Other-transaction Storage Fee | Fulfillment and Warehousing |
FBA Fees | Other-transaction Other-transaction StorageRenewalBilling | Fulfillment and Warehousing |
FBA Fees | Other-transaction Other-transaction FBAInboundTransportationFee | Delivery and Transport |
FBA Fees | Other-transaction Other-transaction Inventory Placement Service Fee | Delivery and Transport |
Cost of Advertising | ServiceFee Cost Of Advertising TransactionTotalAmount | Advertising |
Amazon Fees | Order ItemFees Commission | Commissions and Selling Fees |
Amazon Fees | Order ItemFees GiftwrapChargeback | Commissions and Selling Fees |
Amazon Fees | Order ItemFees FBAPerUnitFulfillmentFee | Fulfillment and Warehousing |
Amazon Fees | Order ItemFees ShippingChargeback | Shipping Expense |
Amazon Fees | Order ItemFees SalesTaxServiceFee | Subscription and Service Fees |
Amazon Fees | Other-transaction Other-transaction Subscription Fee | Subscription and Service Fees |
Other (Expenses) | Other-transaction Other-transaction Amazon Capital Services | Lending |
Amazon Dashboard Category | Taxomate Settlement Data | Taxomate Category |
|---|---|---|
Account Level Reserve | Amazon.com Other-transaction Other-transaction Current Reserve Amount | Reserved Balance |
Account Level Reserve | Amazon.com Other-transaction Other-transaction Previous Reserve Amount Balance | Reserved Balance |
