[FREE] BASIC_AMZN P&L - Google Drive


1

2	Seller ID1	entertheSellerID	Seller ID2	entertheSellerID
3	Period 1	Last Year	Period 2	2019Q4
4	Marketplace 1	DEFAULT	Marketplace 2	DEFAULT
5	SKU/ASIN 1		SKU/ASIN 2		Example of how it looks using Gorilla ROI
6
7	Consolidated Income - Amazon	Last Year	Consolidated Income - Amazon	2019Q4	Consolidated Income - Amazon	2019Q4
8	Sales	0.00	Sales	0.00	Sales	586,455.41
9	Discounts/Promotions	0.00	Discounts/Promotions	0.00	Discounts/Promotions	(17,501.79)
10	Amazon Reimbursements	0.00	Amazon Reimbursements	0.00	Amazon Reimbursements	5,570.65
11	Shipping Income	0.00	Shipping Income	0.00	Shipping Income	4,907.04
12	Income-Other	0.00	Income-Other	0.00	Income-Other	55.86
13	Amazon Lending	0.00	Amazon Lending	0.00	Amazon Lending	0.00
14	Total Income	0.00	Total Income	0.00	Total Income	579,487.17
15	COGS	0.00	COGS	0.00	COGS	(92,787.37)
16	Gross Profit	0.00	Gross Profit	0.00	Gross Profit	486,699.80
17	Gross Margin	#DIV/0!	Gross Margin	#DIV/0!	Gross Margin	84.0%
18
19	Consolidated Expenses - Amazon	Last Year	Consolidated Expenses - Amazon	2019Q4	Consolidated Expenses - Amazon
20	Amazon Fees	0.00	Amazon Fees	0.00	Amazon Fees	(163,006.26)
21	Operating Profit	0.00	Operating Profit	0.00	Operating Profit	323,693.54
22	Operating Margin	#DIV/0!	Operating Margin	#DIV/0!	Operating Margin	55.9%
23
24	DETAILED Income - Amazon	Last Year	Detailed Income - Amazon	2019Q4	Detailed Income - Amazon
25	Sales	0.00	Sales	0.00	Sales	586,455.41
26	Selling price (Principal)	#NAME?	Selling price (Principal)	#NAME?	Selling price (Principal)	586,455.41
27
28	Discounts/Promotions	0.00	Discounts/Promotions	0.00	Discounts/Promotions	(17,501.79)
29	Promo Rebate	#NAME?	Promo Rebate	#NAME?	Promo Rebate	(17,501.79)
30	Promotional discount for an order item	#NAME?	Promotional discount for an order item	#NAME?	Promotional discount for an order item	0.00
31
32	Amazon Reimbursements	0.00	Amazon Reimbursements	0.00	Amazon Reimbursements	5,570.65
33	COMPENSATED_CLAWBACK	#NAME?	COMPENSATED_CLAWBACK	#NAME?	COMPENSATED_CLAWBACK	(718.97)
34	Compensation for return shipping when a buyer receives the wrong item and requests a free replacement	#NAME?	Compensation for return shipping when a buyer receives the wrong item and requests a free replacement	#NAME?	Compensation for return shipping when a buyer receives the wrong item and requests a free replacement	0.00
35	CRETURN_WRONG_ITEM	#NAME?	CRETURN_WRONG_ITEM	#NAME?	CRETURN_WRONG_ITEM	76.96
36	CS_ERROR_ITEMS	#NAME?	CS_ERROR_ITEMS	#NAME?	CS_ERROR_ITEMS	1,086.07
37	INBOUND_CARRIER_DAMAGE	#NAME?	INBOUND_CARRIER_DAMAGE	#NAME?	INBOUND_CARRIER_DAMAGE	0.00
38	INCORRECT_FEES_ITEMS	#NAME?	INCORRECT_FEES_ITEMS	#NAME?	INCORRECT_FEES_ITEMS	0.00
39	LostOrDamagedReimbursement	#NAME?	LostOrDamagedReimbursement	#NAME?	LostOrDamagedReimbursement	0.00
40	MISSING_FROM_INBOUND	#NAME?	MISSING_FROM_INBOUND	#NAME?	MISSING_FROM_INBOUND	373.12
41	MISSING_FROM_INBOUND_CLAWBACK	#NAME?	MISSING_FROM_INBOUND_CLAWBACK	#NAME?	MISSING_FROM_INBOUND_CLAWBACK	0.00
42	MULTICHANNEL_ORDER_DAMAGED	#NAME?	MULTICHANNEL_ORDER_DAMAGED	#NAME?	MULTICHANNEL_ORDER_DAMAGED	0.00
43	MULTICHANNEL_ORDER_LOST	#NAME?	MULTICHANNEL_ORDER_LOST	#NAME?	MULTICHANNEL_ORDER_LOST	0.00
44	PAYMENT_RETRACTION_ITEMS	#NAME?	PAYMENT_RETRACTION_ITEMS	#NAME?	PAYMENT_RETRACTION_ITEMS	0.00
45	PointsAdjusted	#NAME?	PointsAdjusted	#NAME?	PointsAdjusted	0.00
46	PREPFEE_REFUND	#NAME?	PREPFEE_REFUND	#NAME?	PREPFEE_REFUND	0.00
47	REMOVAL_ORDER_DAMAGED	#NAME?	REMOVAL_ORDER_DAMAGED	#NAME?	REMOVAL_ORDER_DAMAGED	0.00
48	REMOVAL_ORDER_LOST	#NAME?	REMOVAL_ORDER_LOST	#NAME?	REMOVAL_ORDER_LOST	78.54
49	REVERSAL_REIMBURSEMENT	#NAME?	REVERSAL_REIMBURSEMENT	#NAME?	REVERSAL_REIMBURSEMENT	1,726.58
50	SAFE-T claim amount for the item	#NAME?	SAFE-T claim amount for the item	#NAME?	SAFE-T claim amount for the item	0.00
51	SAFETReimbursementCharge	#NAME?	SAFETReimbursementCharge	#NAME?	SAFETReimbursementCharge	0.00
52	SI_CRETURN_MERCHANT_REIMBURSEMENT	#NAME?	SI_CRETURN_MERCHANT_REIMBURSEMENT	#NAME?	SI_CRETURN_MERCHANT_REIMBURSEMENT	0.00
53	Value of Amazon Points deducted from the refund if the buyer does not have enough Amazon Points	#NAME?	Value of Amazon Points deducted from the refund if the buyer does not have enough Amazon Points	#NAME?	Value of Amazon Points deducted from the refund if the buyer does not have enough Amazon Points	0.00
54	WAREHOUSE_DAMAGE	#NAME?	WAREHOUSE_DAMAGE	#NAME?	WAREHOUSE_DAMAGE	2,744.57
55	WAREHOUSE_DAMAGE_EXCEPTION	#NAME?	WAREHOUSE_DAMAGE_EXCEPTION	#NAME?	WAREHOUSE_DAMAGE_EXCEPTION	0.00
56	WAREHOUSE_LOST	#NAME?	WAREHOUSE_LOST	#NAME?	WAREHOUSE_LOST	203.78
57	WAREHOUSE_LOST_MANUAL	#NAME?	WAREHOUSE_LOST_MANUAL	#NAME?	WAREHOUSE_LOST_MANUAL	0.00
58
59	Shipping Income	0.00	Shipping Income	0.00	Shipping Income	4,907.04
60	Shipping charge	#NAME?	Shipping charge	#NAME?	Shipping charge	4,892.27
61	Shipping charges for a COD order	#NAME?	Shipping charges for a COD order	#NAME?	Shipping charges for a COD order	0.00
62	LowValueGoods-Shipping	#NAME?	LowValueGoods-Shipping	#NAME?	LowValueGoods-Shipping	0.00
63	Amount given to the buyer to compensate for shipping the item back to Amazon	#NAME?	Amount given to the buyer to compensate for shipping the item back to Amazon	#NAME?	Amount given to the buyer to compensate for shipping the item back to Amazon	0.00
64	Charge that Amazon charges the buyer when returning a product	#NAME?	Charge that Amazon charges the buyer when returning a product	#NAME?	Charge that Amazon charges the buyer when returning a product	14.77
65
66	Income-Other	0.00	Income-Other	0.00	Income-Other	55.86
67	COD charge for an order	#NAME?	COD charge for an order	#NAME?	COD charge for an order	0.00
68	COD charge for an order item	#NAME?	COD charge for an order item	#NAME?	COD charge for an order item	0.00
69	COD refund	#NAME?	COD refund	#NAME?	COD refund	0.00
70	COD revenue	#NAME?	COD revenue	#NAME?	COD revenue	0.00
71	Export duty that is charged when Amazon ships an item to an international destination	#NAME?	Export duty that is charged when Amazon ships an item to an international destination	#NAME?	Export duty that is charged when Amazon ships an item to an international destination	0.00
72	FBA Liquidation	#NAME?	FBA Liquidation	#NAME?	FBA Liquidation	0.00
73	Fee collected for certain payment methods	#NAME?	Fee collected for certain payment methods	#NAME?	Fee collected for certain payment methods	0.00
74	FREE_REPLACEMENT_REFUND_ITEMS	#NAME?	FREE_REPLACEMENT_REFUND_ITEMS	#NAME?	FREE_REPLACEMENT_REFUND_ITEMS	139.81
75	Gift wrap charge	#NAME?	Gift wrap charge	#NAME?	Gift wrap charge	26.43
76	GoodWill (Amount given to a buyer as a gesture of)	#NAME?	GoodWill (Amount given to a buyer as a gesture of)	#NAME?	GoodWill (Amount given to a buyer as a gesture of)	(110.38)
77
78	Amazon Lending	0.00	Amazon Lending	0.00	Amazon Lending	0.00
79	Loan Advance	#NAME?	Loan Advance	#NAME?	Loan Advance	0.00
80	Loan Payment	#NAME?	Loan Payment	#NAME?	Loan Payment	0.00
81	LoanRefund	#NAME?	LoanRefund	#NAME?	LoanRefund	0.00
82	Generic bad debt deduction	#NAME?	Generic bad debt deduction	#NAME?	Generic bad debt deduction	0.00
83	DebtPayment	#NAME?	DebtPayment	#NAME?	DebtPayment	0.00
84	DebtPaymentLevel2Failure	#NAME?	DebtPaymentLevel2Failure	#NAME?	DebtPaymentLevel2Failure	0.00
85
86	Total Income	0.00	Total Income	0.00	Total Income	579,487.17
87
88	COGS	0.00	COGS	0.00	COGS	(92,787.37)
89	Commission	#NAME?	Commission	#NAME?	Commission	(84,037.93)
90	FBA Amazon-Partnered Carrier Shipment Fee/Inbound Transportation Charge	#NAME?	FBA Amazon-Partnered Carrier Shipment Fee/Inbound Transportation Charge	#NAME?	FBA Amazon-Partnered Carrier Shipment Fee/Inbound Transportation Charge	(8,749.44)
91
92	Gross Profit	0.00	Gross Profit	0.00	Gross Profit	486,699.80
93	Gross Margin	#DIV/0!	Gross Margin	#DIV/0!	Gross Margin	84.0%
94
95	DETAILED Expenses - Amazon	Last Year	Detailed Expenses - Amazon	2019Q4	Detailed Expenses - Amazon
96	Amazon Fees	0.00	Amazon Fees	0.00	Amazon Fees	(54,188.54)
97	FBA Fee for cash on delivery	#NAME?	FBA Fee for cash on delivery	#NAME?	FBA Fee for cash on delivery	0.00
98	FBA Fulfillment Fees	#NAME?	FBA Fulfillment Fees	#NAME?	FBA Fulfillment Fees	(50,644.62)
99	FBA Inbound Shipment Carton Level Info Fee	#NAME?	FBA Inbound Shipment Carton Level Info Fee	#NAME?	FBA Inbound Shipment Carton Level Info Fee	0.00
100	FBA Inbound Transportation Program Fee	#NAME?	FBA Inbound Transportation Program Fee	#NAME?	FBA Inbound Transportation Program Fee	0.00
101	FBA Inventory Disposals	#NAME?	FBA Inventory Disposals	#NAME?	FBA Inventory Disposals	0.00
102	FBA Inventory Placement Service Fees	#NAME?	FBA Inventory Placement Service Fees	#NAME?	FBA Inventory Placement Service Fees	0.00
103	FBA Inventory Removals	#NAME?	FBA Inventory Removals	#NAME?	FBA Inventory Removals	(47.00)
104	FBA Inventory Storage Fee	#NAME?	FBA Inventory Storage Fee	#NAME?	FBA Inventory Storage Fee	(1,580.45)
105	FBA Label Service Fee	#NAME?	FBA Label Service Fee	#NAME?	FBA Label Service Fee	0.00
106	FBA Liquidation Fee	#NAME?	FBA Liquidation Fee	#NAME?	FBA Liquidation Fee	0.00
107	FBA Long-Term Storage Fees	#NAME?	FBA Long-Term Storage Fees	#NAME?	FBA Long-Term Storage Fees	0.00
108	FBA Multi-Channel Fulfillment Weight Handling	#NAME?	FBA Multi-Channel Fulfillment Weight Handling	#NAME?	FBA Multi-Channel Fulfillment Weight Handling	0.00
109	FBA Per Order Fulfillment Fee	#NAME?	FBA Per Order Fulfillment Fee	#NAME?	FBA Per Order Fulfillment Fee	0.00
110	FBA Prep Service Fees (Bubble Wrap)	#NAME?	FBA Prep Service Fees (Bubble Wrap)	#NAME?	FBA Prep Service Fees (Bubble Wrap)	0.00
111	FBA Prep Service Fees (Labeling)	#NAME?	FBA Prep Service Fees (Labeling)	#NAME?	FBA Prep Service Fees (Labeling)	0.00
112	FBA Prep Service Fees-Adult-Bagging (black or opaque)	#NAME?	FBA Prep Service Fees-Adult-Bagging (black or opaque)	#NAME?	FBA Prep Service Fees-Adult-Bagging (black or opaque)	0.00
113	FBA Returns Processing Fee-Order Handling	#NAME?	FBA Returns Processing Fee-Order Handling	#NAME?	FBA Returns Processing Fee-Order Handling	0.00
114	FBA Returns Processing Fee-Pick & Pack	#NAME?	FBA Returns Processing Fee-Pick & Pack	#NAME?	FBA Returns Processing Fee-Pick & Pack	0.00
115	FBA Returns Processing Fee-Weight Handling	#NAME?	FBA Returns Processing Fee-Weight Handling	#NAME?	FBA Returns Processing Fee-Weight Handling	0.00
116	FBA Taping Fee	#NAME?	FBA Taping Fee	#NAME?	FBA Taping Fee	0.00
117	FBA transportation fee	#NAME?	FBA transportation fee	#NAME?	FBA transportation fee	0.00
118	FBA Unplanned Prep Service Fees	#NAME?	FBA Unplanned Prep Service Fees	#NAME?	FBA Unplanned Prep Service Fees	0.00
119	FBA Weight Based Fee	#NAME?	FBA Weight Based Fee	#NAME?	FBA Weight Based Fee	0.00
120	FBADeliveryServicesFee	#NAME?	FBADeliveryServicesFee	#NAME?	FBADeliveryServicesFee	0.00
121	FBALocalizationFee	#NAME?	FBALocalizationFee	#NAME?	FBALocalizationFee	0.00
122	FBAOverageFee	#NAME?	FBAOverageFee	#NAME?	FBAOverageFee	0.00
123	Fresh Inbound Transportation Fee	#NAME?	Fresh Inbound Transportation Fee	#NAME?	Fresh Inbound Transportation Fee	0.00
124	Get Paid Faster Fee	#NAME?	Get Paid Faster Fee	#NAME?	Get Paid Faster Fee	0.00
125	Gift Wrap Charge-Back Fee	#NAME?	Gift Wrap Charge-Back Fee	#NAME?	Gift Wrap Charge-Back Fee	(3.99)
126	Gift Wrap Commission	#NAME?	Gift Wrap Commission	#NAME?	Gift Wrap Commission	0.00
127	Global Inbound Transportation Fee	#NAME?	Global Inbound Transportation Fee	#NAME?	Global Inbound Transportation Fee	0.00
128	GlobalInboundTransportationDuty	#NAME?	GlobalInboundTransportationDuty	#NAME?	GlobalInboundTransportationDuty	0.00
129	High-volume listing fee	#NAME?	High-volume listing fee	#NAME?	High-volume listing fee	0.00
130	JumpStartYourWebstoreFee	#NAME?	JumpStartYourWebstoreFee	#NAME?	JumpStartYourWebstoreFee	0.00
131	MFNDeliveryServiceFee	#NAME?	MFNDeliveryServiceFee	#NAME?	MFNDeliveryServiceFee	0.00
132	Monthly subscription fee	#NAME?	Monthly subscription fee	#NAME?	Monthly subscription fee	(39.99)
133	PaidServicesFee	#NAME?	PaidServicesFee	#NAME?	PaidServicesFee	0.00
134	Per-item fees for Individual Sellers	#NAME?	Per-item fees for Individual Sellers	#NAME?	Per-item fees for Individual Sellers	0.00
135	Purchase of Rented Books	#NAME?	Purchase of Rented Books	#NAME?	Purchase of Rented Books	0.00
136	Referral Fees	#NAME?	Referral Fees	#NAME?	Referral Fees	0.00
137	Refund Administration Fee	#NAME?	Refund Administration Fee	#NAME?	Refund Administration Fee	(99.26)
138	Rental Book Service Fee	#NAME?	Rental Book Service Fee	#NAME?	Rental Book Service Fee	0.00
139	Rental Extensions	#NAME?	Rental Extensions	#NAME?	Rental Extensions	0.00
140	Review Enrollment Fee	#NAME?	Review Enrollment Fee	#NAME?	Review Enrollment Fee	0.00
141	RunLightningDealFee Principal	#NAME?	RunLightningDealFee Principal	#NAME?	RunLightningDealFee Principal	0.00
142	RunLightningDealFee Tax	#NAME?	RunLightningDealFee Tax	#NAME?	RunLightningDealFee Tax	0.00
143	SalesTaxCollectionFee	#NAME?	SalesTaxCollectionFee	#NAME?	SalesTaxCollectionFee	0.00
144	Shipping Charge-Back Fee	#NAME?	Shipping Charge-Back Fee	#NAME?	Shipping Charge-Back Fee	(524.78)
145	Shipping HB Fee	#NAME?	Shipping HB Fee	#NAME?	Shipping HB Fee	(1.05)
146	SSO Fulfillment Fee	#NAME?	SSO Fulfillment Fee	#NAME?	SSO Fulfillment Fee	0.00
147	Tax Calculation Services Fees	#NAME?	Tax Calculation Services Fees	#NAME?	Tax Calculation Services Fees	0.00
148	TechnologyFee	#NAME?	TechnologyFee	#NAME?	TechnologyFee	0.00
149	Unit Fulfillment Fee	#NAME?	Unit Fulfillment Fee	#NAME?	Unit Fulfillment Fee	0.00
150	Coupon clip fee	#NAME?	Coupon clip fee	#NAME?	Coupon clip fee	0.00
151	Coupon redemption fee	#NAME?	Coupon redemption fee	#NAME?	Coupon redemption fee	(1,247.40)
152	Cross-Border Fulfillment Fee	#NAME?	Cross-Border Fulfillment Fee	#NAME?	Cross-Border Fulfillment Fee	0.00
153	Easy Ship Fee	#NAME?	Easy Ship Fee	#NAME?	Easy Ship Fee	0.00
154	EPSO Chargeback fee	#NAME?	EPSO Chargeback fee	#NAME?	EPSO Chargeback fee	0.00
155	EPSO Cross-Border fee	#NAME?	EPSO Cross-Border fee	#NAME?	EPSO Cross-Border fee	0.00
156	EPSO Payment Authorization fee	#NAME?	EPSO Payment Authorization fee	#NAME?	EPSO Payment Authorization fee	0.00
157	EPSO Payment Settle fee	#NAME?	EPSO Payment Settle fee	#NAME?	EPSO Payment Settle fee	0.00
158	EPSOChargebackFee	#NAME?	EPSOChargebackFee	#NAME?	EPSOChargebackFee	0.00
159	Amazon Imaging fee	#NAME?	Amazon Imaging fee	#NAME?	Amazon Imaging fee	0.00
160	AmazonExclusivesFee	#NAME?	AmazonExclusivesFee	#NAME?	AmazonExclusivesFee	0.00
161	Cash on Delivery Chargeback	#NAME?	Cash on Delivery Chargeback	#NAME?	Cash on Delivery Chargeback	0.00
162	Closing Fees	#NAME?	Closing Fees	#NAME?	Closing Fees	0.00
163
164	Operating Profit	0.00	Operating Profit	0.00	Operating Profit	432,511.26
165	Operating Margin	#DIV/0!	Operating Margin	#DIV/0!	Operating Margin	74.6%
166