1. Freeware Food Journal Template For Mac Free
2. Freeware Food Journal Template For Mac Download
3. Freeware Food Journal Template For Mac Download
4. Food Journal Template Excel
5. Food Journal Printable
6. Mac Freeware Software

If you’re being very specific, this is a good journal. It also has more room for writing. There is also room to track food, water, and exercise. The second image is the end of week. It includes the day 7 food journal as well as a summary section. I really, really like this aspect of the journal.

How To Keep A Food Journal Tips Make Counting Veggies/Fruits Easy Tabulating all the different food items in your meals and snacks can be a BIG pain. Make your life easier by counting a cup of veggies as 50 calories, and a cup worth of fruit as 100 calories. The right way to follow the diet is to write down what and when you eat to make sure your body gets enough of valuable elements yet you don’t overeat. This is exactly what food diary templates and daily meal planner are designed for. Download printable diary template to keep track of what you eat every day and achieve your goals easily. Find & Download Free Graphic Resources for Diary Design. 2,000+ Vectors, Stock Photos & PSD files. Free for commercial use High Quality Images. Free Printable Food Diary Template & Log Author: Marc Perry - BuiltLean.com Subject: Free Printable Food Diary Template & Log Keywords: Free Printable Food Diary Template & Log Created Date: 6/17/2010 9:50:51 PM.

Trying to figure out how profitable a new menu will be? Not feeling confident about ingredient costs? We’ve got you covered with the release of the Menu Recipe Upscale and Food Costing Spreadsheet (patent pending).

Using this cost and recipe scaling tool couldn’t be simpler, but there are a few details we wanted to take a moment to walk you through in this tutorial to help unleash the power of this Excel or Google Docs spreadsheet (.xlsx).

Let’s take a look at the at the reasons you need to utilize a tool like in your business and how start using the tool right away. This tool applies to restaurants, food trucks, and specialty food makers alike. Let’s begin!

Table of Contents:

Why use the recipe cost tool?

Scaling up your recipes.

Maybe the latest issue of Rachael Ray’s magazine has inspired you to try edamame-stuffed wasabi pork burgers on the your food truck or restaurant. But those recipes are only designed to serve 6… So how do you scale the recipe up to serve dozens or even hundreds of hungry customers for a catering event? This tool will give you the answer.

How much should I charge?

How on earth do you figure out what to charge for your new dish? By completing each each field in this spreadsheet, you’ll be confident in knowing every ingredient used to create a dish is taken into account and will understand the profitability (or lack there of) for each menu item.

How to Use the Menu and Recipe Cost Template

In our video walk-through below, we guide you through filling out this tool.

Original Recipe: Begin by entering the values from your original recipe, under the “original recipe” field. You’ll need to enter the total recipe yield (in ounces), as well as the number of servings the original recipe was intended to feed. To scale the recipe up or down, enter the desired number of servings in the field to the right. This will set your “scale factor” for the rest of the spreadsheet.

Ingredients Column: Here you will enter each ingredient needed to produce your recipe. Be as detailed as possible here and making sure to including even small costs like salt or pepper. By default this spreadsheet has space for a recipe with 27 total ingredients, but you can add additional rows into the spreadsheet if the recipe requires more.

Bulk Size Column: Next, begin entering your ingredients. The “Bulk Size” column is the total weight in ounces of the product, as you buy it from the wholesaler.

Bulk Cost: The “Bulk Cost” field is for what you pay for that ingredient, in your bulk sizes. This will generate a “Cost per Ounce.”

Recipe Amount Column: Next, enter the “Recipe Amount” for that ingredient. Again, this is the amount of each ingredient called for in your original, unscaled recipe.

The spreadsheet will scale up the amount you need for the desired amount of servings you’d like to end up with, and give you a total cost for that ingredient, in your new, larger-serving amounts. Keep adding ingredients, sizes, and prices until your recipe is complete.

Toward the bottom of the spreadsheet, you’ll find totals or calculations based on the information you entered:

• Total Recipe Cost field tells you the total ingredient cost for your new, upscaled recipe.
• Total Cost/Serving field tells you how much each serving will cost.
• In red, we’ve included a Recommended Retail Price field, which simply multiplies your total cost per serving by 3, since your raw ingredient cost should be roughly 1/3 of your retail price.

Now, there’s one more cool feature that we want to draw your attention to, and that’s the “If actual servings obtained differ from desired “#” widget.

You Might Also Like: Small Restaurant Startup Costs Breakdown and Spreadsheet

Say you’ve followed your recipe to the letter, but for whatever reason, the number of portions you’ve ended up with is different than you’d planned; for example, you thought 10 pounds of fish would yield you 30 servings of your stuffed baked tilapia special, but for some reason, you’ve only ended up with 26.

Punch that number into the “number of servings obtained” field, and you’ll get a corrected cost per serving and recommended retail price, that more accurately reflects how many servings you actually got out of each recipe.

Sample Menu Cost Calculations: Video

In the video below, I walk you through this spreadsheet using an example from my own restaurant. I own a restaurant in Maine, so I decided to share my own food costs for our popular clam dip. Click the play to start the video tutorial.

Download the Menu and Recipe Cost Tool

That about covers it! Now, you’ll never spend precious minutes upscaling recipes and you’ll never have to worry if an elaborate special is wreaking havoc on food costs.

• Menu and Food Costing Spreadsheet (.xlsx file)

Quick Reference Guide:

1. Enter the number of servings from your original recipe in cell D6, and your desired number of servings in cell F5. This will scale your recipe up and down.
2. Enter ingredient names in column A, along with size in ounces and price paid for ingredients. This will calculate cost per ounce in column D.
3. Enter the amount of each ingredient used in your recipe in column E. This will scale your ingredient amounts to match your desired servings, and calulate cost.
4. In row 40, your recommended retail price per serving is displayed. (This calculation is cost, multiplied by 3. Feel free to increase retail price further if product warrants a premium.)
5. If, after cooking, you end up with a different number of servings than you had planned, enter this number in cell I5 to perform corrected calculation.

Let us know if you have any questions about this tool in the comments field below. Once you’ve got your costs figured out using these formulas, download this food business canvas template to help you map your strategy for starting a profitable food business.

Want to start your own food business?

Hey! 👋I’m Brett Lindenberg, the founder of Food Truck Empire.

We interview successful founders and share the stories behind their food trucks, restaurants, food and beverage brands. By sharing these stories, I want to help others get started.

If you liked this story, sign up for our newsletter that includes our food business startup kit and most popular interviews sent straight to your inbox.

Know someone interesting that should be interviewed on the website? Tell us about them here.

Freeware Food Journal Template For Mac Free

This file will help you track what you eat. The file contains 17 food categories, eating diary and statistics. There are also some sample data for better orientation how it works. It’s very easy to use it. You simply choose food from the list and type the quantity. Excel automatically calculates everything else (like number of calories, carbohydrates, proteins, fats and fiber).

How to write down my eating

Use the worksheet called “Eating diary”. For example, you eat 150 grams of Nestle Fitness Corn flakes with 100 ml Semi-skimmed milk. Each item must be entered separately.

1. Enter a date below the last line of the table.
2. Select the Type. (Grains)
3. Select the Item. (Nestle Fitness Corn flakes)
4. Enter the Quantity in units that are in the column Units (150). Units can be changed but not in this table!
5. Excel calculates everything else.
6. Repeat this procedure for the next food.

Statistics

Your diet statistics are made by an ordinary Excel PivotTable on the sheet “Statistics”. It shows sum of each day.

The Pivot table doesn’t show the newly added data immediately. It has to be refreshed or you have to save, close and open again the file. To refresh the statistics table, do:

1. Right-click somewhere into the statistics table.
2. Select “Refresh” from the menu.

My calculations

You can use the “My calculations” worksheet if you need more than basic day statistics. This is place for your own tables and formulas.

How to save or edit food into the database

You have to save the food into the database before the first use. The file contains 17 named categories of food and 2 custom categories. Each category is on the separate worksheet. The list of categories is below.

For example, I want to save Peanuts (1 oz, Calories: 161, Carbohydrates: 4.6, Proteins: 7.3, Fats: 14, Fiber: 2.4)

1. Find the right category. (Nuts & peanuts)
2. Enter the name of food below the last line of the table.
3. Enter the quantity.
4. Enter the unit.
5. Enter the rest of the values (Calories, Carbohydrates, Proteins, …).
6. Now you can use Peanuts in the Eating diary.

Freeware Food Journal Template For Mac Download

The basic unit does not to be exactly 1 oz. You can use cups, fl oz, gram, ml or whatever you need, it is up to you. The basic value also doesn’t to be 1. You can use any number.

For example, I bought a bag of chips and eat 150 grams. On the back side of the bag is a table with nutrition. But there are values only for 30 grams. So I enter this into the database.

Crusty Croc Chips: 30 g (grams), Calories: 158, Carbohydrates: 1.7, Proteins: 14, Fats: 10, Fiber: 1.2

Food categories

How to change the category name

I strongly recommend to do backup copy of your Eating diary file before any change in categories.

There is the hidden sheet named Type. It contains the list of categories that can be changed. The category name is joined with the name of the source table. Both have to be exactly the same (and without spaces). The name of the source table (table with items) can be edited in Formulas >> Name Manager or in Table tools >> Design >> Table Name.

Freeware Food Journal Template For Mac Download

In this video example, I will rename the Drinks & Juices category to Abcd. As you see, it doesn’t matter of the sheet name. Only the source table and the item in Type sheet is important.

How to add the new category

In this example, I will create the new category called CategoryName As in the previous, it doesn’t matter of the sheet name.

Free download

This file is free for any use.

Version with sample data: eating_diary.xslx

Food Journal Template Excel

Clear version: eating_diary_clear.xlsx

Food Journal Printable

Edit. 02/10/2015

- added new videos: How to change the category name, How to add the new category
- repaired formulas in eating_diary_clear.xlsx
- removed sheets protection – feel free to do any updates or changes you want

Mac Freeware Software

1. Thanks for the template, its really useful. but how can we add more rows, for example adding data for vitamins A. C, D etc.

2. Is there a similar one with standard rather than metric values? I might use it if there was. But converting everything to metric is otherwise a constant extra step for me.

   • Units are completely in your hands. There is no need to use metric values. Predefined values are only used as an example. BTW. there are also units like cup, teaspoon, …

3. How do I add Sodium to the list of nutrients?

4. Awesome template! Do you have free nutrition plan?

5. I track my keto diet with this. I can recommend it.

6. I believe that this will help me to low my body fat

7. Does anybody have list of nutritional values of common food? Like pastries, fruits, vegetables, meat,..

8. This really looks awesome! The only problem is I get this #NAME? error under unit, total calories etc on the eating diary and I can’t seem to find the solution! Has anyone else encountered the same issue? If yes, how did you solve it?

   • Hi,

     I have the similar issue. I see #REF error in unit, total calories etc on the eating diary.

     • Hi,

       as it is mentioned in video. #REF error will disappear after you enter all values: data, type and item.

   • Hi,

     #NAME error occurs mostly when Excel doesn’t recognize formula. Are you sure that you are editing the right cells? You can try to download version with sample data: eating_diary.xslx and fill your eating again.

9. I love this! Thanks for making my life easier
   I was about to create one myself but it would take ages…

10. I’m sending this again…..I received no conformation of my previous message delivery…..not sure if I was successful in proving that I am, indeed, a human………..but I am…..actually I’m a space alien in need earthly food education

    I am looking to find a spreadsheet to use for daily planning. I have no need for history of yesterday and before. I would like to be able to mix and match items……add or subtract…modify…..my daily menu and observe how each item reflects the daily goal in real time. Can I do this….will it work for Mac……..and where is the download button? Please advise….

11. I am looking to find a spreadsheet to use for daily planning. I have no need for history of yesterday and before. I would like to be able to mix and match items……add or subtract…modify…..my daily menu and observe how each item reflects the daily goal in real time. Can I do this….will it work for Mac……..and where is the download button? Please advise….

12. • Hello,

      there is “Free download” section on the article bottom.
      With version with sample data and clear version. Just click on the eating_diary.xslx.

13. Hello,
    looks pretty awesome but every cell in the eating diary is #REF!
    Can you help us to understand why ? What should be the formulas ?
    thanks

14. This is the best excel app for tracking calories and proteins. I used it in my training plan and it worked prefect.

15. It is great with my fitness tracking app in Excel.

    Thank you.

16. I need template with charts to see the progress of fat burning and calorie income. This calculator is great but some charts would it make perfect.
    Thank you

17. I need to make a chart for my Bio Life Science class. Need a template for a food log with all calories, fat, protein….etc

18. I would like to keep track of my sugar intake, How can I add a column for sugar on each sheet?

    • You can try to expand all tables (add a column). Then copy the formula from last column. Be careful, the copied formula has to be exactly the same as original formula. Only difference has to be that the number 8 changes to 9. I hope it helps. I think this is one of the best app to track calories and eating diary.

      • Thank you. This is what I have been looking for. It is much better than my Android app calorie counter. I can set everything in my way. Superb

        • I don’t think so. Mobile apps are much better. Try it. The best android app for calorie counter and diet is the FatSecret Calorie Counter and is for free.

          • You can update this Excel template and make calculations and statistics by your own needs. This is not possible in the mobile app.

19. Hi Jan. Here’s an issue that needs a fix.

    I autosave my file every 2 min, and save it after finishing some work.

    When I reopen the file, I’m getting a repaired error notification, which requires the file to be saved to a new name.

    Problem is, this happens every time I open the new file, too! The tables repaired are the same, however how do you identify them?

    Not sure what to do. Please advise.

    ”
    -
    error028400_01.xml
    Errors were detected in file ‘C:UsersPublicDocuments_Food keto eating_diary 2.xlsx’
    -
    Repaired Records: Table from /xl/tables/table3.xml part (Table)
    Repaired Records: Table from /xl/tables/table4.xml part (Table)
    Repaired Records: Table from /xl/tables/table5.xml part (Table)
    Repaired Records: Table from /xl/tables/table6.xml part (Table)
    Repaired Records: Table from /xl/tables/table29.xml part (Table)
    Repaired Records: Table from /xl/tables/table30.xml part (Table)
    Repaired Records: Table from /xl/tables/table45.xml part (Table)
    Repaired Records: Table from /xl/tables/table46.xml part (Table)

    “

20. Great spreadsheet! I’ve not used pivot tables before, so editing has been fun.

    I added food items, added a column to the food pages and the Eating Diary (and corrected the formula so it worked); changed the tab names; and update the TYPE tab. I checked all the new names in Eating Diary, and everything is working great there. The new column is pulling data from the pages.

    Statistics is not though, even with refreshing. It wants to show me various levels for each main line. It is not showing a total column I added, even though it is check in the Pivot Table control panel. I’m not sure what to do. Please advise.

    • I figured out the StatisticsTab. The Row Labels had all kinds of extra sorts, when it should have been just “Date.” I’m guessing it went wacko after I updated Types.

      BTW, when you change the Types and the Tabs, the respective tables are automatically renumbered. I didn’t have to change one of them.

      On Eating Diary a new minor issue has cropped up: Columns Carb, Fiber, Net Carbs (new), Protein and Fats all have “inconsistent error” flags. After the save, the formula for those columns had to corrected. Besides turning them off for all those cells constantly, I’m not sure what to do.

      The only other error is input. When I cross foot the calculations on the Statistics, I’m 100 calories off. A minor thing.

    • Okay, so my solution to the Eating Diary was to Move a Copy from the ‘eating diary clean’ Eating Diary tab to my file. I changed any columns I need (including adding and rearranging). I saved the document.

      Then I copied and pasted columns A, B, C, D from the original Eating Diary to this new one Eating Diary (2) tab. Once I verified the numbers were correct (using sum function for columns F-H (or what ever you have added) a few rows below the table, I created a new pivot report. Instructions are in the Help menu.

      On the new Statistics tab, I changed the color of the text for the Grand Totals so they nearly met the background. Grand totals don’t mean anything to me.

      Next I renamed Eating Diary and Statics to ‘Eating Diary 1″ and “Statics 1″ then hid them. I renamed my new Eating Diary Statistics tabs. Voila!

    • Because I make a lot the same recipes repeatedly, I use a fresh copy of Eating Diary and renamed it ‘Recipe Base.’

      To use it, I make another copy of it, naming it for the recipe. Ignoring the date field, I put together the ingredients.

      A few rows below the table I use sum to tally columns F-H (or what you have). I then divide those numbers by the number of servings. Next, I list the serving results on the appropriate page for the dish, so I can add it to the Eating Diary. I move this named recipe tab to the end of the tabs. It’s available to update and out of my way.

21. I found this template very helpful however, I have tried to add a new column (Total Sodium) and cannot get it to work. Is there something that I am missing? Again, thanks for developing this template – it is very helpful.

    • George, see my post.

      I too am having trouble with the formulas on Eating Diary after adding a new column. My comments might help you get fix some of your errors. Until I figure out how to change the default formulas for Eating diary, I change them for the group on a daily basis.

22. The eating diary is fantastic however I have encountered an issue I don’t know how to fix. Running Excel 2010

    When I get to line 27. Drop downs are no longer available and the Design tab goes away.

    How can I keep this going after line 26?

    This is fantastic but after two days I’m no longer able to enter data in the eating diary worksheet due to no drop downs

    • Very valid, pithy, suntccci, and on point. WD.

    • I experienced the same problem — go to the last good line – start at the date and tab to the end – it will go to a new line and all will be restored so that you can enter data again.

23. Excellent template…saved me an hour of work by just googling, and downloading!

    I am on a low carb/ketogenic diet, and this works great for tracking my meal breakdown.

    Thanks again!

    • I’d venrtue that this article has saved me more time than any other.

24. Hi there,

    Just come across this and it is brilliant. How do i manage to change each category or add additional categories?

    Thank you

25. Thanks so much for putting this invaluable tool together. I keep in my Dropbox so that wherever I am and whatever device I am using I can add as I go through my day. Using this has helped me keep under 60 grams of carbs a day and that along with increasing my exercise slightly has helped me lose 12.5 pounds from December 26 to Jan 30.

    • Thanks for inciodutrng a little rationality into this debate.

26. I think your blank document doesn’t have all the formulas. I just used the sample one and cleared the data. That might be why the poster from February couldn’t get it to work.

    • @Sam

      yes i am having the same complications with the blank sheet, i would love to edit and add in my own tabs and fully customize everything as my own but this file is protected,

27. Excellent .A+ .Unfortunately does not work in Excel 2013

    • Why does this have to be the ONLY rellbaie source? Oh well, gj!