Daycare.com Forum Daycare Forum

Go Back   Daycare.com Forum > Daycare and Taxes

Daycare and Taxes All things related to Taxes and running a Daycare post here. Topics of tax exemptions, forms, filings, tax write offs, IRS etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2013, 08:28 PM
Abigail's Avatar
Abigail Abigail is offline
Child Care Provider
 
Join Date: Jul 2010
Location: North Dakota
Posts: 2,414
Default Creating A Spreadsheet To Calculate Meals Served

I started to setup a spreadsheet in excel to calculate meals served for daycare kids all year. I have not recorded this, but I do have my attendance sheets and I served Breakfast, Snack, Lunch, and afternoon Snack each day so I want to create something in excel to calculate this for me. Does anyone have some format that works well?

I started doing the tabs per month so sheet one is January 2012. Then on column A is Names of children in my care. Then across the rows were B, S, L, S repeated for each meal type for the entire month and above those 4 lettered columns is a date that is merged over the four. My only issue is that when I'm done entering the number 1 for every child who was here for each of those based off attendance is that I'll have totals for each during that day, BUT I would have to manually add up how many for each meal or snack was total for the month so I'm thinking their is a better way to have it automatically calculate this for me. Please share how you would do it in excel. I'm putting all my things into excel for bills and everything so I want to use excel.
Reply With Quote
  #2  
Old 01-03-2013, 05:00 AM
heyhun77's Avatar
heyhun77 heyhun77 is offline
Advanced Daycare.com Member
 
Join Date: Jan 2011
Location: North Dakota
Posts: 370
Default

Arn't you doing online claming now? If so, when I ended the month I would print the claim out and then just add up the number of meals served of each kind and I have a spreadsheet I entered the whole year on to keep track of the total meals served for the year as well as the food program income. That way at the end of the year I had a total for the number of meals served (both reimbursed and not) so I knew what my standard food deduction would be as well as the total food program income.
Reply With Quote
  #3  
Old 01-03-2013, 05:11 AM
BumbleBee's Avatar
BumbleBee BumbleBee is offline
Advanced Daycare.com Member
 
Join Date: Jun 2012
Location: Michigan
Posts: 2,379
Default

There is a way to automatically calculate in excel Here's how to do it:

Enter your data as you've already done

1. Click in an empty cell (at the bottom of the column for breakfast for example)

2. Type. =SUM(

3. Highlight the cells you want to add up (for example, in the breakfast column click the first cell w/a number in it & drag your cursor down to the last cell w/a number in it).

4. Type. )

5. Press enter. It should now be totaled.
Reply With Quote
  #4  
Old 01-03-2013, 05:53 AM
Angelsj's Avatar
Angelsj Angelsj is offline
Daycare.com Member
 
Join Date: Aug 2012
Location: Minnesota
Posts: 1,323
Default

Excel is even easier than that. If you look up above the page you will find a symbol that looks like this Σ. This is the SUM symbol. Click it and excel will automatically highlight the most likely row or column. If you don't like it you can change it using the click and drag method described above.
Excel will add up any group of numbers this way.

If you want to do the same calculation, but on a lot of rows or columns (say you are adding B3 thru B30 and you want to also add C3 through C30 and D3 through D30, you can click on the answer box for the first one (B3 through B30) and grab the little square in the corner. Drag it all across the row and it will place the same formula in each answer box for the appropriate column. Pretty handy

You can also do the multiplication calculations this way when you are ready to multiply by the allowed amounts. Type = in the box you want your answer in, click on the first number you want, type * (multiply) and click the second number. Hit enter, and it is done.
Reply With Quote
  #5  
Old 01-03-2013, 06:14 AM
BumbleBee's Avatar
BumbleBee BumbleBee is offline
Advanced Daycare.com Member
 
Join Date: Jun 2012
Location: Michigan
Posts: 2,379
Default

Quote:
Originally Posted by Angelsj View Post
Excel is even easier than that. If you look up above the page you will find a symbol that looks like this Σ. This is the SUM symbol. Click it and excel will automatically highlight the most likely row or column. If you don't like it you can change it using the click and drag method described above.
Excel will add up any group of numbers this way.

If you want to do the same calculation, but on a lot of rows or columns (say you are adding B3 thru B30 and you want to also add C3 through C30 and D3 through D30, you can click on the answer box for the first one (B3 through B30) and grab the little square in the corner. Drag it all across the row and it will place the same formula in each answer box for the appropriate column. Pretty handy

You can also do the multiplication calculations this way when you are ready to multiply by the allowed amounts. Type = in the box you want your answer in, click on the first number you want, type * (multiply) and click the second number. Hit enter, and it is done.
Woah...I learn something new everyday! Can't wait until nap time so I can try this method out!!! Thanks!
Reply With Quote
  #6  
Old 09-26-2016, 11:19 AM
Unregistered
Guest
 
Posts: n/a
Default Willing to share spreadsheet?

Hi! I have been searching for spreadsheets to track meals for daycare and have not been successful. I was wondering if you would be willing to share your spreadsheet.

Thanks so much,
Susie
Reply With Quote
  #7  
Old 09-26-2016, 01:50 PM
Blackcat31's Avatar
Blackcat31 Blackcat31 is offline
 
Join Date: Oct 2010
Posts: 19,760
Default

Quote:
Originally Posted by Unregistered View Post
Hi! I have been searching for spreadsheets to track meals for daycare and have not been successful. I was wondering if you would be willing to share your spreadsheet.

Thanks so much,
Susie
I'm sorry but this thread is over 3 yrs old so I dont think the OP will reply. However, I do know there is a gal on TpT that has great menu and tracking forms....maybe they are what you are looking for. You do have to pay to download them but usually TpT is really inexpensive and worth it!

https://www.teacherspayteachers.com/...-Lists-2740568
Reply With Quote
Reply

Tags
excel, meals, meals served, menu, taxes

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 02:37 AM.



Daycare.com         Find A Daycare         List Your Daycare         Toys & Products                 About Us

Daycare.com
Please read our Disclaimer before continuing.

Topics pertain mainly to the following States:

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming