skip to Main Content

Wholesale Price Calculator Excel Template

4.2 (5 reviews)

Wholesale pricing spreadsheet in Excel. Define discounts, calculate profit & prepare price list. Easy-to-fill and printable listing. No installation needed.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



Wholesale Price Calculator Excel Template is a tool to calculate your wholesale offer details once you set the inputs. You will input all the product info into the database with its unit price and unit cost.

Once you also input the details of the trade, it will be much easier to check to see the price offer results.

wholesale-price-calculator-flow-1Also, the impact of a new product in the wholesale offer could be easily seen by the dynamic change in the top right corner.


This section helps you to register all your products with its unit price and unit cost which later you can use in the dashboard section of the Excel Wholesale Price Calculator. The products which have been input into the database could be chosen by a drop-down menu in the dashboard section.



Above all, the dashboard will give you access to choose the products that you input in the database section. You will be able to select items from the drop-down menus under the Product Description column. Once you choose, the Unit Price and Unit Cost will show up on the dashboard.


When you input all the details of the wholesale — the quantity of each product you sold and discount percentage for each product (if there is any), the template will give you the details of the trade such as Total Quantity, Revenue, Profit, and Average Profit (%).

Wholesale Price Calculator Excel Template Features:

  • Easy to use Price Offer Template
  • Provides an overview of average profitability
  • Informational notes included
  • No installation needed. Ready to use.
  • Works both on Mac and Windows
  • Compatible with Excel 2007 and later versions
  • Does not include any VBA macros

Wholesale Price Calculator is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.



5 reviews for Wholesale Price Calculator Excel Template

  1. Harsh Sri

    Can we use this excel sheet into Andriod Smartphone with the excel application?

    • Someka

      Hi Harsh, thanks a lot for your comment!

      We mainly build our templates for Desktop Use. However, some of our simple templates (especially those which don’t include macros) may work in Excel Mobile App. We don’t test our templates on mobile devices, so we can not guarantee that all the features will work properly or not. Hope that helps!


  2. Jenny Scott

    I purchased this template. But, when I tried to add more information to it, I realized that It doesn’t allow me to add more sheets and this is not what I expected. Also, I have to use the same template and save it per different projects individually instead of having a track of it in the same file.

    • Someka

      Hi Jenny, thanks for your review!
      Did you unlock the template with the password you received?

      Firstly, you should unlock the template to be able to add more sheets, rows/columns, etc. Please follow these steps: unlock the template > open the sheet tabs > display the headings. You should use the little plus sign on the left side of the template to add new rows. We have shown how to do it on Wholesale Calculator – product video, so please do not forget to have a look at it as well.

      Besides that, you can use one file if you would like to see the total offer summary for multiple projects at the same time. But, it is not possible to do each project separately in the same template. We recommend using the template for each project as a different name in such cases. Hope that helps!

    • Jenny

      I didn’t realize that I have to unlock it before modification. I unlocked it and added new sheets for my personal info and tables. It is more useful now with my changes. thanks!

  3. Voldux

    I have a question. I recently bought the Wholesale price calculator for single user and I have a little problem.

    I can’t see all my products in the drop down menu. I can only find 47 products but a have many more product that I have to use. Do you have a solution.

    Kind regards

    • Someka

      Hi Voldux,

      First of all, thanks a lot for your interest!

      Did you input your all product names into the “Products/Services Database” sheet? Even if you completely fill the table on the database sheet, the template allows you to enter about 90 products. So, you will be able to see all those item names in the dropdown button on the dashboard. Besides that, you can also unlock the template and click the plus sign on the left side of the table to add new rows.

      On the other hand, if you are asking this for the dashboard, you should use the same plus sign on the left to increase the row number. You can also add new rows manually to enlarge the table. But, we recommend adding it from the middle to keep the format the same.

      Hope that helps!

      Best regards,

  4. leung

    may i know how to do the following?
    1. add a column/ row inside the form
    2. Display like a normal excel table which has A to Z and 1-9999 axis and open some sheets underneath??

    • Someka

      Hi Leung,
      Let us answer your questions!
      To do all of the modifications, you need to unlock both worksheets and the workbook first: How can I unlock the sheets? What is the password?

      Q1: Now, you will be able to click the plus sign on the left side of the template to add more rows. Besides that, you can also add new columns by right click > insert.

      Q2: We guess you would like to open headings and display sheet tabs to make the sheet more like the original excel appearance.

      Hope that helps! We will be happy to answer if you have further questions.

  5. Abdu


Leave a customer review

Only verified users who have downloaded and used the template may leave a review.