Jules
3 min read
Oct 26, 2016

Key Points:

  • When you’re setting your reorder point, you’re trying to strike a balance between overstocking and understocking
  • Excel Inventory Management Template lets you input your product details, purchase orders, and sales orders into the respective tabs
  • If you’re having difficulty keeping all the numbers straight in your mind, you might be interested in an SKU Generator

Do you want to know how to make better decisions to grow your business? At TradeGecko, we understand that spreadsheets offer an affordable and convenient option for managing different areas of their operations for young businesses. So to help you get better insights into your business, we’ve built some free inventory management tools to get you started on growing your business.

1. SKU Generator

We know how challenging it can be to think up a unique SKU code for all your items. If you’re having difficulty keeping all the numbers straight in your mind (what does 151930205 mean?!), you might be interested in our SKU Generator.

It takes your Product Name, along with two descriptive options, into account when generating your SKU code. You’ll receive easily understandable product codes that you can use to search and identify stock on hand from lists, invoices, and order forms.

sku-generator-excel-template-download

2. Reorder Point Calculator

We know how difficult it can be to decide on your reorder point. When you’re setting your reorder point, you’re trying to strike a balance between overstocking and understocking. To help you out, we’ve designed a reorder point calculator that lets you know exactly when it’s time to place an order for a new shipment of products.

All you need is your average daily sales, your average lead time in days, your maximum daily sales, and your maximum lead time.

But we understand it can be exhausting typing in the details of every one of your 100 SKUs, and copying the results of the web calculator into a new spreadsheet. So we’ve created a reorder point excel template!

reorder-point-calculator-excel-download

3. Invoice Template

Did you know that only 63% of invoices are paid on time?

And one of the biggest reasons for late payments comes from invoices with unclear instructions. Always ensure you spell out your product details in full so your customers know exactly what they’re getting billed for. Also, personalizing your invoice with your business logo helps you look more professional… while increasing your chances of getting paid by 300%!

Our invoice template lets you select an image to be used as your logo, along with a section for ‘Notes’ where you can input the details around payment terms. We’ll also automatically calculate the total for you, taking any applicable discounts and taxes into account!

You’re welcome.

invoice-generator-template

4. Excel Inventory Management Template

Our Excel Inventory Management Template lets you input your product details, purchase orders and sales orders into the respective tabs. And from these, our Inventory Management tool will calculate your retail price, total orders, orders waiting to be fulfilled, stocks waiting to be received, and stock on hand.

To see all your data at a glance, there’s also the ‘reports’ tab, which lets you see the amount and quantity purchased and sold, sorted by the supplier.

inventory-management-excel-template-download

In time, as your business grows and evolves, you’ll need a system that grows with it. If you’re moving from the Excel Inventory Management Template to TradeGecko, the ‘Export to TradeGecko’ tab lets you import ALL your existing data into TradeGecko, and you’ll be all ready to take your business to the next level.

Moving Forward

While these free inventory management tools offer young businesses a great way to start growing, you may soon discover that dealing with four different tools to manage your business is becoming a little troublesome.

And when that happens, TradeGecko provides you with a streamlined system that makes business operations as easy as possible, freeing up time for you to grow your business.

Guest Post By Tradegecko

TABLE OF CONTENTS

Key Points:

  • When you’re setting your reorder point, you’re trying to strike a balance between overstocking and understocking
  • Excel Inventory Management Template lets you input your product details, purchase orders, and sales orders into the respective tabs
  • If you’re having difficulty keeping all the numbers straight in your mind, you might be interested in an SKU Generator
Get Your Ship Together.

By submitting the form, you agree to receive marketing emails from Easyship.

Save up to 91% on Shipping. Try for free.

Effortlessly compare 550+ courier services with one global account. Instant discounts. Start in minutes.

Shipping Internationally? Unsure What Tariffs or Duties Apply?
Try our FREE Tax & Duty Calculator

Trying to stay up to date on the latest cross-border shipping and import requirements? Get an instant estimate of all applicable taxes and duties for every country across 220+ global destinations or sign up and take advantage of our in-built HS Code lookup tool.

Calculate Tax & Duties Instantly (Free Tool)
Ready to Stop Overpaying for Shipping?
Try our FREE Shipping Rate Calculator

Looking for the cheapest way to ship a package? Get an instant shipping quote and compare rates from 550+ courier services across the United States, Canada, UK, Australia, and more. Simply add your package size and delivery location, and you'll find the best deal in seconds.

Calculate Rates Instantly (Free Tool)
Planning Your Campaign?

Get in touch with us now and our shipping consultants can give you a detailed quote and additional info to help with your campaign.

Get in touch
The Cheapest Shipping from USPS, UPS & FedEx

Find the guaranteed cheapest rates for any courier in seconds with Easyship’s free shipping rate calculator. Compare discount rates from USPS, UPS, FedEx, and 250+ couriers at a glance.

GET RATE QUOTES FREE
The Cheapest Shipping from USPS, UPS & FedEx

Find the guaranteed cheapest rates for any courier in seconds with Easyship’s free shipping rate calculator. Compare discount rates from USPS, UPS, FedEx, and 250+ couriers at a glance.

GET RATE QUOTES FREE
Get in touch with our fulfillment experts!

We believe simple pricing is the best pricing. Get a quote with a simplified pricing structure and no hidden fees.

Contact us
Need help fulfilling your crowdfunding campaign?

We provide the necessary tools needed to keep you on budget for shipping and to safely deliver your product to backers around the world.

Learn more
Try our duty & tax calculator!

Need to estimate your shipping duties & taxes? Our calculator can give you an idea of what to expect.

TRY IT NOW
Save up to 91% on Shipping. Try for free.

Compare 550+ courier services with one global account. Start in minutes.

GET STARTED FOR FREE
Get a Free Quote for Your Campaign

Receive a personal cost estimate for your crowdfunding campaign from our trusted global fulfillment partners. Easyship is a certified Indiegogo partner.

GET FREE QUOTE
Looking for great rates from a top courier?

Save up to 74% on UPS shipping rates by shipping with Easyship. You can run a quote and generate your first shipments in literally minutes!

SHIP WITH UPS TODAY
The cheapest way to ship for eCommerce

Get instant access with volume-discounted shipping rates. Save up to 89% off on USPS, UPS, FedEx, and more. Easyship is free for 50 shipments each month.

SIGN UP FREE TO SAVE
Find your perfect fulfillment partner with expert help

Let Easyship connect you to the largest shipping and fulfillment network on Earth. You’ll find trusted partners for all things logistics. Guidance is free from our global shipping experts.

ASK AN EXPERT
Don’t miss our money and time-saving features!

Explore the powerful features that 100K+ merchants use to ship smarter, not harder. Shipping automation, live rates at checkout, live duty and tax – all free to try with Easyship.

EXPLORE ALL FEATURES
Start saving on shipping in seconds

Create your free Easyship account to streamline shipping and save with discounted rates. No hidden fees. No minimums. Just savings.

CREATE YOUR FREE ACCOUNT
Create Your Shipping Policy Free

Use our guided walk-through to build the perfect shipping policy for your eCommerce business.

CREATE YOUR POLICY FREE
Looking to intergrate your Shopify store?

With 550+ pre-negotiated shipping services available with discounts of up to 91%, you can save time & money today when you integrate your Shopify store with Easyship

REGISTER FOR FREE
Use Easyship Free Every Month

Easyship is free to use for 50 shipments every month. You’ll save big on our discounted shipping rates up to 91% off, and save time with smart automation. Signup is fast and free.

CREATE YOUR FREE ACCOUNT
Don’t miss the key steps to fulfillment success

Follow the easy path to fulfillment success. Easyship’s free fulfillment checklist provides a proven step-by-step so you can ship at scale without the guesswork.

VIEW THE CHECKLIST
Ship for less with any courier, guaranteed

Save up to 89% off all shipping rates. Easyship offers the guaranteed cheapest volume-discounted rates on the market from USPS, UPS, FedEx, and 250+ global couriers.

SIGN UP TO SAVE
Don’t miss all our money and time-saving features!

Explore the innovative features that 100K+ merchants use to ship smarter, not harder. Shipping automation, live rates at checkout, live duty and tax – all free to try with Easyship.

EXPLORE FEATURES
Want the cheapest rates?

Register for an Easyship account today and you will gain access to the cheapest rates, instantly.

REGISTER FOR FREE
Watch out for international duty and tax!

What exactly does it cost to ship cross-border? Use the free duty and tax calculator from Easyship to view accurate import costs for any shipment to anywhere.

USE FREE
Protect Your Crowdfunding Budget from Cost Creep

Prices are rising, deliveries are slowing. Get up to speed on the state of crowdfunding shipping with expert Easyship analysis and keep your campaign on budget.

LEARN MORE
Discover the Cheapest Shipping from USPS, UPS & FedEx

Find the guaranteed cheapest rates for any courier in seconds with Easyship’s free shipping rate calculator. Compare discount rates from USPS, UPS, FedEx, and 550+ courier services at a glance.

GET A FREE QUOTE
Discover Your Cheapest Way to Ship

Find the guaranteed cheapest shipping in seconds with Easyship’s free shipping rate calculator. Compare discounted rates from USPS, UPS, FedEx, and 250+ global couriers at a glance.

COMPARE RATES FREE
Compare the best rates in seconds

Get an instant estimate of the cheapest shipping rates with our free calculator tool.

GET FREE RATE QUOTES
Save money on every shipment

Save up to 91% off shipping with Easyship’s discount courier rates. Create your free account to save instantly on 550+ courier services, including USPS.

CREATE YOUR FREE ACCOUNT
Ready to ship internationally?

Get help from our global shipping experts on warehousing, global shipping and to connect with our network of trusted 3PLs.

GET FREE SHIPPING TIPS
How’s Your Covid Shipping Policy?

Use our free shipping policy generator to formulate your safest, most customer-friendly shipping policy in seconds.

GET YOUR SHIPPING POLICY
Try Pre-generated Return Labels For Free

Register for an Easyship account today and get 30-days access to a Premier plan with access to Pre-generated Return Labels.

Generate Return Labels Today
Discover the Cheapest Shipping from USPS, UPS® & FedEx

Find the guaranteed cheapest rates for any courier in seconds with Easyship’s free shipping rate calculator. Compare discount rates from USPS, UPS, FedEx, and 250+ couriers at a glance.

GET RATE QUOTES FREE
Get Up to Speed On Covid Shipping

Explore our Covid shipping resources to make sure your shipment arrives on time and in good condition.

LEARN MORE
Free Shipping for the Holidays 101

Learn how the leading brands offer free shipping, calculate costs, and ship on a budget for the holidays in our free shipping guidebook.

LEARN MORE
Your Perfect Shipping Policy, Ready in Minutes

Use Easyship’s free shipping policy generator to formulate your perfect holiday shipping policy for returns, tracking, and more. Just follow the prompts and you’re done!

GET YOUR SHIPPING POLICY
Scale Your Growth Internationally With Pro Tips

Learn how to ship internationally without missing a step. Our case studies show you proven tactics for shipping worldwide from Easyship users who did it right.

READ CASE STUDIES
No items found.
Share on:

Related Articles

No items found.