Today’s FBA Q&A Question comes from Trina. She writes:Hi Stephen. I was wondering the best way to get a “end of year snapshot of inventory” report from Amazon? I am kind of new to this and not sure the best way to do this and what program to put it in for best viewing or printing. Thanks for your help! Trina
Thanks for your question. Yes, there are several reports you should be sure to print off for your CPA (or whoever is doing your taxes).
Before we go any further I want you to know that I am not a tax specialist or giving you any tax advice. I highly recommend hiring a CPA who is knowledgable of online sales and all the tax implications. Today, I’m only showing you how to get the reports that you need to add to all of your other 2015 tax documents.
Ok, there is one report that you MUST run on December 31st (or at the very latest, early in the morning on January 1st). This report will let you know how much inventory you have still stored at Amazon at the end of the year. The reason you need to run this report on December 31st is because Amazon does not currently have a report that tells you what inventory you had in their FBA warehouses on specific dates in the past. The only way to get an accurate printout of the inventory you are rolling over into 2015 is to run this report on December 31st or early on January 1st.
- Log in to Seller Central.
- Hover your pointer over “Reports,” and then select “Fulfillment.”
- Click on “Amazon Fulfilled Inventory” on the left side of your screen.
- Click on the “Request Download” button.
- The report status column will state that this report is “In Progress” until it’s completed.
- Once the report is completed (usually a minute later), a “Download” button will appear. Press it.
- Your report is now downloaded to your computer as a .txt file. Open up the file.
- The text is hard to read, so select all the text (Control A for PC users or Command A for Mac users).
- Open up an Excel type spreadsheet and paste the text you just copied. The data will now be more organized.
- Save the file with a name like “2015 Amazon Year End Inventory.”
Note: Do not print this document out. If I would have printed my document out, it would have used 784 pages. That’s because the document also contains all of the items in your inventory that are sold out and are at zero quantity. If you rarely (or never) delete any of your MSKUs that you no longer use (because you’re sold out and don’t plan on selling again), then you may have a file even longer than mine. So, don’t print the file, but do save it and email it to your CPA (or whoever is doing your taxes).
Other reports on the same Reports/Fulfillment page that your CPA would probably like to see are the following:
– Monthly Inventory History – Found under Reports, then Fulfillment, then Show More, then Monthly Inventory History. Run this report for the full year (choose “last 12 months” for the report time period) and it will show you a monthly breakdown of what you sold each month.
– Received Inventory – Found under Reports, then Fulfillment, then Show More, then Received Inventory. This shows what inventory items Amazon received from you this year.
Note: On the above two reports, be sure you click on the Download tab so you can easily download these reports. As with the “Year End Inventory” report, be sure to move the report over to Excel so that it’s easier for your CPA to read.
When you run these reports, don’t forget to choose “last 365 days” or “last 12 months” for your report dates. You want the reports for the whole year, not just the current month.
Your CPA would also like to see a report of your sales, fees, and income from Amazon. The way to find and run this report is a little different, so here is how you do it:
- Log in to Seller Central.
- Hover your mouse over “Reports,” and then select “Payment.”
- Click on the “Date Range Reports” tab.
- Click on the “Generate Report” button.
- Select Report Type: Summary
- Select Date Range: Custom
- Enter in the date range you want. For tax purposes enter “01/01/2015 – 12/31/2015”
- Click “Generate” to get the report started.
- Once the report is ready, it will be available to download.
Note: If you are running this report before December 31st, then the report will not be ready to download until January 1st. Set a reminder somewhere to come back and download the report on January 1st. If you are running this report after January 1st, then it should be ready to download in a few minutes.
Get all of these reports to your CPA ASAP. You really don’t want to be late on getting the tax process started. Again, if you don’t have a CPA, I highly recommend getting one as soon as possible. It’s costly, but you want to be sure your numbers are right, and you want a professional to do the work that would eat up way too much of your time if you did it yourself.
Of course, these aren’t the only numbers you’ll need to give to your CPA. They will also need to know your cost of goods (you logged your receipts, right?) and any other business related expenses that will deduct from your sales numbers.
With tax season upon us, I wanted to let you know that you can download a copy of Introduction to Sales Tax for FBA Sellers by Kat Simpson and Michael Rice. This book is usually $16.99 but you can get it today for only $9.99. Click here or on the cover image to the right to get your copy. Remember, you don’t need a Kindle device to read Kindle books. There are many free Kindle reading apps for your PC, Mac, Smartphone, and Tablet.
If you liked this post and found it helpful, scroll back up to the top and subscribe to the blog. I’ll update you about once a week with helpful tips on how you can make a full-time income with FBA.
Ok, the 2015 year is almost over. What other things are you doing during the last week of the year in order to prepare for 2016? I’d love to hear what you’re up to this week!