Description
Update: Version 2 of this spreadsheet is currently available! See the details here.
The Ultimate Amazon FBA Sales Spreadsheet is by far, the most advanced and comprehensive spreadsheet available for Amazon FBA sellers. We’ve made it incredibly versatile, and built features you didn’t think were even possible with a spreadsheet!
Easily track your:
- Sales
- Inventory
- PO’s
- Returns
- Detail page stats
- Supplies
- Mileage
- Advertising
The Ultimate Amazon FBA Sales Spreadsheet even gives you the ability to accurately and dynamically calculate COGS over time. Best of all, no monthly fees, and no giving your data to a 3rd party!
Sales Tracking:
- View detailed sales data by month
- Automatic COGS calculations that account for price changes based on PO price & quantity (up to 13 different price changes – if price changes more than once in a month, the average PO price is used for that month)
- Monthly sales summaries by SKU that include Sales, average sales a day, detail page sessions, buy box percentage, unit session percentage, units per order, inventory value, turn rates, various fees, profit margins, refunds, and reimbursements
- Track total taxes collected by month
- View sales data by individual dates and/or SKU’s that you choose
- Product Summary for the entire year that displays all SKU’s sales data, available inventory, and PO data (see SKU detail below)
- Yearly summary that displays all data for every month
- Income statement sheet to show you exactly what your income & expenses consist of
PO Tracking:
- Track POs to see exactly how much you’re spending & ordering
- Easily copy in manifest data from liquidation companies like 888 Lots
- Automatically compiled product price list by SKU to see what you’ve ordered over time
- Track PO Source and view summaries by date range
- Accounts for inventory left over from previous year
SKU Detail:
- View a multitude of stats broken down by SKU including:
- Total Sold & Average/day
- Sessions, Buy Box Percentage, Unit Session Percentage, Units per Order
- Total inventory on hand
- Purchased inventory
- Inventory value (estimated by net sales)
- Turn rates
- Amazon fees & credits
- Refunds
- Returns (sellable & non-sellable)
- Adjustments
- Advertising spend
- Fee & Margin percentages
- COGS & Net Sales
Returns Tracking:
- Summarizes all returns data by month, return reason, and SKU
- Automatically adjusts sales numbers and COGS based on the type of return (sellable or non-sellable)
- Track which returns were put back into inventory, and which were a loss
- Summary of how much you’ve lost due to non-sellable returns by month
- Enter returns back into inventory manually if you send a return back to Amazon
- Calculates the top 20 most returned items
Advertising PPC tracking – *NEW*
- Track exactly how much you’re spending per SKU on Amazon advertising
- See data organized visually in graphs
- Ad spend deducts from overall SKU net profit (by month)
- View which keywords/campaigns are performing the best
- Filter by date range, SKU, and match type
Detail Page Statistics – *NEW*
- View Sessions, Buy Box Percentage, Unit Session Percentage, Units per Order
- View estimated Detail Page Sessions by DAY, by SKU!
- Filter by Month and SKU
- See data organized visually in graphs (also filterable by date/sku)*
- View stats by Product Summary & Monthly Summaries
General features:
- Works with Microsoft Excel 2007+, and Excel for Mac 2011+
- Includes a dashboard that neatly displays sales stats visually with graphs
- Easily import Amazon sales, returns, detail page stats, and advertising data without copy/pasting in reports
- Handles 6000 sales (72,000 total per year), across 1000 SKU’s a month, and 5000 SKU’s total (This limit will be lifted in the next version)
- Track purchases of shipping & office supplies, mileage and other online tools by month
- Track taxes collected by Year, Month, and SKU
- Track transfers to your bank account by month
- Comes with FREE updates and improvements – only pay once
Don’t pay $50 or more a MONTH to hand over your sales data to a 3rd party company. Pay once, and keep it on your computer with our easy to use spreadsheet!
See the FAQ for answers to common questions
Check out the video demo of the spreadsheet (this is a demo from v1.7. The PO sheets were replaced with one sheet in v1.8):
Reviews
There are no reviews yet.