I will build an automated inventory control spreadsheet in excel or sheets

Your stock runs out and you only find out when a customer asks for it. I fix that.

I build a live inventory sheet that records every entry and exit, calculates the current balance by itself, and flags every item that has to be reordered BEFORE it runs out, in colour, on the first screen you open.

WHAT YOU GET

• A dashboard: total stock value, items to reorder, items out of stock
• - A product list with a minimum stock level per item
• - A movement log with dropdowns, so nobody types a product name wrong
• - Automatic status per product: OK / REORDER / OUT OF STOCK
• - An instructions tab written in plain language, so your team can use it without me

Works in Excel and in Google Sheets. Send me your product list and it arrives already loaded with your own items.

WHY ME

I came from behind the counter. I worked in a pharmacy and I know the routine of controlling stock by hand, so the sheet is built for the person who will actually use it at the end of a long shift, not for a spreadsheet expert.

EM PORTUGUES: planilha de estoque viva, com painel, alerta de reposicao e aba de instrucoes. Atendo em portugues.