Skip to content

Wholesale Price Calculator Excel Template

4.58 (12 reviews)

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

Download Free Version
One-Time Purchase
Business Subscription

Additional Services



Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

One-Time Purchase
Business Subscription
SOMEKA BUSINESS 99 $ /m

Redeem 3 Templates

Download 3 premium templates of your choice for free each month.

Continuous Technical Support

We’ll be your one-stop assistant for all your Excel & Google Sheets questions and needs.

Multi-User Environment

You’ll be entitled to multi-user licensing for your templates.

Cancel Anytime | Growing Catalogue | Continuous Updates

someka-bundle-icon

TEMPLATE DESCRIPTION

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.

Database:

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.

Wholesale-Price-Calculator-Template-S01

Dashboard

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.

Wholesale-Price-Calculator-Template-S02

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.

PRODUCT VIDEO

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

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

12 reviews for Wholesale Price Calculator Excel Template

  1. Debbie.S

    I lost the original of my template, can u help m,e?

    • Someka

      Hey there! Don’t worry, we can easily send you the product via email. All you have to do is email us with the exact email address that you used to purchase the template. Then, we’ll get the original version of the Wholesale Price Calculator to you as soon as possible.

  2. Aneta

    I think it’s great that the top right corner has this cool change feature! It makes it easy to check out what would happen if we added a new product to the wholesale selection.

  3. Kork Lebuwitz

    I’ve been using this awesome wholesale price calculator for years! It’s easy to use and works great.

  4. Leni. D

    This teamplate is amazing! I feel like a pricing prooa now.

  5. Ivan Vang

    I was so impressed by the informative instructions in this template! They made it easy to figure out how to use it.

  6. Travis.B

    I had some troublwe with this template, it seem to be locked and I could not input any data.

    • Someka

      Hey there! We’ve locked all of our templates so you won’t accidentally change any of the formulas. If you’d like to make any adjustments, you can use the password in the zip file we sent you initially. If you need any help, let us know right away!

  7. Ross K.

    Does this template work on Mac?

    • Someka

      Hey there! If you’re using a Mac, this price calculator template will still work. Just make sure you have Microsoft Excel installed first!

  8. 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!

      Regards,

  9. 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!

  10. 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,

  11. 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.
      Regards,

  12. Abdu

    Nice!!!

Leave a customer review

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

RELATED TEMPLATES

Search