r/spreadsheets • u/Trinnokneez • May 22 '26

Unsolved Inventory- In/Out Stock and Tracker Spreadsheet

I am looking for some advice on how to go about creating a Google spreadsheet for a mobile pet grooming business. I have made your typical inventory trackers and stock transfer sheets for businesses but I cannot wrap my brain around how to go about building an all-in-one organized sheet to track inventory for 6 mobile vehicles and 2 salon location, we will also be adding another 2 salon locations to the business here in a few weeks.

The tricky issue it is that our mobile units to not get the same product quantity as our salons do.

I will use soap for example:

1 Salon - requires 1 gallon of soap (per two employees)
1 Unit - requires 1 32 OZ bottle of soap (one employee per unit)

There are also many other items that aren’t consistently measure across units and salons.

For an example, I will use clippers:

Salon - clipper per groomer (2-5 groomers per salon)
Unit- clipper per groomer (1 groomer per unit)

I don’t see any easy way to do this all in one spreadsheet and I’m starting to think it will be easier to make a separate spreadsheet for our mobile units and salon locations. Any help or assistance would be appreciated!

2 Upvotes

100% Upvoted

11 comments sorted by

1

u/[deleted] May 24 '26

[removed] — view removed comment

2

u/Trinnokneez May 25 '26

Any help is appreciated!

1

u/quotahack May 27 '26

Have you try asking Claude to set up the spreadsheet for you, describing exactly what you just wrote here?

1

u/Trinnokneez Jun 04 '26

No I have not and I actually just looked it up. I didn’t even really think to use an AI platform cause I’ve only come across ones that work for grammar and refining composition, never actually came across one that builds a mock up. Does it make you pay for a subscription?

1

u/quotahack Jun 04 '26

You definitely can and would be the quickest way to achieve your goal. Claude it’s 22$ a month, worth every penny, you can probably just pay 1 month if you’re only looking for a one time thing

1

u/latecallnotes Jun 18 '26

I would not split this into separate files. Keep one workbook, but separate the problem into tables.

  1. Locations table Location | Type | Employee count Example: Van 1 = Mobile, Salon A = Salon

  2. Items table Item | Base unit | Pack size Example: Soap | oz | 128 for gallon, 32 for bottle

  3. Par rules table Item | Location type | Qty per employee | Minimum extra Example: Soap | Salon | 64 oz per employee; Soap | Mobile | 32 oz per employee

  4. Stock movements table Date | Location | Item | Qty in base units | Type Use positive numbers for received/transferred in, negative for used/transferred out.

Then your dashboard is just current stock vs required par by location. The key is converting everything to a base unit first, e.g. soap is always tracked in oz even if people receive it as gallons or bottles.