The process of scanning inventory into and out of inventory using QR codes, Google Forms, and Google Sheets

A Transactional Inventory without the ERP

QR locator code scans in at location for inventory entry
QR locator code scans in at location for inventory entry. Pattern has been corrupted to protect the innocent.

If you find that your partners, employees, or you are falling short or ending up with too much of particular inventory items in your business, your inventory tracking is probably a factor. A lot of people think of one of two things when they think of “inventory”: a clipboard and a computer screen. As companies grow, they migrate from manual inventories, to more complex inventory management systems. A great bridge system for a growing business may be to use my system leveraging Google Sheets, Google Forms, and QR Codes for a quick boost to a digital transactional inventory. Read more

Screenshot of an Excel purchase order template

Keeping Excel (and Data) “Upright”

It happens every time I see a new company, employee, or private coaching client: they open up their ‘working’ spreadsheet — you know, the one that runs everything — and their data is laid out horizontally. I discreetly calm myself down and put my hands behind my back, in my lap, on a notebook…anywhere I can to keep from reaching out and taking the keyboard and mouse away from them. I remind myself it is an easy fix, and the opportunity to change the way a person looks at data forever. They have violated my number one rule of functional Excel: Read more