Retail Inventory Tracker – Free Inventory (Stock) Management template

Posted on
Retail Business Process - Retail Inventory Tracker Template
I am glad to present a simple and effective way to manage orders and inventory for your retail business. If you are getting started with a retail business where you plan to buy products from your suppliers and then sell them to customers with a margin, then you would need a tool to track your business in an effective way.

Continue reading Retail Inventory Tracker – Free Inventory (Stock) Management template

Inventory Management Excel Template – Migrating data

Posted on

This post demonstrates how to migrate data from the free Inventory and Sales Management Excel template to the premium version. It should take less than 10 minutes to migrate and get all the additional benefits of the premium Excel template. The following video demonstrates the process and the steps are also explained in the post below.

 

https://youtu.be/XdQAHmw4hzU

 

  1. SETTINGS
    • Enter Basic business info in the premium template. Enter Location if you need to change it
  2. PRODUCTS
    • Copy Products data from free template and then paste as values in cell B6 in PRODUCTS sheet in premium template.
    • Enter Product Ids Copy/Paste from your source or Type them in. If you don’t have Product IDs yet, then you can type 1, 2 and then fill the column.
    • Ignore Starting Inventory sheet
  3. PARTNERS
    • Copy Paste Partner Names from ORDERS_AND_INVENTORY sheet in the free template to the PARTNERS sheet in premium template
    • Remove Duplicates
    • Enter Partner IDs, Shipping address, Billing address, etc.
  4. ORDERS
    • From ORDERS_AND_INVENTORY sheet in the free template, copy first three columns and then paste as values in Cell A6 in ORDERS table in the premium template.
    • Copy Partner name column to ORDERS table.
    • Select ORDER TYPE column values. Press Control+F (Find and Replace). Replace Purchase with PURCHASE and Sale with SALE.
    • Remove duplicates
    • Enter Location.
  5. ORDER DETAILS
    1. From ORDERS_AND_INVENTORY sheet in the free template, copy columns (Order Number, Expected Date, Product Name, Quantity, Unit Price) to ORDER_DETAILS sheet in the premium template.
  6. Refresh data

 

With this, you have now migrated all your data to the premium excel template.

Retail Inventory and Sales Manager – Excel Template – Support

Posted on

The Retail Inventory and Sales Manager is suited for managing inventory and sales if you are running a business of buying products from suppliers and selling to customers. This Excel document will assist in knowing the inventory levels of each product and understanding which products to re-order. You can also create invoices instantly and print or save as PDF. In addition, you can quickly view the purchases/sales patterns over time and identify the best performing products. 

 

REQUIREMENTS

You need a copy of Microsoft Excel to open this file. The product has been tested in 

  • Excel for Windows (2007 or 2010 or 2013)
  • Excel for Mac (2011) – Since Excel for Mac doesn’t support Slicers and Pivot Charts, Analysis sheet is not available. Analysis Details sheet provides tables but not the charts. Please e-mail at indzara at gmail if there are questions.


LIMITATIONS

The template is not capable of reading data from bar code scanners.
 
There are several formulas embedded in the document. When the size of your data approaches the limits of this template (2000 products and 50,000 line items), there is a 3 to 5 second lag while inserting new line item. After a new line item is inserted, everything else works instantly. If you notice a lag, you can save a copy of the current file and start entering new orders in a new file.
 

CLICK HERE TO GO TO PRODUCT PAGE WHERE YOU CAN BUY

SUPPORT TOPICS

1. Migrate data from free to premium version in less than 10 minutes

 

 

2. HOW TO CHANGE CURRENCY
In the ‘Invoice’ sheet, from the Home ribbon, choose Find & Select –> Go To.
Retail Inventory and Sales Manager - Excel Template - Change Currency
Retail Inventory and Sales Manager – Excel Template – Change Currency
Retail Inventory and Sales Manager - Excel Template - Change Currency
Retail Inventory and Sales Manager – Excel Template – Change Currency

Choose CURRENCY_CELLS

Press Ctrl+1 or click on the Number format menu.

Retail Inventory and Sales Manager - Excel Template - Change Currency
Retail Inventory and Sales Manager – Excel Template – Change Currency
In the Format cells dialog box, choose the currency you would like to use.
Retail Inventory and Sales Manager - Excel Template - Change Currency
Retail Inventory and Sales Manager – Excel Template – Change Currency
Now, the invoice will display the amounts in the chosen currency.

3. WORKING WITH EXCEL TABLES

The template has several Excel Tables (link to Microsoft help). If you type data in the row after the last row of the table, then the table expands and includes your new row of data automatically. For deleting rows from a table, select cells from rows that you would like to delete. Right Click and select Delete—> Table Rows. This is the recommended way of adding and deleting data from tables.

Retail Inventory and Sales Manager - Excel Template - Delete Rows in Table
Retail Inventory and Sales Manager – Excel Template – Delete Rows in Table
If you have any questions about this Excel template, please leave a comment and I will respond as soon as I can. Thank you.

Inventory and Sales Manager – v2 (for 2000 products)

Posted on
Several of you have left comments or e-mailed me asking for the Inventory and Sales Manager template to support more than 100 products. I have posted a new version (v2) of the template that will allow 2000 products. All the other features remain the same. Please visit the original post to download the new version. The Template file and the Sample data file for v1 have been replaced with the files for v2. 

Please try the new version and let me know your feedback.