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
flyer
flyer Posts: 2,286 Forumite
Part of the Furniture 1,000 Posts Name Dropper
Hi all. I'm looking for a spreadsheet whereby the home can have a monthly budget for, say, children's food, and whenever they go shopping, they enter the amount spent and it draws down against the budget so the manager can always see what is left. Is anyone aware of such a thing?
Even if you are a minority of one, the truth is the truth.
«13

Comments

  • Emmia
    Emmia Posts: 5,607 Forumite
    Fifth Anniversary 1,000 Posts Photogenic Name Dropper
    edited 15 July at 7:15PM
    That sounds like a standard spreadsheet with suitable formulae...
  • flyer
    flyer Posts: 2,286 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    I'm not an expert on Excel so I'm hopefully looking for a template I can adapt?
    Even if you are a minority of one, the truth is the truth.
  • elsien
    elsien Posts: 35,964 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    edited 15 July at 7:37PM
    Is it a care home that is part of the local authority, or a private company because generally speaking they would already have software in place for you to use?

    because presumably there would be other categories that you also need to monitor, such as utility bills, recreation etc? 
    All shall be well, and all shall be well, and all manner of things shall be well.

    Pedant alert - it's could have, not could of.
  • flyer
    flyer Posts: 2,286 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    It's private
    Even if you are a minority of one, the truth is the truth.
  • flyer
    flyer Posts: 2,286 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    Yes, I would adapt the template to cover other expenditure
    Even if you are a minority of one, the truth is the truth.
  • Emmia
    Emmia Posts: 5,607 Forumite
    Fifth Anniversary 1,000 Posts Photogenic Name Dropper
    flyer said:
    Yes, I would adapt the template to cover other expenditure
    But if you don't know how to create this, how will you adapt it ensuring you don't muck up the formulae?

    Have you got access to Microsoft Excel? Microsoft do a lot of free templates and I'm sure there's one that would be suitable.
  • elsien
    elsien Posts: 35,964 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    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.)
    All shall be well, and all shall be well, and all manner of things shall be well.

    Pedant alert - it's could have, not could of.
  • Heedtheadvice
    Heedtheadvice Posts: 2,768 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    I can appreciate your comments Elsie's bit it could also be in Flyer's interest to propose this or show initiative, as examples.

    If a small cost is available then one such as https://www.excel-skills.co.uk/petty-cash-template.php?sesreq=1315296202507151941&ctime=1752608523 could well be suitable with minor changes.

  • flyer
    flyer Posts: 2,286 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    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!
    Even if you are a minority of one, the truth is the truth.
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.