Sale!

The Ultimate Amazon FBA Sales Spreadsheet v2

$174.99 $124.99

Description

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!

*New for v2.1 – Automatic downloading of Seller Central data reports!* (for PC users only)

You simply won’t believe that we made a spreadsheet that can filter, display, and summarize your sales data like the Ultimate Amazon FBA Sales Spreadsheet.

Easily track your:

  • Sales (FBA & MF)
  • Inventory
  • PO’s
  • Returns
  • Reimbursements (*NEW in v2!)
  • Removals (*NEW in v2!)
  • Detail page stats
  • Supplies
  • Mileage
  • Advertising
  • Fulfillment only orders (*NEW in v2!)
  • Inbound FBA Shipping (*NEW in v2!)

The Ultimate Amazon FBA Sales Spreadsheet even gives you the ability to accurately and dynamically calculate COGS over time. Most online solutions can’t even do this!  Best of all, no monthly fees, and no giving your data to a 3rd party!

The Dashboard – View all important data in one place!

Also see data by any given date range:

  • Top 20 Sales
  • Top 20 Returns
  • Top 20 Most Profitable Items
  • Items Low on Inventory
  • Well Stocked Items
  • Stale Inventory (high days in stock, no sales)

Sales Tracking – 3 Different ways to view sales statistics!

Product Summary:

To view more screen shots click on the thumbnails under the main image at the top of the page

View a multitude of stats broken down by SKU and filterable by any Date or Settlement ID including:

  • Total FBA & Manual Fulfillment Sold
  • Days in Stock (*NEW in v2 – excludes days out of stock in-between days in stock)
  • Average sales / day
  • Sessions, Buy Box Percentage, Unit Session Percentage, Units per Order
  • Total inventory on hand at the beginning & end of set date range
  • Turn rates
  • Inventory value (estimated by cost)
  • Gross Sales
  • Amazon fees & credits
  • Inbound shipping cost by SKU (*NEW in v2)
  • Advertising spend per SKU (factors into net sales)
  • Refunds
  • Returns (sellable & non-sellable)
  • Adjustments
  • FBA Fee & Margin percentages
  • COGS & Net Sales
  • Totals for everything in the set date range

 

Daily Summary:

The Daily Summary is filterable by any date range, settlement ID, sku or type (Order, Adjustment, Inventory & Service Fees), etc.

You can view stats like:

  • Number of orders/refunds/adjustments
  • Returns & Adjustments
  • Gross Sales
  • COGS
  • Net Profit

 

Year Summary:

To view more screen shots click on the thumbnails under the main image at the top of the page

View all of the above stats by month, including:

  • Totals for everything
  • Breakdown of Expenses/Income
  • PO Summary
  • Transfers from Amazon
  • Returns Summary

Purchase Order Tracking

To view more screen shots click on the thumbnails under the main image at the top of the page
  • 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
  • Import PO Data from Inventory Lab

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
  • Enter returns back into inventory manually if you send a return back to Amazon
  • Calculates the top 20 most returned items

Advertising PPC tracking

toolsforfba_amazon_fba_sales_advertising

To view more screen shots click on the thumbnails under the main image at the top of the page
  • 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
  • View which keywords/campaigns are performing the best
  • Filter & sort by date range, SKU, and match type

 

 

Detail Page Statistics

To view more screen shots click on the thumbnails under the main image at the top of the 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 in Product Summary

FBA Shipping Data (*NEW*)

To view more screen shots click on the thumbnails under the main image at the top of the page

View stats on FBA Shipping like:

  • Total quantity sent & received by shipment
  • Shipments with quantity discrepancies
  • Average cost per item to ship per shipment
  • Cost of shipping factored into net profit by SKU on Product Summary
  • Days in transit
  • Days to process
  • Summary by SKU of all of the above stats
  • Breakdown of all of the above by fulfillment center state
  • View which fulfillment centers cost you the most, and take the longest to ship to/process

 

General features: 

  • Support for Amazon.com, Amazon.ca, and Amazon.co.uk
  • Works with Microsoft Excel 2010+, and Excel for Mac 2011+ (certain early versions of Excel for Mac 2016 may experience issues – the latest version is highly recommended) – Charts and the automatic data imports will not work in Excel for Mac
  • Includes a dashboard that neatly displays sales stats visually with graphs
  • Easily import Amazon sales, returns, detail page stats, FBA shipping, and advertising data without copy/pasting in reports – just download the reports and click a button to import – or for PC Users, use the Auto-Import feature! (*NEW in v2.1)
  • Track purchases of shipping & office supplies, mileage and other online tools by month
  • Track taxes collected by any date range, and SKU
  • Track transfers to your bank account & reconcile by Settlement ID
  • Import PO Data (COGS), Mileage, and Shipping costs from Inventory Lab (*NEW in v2)
  • Import mileage data from MileIQ (*NEW in v2)
  • Automatic downloading of data reports from Seller Central (for PC only) – just click a button to refresh all of your data!
  • The spreadsheet can handle as much sales data as your computer can – we do recommend a 64 bit Excel, high memory computer for over 100,000 sales a year. The upper limit of Excel is 1 million rows per sheet.
  • Comes with FREE updates and improvements – only pay once

 

Video of how the Auto-import process works:

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

 

Additional information

Release Log

4/10/16 – v1.0 – Initial release
See change history on v1 product page

3/16/2017 – v2
– Removed upper limit of sales records & monthly SKU amounts (this is now only limited by Excel and your computer)
– Added FBA Shipping Summary & Data
– Added Daily Summary (filterable by any date range, settlement ID, or SKU)
– Added ability to import & update Sales Data with one report
– Removed individual monthly report & summary sheets (24 in all)
– Condensed Product Sum & Income Statement into one very detailed Product Sum page
– Added importers for Inventory Lab PO Data, Shipping Costs, and Mileage data
– Added MileIQ data import for Mileage data
– Added additional detailed costs to Product Sum Income statement
– Added Adjustment COGS, Return COGS, and Sales COGS
– Added ability to display Product Summary by any date range (within the same year)
– Added ability to reconcile / filter Product Summary by Settlement ID
– Added Manual Fulfillment Sold field on Product & Year Summary
– Added shipping calculations to individual SKU\\\'s on Product Summary
– Added and updated calculations for Beginning and End Inventory to reflect inbound FBA shipping
– Added report for SKU\\\'s with no or 0 PO\\\'s on PO Data sheet
– Added refresh data status update for Excel for Mac
– Added status for individual sections of updating, like sales, product sum, and shipping
– Added two new charts to the Dashboard – Refunds/Adjustments, Detail Pages
– Added Fulfillment Only Summary report which shows orders that were not sold through Amazon, but that Amazon fulfilled
– Fixed compatibility issues with Excel for Mac (except for early versions of 2016, which didn\\\'t have full VBA support)
– Fixed turn rate calculations for Product & Year Summary
– Updated Inventory Value to calculate by cost since this is more commonly used
– Updated PO Source Sum to include PO\\\'s with no source

3/19/2017 – v2 Beta 11
– Fixed bug with Data import on Shipping Data with Excel for Mac
– Added more status indicators in the lower left
– Several changes to the back end to make updating everything faster

3/20/2017 – v2 Beta 12
– Fixed bug with copying Inventory History in FBA Shipping Data correctly
– Fixed dates in UK data Shipping SKU Lists
– Made importing UK sales data slightly faster for large data sets
– Made some cumbersome formulas in FBA Shipping Data faster
– Fixed bug with updating PO Data totals when clicking Refresh all on Dashboard
– Fixed bug with Refresh PO Totals button

3/22/2017 – v2 Beta 13
– Corrected report URLs on Detail Page Data & Instructions for UK data
– Changed Refresh PO Totals to format PO Data and update PO Sum & Source Sum tables
– Improved speed of refreshing PO Data
– Added feature to change pasted in dates in PO Data to correct format (otherwise PO Sum would not work and COGS would not populate)
– Removed requirement for sku titles to match between the same sku entered multiple times in the PO Data sheet
– Filtered blanks from Source Sum
– Fixed bug that would prevent Product Sum from updating correctly after importing data from another sheet
– When importing data from another v2 sheet, dates from sheets with date filtering are also copied

3/24/2017 – v2 Beta 14
– Fixed issue with calculating average shipping cost per item on the Shipping Data / Sum pages
– Added detailed chart to Daily Sum sheet
– Added Month drop down selection to Daily Sum
– Added Month drop down selection to PO Source Sum
– Selecting a month in the month drop down or a Settlement ID now filters everything automatically on the Product Sum page.
– Fixed DIV/0 errors on Product Sum page when no data is loaded

3/25/2017 – v2 Beta 15
– Fixed error with loading FBA Shipping data on Excel for Mac
– Improved speed of calculating shipping data
– Fixed issue with updating all data and the order that things execute so everything doesn\\\'t have to be updated twice
– Improved speed of updating everything by reducing redundancy
– Fixed error with importing shipping data from another sheet – the first set of data was not importing
– Improved speed of copying data from another sheet

3/27/2017 – v2 Beta 16
– Added Shipment URLs to FBA Shipping Data sheet to easily gather cost data if needed
– Fixed bug with calculating ship cost per item (regression from b15)
– Major improvement with calculating ship cost automatically per shipment
– Fixed calculation with Avg Ship Cost/Item – previously it was taking the average of averages, which is not correct and would result in averages that were too high
– Added conditional formatting to Actual Ship Cost/Item manual entry field to show red when it needs to be filled in
– Added "Total Cost" to FBA Shipping Sum tables
– Restructured FBA Shipment Detail to data to make a little more sense
– Fixed another bug with import Shipping SKU lists on Excel for Mac
– Fixed bug with filtering by Settlement ID on Product Sum
– Removed un-used data model from PO Data
– Made importing data from v2 sheet faster and more efficient

3/29/2017 – v2 Beta 17
– Fixed error with Date Shipped on FBA Shipping Data
– Optimized re-calculating Shipping Data a little more
– Fixed locked error on PO Data
– Fixed formatting of Source column on PO Data
– Updated field descriptions
– Increased Advertising data from 500k to 1mil rows (Excel limit)

3/31/2017 – v2 Beta 18
– Added error check to make sure PO Data works correctly after copy/pasting data around within the sheet
– Fixed bug in FBA Shipping Data where certain fields would not be calculated correctly after importing new shipping data
– Added filter for Received Inventory Data where the date does not populate because it doesn\\\'t have corresponding data from the Shipping SKU List
– Fixed header on Returns sheet

4/4/2017 – v2 Beta 19
– Added importers for Inventory Lab PO Data, Shipping Costs, and Mileage data
– Fixed Shipment Totals in FBA Shipment Summary, and Shipments by Month chart
– Added Shipping Cost in Shipments by Month Chart on FBA Shipping Sum
– Added filter on FBA Shipping Sum for SKU in Fulfillment Center State Sum
– Changed filter on FBA Shipping Sum for Summary By SKU to Months
– Added cell highlighting if required data is not entered on PO Data
– Fixed monthly calculation totals on SuppliesMileage if dates are entered in the format d/m/yyyy
– Fixed Total FBA Sold on Year Sum
– Fixed End Inventory on Year and Product Sum to reflect MF items sold
– Cleaned up some XML code on the back end

4/7/2017 – v2
– Added Fulfillment Only Summary report which shows orders that were not sold through Amazon, but that Amazon fulfilled
– Added MileIQ data import for Mileage data
– Fixed case where updating sales data was crashing Excel for Mac
– Fixed data import on Detail Page Data, when a report contained one record
– Fixed dates for FBA Shipping Data SKU Lists, when dates were in the format mmddyyyy, mm.dd.yy instead of the default mm/dd/yy

4/17/2017 – v2.01
– Fixed bug with "Other Expenses" on Product Sum being positive instead of negative numbers
– Fixed crash bugs with Excel For Mac when importing sales data, shipping data, or Update on the dashboard.
– Fixed bug with imported Received Inventory Data with Excel For Mac
– Fixed bug with importing FBA shipping data sku lists when first file is blank
– Fixed bug when importing a blank Received Inventory Data file
– Added "Remove Data" button to Returns sheet

7/7/2017 – v2.05
– Added Reimbursements report and data analysis
– Reimbursements now help factor into inventory counts, like when Amazon reimburses with inventory instead of cash
– Modified how adjustments modify inventory counts
– If new returns data is loaded, the sellable override no longer goes out of sync with the line item (everything is now sorted by oldest to newest)
– Fixed bug when Advertising cost was included with sales data, and displaying it properly on the Yearly and Product Summary sheets
– Fixed bug with Returns report (Amazon added LPN and customer comment fields)
– Removed redundant "Net Sales" from Year Summary, and changed the Total at the far right to Net Sales to be consistent with figures on the Product Sum page

9/22/2017 – v2.06

For the PO Data sheet:
– Improved COGS calculation for items that, when returned, were entered back into inventory, For example, if you sold 1 item, it was returned, but then automatically put back into inventory, COGS would not calculate for the second sale unless you had a quantity of 2 entered for that item on the PO Data sheet.
– Fixed bug where, if wrong year was entered on PO Data sheet for one line item, COGS would not calculated correctly for an item
– Added "Shipped to Amz" column on PO Data sheet to count the number of that SKU that was shipped to Amazon, dependent on FBA Shipping Data
– Changed Total Sold on PO Data to not be dependent on the date range set on Product Sum dates

For the Product Sum sheet:
– Fixed bug with return COGS calculation total on Product Sum sheet. Previously only items that had sales during the given period were calculated.
– Added "Lightning Deal Fee" to Advertising totals
– Added "Manual Processing Fee" under Inventory Fees
– Added "Days in Stock"
– Avg Sales/Day now calculates from "Days in Stock"
– Added "Avg. Days in Stock" to Product Sum right column
– Multiple SKU titles are now removed
– Products that have been shipped to Amazon, but do not have any sales, are now displayed
– Inventory Value calculation improved to take inventory with no sales into account

For the Year Summary sheet:
– Fixed bug with monthly Tax calculation on Year Summary – previously only orders were being calculated, now return Tax are included.
– Added FBA Return Fees
– Added "Lightning Deal Fee" to Advertising totals
– Added "Manual Processing Fee", and "Long-Term Storage Fees"

For the Returns sheet:
– Added return fees column
– Added Net Total column (sum of fba fees, return fees, and COGS)
– Added above data to tables and removed one redundant table since everything can be filtered by month
– Added product name to “Summary by Month/Sku”
– COGS calculation for returns now gets its value from the matching order ID. If there is no matching order ID, COGS are averaged from what is available in the PO Sum sheet.

v2.1
– Fixed bug with running total for sales data over 6,000 records
– Fixed bug related to repairing the spreadsheet after importing return data and re-opening the spreadsheet
– Fixed bug that would allow the first record in FBA Shipping Data to appear twice if it was imported twice
– Fixed case where if you were reimbursed cash for lost or damaged inventory, but had not sent in any of that item in the current year, the End Inv. would be a negative number
– Fixed bug on Product Sum that would leave product titles with no SKUs at the end of the list if no FBA Shipping Data was imported
– Fixed bug that would remove some data related to counting returns and adjustments when deleting everything on the spreadsheet
– Fixed bug that would incorrectly add pound signs to some regular numbers when switching between US and UK data
– Fixed error with importing Returns data from previous versions and Override Sellable being populated with dates
– Fixed bug with Dec 1st showing up in Detail Page data even if there wasn\\\'t data for Dec
– Fixed bug with FBA Shipping Data that skewed data incorrectly if the quantity received for an item was later adjusted and showed up as a negative number
– Fixed bug with FBA Shipping Data Date Shipped & Days to Process when Date Shipped is missing from the data
– Fixed URL\\\'s on Detail Page Data, FBA Shipping Data, and Instructions for Canada
– Fixed bug with Net Total column on Returns sheet when returns and orders were more than one
– Added separate Locality selection on Instructions – Settings for Canada
– Refresh all data progress bar now closes on its own (PC Users)
– Added error checking around importing data from another sheet
– Added feature to save the spreadsheet quickly without re-calculating everything
– Speed improvements to Refresh all data, and loading new data
– Added AUTOMATED download of all data from Seller Central for PC users

v2.11
– Fixed bug where using Auto-Import all data would throw an error when getting to the FBA Shipping Data step
– Fixed bug that prevented auto-importing from gathering data from a previous year
– Fixed bug for date formatting for UK users when gathering sales and FBA shipping reports
– Fixed bug when data would not update properly if you have a spreadsheet open with the same sheet names (like the reimbursement checker or another copy of the sales spreadsheet)
– Fixed bug where Auto Import All Data would not cancel if you never logged in
– Added error checking around auto-importing Advertising data if you did not have access to reports or do not have any advertising data
– Added check to auto-importing advertising data to only download reports for data that are not already loaded, and only reports for the current year. Previously all reports were downloaded every time, and all data was reloaded, wasting time.
– Added feature to download Returns and Reimbursement reports if they have already been generated for that day, instead of generating them again and downloading.
– Added additional error checking for auto-imports around loading all pages properly
– Changed the way fulfillment reports (returns, reimbursements, received inventory, inventory history) are generated and downloaded for auto-import. Previously they were generated and downloaded one at a time, wasting a LOT of time. Now they are generated at the beginning of the process and then downloaded at the end.
– Changed auto-import for sales data to import incrementally by date for the current year instead of all data every time. This will save time significantly on generating the sales report and updating data.
– Clicking "Auto-Import Last Sales Report" and "Import Sales Report (manual)" now updates and refreshes all sales data
– Changed the way the first set of data is displayed in the table on Detail Page Data. It is now filterable by SKU
– If a file is not imported after manually importing sales data, the refresh of data is not initialized
– Added check to make sure the last sales report isn\\\'t "Scheduled"
– Added check to last sales data date – if it is current as of yesterday, do nothing
– Added "Stale Inventory" report to Dashboard
– Added the date range being shown to the Dashboard
– Added "Refresh Dashboard Data" button
– The To Date is now updated on Product Sum if you update sales data and have Date Range: All selected

v2.12 – 11/22/2017
– Restriction placed on period of time that can be downloaded for sales data reports to 180 days. The manual importer now updates data sequentially, and you can now load more than one file at a time. The auto-importer splits the sales data in to a max of 3 files
– Added date check for sales data
– Fixed compile error bug on Excel 2010 and 2013
– Restructured some back end code surrounding the fulfillment reports
– Fixed bug with importing detail page data
– Fixed bug with date checking for UK data
– If your computer is set to UK time, but you are importing US data, the Auto-import now compensates for this
– Added better check if you do not have any data for fulfillment reports
– Added better error handler. If there is an error it will now be logged in a file (spreadsheetname_error_log.txt)
– Added check for "no shipments found" when importing shipment data

v2.13 – 12/1/2017
– Fixed formatting issue with Detail Page Data in November
– Fixed case where detail page data report would try to download before page was fully loaded
– Added check for detail page data when report contains no data
– Added check for proper date formatting on PO Data sheet in case dates or other data is pasted in
– Fixed "To Date" error on fulfillment reports
– Fixed issue with IE windows running in the background or leaving one window open after things completed running
– Made running total for Sales Data more accurate when there are multiple purchases per order
– When importing more than one sales data file manually at the same time, the data is now sorted by the date
– Improvements to speed of recalculating sales data
– Added filter to item titles that contain "FBA" in Product Sum

v2.2 – 12/6/2017
– FIX FOR AMAZON.COM SALES DATA – a tax field was added to the sales data files from Amazon.com – this would throw off totals of imported data starting 12/5/2017
– Fixed issue with importing more than 100 shipping data files – only 5 would import
– Fixed issue with Amazon.co.uk sales data skipping the first record
– More code optimizations on the back end
– Improved error checking & reporting
– Added formatting check for imported sales SKUs
– Added removal of "amp;" in fulfillment data if you use ampersands in SKUs
– Added prompt when just generating sales data reports to let you know that the initiation of generating them is complete
– Added dated folder for advertising data so if more than one new report is downloaded, they all aren\\\'t imported again
– Added support for Removals report, which ties into inventory numbers, making them more accurate

v2.2 – 12/13/2017
– Fixed bug with auto downloading new FBA Shipment files – Amazon changed something on the page that broke the auto-loader
– Fixed bug with updating Removal orders
– Made downloading FBA shipment data faster

v2.22 – 2/5/2018
– Fixed bug with re-calculating some sales data after importing new data, manually and auto-import
– Fixed bug with importing UK Sales data starting on the wrong row
– Fixed bug with rows after the sales tax column being in the wrong columns on UK Sales data
– Fixed formatting of dates when auto-generating sales reports for UK Data. They are in US format for these reports
– Fixed bug with auto-importing sales data if there were no reports to get
– Fixed message "To Date is not before the From Date" when importing sales data for the first time
– Changed the way Advertising data is filtered by date in the compiled data table. The old method was not working properly
– Two copies of sales data were previously saved with the spreadsheet in a cache. This is no longer done which will result in a smaller file and a bit of a speed improvement for those with large sets of sales data
– Improved the way the Auto-Importer actually clicks "save as" in IE, inputs the folder, and file name. The old method was causing issues for some people, and open would be clicked, and/or the file name would not be changed.

v2.23 – 2/19/2018
– Fixed bug with importing Canadian sales data. Fields were not lining up correctly.
– Fixed bug with manually importing UK Sales Data on Excel for Mac – the top 2 rows were being excluded
– Fixed regression causing Days in Stock to not calculate on Product Sum
– Fixed regression causing ship costs to not Auto-Import correctly
– Removed some erroneous connections to files that don\\\'t exist
– Shipping cost is now calculated with Qty Received if Qty Shipped is 0. This was also causing a DIV/0 Error
– Improved the way FBA Shipping SKU Lists are downloaded and imported for Auto-Importing. Previously the download link was being clicked – now the download URLs are loaded directly.
– Added feature to gather dates for Shipping SKU Lists if they are not formatted correctly via Auto-Import
– Added feature to insert

v2.25 – 3/6/2018
– Fixed bug that would prevent more than 200 shipments from being auto-imported
– Fixed bug that was causing Detail Page Sum to not update properly
– Fixed bug that was preventing Advertising Data from auto-importing (related to switching to new Advertising report system)
– Fixed bug that was preventing Advertising Data from removing duplicates on import of data
– Fixed bug that was leaving open IE sessions after auto-importing fulfillment reports
– Fixed multiple little bugs that were throwing erroneous errors
– Fixed bug that preventing a file name from being properly changed on auto-import
– Added a yearly sub-folder to the download folder so reports are not mixed for different yearly spreadsheets
– Added completely new method for importing FBA Shipping SKU Data! It is much faster and you no longer have to download a file for every shipment. This also means it is more reliable!

v2.26 – 3/16/2018
– Fixed regression that left out calculations for FBA shipping cost per item
– Fixed bug with not including cost/COGS for lost and damaged inventory
– Fixed issue that was causing lost and damaged inventory to not show up and refunds to show up in the SKU\\\'s with no PO\\\'s report
– Fixed bug that was causing sales data with the description "FBA Inventory Reimbursement – General Adjustment" to show up in the SKU\\\'s with no PO\\\'s report
– Fixed bug that allowed sales data with the description "FBA Inventory Reimbursement – General Adjustment" to count as a sale and get assigned a cost/COGS
– Fixed bug that was importing the incorrect number of items for a case packed shipment with the Auto-import

v2.3 beta 1 – 4/27/18
– Added separate and more detailed stats for Income & Expenses sheet. This was previously on the right side of the Product Sum sheet. Calculations with refunds and other fees are now in line with Amazon Summary reports, and contain all (plus more) of the fields.
– Completely reworked some large and lengthy formulas, greatly improving calculation speed up to 75% for users with large data sets and multi core processors (Excel 64bit)
– Added ability to sort Product Sum sheet by any field.
– Updated yearly sum sheet to reflect some new fields, and reorganized a bit to make more sense
– Added Refund Amt. & Return fees calculation to Returns sheet

v2.3 beta 2 – 5/2/18
– Fixed bug that counted MF sold incorrectly when no MF orders were placed.
– Fixed bug that reported End Inventory incorrectly when no MF orders were placed

v2.3 beta 3 – 5/3/18
– Added marketplace facilitator tax column in sales data
– Added marketplace facilitator tax to Income Expenses
– Fixed bug with changing markets and dollar signs updating correctly
– Fixed bug in formula for counting End inventory in Product Sum
– Fixed bug where PO Data would not populate on Sales Data after adding more PO Data and refreshing data
– Fixed Refunds/Adjustments chart on Dashboard

v2.3 beta 4 – 5/4/18
– Added ability for auto-importer to try to recover if it loses the IE window (or it is closed)
– Added timeout for waiting for IE window to do something. If it doesn\\\'t after 10 seconds, it will close the window and move on or reload a page.
– Fixed another bug that was counting End Inventory incorrectly on Product Sum
– Fixed bug in MF Sold count on Product Sum and Income Expenses
– Fixed bug with FBA Shipping Data not calculating Dest State and Date Received correctly
– Fixed bug with Actual Ship Cost saving the last imports after running the Auto-Importer for shipping data
– Fixed bug that would cause some formulas to clear after removing all data from the spreadsheet

v2.3 beta 5 – 5/10/18
– Reconfigured the charts on the Dashboard a bit
– Got rid of the log scale notification on the Dashboard after recalculating data
– Optimized recalculation of sales data cache for slightly faster recalculation
– Fixed a bug with updating info on Daily Sum and Fulfillment Sub by individual filter (vs Refresh all data)
– Fixed a bug with End Inv. when there was no inventory from the previous year
– Fixed some inconsistencies with prices changing to Amazon.co.uk, and optimized the process
– Fixed calculation of facilitator tax on Product Sum and Year Sum (if an item has facilitator tax, it\\\'ll show regular tax, then facilitator tax as a negative number, making the regular tax 0)

v2.3 beta 6.1 – 11/23/18
– Fixed bug with manually updating sales & shipping data for PC users
– Fixed bug with inconsistent gross income & gross sales numbers across Year Summary and Income Expenses
– Fixed some inconsistency in back end code
– Fixed seller central login check when individually updating shipping data
– Added "General Adjustment" to Income Expenses
– Deactivated old advertising data system

v2.3 beta 7 – 11/27/2018
– Fixed bug with auto-importing sales data
– Fixed bug where incorrect data would be copied to the Product Sum sheet
– Made the process for Auto-importing sales data only a single step (instead of generating reports, then downloading)
– Adjusted the Sales reports so that up to 365 day reports can be generated instead of the old 180 day reports
– Sales reports will no longer generate again if the report is already available in the top position for the dates requested
– Fixed bug with updating sales data with over 32k records

v2.3 beta 8 – 1/7/2019
– Fixed bug with auto-importer stalling on non-existent FBA Shipments

v2.3 beta 9 – 1/25/2019
– Fixed bug that prevented inventory history from auto-importing
– Fixed bug that prevented fulfillment reports from downloading properly if the spreadsheet had to wait for the report to finish generating (a change was made to the fulfillment pages download button)

v2.3 beta 10 – 2/25/2019
– New Advertising reports now work with the spreadsheet! (manual import only at the moment)
– Fixed bug related to Product Sum showing duplicate SKUs if you have 2 SKUs
– Added some error checking around date formatting – if the formatting in the data doesn\\'t match your computer formatting an error is thrown

v2.3 beta 12 – 4/9/2019
– Fixed bug preventing Inventory History report from generating and downloading properly due to change on the download page
– Added feature to detect when new fulfillment reports are available for download with auto import when seller central is set to German, French, Spanish, or Italian

v2.3 Beta 13 – 6/28/2019
– Fixed bug with generating correct inventory history report (csv vs txt – now generates txt)
– Fixed importing Canada sales data (accommodation for difference in sales tax columns)
– Added check to make sure correct fulfillment report is downloaded

v2.3 Beta 14 – 8/16/2019
– Fixed bug preventing fulfillment reports from generating
– Added some error checking around skipping reports
– Removed some redundant code associated with inventory history reports

v2.3 Beta 15 – 11/20/2019
– Fixed Amazon.com Sales data report to accomodate for new tax fields. (only the total field is used for now)

v2.3 Beta 16 – 1/8/2020
– Fixed auto import of Amazon.com Sales data report to accomodate for new tax fields.

v2.3 Beta 17 – 7/29/2020
– Fixed import of Sales data with added column

v2.3 Beta 18 – 11/6/2020
– Fixed issue with importing sales data when data is from a Normal vs Business seller account. Previously added column "account type" is only contained in business accounts

You may also like…