A2X Amazon Reconciliation Example
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
A2X Amazon Reconciliation Example
3
This table shows how to reconcile an Amazon settlement summary to the individual transaction types you see in A2X
4
Find out more at a2xaccounting.com
Example report from Amazon:
5
6
Amazon Transaction TypeTotalAmazon GroupingTotal
7
Principal - Amazon.ca (Order ItemPrice)$5,215.83Product Charges$5,215.83
8
9
Shipping - Amazon.ca (Order Promotion)-$199.69Promo Rebates-$199.69
10
11
Commission - Amazon.ca (Order ItemFees)-$760.16
12
FBAPerUnitFulfillmentFee - Amazon.ca (Order ItemFees)
-$152.39
13
FBAWeightBasedFee - Amazon.ca (Order ItemFees)
-$357.75
14
ShippingChargeback - Amazon.ca (Order ItemFees)
-$84.73
15
SalesTaxServiceFee - Amazon.ca (Order ItemFees)
-$5.61Amazon Fees-$1,360.64
16
17
Shipping - Amazon.ca (Order ItemPrice)$274.95
18
ShippingTax - Amazon.ca (Order ItemPrice)$1.98
19
Tax - Amazon.ca (Order ItemPrice)$190.52
Other (Shipping and Giftwrap credits)
$467.45
20
21
Principal - Amazon.ca (Refund ItemPrice)-$179.98Refund - product charges-$179.98
22
23
Commission - Amazon.ca (Refund ItemFees)$27.00
24
RefundCommission - Amazon.ca (Refund ItemFees)
-$5.40Refund - Amazon fees$21.60
25
26
Storage Fee (other-transaction)-$209.58
27
WarehousePrep (other-transaction)-$40.32
28
RemovalComplete (other-transaction)-$3.96FBA Inventory Fees-$253.86
29
30
REVERSAL_REIMBURSEMENT (other-transaction FBA Inventory Reimbursement)
$30.00Other$30.00
31
32
33
$3,740.71$3,740.71
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...