Hi, Does anyone have clients who sell purely through Amazon or at least mostly? I have a new client and every quarter he wants Management Accounts producing.
To enable me to do this I need to calculate closing stock. I have only had 1 client before who sold solely through Amazon and he provided me with a figure at year end.
Does anyone know if this is easy to do? I have asked for Access to Amazon account so I can go take a peep.
Kind regards,
Elaine
-- Edited by Elaine R on Tuesday 20th of October 2015 10:29:44 AM
I have a client who sells via Amazon and their website. They just give me a figure at the year end, too. If your client wants quarterly MA's, presumably they just need to give you the figure quarterly?
If they are expecting you to sort it, I am not sure about where it is on Amazon, so I have emailed my client for you, and asked whether it can be done
Hi both
Just a thought (and not knowing the size of this client) - should they not also be doing a physical stock take just as they would at year end, pulling out obsolete stock etc and then letting you have the figures rather than just going off what is essentially just a list on Amazon? For the sake of accuracy.
Or am I over complicating things?
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
Its a small client at the moment and very new ie not even 6 months old it itself. I want to get on top of this in the early days to make it easier at year end and also the client is asking for quarterly management accounts.
Hi Elaine
It would be good practice for them to do that physical check and pretty quick and easy to do whilst they are small, start those good habits for when they are much bigger as long as they understand the reasonings for it, but whilst obviously trying to keep costs down.
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
"You can do a current inventory report but its pretty crap, are they wanting to know how much stock they have real time or historical?"
I've gone back and said that it will have to be real time, if historic isn't accessible... so it may mean that you have to remember to look on the last day of the quarter, say in the evening. I've asked for the online navigation to the report.
This test.xls is about the only inventory-type report I can find, within seller central, for products not fulfilled by Amazon.
If products are fulfilled by Amazon, there are a few more options which appear to be able to generate stock at the end of a particular month (fulfilled by amazon.xls)
OR
If the customer has a mix of fulfilled by Amazon and sending goods themselves, you can run a report which shows amount of units sold broken down per by product between two exact dates.
Basically Amazons reporting tools are a bit (removed as naughty word), depending on how important this is. They could always go on freelancer or peopleperhour to write a bit of code that will do exactly what she wants......I think
So I asked for the navigation route -
For the FBA reports: reports > fulfillment by amazon > You will see some inventory report options
For FBA and sent by seller: Reports>Business Reports>Inventory in Stock
For stock sold between two dates: Reports>Business Reports>Detail Page by Sales and Traffic....then select whatever dates
I attached the test files he sent me, removing product details as they are own brand products. But you'll get an idea of what's available.
Personally, I would be asking the client for the figure, not getting involved in it, yourself. If you get it wrong, they'll blame you. Best to let them decide, and cover your own ass!
They could always go on freelancer or peopleperhour to write a bit of code that will do exactly what she wants......I think
My brother wrote his own database for stock monitoring for his own business a few years ago, so I had him do the same for a client and they have passed him on to one of their clients.
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
