Sale!

The Ultimate Amazon FBA Sales Spreadsheet v1

$99.99

Out of stock

Category:

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:

monthly sales data

  • 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:

toolsforfba_amazon_fba_sales_po_new

  • 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:

toolsforfba_amazon_fba_prod_summary2

toolsforfba_amazon_fba_prod_summary

  • 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:

toolsforfba_amazon_fba_sales_returns

  • 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*

toolsforfba_amazon_fba_sales_advertising

  • 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*

toolsforfba_amazon_fba_sales_detail_page

  • 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):

Additional information

Release Log

4/10/16 – v1.0 – Initial release
4/12/16 – v1.01 – Fixed bug with Jan price calculation – price would not populate in COGS if Price 1 was the only option
4/14/16 – v1.02 – Fixed bug with import data with Macs – made all data sheets filterable & sortable

4/22/16 – v1.5
– Added Refunds sheet & more accurate refunds calculations that tie in with sales data
– Added "Top 20 Most Profitable Items" on Dashboard
– Added Manual Fulfillment shipping to summary sheets
– fixed another bug with Excel for Mac
– fixed an error with calculating COGS for reimbursements and added new column on summary sheets
– Made some calculations faster on summary sheets

4/27/16 – v1.6
– Fixed bug with matching skus & reporting data in summary sheets
– Rearranged some data on summary sheets to make more sense, removed extra sales and cogs calculation fields
– Made summary sheets more viewable by freezing item sku and title
– Added dedicated Tax field for summarizing amount of sales tax collected
– Added metric to report on lost revenue due to non-sellable returns
– Added "Items Low on Stock" on Dashboard

5/25/16 – v1.7
– Added ability to select individual or multiple dates to view sales data on monthly summary sheets
– Added "Update File Links" which allows you to update all data without re-importing the file if the data files have changed
– "Remove All Data" now removes file links
– Improved the styling of Refunds reports & added item title
– Improved styling of PO summary reports
– Fixed another Mac bug that affected specific systems
– Fixed bug with calculating running total sold
– Fixed bug with refunds sheet that would appear if you did not have any reimbursements
– Improved speed of running total calculation, and calculations on Prod Summary sheet

5/25/16 – v1.71
– Tweaked two formulas to shave off 5mb (!!) of file size while increasing calculation speed a bit

8/1/16 – v1.8
PO's:
– Removed monthly PO sheets & condensed into one sheet
– Added shipping field for PO's
– Added source field for PO's & Source Summary sheet
– Added ability to add inventory from previous year

Sum sheets:
– Added calculations for:
– inventory turn rates by product & month
– Inventory value by product & month
– New & Total inventory by product & month
– Broke out calculations for "Service Fees" to include Advertising PPC, Disposals, Inventory Placement, Subscription, and Other inventory fees
– Fixed potential error with calculating COGS on reimbursements
– Added Credits column (shipping, gift wrap, promotional rebates)
– Added Advertising column, which is the amount spent on that product on advertising that month
– "Amz fees" is now split into Selling fees and FBA fees
– Fixed calculation for average/day sold (depending on the month, some were off)

Other enhancements:
– Added Advertising sheet, complete with charts that summarize your advertising
– Added Income Statement sheet that summarizes all expenses and income
– Added mileage calculation on SuppliesMileage sheet
– Broke out individual category costs by month on SuppliesMileage sheet
– Reduced file size by half to under 10mb!
– Optimized memory usage

8/2/16 – v1.81
– Fixed bug that prevented COGS from calculating correctly from PO's entered for the previous year
– Fixed bug that prevented PO Data from being entered after 4000 entries
– Fixed bug that affected how COGS were calculated for Adjustments
– Fixed bug with Jun selling fees in the Yearly Summary sheet

8/14/16 – v1.86
– Backwards compatibility with Excel 2007 to 2010.
– Fixed compatibility with Excel for Mac
– Added refunds to chart on Dashboard
– Added additional metrics to charts on Advertising sheet
– Added sort filter for match type on Advertising sheet
– Fixed bug with CTR calculation on Advertising sheet
– Fixed bug with Refreshing data after adding new data (you shouldn't have to click refresh multiple times now)

9/10/16 – v1.91
– Added Detail Page data
– Includes data for detail page Sessions counts, Units/Order, Unit Session Percentage, and Buy Box Percentage
– View an estimated Session count by DAY, by SKU
– Charts to visualize Session, Units/Order, Unit Session Percentage, and Buy Box Percentage by Month, by SKU
– Added color coding on Year, Product and Monthly Summary sheets
– Added date validation for PO Data sheet to prevent errors (if something other than a date was entered, COGS calculations would not work at all)
– Added check to make sure SKU's on PO Data sheet were stored as text (if they were not COGS would not match)
– Added feature to remove spaces and line returns in SKU's
– Added Total Inv., Buy Box %, Unit Ses. % to chart on Dashboard
– Fixed logic for Returns Not Sellable, and Returns Sellable (Returns Sellable were being counted twice in inventory if sold again)
– Returns not sellable are now subtracted from Total Inventory calculations
– Fixed Total calculations on Year Summary for Average/Day. New Inventory, Total Inv. Turn Rate, and Inv. Value
– Changed "Inv Value" to be based on Net Profit instead of COGS
– Expenses on the Year Summary now include COGS

9/13/16 – v1.92
– Fixed issue with Jan cost, net profit, and margin calculations
– Fixed error with Excel for Mac when importing data
– Fixed issue with Detail Page Sum sheet updating after entering new data
– Added feature to remove carriage returns from cost field on PO Data sheet

9/20/16 – v1.93
– Fixed issue with calculating credits for Sep Sum
– Fixed bug where some Returns were being incorrectly marked as reimbursed
– Improved speed of Refresh/Update
– Added ability to filter charts on Advertising sheet by SKU

9/29/16 – v1.93 uk
– UK Specific version released. Dates and tax field were not consistent with US data, causing issues for UK users.

10/19/16 – v1.94
– Fixed bug with detail page data not compiling correctly after clicking an import button, and then clicking cancel
– Fixed bug with importing one sale into sales sheets
– Fixed logic with how Returns are factored into Total Inventory counts – they were being counted twice
– Fixed bug with counting Returns if the item has more than one product name over time
– Fixed bug where SKU's with spaces would not work
– Added feature to filter Returns summary by date

10/19/16 – v1.94 uk
– Changed references from amazon.com to amazon.co.uk
– Fixed pound sign in PO Data cost field
– Fixed bug with detail page data not compiling correctly after clicking an import button, and then clicking cancel
– Fixed bug with importing one sale into sales sheets
– Fixed logic with how Returns are factored into Total Inventory counts – they were being counted twice
– Fixed bug with counting Returns if the item has more than one product name over time
– Fixed bug where SKU's with spaces would not work
– Added feature to filter Returns summary by date

11/18/2016 – v1.95
– Fixed bug with Advertising calculation on month summary sheets
– Fixed bug with running total count for promotion sales (when total was negative), and counting reimbursements for customer returns correctly – this would only affect COGS prices if they changed
– Fixed bug with displaying COGS price on monthly sales data sheets for promotion sales (if total was negative), and reimbursements/adjustments
– Fixed bug with calculating COGS when a previous year cost was entered – COGS were not calculating when the amount sold went over the quantity/cost for the previous year
– Moved Advertising cost on the monthly summary sheets so it is subtracted from Net Sales, since it is directly associated with SKUs.
– Made Prod Summary default to sorted by SKU
– Reduced file size by nearly 8MB, which will also increase speed!
– Increased the amount of sales per month to 6,000, for a total of 72,000 sales
– Added a previous version data importer so you don't have to load all of your data again for every update!

11/20/2016 – v1.951
– Actually fixed bug with Advertising total calculation on month summary sheets, and advertising SKU totals for Oct, Nov, Dec.

2/17/2017 – v1.952
– Fixed compatibility with importing data with Excel for Mac

Reviews

There are no reviews yet.

Be the first to review “The Ultimate Amazon FBA Sales Spreadsheet v1”

Your email address will not be published. Required fields are marked *

You may also like…