Freelance Google Sheets / Excel Inventory & Usage Tracker (Simple, No Macros)

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.