FBA Inventory Analyzer Workbook
Introducing the Amazon FBA Inventory Analyzer Workbook. This package includes the following:
Amazon FBA Inventory Analyzer with macros (Excel)
Amazon FBA Inventory Analyzer without macros (Google Sheets, Open Office Calc, MAC Numbers, etc.)
PDF guide to using the spreadsheets
Added Bonus - Income Statement Workbook
Watch a demo video on YouTube at https://www.youtube.com/watch?v=ZBUkbU8psi0
The Analyzer Workbooks utilize two Amazon Seller Central reports and cross references the data to produce a worksheet that displays FBA inventory into a beautiful sheet that makes it easy to analyze how you are doing.
Some of the features include dynamic links to your products on keepa and Amazon websites. With a single click of the mouse, your browser will display the item on the relevant website, no more copy and pasting ASINS or item product titles to do your research.
The Return on Investment column will display the ratio of your earnings to investment. The cells are shaded green, yellow, or red to indicate how you are doing, with green being good, and red indicating potential losses.
Also included are columns for viewing total payout, profit, quantity on hand, recommended quantity to ship to FBA, etc. At any given moment, you can view to the total cost of goods in Amazon fulfillment centers.
The built in shipping calculator uses the weight stored in Amazon's system to calculate your approximate inbound shipping cost per item. This amount is calculated with the payout to reflect more accurate profit data. The default inbound shipping rate is $0.50, but can be changed to suit each individual seller.
Included in the workbooks are sheets that you can use to store product information, or play with pricing to determine your profit. Those that purchased the first workbook release will be familiar with these worksheets. They can also be used to create a shopping list of the items you want to source on your next sourcing trip.
As an added bonus, you'll receive another workbook, Income Statements. This workbook includes income statement sheets for January-December, and a year end sheet that is automatically updated as you complete each month's income statement. This is a great tool for bookkeeping and tracking the financials of your business.
Upload your workbooks to Google Drive for instant access on your mobile devices. This makes it easy to take your data with you when you are out sourcing at retailers or thrift stores.
Works on PC & MAC & Open Office, Google Sheets, Excel, Numbers
NEW! Cost of Goods Totals Worksheet. This worksheet is designed to assist sellers with calculating their end of the month Cost of Goods (COGs) for accounting purposes. This is ideal for those that produce monthly income statements, and for end of the year COG in Amazon FBA fulfillment centers. One report is needed to populate the data on this worksheet.
Buyers will receive access to updated versions at no additional cost.
Support and discussions on Facebook: https://www.facebook.com/groups/954713437945327/
Inventory Planner and Tracker Workbook:
https://gumroad.com/products/DOrp