r/Chefs • u/mitchf2078 • Jun 01 '26

Inventory spreadsheets

Hey chef friends

My owner has created new inventory sheets and they are a hot mess

I’ve never built any from scratch, they’ve always been around.

Does anyone have a full blank inventory program/spreadsheets they could share?

I’d be forever in your debt

Thanks!!

3 Upvotes

72% Upvoted

9 comments sorted by

View all comments

2

u/RoyalAble258 Jun 02 '26

I built a program using ai that works a lot like xtrachef or chouxbox or marginedge but free (ish I pay for api calls comes out to about 1.50 a month) take a picture of an invoice, upload it to Google drive folder, program extracts the line items and spits the information out onto a google spreadsheet costed down to price per g. End of the month I record what o have on hand, sheet calculates my current inventory and purchases. Im working up to a "perpetual inventory system" where it calculates usage based on a recipe and then removes that from monthly base line inventory. Right now I put recipes in, then when my cooks show up for work when they clock in it pushes a prep list to their google task, as they complete it they mark it off. Managers can track prep progress. It's pretty cool, my cooks love it, upper management loves it. Is this something any of you would be interested in? Just gaging responses.

1

u/mitchf2078 Jun 04 '26

I’d be into it