We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Spreadsheet for a children's home

Options
2

Comments

  • flyer
    flyer Posts: 2,286 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    Even if you are a minority of one, the truth is the truth.
  • PHK
    PHK Posts: 2,283 Forumite
    Eighth Anniversary 1,000 Posts Photogenic Name Dropper
    flyer said:
    elsien said:
    Honestly, I’d be chucking this one back at the owner. If they want the manager to do a half decent job  then they need to provide the tools for you to do so. 
    (Ex/care home manager here.)
    I am the owner!
    In which case, the software that you use to do your books will also have budgeting built in. 
  • GDB2222
    GDB2222 Posts: 26,202 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    PHK said:
    flyer said:
    elsien said:
    Honestly, I’d be chucking this one back at the owner. If they want the manager to do a half decent job  then they need to provide the tools for you to do so. 
    (Ex/care home manager here.)
    I am the owner!
    In which case, the software that you use to do your books will also have budgeting built in. 
    Exactly why I am finding this so puzzling. Isn’t the op in some danger of doubling up the paperwork, by entering stuff in the spreadsheet and then also in the proper books? 

    If you have an accountant you need to make sure that your records satisfy him and are compatible with his systems. 
    No reliance should be placed on the above! Absolutely none, do you hear?
  • GDB2222
    GDB2222 Posts: 26,202 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    How does a monthly food budget work, anyway? Say there’s a really great deal on canned tuna, so you buy a year’s worth. Do you then have to tell the children that they can’t have milk for the rest of the month, as you have used the food budget up buying tuna for the next year? 
    No reliance should be placed on the above! Absolutely none, do you hear?
  • PHK
    PHK Posts: 2,283 Forumite
    Eighth Anniversary 1,000 Posts Photogenic Name Dropper
    GDB2222 said:
    How does a monthly food budget work, anyway? Say there’s a really great deal on canned tuna, so you buy a year’s worth. Do you then have to tell the children that they can’t have milk for the rest of the month, as you have used the food budget up buying tuna for the next year? 
    Accounts software would allow a business to show the cost of the tuna throughout the year. 

    A simple running total on a spreadsheet won't do that. 

    Normally, with regular expenditure (like meals) there is a budgeted overall cost to the business of buying ingredients (or constituent parts) but this is based on a budget of £x per meal. So when working out menus you have a target to aim for. You can then adjust the budget easily if the number of meals changes or food price inflation takes hold. 
  • flyer
    flyer Posts: 2,286 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    PHK said:
    flyer said:
    elsien said:
    Honestly, I’d be chucking this one back at the owner. If they want the manager to do a half decent job  then they need to provide the tools for you to do so. 
    (Ex/care home manager here.)
    I am the owner!
    In which case, the software that you use to do your books will also have budgeting built in. 
    We use Xero, which does have budget options but not in the way I need to use it. Let's say the manager has a budget of £400 per month for food. They go shopping twice a week, and she needs to be able to draw down the money she spends so she knows what she has left. Does that make sense?
    Even if you are a minority of one, the truth is the truth.
  • GDB2222
    GDB2222 Posts: 26,202 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    flyer said:
    PHK said:
    flyer said:
    elsien said:
    Honestly, I’d be chucking this one back at the owner. If they want the manager to do a half decent job  then they need to provide the tools for you to do so. 
    (Ex/care home manager here.)
    I am the owner!
    In which case, the software that you use to do your books will also have budgeting built in. 
    We use Xero, which does have budget options but not in the way I need to use it. Let's say the manager has a budget of £400 per month for food. They go shopping twice a week, and she needs to be able to draw down the money she spends so she knows what she has left. Does that make sense?
    A piece of paper stuck to the fridge will do that. Just keep a running total of what is remaining. 
    No reliance should be placed on the above! Absolutely none, do you hear?
  • PHK
    PHK Posts: 2,283 Forumite
    Eighth Anniversary 1,000 Posts Photogenic Name Dropper
    flyer said:
    PHK said:
    flyer said:
    elsien said:
    Honestly, I’d be chucking this one back at the owner. If they want the manager to do a half decent job  then they need to provide the tools for you to do so. 
    (Ex/care home manager here.)
    I am the owner!
    In which case, the software that you use to do your books will also have budgeting built in. 
    We use Xero, which does have budget options but not in the way I need to use it. Let's say the manager has a budget of £400 per month for food. They go shopping twice a week, and she needs to be able to draw down the money she spends so she knows what she has left. Does that make sense?
    That's an unusual way to do it.

    Normally you set a cost per meal or serving. Doing it that way, it doesn't matter that some food will be bought in one month but eaten in another or that some packages are large enough to last multi months. 


  • GDB2222
    GDB2222 Posts: 26,202 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    @PHK  do you mean that, having decided on the menu, you calculate the cost of all the ingredients? So, for example, the cake has 450 grams of sugar, which is 30% of a bag … You’d need to automate that calculation or there will be no time left for cooking. Besides that, the sort of person who likes cooking may not want to spend ages on the task, and will quickly find another job!
    No reliance should be placed on the above! Absolutely none, do you hear?
  • Vitor
    Vitor Posts: 631 Forumite
    500 Posts First Anniversary Photogenic Name Dropper
    edited 19 July at 11:30AM
    Do you need to account for children asking for more?  :*

    Please sir I want some more video clip by Oliver Twist
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.9K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.9K Work, Benefits & Business
  • 598.7K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.2K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.