Collaborate on Monthly Invoice Amazon for Inventory with Ease Using airSlate SignNow

Monthly invoice amazon for Inventory

hi this is Karen Holmes and I just want to guide you through how to get to your yearend inventory report go to Seller Central reports fulfillment click on that and come over to the left side and you'll want to select the monthly inventory history click on the link see more if you don't see it immediately from there it defaults to view online but we're going to want to download it and we're going to want to choose the exact months and what we're interested in is the year end inventory for the sake of your taxes uh so you want select from December to December if it is before the end of the year this is going to show us no data available so for the purpose of this video I'm going to show you 2014's year end report and you can run 2015's year end report reports in January after December 31st so you're going to request download and it'll come up as in progress I've already it doesn't take long to come up I've already downloaded it so I'll show you how it comes up it comes up in a text file we want to put it into Excel so that we can data sort it so you're going to go to edit select all to highlight it and you you can do contrl C or right click and copy and bring up Excel and in the top left box contrl V to paste it now you may look at this report and think well I have more than one of this item Don't Panic that is ing to the warehouse in Oak 4 you only have one of the item but you may have more of the items at other Warehouse is before we sort out and group the items together we can do this by the FN skew the Fulfillment Network stock keeping unit the x00 number is what I like to call it or you can do it by the merchant skew which I tend to do because I have it grouped together like items different categories before you do that though you want to get rid of any zeros any the end quantities of zeros so data sort by end quantity smallest to large or do its largest to small so that you can get rid of any of the zeros so from here down you can just scroll down and delete right click delete and then you'll have to just inventory that you have left so we're going to now data sort it by skew so now we want to work out the cost and the quantity to get the final value of the inventory left uh we do not need some of these columns although I I like to keep them rather than delete them just uh in case we want to refer to in the future so I'm going to highlight these two columns and right click and hide we don't need to know what Warehouse it's at we know they're all sellable and we're going to hide that too so we've got the end quantity but some of these are grouped together so we can do um we can insert a column for total quantity of the item and then we could put the cost of the item so we're going to do the total quantity this has got three five seven eight of these so we can do eight if you have a lot of them you could just insert I'll show you on on this one it's a little more complicated CU there a lot of them but that's just eight on this one there's only three on these is is only two these is only three but these we we have a lot so I'm actually going to go to the bottom of the packs insert a row so I can work out the cost of that and we do this by clicking on the box left click drag down to the blank row and then go over to little symbol if you can't see it click home and find the auto sum and that's going to give us the total of these so we can then put that 687 and then we're going to do the same with the other item these have done a little bit of a mockup so I've changed some of the details uh so here we're going to do this one and we want to work out what the total in all the warehouses is so we Auto sum and 554 and this is just one one two I do it on the last row two of those okay so you get the idea of that I'm just doing this roughly and the cost now this is where the beauty is of including the cost in the skew otherwise you'd have to refer to your record whether it's inventory lab or whatever you keep a record of your SKS but here I can easily look and say these are 12 and these are 13 and these are 345 and so forth 7even so it's it's coded in here the 09 is 90 cents so let's go down here these are .90 uh these are $4 so that's four so I'll just show you for this far um you can always if you want oops that should have been this column if you want to change them to be the proper numbers you can format the cell to currency you can have the dollar sign if you want or you can have no dollar sign and the two decimal places so that your columns are even and now we're going to do the year end total so we're going to go to this cell L5 and we're going to times J5 is row five J5 by K5 to get to the year run total of this item so we're going to do that by doing that equals sum J5 times which is the asteris K5 and because we' put the formula in this first cell you can see a little box at the bottom right hand corner we can put this cross over it and drag that formula all the way down to the last row that we want it and the formula will copy this column time this column equals this column so that we have the totals of all the rows then what we do is total all of it together so we've got the formulas been multiplied out so we'll go from this row and we're just highlighting we're not dragging a formula down we're highlighting it down to the very last row where there is nothing on the row we're going to go to the homepage again home and auto sum and that will give us the total of all the inventory left and this will be ending inventory for for in this case 2014 and beginning inventory of 2015 you will then want to add to this any inventory that isn't at Amazon or possibly what's on the way to Amazon and isn't checked in yet