I’m looking for a freelancer to help me finish and organize an inventory tracking system in Excel / Google Sheets. I already have an inventory draft started in .xlsx (about half the items are entered), so this is not from scratch. I need a simple, formula-based system that automatically updates stock when items are used or when deliveries come in. Important: This file will be used by an older, non-tech-savvy person, so the layout must be very clear, easy to read, and require minimal steps. Current Inventory Setup (already started a draft, you can change the table as you see fit) The main inventory sheet already includes columns like: -Part number -Item name -Category (what vehicle/part it’s for) -Brand -Stock location (I'm organizing by shelf) -Units per box (e.g. 1 piece inside per box) -Quantity (number of boxes I have in stock) -Total quantity in stock (auto-calculated) I may add more inventory items later. What the system needs to do 1) Daily Usage Log (for billing by company) A simple sheet where the user only enters: -Date used -Item / part number -Quantity used -Company that used it (about 5 companies total) This should: -Automatically deduct quantities from inventory -Be filterable by day / week / month -Allow totals by company by day/week/month (so I know what to bill) 2) Delivery / Restock Log A simple sheet where the user enters: -Date received -Item / part number -Quantity received This should: Automatically add stock back into inventory 3) Reorder Alerts When stock drops below a set level (e.g. 2 boxes or pieces), show a clear visual warning (red cell or “REORDER” text) Reorder levels should be easy to adjust 4) Simple Summary (no fancy dashboard required) -Items that need reordering -Usage totals by company -Usage totals by date -Technical Requirements -No macros / VBA -Must work in Google Sheets -Formulas + conditional formatting only -Keep the file unlocked -Simple layout for fast manual entry Budget & Scope -I’m intentionally keeping this very simple. Similar projects on this platform are priced around $20–40 USD, and I’m aiming for that range. Please avoid overengineering — clean formulas and clear structure are all I need. Should be easily accessible in google/online/phone/tablet. What I’ll provide -Current inventory list/draft in .xlsx Please briefly explain how you’d structure inventory + usage + deliveries using formulas only.