As a chef, I enjoy creating new recipes and working on an artistic presentation. I’ll add a little of this, a little of that, some more of the other, taste it, a few more tweaks, and then “Ahhh! That’s it!” But…writing (documenting) the recipe is always so damn tedious! “Was it 1 tsp or 2? How do I calculate the cost of 1 cup fresh corn kernels? How much does 2 Tbl of fresh tarragon cost?” It is an unfortunate yet necessary exercise. Keeping track of how you did these calculations can save you a huge amount of time and frustration the next time you need to use the same ingredient.
If your company doesn’t have a professional software package which synchronizes current pricing to recipes, then using Excel is a good alternative. The Excel Recipe Template with Inventory file below will allow you to add multiple recipes to one Excel workbook and link all the recipes to one master inventory sheet. To update the pricing on all your recipes, simply update the prices on the inventory tab and all your recipes will be updated with current prices. I suggest that you keep the number of recipes per workbook under about 100, otherwise the file can become so large that it may run slowly.
Some knowledge of using Excel, especially Excel formulas, is helpful. But, the video demo should give you the tools to be able to use the file even if you are unfamiliar with Excel. You will however have to have a copy of Microsoft Excel on your computer in order to open and use this file. But if you are searching for professional inventory software then here is some info to get you started.
Here is an index of what is covered in the Excel video below:
- 1:44 using the recipe templates
- 2:35 syncing recipe costs to inventory
- 7:35 editing and working in the inventory list
- 7:44 adding “quick commands” which make using Excel easier
- 13:28 renaming tabs
- 13:39 moving tabs
- 14:10 creating an index with hyperlinks to the recipes
The Inventory & Recipe Template in the tutorial below is available to all Paid Subscribers
(get membership info)
Note: Microsoft Excel Required (not included)
To Change Currency
To change the currency from US dollars to any other currencyfollow this link to a short video.
To Change Units of Measure to Metric
Changing the units of measure is easy. Go to the “Inventory” tab. You will notice that there are multiple columns for “Unit” and “Price”. Simply add your item in the “Item” column, and then type in the units of measure that you want to use. Start with the largest unit first and do the math for each subsequent smaller unit of measure for that specific item.
For example: Mushrooms Porcini Dried, Case $175.00, Kg $35.00, G $1.25
For the recipes simply enter the unit of measure you want to use.
To Unprotect the sheets:
Although the sheets are protected there is no actual password. On the Excel menu bar go to: Format/Unprotect Sheet and click on “Unprotect Sheet”. Leave it blank and just click. You’ll have to do this with each sheet which is protected.
Or, check-out my short video on how to unprotect an Excel sheet.
Click picture for a larger image.
Comments from before Site Migration
Add a Comment!
Hi Carrie – the download button is above the video. But here’s a link in case you can’t find it.
Recipe-Template-Bulk_w_Inventory.xlsm
Hi Chef David,
how doi download this file, i cant find the link on your page.
Hi David,
Can you recommend any software for efficient control of food costs?
Thanks for all the information you have provided you should be proud, helping alot of people.
Cheers Mat
how to download it
Hi chef David what is the password to unprotect the cell it will not let me change the tax of food cost amout with out the password and the macros ?
Hey Chef David great from/ tool I only have one question ? how do you add a sub recipe price/ cost to the line recipe ? IE say you make a tomato sauce and add it as a recipe to this tool and then later on you use that same sauce in a tomato pasta recipes ? do you add the tomato sauce to the inventory and then add it back into the recipes and if so how do you do it does it update the cost of the sauce in the pasta recipe ?
What an incredible resource and how kind of you to offer it for free download (note: no longer free). I am using it in the UK where tax is included in all prices, in the info section under tax rate should I just input 0%? Thanks
Thanks so much for taking the time to make this and especially to make it available for free (note: no longer free). It has simplified my costing process considerably. One question, I would like to change the currency forrmat because the currency i work in (won) is larger by a factor of 1000 so it will not show larger values in the cells, just pound signs. Thank you again.
Leon – the download button for the template will only appear if you are a registered (free) user. FYI registered users may receive a few email newsletters a year from us…but nothing more. No BS, no marketing crap.
Where can I download this template
Thanks
Jay – are you having the problem on the “Inventory” tab? Please give me all the details of the item you are costing, including all the math, so I can test it out. Probably best to contact me via email rather than in the comment section: chefs-resources@ msn. com And if you know how to send a screen shot of the problem that would be helpful…here’s a link if you don’t know how https://windows.microsoft.com/en-us/windows/take-screen-capture-print-screen#take-screen-capture-print-screen=windows-7
and it always turned the section green. if that means anything. how do i change the color back?
hi for some reason the forth column for the unit and price (white) section doesn’t add up correctly. the equation is right but once i press enter my total comes out to 1. please tell me how to fix this. thank you!
Thank you so much for the quick response. I just wanted to make sure I wasn’t going to be breaking any rules by doing so! Thanks for all of your wonderful resources 🙂
Kristin – no worries! You can use it for your restaurant. You just can’t sell the template to anyone.
Hello. I just wanted to say that all of your resources are wonderful. I find this system much easier to use then the system we are currently using in my kitchen. My question is….. am I allowed to your system in my kitchen? The reason I am asking is because at the bottom of the recipe sheets there is a disclaimer that says “This file can not be used or sold as a means of generating revenue without prior permission in writing”. Since my kitchen does generate revenue, I am not sure if I am allowed to use it. If you could let me know it would be greatly appreciated.
Thank you for the wonderful and very helpful information on your website.
Kristin
Subscribe
Connect with
65 Comments
oldest
newest most voted
Inline Feedbacks
View all comments
brittany
8 years ago
For your costing spread sheet I can not seem to get it to actual cost out a recipe. I have followed your youtube video to the T and it still isn’t working. AP$/UNIT always comes back 0
Reply
ChefsResources
Admin
Reply to brittany
8 years ago
Not sure what the issue is I just downloaded it and tried some numbers and it worked ok. If you use the contact us form (link is in the footer at the bottom right) you can send me your email. Then I can contact you and have you send me the template with some numbers in it so I can see what exactly is wrong. Should be a very easy fix.
Reply
Kathleen
8 years ago
i’m not a chef, but i’m volunteering my services/ time to help a local vegan chef/cafe owner streamline some processes to help her be more profitable. I’ve been trying to download your recipe costing template with the inventory, but cannot find the download button and the links just take me back to the page with the video, and no way to download. I have registered on this site, and i’ve been able to download sever other templates (thank you for that!). Would greatly appreciate any direction. thank you! Kathleen
Reply
David Buchanan
Author
Reply to Kathleen
8 years ago
@disqus_Kbdcsg4E0r:disqus Sorry, a glitch removed the download button. I have put it back in place so you should be able to download now.
1
Reply
Kathleen
Reply to David Buchanan
8 years ago
Oh, thank you!!
Sent from my Verizon Wireless 4G LTE DROID
Reply
Kathleen
8 years ago
sorry – disregard. i found it on your fb page.
Reply
Chris DiNunno
8 years ago
Nice presentation. I used what I learned from you as a basis for my own. I learned a few new things, I hope you don’t mind if I pass them on and you can use them if you like. My inventory list has quite a few columns including UPC CODE so I’m sure I’m getting the right product from the company; the SUPPLIER so I can print ORDER SHEETS from a new tab and list only “Sysco” or “USFoods”, etc.; CATEGORY so I can sort by food type (seafood, meat, etc., regardless of storage location) – I also have a…Read more »
1
Reply
Matt Black
Reply to Chris DiNunno
6 years ago
Hi Chris,
I’m interested in the amendments that you’ve made to Chef David’s workbook is there any chance I could have a copy to try and cherry-pick the bits I need. Like you I have inventorized as products rather than areas and I just need a look-up sheet to speed up the search process, not that I’m not fully impressed by the other amendments that you have made, just that I don’t fully understand all the functionality. Very best wishes
Matt Black
Reply
Michael Hoyt
Reply to Chris DiNunno
8 years ago
@chrisdinunno:disqus Fascinated by your changes. If you are willing to share, I would love to see the spreadsheets. caterers@gmail dot com Thanks for considering my request
Reply
Neil Bell-Irving
Reply to Michael Hoyt
7 years ago
Fascinated by your changes as well @chrisdinunno:disqus . If you’re willing to share the form again, I would greatly appreciate learning from your improvements. My email is nbellirv@gmail dot com. Thanks for considering it.
Reply
David Buchanan
Author
Reply to Michael Hoyt
8 years ago
@disqus_j73MhrfBWc:disqus I forwarded the Excel sheet which @chris DiNunno emailed to me.
Reply
rhod uy
Reply to David Buchanan
5 years ago
HI Chef!
Just came across of your page. Thank you for the template. This will help us a lot in our small restaurant here in the Philippines.
If you don’t mind sharing the file of @chris DiNunno, I would love to check and try that out.
Appreciate your help and generosity.
Thank you so much from the Philippines!
email: rhodney.uy@gmail.com
Reply
David Buchanan
Author
Reply to Chris DiNunno
8 years ago
Awesome work @chrisdinunno:disqus! Sounds very detailed…very useful. I’d love to see your actual form if you wouldn’t mind sharing it. My email is chefs-resources @ msn dot com
Reply
Wil Ng
8 years ago
Hi David, just wanna say the biggest THANK YOU.. This spreadsheet has helped me, and surely others too, immensely keeping all costing organized and taken off a portion of the behind-the-scenes hard works. God bless you for what you do and we are all appreciative for your hard efforts! Keep up the great work! 🙂
Reply
Matt Black
Reply to Wil Ng
6 years ago
I agree wholeheartedly.
Reply
John Muyargas
7 years ago
i dont understand what i have done but it wont let me create a new recipe template. it errors. ‘cannot run macro….macro may not be available with this workbook or macros may be disabled.
Reply
Ana Espinal
7 years ago
Hi David, I do cakes, and I would like to change the amount of number of portions since cakes can be sell using a higher number of portions than 24. I might be misunderstanding. What number of portions is referring to? Can you help me out on this? and, if I am misunderstanding, can you explain to me? Thanks in advance.
Reply
David Buchanan
Author
Reply to Ana Espinal
7 years ago
24 is just an example number which you can change. You should definitely put the actual number of portions which your recipe will yield.
Reply
Ana Espinal
Reply to David Buchanan
7 years ago
Thanks sooooo much David. I would like you to know that I do love the template. Has been a huge blessing for me keeping everything organized and much more. Thanks again, and God continue blessing you in abundance!!!
1
Reply
Fadi Suleiman
7 years ago
Hi All,
I have a question in terms of setting up an inventory sheet. Say I have a batch of sauce that requires 7 ingredients. What I want to create is a sheet when I do inventory and I am counting my line. If I see there is a full batch and I enter 1, I want it to pull from the ingredients that are in the sauce. How do I do that?
If anyone can help that would amazing. My email is fsuleiman123@gmail.com
1
Reply
Matt Black
Reply to Fadi Suleiman
6 years ago
That will be from your recipe sheet. I don’t see why you would want to deconstruct the sauce to count the ingredients. As a recipe it is no longer individual items but a unique product with a new value. Maybe I have misunderstood the question.
Reply
Leonard
6 years ago
Good day Chef David
I placed everything in the inventory but now when i want to get the cost from inventory by going =then the line its not coming over to the recipe costing sheet. did i would something wrong plus I get a Macros disable at the top too. please help
Reply
David Buchanan
Author
Reply to Leonard
6 years ago
Hi @disqus_B7jmcr2PsD:disqus,
Send me the form you have as an attachment and I’ll take a look at it david@ chefs-resources.com (no space between @ and chefs-resources). You will need to Enable Macros to use some of the features of the file, but I don’t think it will affect what you are currently having an issue with.
Reply
Matt Black
6 years ago
Hello Chef David.
So many thanks for making this resource available for us, you are a true star. I am a European using kilos and grams, is it possible to change the formulas in the recipe sheets to accommodate this? I break the everything down to 100g on the inventory sheet, should I break things down to 1g with lots of decimal places or will I be able to use a formula that works with 100gs?
Very best wishes.
Matt.
ps if you ever visit the Cotswolds there’s a cup of tea and slice of cake waiting for youy.
1
Reply
Matt Black
Reply to Matt Black
6 years ago
Thanks Chef David It was a long long day yesterday and I realised almost as soon as I sent the email that I was being blonde. I have all weights set up in kilos in the inventory (apart from saffron which made my eyes water when I worked it out) so I assume that I just put the quantity as .250 for 250g or .010 for 10g in the recipe sheets. I am still working to input everything on the inventory section so will be trying out the recipe sheet tomorrow. Fingers crossed it’ll work nicely. Chris DiNunno posted about…Read more »
Reply
David Buchanan
Author
Reply to Matt Black
6 years ago
Would love to stop by for tea & cake! Perhaps someday that will work out. The units of measure on this sheet are easy to change. Simply type in the unit which you want to use. The formulas should work regardless of the unit of measure. But, on the Inventory sheet you will have to enter the formula for each unit of measure you choose. The video tutorial for this starts at about time mark 10:32. Formulas in Excel are just basic math. If you have a case of eggs w/ 15 dozen eggs in the case and the cost…Read more »
1
Reply
Matt Black
6 years ago
hello Chef David
would it be possible to share Chris DiNunnos excel sheets with me as I am interested in show he has organised his look-up sheets and recipe basics sheets.
best wishes
Matt Black
Reply
bikram
6 years ago
hi chef how can i make costing with this country kuwait dinner is it possible please give me the idea for this my email id is bikrsmb@gmail.com thank you for ur great suppourt
Reply
David Buchanan
Author
Reply to bikram
6 years ago
To Change Currency
To change the currency from US dollars to any other currency follow this link to a short video.
https://www.chefs-resources.com/culinary-videos/change-currency-in-excel/
Reply
bikram
Reply to David Buchanan
6 years ago
i did not get proper amount
bikram
6 years ago
hi chef thank you for ur great suppourt but chef i did not get the result proper or i didnt got rite i got some confuced
Reply
Ajit Singh
6 years ago
HI DAVID,
Kindly recommend me any software for INVENTORY and efficient control of food costs?
Reply
David Buchanan
Author
Reply to Ajit Singh
6 years ago
The Excel sheet on this page is a free way to manage inventory. Other software packages include ChefTec and Red Rock but their are many others. I’ve heard good things about ChefTec but haven’t used it. Red Rock works but it’s cumbersome.
Reply
Ajit Singh
Reply to David Buchanan
6 years ago
Thanks Man for the feedback.
Reply
Pete
6 years ago
Hi David,
I cannot get this to download
Reply
Andre
4 years ago
You are absolutely great. Thanks for helping other people with your knowledge and patience!! And also, your good will…
Reply
The Jude
4 years ago
Chef David – THANK YOU
Your generosity of nature and restaurant savvy has helped us so much in using your software.
Thank you so much for taking the time and having the heart to do what you have done by offering your software for us to use. You have enabled people to better run their businesses, keep an eye on their costs and become better owners, managers and chefs.
Thank you Chef David.
Reply
Anja
4 years ago
Hi David, when I add an inventory item, and then sort it, the cell that I linked it to originally in the recipe does not move with the sort and my costs are off. Is there a function missing, or can I not sort the inventory once I linked ingredients to recipes?
Anja
Reply
Paul
4 years ago
When I attempt to link from the inventory tab to a recipe it does not link? I press = and go to the inventory and select the box with the correct formula and when i go back to the recipe I am working with it is only selecting from that recipe? =Chicken!H12 It should read =Inventory!H12 but for whatever reason it will not do this?
Reply
Sameh
4 years ago
Good job
1
Reply
Michael Purcell
3 years ago
I have the program for Inventory matched up with menus but the extension does not work with my inventory, I put in the = sign then click onto the space on the inventory, it gets highlighted, and gets added into the area but nothing calculates across. What am I missing or is there another down load to add to the program?
Thanks
Mike
Reply
ChefsResources
Author
Reply to Michael Purcell
3 years ago
Are you also adding a yield %? It will not calculate until yield is entered. Also, try saving it and see if it calculates after saving. Depending on what your preferences are set at in Excel, it will automatically calculate as your enter numbers, or it will only calculate after saving the file.
Reply
ALFREDO SALAZAR
3 years ago
Dear Chef Buchanan, this format template is calculated wrongly, the formula used in the EP$ Column H, please could you fix it.
Reply
ChefsResources
Author
Reply to ALFREDO SALAZAR
3 years ago
Hi Alfredo, download the version currently on this page. I just checked it and it seems to be correct. 1 each at a cost of $100 w/ a yield % of 75% = extended cost of $125
Reply
YOLANDA DENE SMITH
3 years ago
thank you chef this is exactly what i was looking for
1
Reply
hruiz97
3 years ago
where the download for this file im a pay member but for some reason when i click download takes me to another page where no download happened
Reply
ChefsResources
Author
Reply to hruiz97
3 years ago
When you click on the download button it takes you to a new page which only opens if you are a paid member. Since you are a paid member, all the downloads you have access to are on that page. Just look for the one you want and click on the download button under that form’s picture.
For this form it would be the sync recipes & inventory form.
Reply
Jane
3 years ago
Hi I need help with my assignment please help
Reply
ChefsResources
Author
Reply to Jane
3 years ago
I posted a reply on the plate cost page you commented on. https://www.chefs-resources.com/kitchen-forms/recipe-template/plate-cost-how-to-calculate-recipe-cost/#comments
Reply
Gregory Spirito
2 years ago
Hello
I get s runtime error 9 when trying to add blank forms
If you could help
Reply
ChefsResources
Author
Reply to Gregory Spirito
2 years ago
Not sure what that error means, but it may be that you need to enable macros which you can do in your Excel security settings. Google “enable macros in Excel” to see how to do this. Alternately, you can copy and paste a blank form into a new tab. The best way to do this is to click on the small square in the upper left hand corner of the sheet (above row 1 and to the left of column A). Click there and it highlights the entire sheet. Copy it, and then on the new tab where you want…Read more »
Reply
Kyle Davis
2 years ago
HEY CHEF, THIS IS CHEF KD. IM JJUST RECENTLY DOWNLOADED THE RECIPE BULK WITH INVENTORY. HOWEVER IT DOESN’T HAVE AN INVENTORY TAB IN THE DOWNLOADED ONE. IS THERE A SEPARATE LINK FOR THE INVENTORY ?
Reply
ChefsResources
Author
Reply to Kyle Davis
2 years ago
Hello Kyle, I’m not sure which form you downloaded…it should be this one
Reply
Denise von Wiecki
2 years ago
Hello, I am trying to download the excel files and all of them download as PDF. I have the corporate membership could you please assist.
Thank you
Reply
ChefsResources
Author
Reply to Denise von Wiecki
2 years ago
I think that you are on the wrong download page because there is one for PDFs and one for Excel. I’ll contact you.
Reply
Denise von Wiecki
2 years ago
I have the corporate subscription and have been trying to down load excel recipe template with inventory but instead of excel it goes to a PDF file. can you assist me with downloading the excel files.
Is there a module available for pricing out Buffet meals?
Thank you in advance
dvonwiecki@gmail.com
Reply
ChefsResources
Author
Reply to Denise von Wiecki
2 years ago
I just sent a reply about accessing the correct download page. As for Buffet pricing, we do not have a module for that. I’ve tried to start one, but there are so many different types of buffets that I haven’t figured out a way to make it customizable to fit each type of operation.
Reply
Paul Kronos
1 year ago
Try using the The Book of Yields: Accuracy in Food Costing and Purchasing 8th Edition
by Francis T. Lynch ( https://www.barnesandnoble.com/w/book-of-yields-francis-t-lynch/1100058304 )
Saw this same procedure offered for free back in the 90’s on the Cyberchefs Electronic Union web site, minus the video. Video is a big improvement
Reply
ChefsResources
Author
Reply to Asit Ray
1 year ago
You can get a copy by becoming a $5.50 or higher subscriber here:
https://www.chefs-resources.com/membership-account/membership-levels/
Reply
speckinthesky
1 year ago
Hi, I am trying to download this file and is the reason why I subscribed. Whenever I try to open the sheet it says: “Operation did not complete successfully because the file contains a virus or potentially unwanted software.” I have no problem opening other files except this one. I have tried downloading multiple times and opening as well to no avail. Hope you can help me on this
Reply
michael mcqueen
5 months ago
When I am trying to recreate the recipe templates and hit create templates button, the button doesn’t work and you can actually move the button. Whats up with that?
Reply
ChefsResources
Author
Reply to michael mcqueen
5 months ago
It may be because you have not allowed macros to run. Macros can be used by unscrupulous people to run bad code, so Microsoft recommends only allowing macros for organizations you trust. Here is a link of how to unlock macros:
https://support.microsoft.com/en-us/office/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6
Reply
joshua pascoe
1 month ago
hi i just downloaded it and cant seem to use it do i have to buy it or?
Reply
ChefsResources
Author
Reply to joshua pascoe
1 month ago
Hi Joshua. If you were able to download it then it should be good to go, there is no extra expense. Check for a yellow notice at the top of the worksheet with a button that says “Enable”. This is an Excel safety feature which may keep it locked until you indicate that you trust the sheet. If you have additional questions, it is quicker to email me at david@chefs-resources dot com
Reply
Suggested Reading