How to create a report to track profits
Hi all,
I’m struggling trying to find/create a suitable report on a monthly basis so I can see for each sale what the deductions are from Amazon and so work out my profit margin.
Doing a search on here hasn’t bought up the info, hence this post.
The FBA shipment invoice doesn’t include any of the deductions made, just the selling price.
Please can anyone help?
Thanks.
28 replies
Seller_7VbclcPFFRTnc
You’d need to create your own spreadsheet
Seller_64jziShTiTjOq
Shouldn’t you be doing that BEFORE you set the sale price? Amazon’s FBA and other fees are published on here, so you can put them into a spreadsheet with all your other costs etc and then set the price to get the profit you want
Seller_77IcbQKVGdZo0
A lot of the payment reports help you with this especially the date range reports as they show you the net amount received after all fees have been taken. If you have signed up for the Amazon Vat Calculation service it also shows you the VAT paid as well.
You can also create your own set of spreadsheets. I have a number which I use to work out profit per item and estimated cash flow along with other things.
Seller_KoWHfm8kasz9x
Profit?
Thought that was the Amazon bit.
