I will create an inventory spreadsheet in excel and google sheets

Brazil

I speak Portuguese, English

Excel and Google Sheets Spreadsheets for Small Businesses

Hi, I'm Leandro. I spent 20 years running the day-to-day of a service company, and spreadsheets were how we kept track of everything: jobs, stock, prices and money. Today I build clean, simple spread...
About this Gig

Stop guessing what's on your shelves. I'll set up a clean, easy inventory spreadsheet that tells you what you have, what it's worth and what to reorder.


HOW IT WORKS

You log stock movements (purchases, sales, returns, adjustments). The spreadsheet calculates everything else for you: stock on hand, stock value, margins and status.


WHAT YOU GET

- Dashboard: stock value, items to reorder, out-of-stock, last 30 days sales and gross profit, month-by-month results and a chart

- Products list with automatic status: OK / Reorder / Out of stock

- Reorder list that fills itself, with supplier, suggested quantity and estimated cost

- Drop-down lists, so no typos

- 4 color themes included


WORKS EVERYWHERE

Microsoft Excel (2007 and newer, Windows and Mac), Google Sheets and Apple Numbers. No macros, no add-ons, no monthly subscription. Your data stays yours.


PERFECT FOR

Small shops, Etsy and Shopify sellers, makers, home-based businesses and anyone who has outgrown a simple item list.


Not sure which package fits? Send me a message before ordering. I usually reply within a few hours.


Platform:

Excel

•

Google Sheets

Development technology:

Excel

•

VLOOKUP

Expertise:

Formatting

•

Formulas

•

Dashboard

•

Charts

•

Data validation

My Portfolio