Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@.

Search
  • FIRST POST
    • mleonard79
    • By mleonard79 28th Jul 06, 3:57 PM
    • 1,612Posts
    • 450Thanks
    mleonard79
    Groceries Spreadsheet to help me budget?
    • #1
    • 28th Jul 06, 3:57 PM
    Groceries Spreadsheet to help me budget? 28th Jul 06 at 3:57 PM
    Hi there,

    Not entirely sure I'm posting on the right board here but I was wondering if anyone has any links to a spreadsheet or budget list that I could use to get the grocery spending down in black and white! I don't have excel so anything that's not excel would be good - everything seems to be these days though! I'm trying to do it on paper just by writing everything down but I'm confusing myself with it and missing things out and its all looking a bit messy now! I just want something that allows me to work out what we've spent on fruit, veg, dairy, meats, bread, cereals, sweets, pet food, meals, drinks, cleaning materials etc by the week and month so I can try to work out why and how we're spending so much money and how I can then cut it down!! Thanks for any help.

    Regards


    Michelle
    Last edited by mleonard79; 28-07-2006 at 4:02 PM.
Page 1
    • Katgoddess
    • By Katgoddess 28th Jul 06, 5:52 PM
    • 1,785 Posts
    • 1,426 Thanks
    Katgoddess
    • #2
    • 28th Jul 06, 5:52 PM
    • #2
    • 28th Jul 06, 5:52 PM
    It's a good idea. I've just made one as I'm bored on my day off.

    It's only an amature attempt as I'm only learning.

    Just need to find somewhere to host it as Orange are playing silly !!!!!!s at the moment.
    "A baby will make love stronger, days shorter, nights longer, bankroll smaller, home happier, clothes shabbier, the past forgotten, and the future worth living for."
  • wigginsmum
    • #3
    • 28th Jul 06, 5:59 PM
    • #3
    • 28th Jul 06, 5:59 PM
    I do have mine on Excel, but basically the columns are Date, Item, Where Bought, three categories - Food/Household/Cats, Comparable Sainsburys Price, Pin Money (a plus or minus figure depending on whether it was cheaper or more expensive than the Sainsburys equivalent).

    I do a running total per month in each of the three categories, and an overall total.
    The ability of skinny old ladies to carry huge loads is phenomenal. An ant can carry one hundred times its own weight, but there is no known limit to the lifting power of the average tiny eighty-year-old Spanish peasant grandmother.
    • Katgoddess
    • By Katgoddess 28th Jul 06, 6:19 PM
    • 1,785 Posts
    • 1,426 Thanks
    Katgoddess
    • #4
    • 28th Jul 06, 6:19 PM
    • #4
    • 28th Jul 06, 6:19 PM
    Ok look at this one, then make it better to suit yourself:

    http://mysite.orange.co.uk/katgoddess/Shopping_Budget.xls

    ETA instructions:

    Click on each sheet at the bottom for the relavant section(the coloured tabs if you are using Excel) and then add each item into column A, and the price into column B. The total for each department will appear in the box in column D. On the grand total tab there is all the departments together and a fancy graph.

    What I would do is save a blank copy and start a new spreadsheet every month/week, however you are counting your shopping budget. (Someone with fancier skills than mine could probably do a reconciliation and add each monthly/weekly figure into a grand total for the year.)

    You could probably add an extra column to C to add the shop where you brought it from. It shouldn't mess with the formula.

    Hope that makes sense.
    Last edited by Katgoddess; 29-07-2006 at 3:34 PM.
    "A baby will make love stronger, days shorter, nights longer, bankroll smaller, home happier, clothes shabbier, the past forgotten, and the future worth living for."
    • squeaky
    • By squeaky 28th Jul 06, 6:31 PM
    • 13,811 Posts
    • 15,845 Thanks
    squeaky
    • #5
    • 28th Jul 06, 6:31 PM
    • #5
    • 28th Jul 06, 6:31 PM
    I'm hosting quite a few Old Style spreadsheets here:-

    http://www.squeaky.demon.co.uk/spreadsheets/spreadsheet.html

    I'll be happy to add more to the page
    Hi, I'm a Board Guide on the Old Style and the Consumer Rights boards which means I'm a volunteer to help the boards run smoothly and can move and merge posts there. Board guides are not moderators and don't read every post. If you spot an inappropriate or illegal post then please report it to forumteam@moneysavingexpert.com. It is not part of my role to deal with reportable posts. Any views are mine and are not the official line of MoneySavingExpert.

    Never ascribe to malice that which is adequately explained by incompetence.
    DTFAC: Y.T.D = 5.20 Apr 0.50
    • Katgoddess
    • By Katgoddess 29th Jul 06, 2:43 PM
    • 1,785 Posts
    • 1,426 Thanks
    Katgoddess
    • #6
    • 29th Jul 06, 2:43 PM
    • #6
    • 29th Jul 06, 2:43 PM
    I'm hosting quite a few Old Style spreadsheets here:-

    http://www.squeaky.demon.co.uk/spreadsheets/spreadsheet.html

    I'll be happy to add more to the page
    by squeaky
    You can add mine if you like.
    "A baby will make love stronger, days shorter, nights longer, bankroll smaller, home happier, clothes shabbier, the past forgotten, and the future worth living for."
  • youngmum
    • #7
    • 29th Jul 06, 2:57 PM
    • #7
    • 29th Jul 06, 2:57 PM
    I don't have Excel either but am still having problems getting any of those spreadsheets to open bar 1!

    Sorry to hijack this thread slightly but does anyone know where I can get a copy of Excel, cheaply of course.
    • Pink.
    • By Pink. 29th Jul 06, 3:01 PM
    • 17,526 Posts
    • 40,365 Thanks
    Pink.
    • #8
    • 29th Jul 06, 3:01 PM
    • #8
    • 29th Jul 06, 3:01 PM
    Sorry to hijack this thread slightly but does anyone know where I can get a copy of Excel, cheaply of course.
    by youngmum
    Hi youngmum,

    If you ask on the techie board or the I wanna board, you should get some help on finding the cheapest place to buy a copy of Excel.

    Pink
  • madauri
    • #9
    • 29th Jul 06, 3:10 PM
    • #9
    • 29th Jul 06, 3:10 PM
    You can make a useful table using Word too. It doesn't go so far as Excel, but you can make quite a good one, including formulas. Just use the "insert field" option for that.
    • squeaky
    • By squeaky 29th Jul 06, 3:14 PM
    • 13,811 Posts
    • 15,845 Thanks
    squeaky
    You can add mine if you like.
    by Katgoddess
    OK, will do, thanks
    Hi, I'm a Board Guide on the Old Style and the Consumer Rights boards which means I'm a volunteer to help the boards run smoothly and can move and merge posts there. Board guides are not moderators and don't read every post. If you spot an inappropriate or illegal post then please report it to forumteam@moneysavingexpert.com. It is not part of my role to deal with reportable posts. Any views are mine and are not the official line of MoneySavingExpert.

    Never ascribe to malice that which is adequately explained by incompetence.
    DTFAC: Y.T.D = 5.20 Apr 0.50
    • Katgoddess
    • By Katgoddess 29th Jul 06, 3:25 PM
    • 1,785 Posts
    • 1,426 Thanks
    Katgoddess
    I don't have Excel either but am still having problems getting any of those spreadsheets to open bar 1!

    Sorry to hijack this thread slightly but does anyone know where I can get a copy of Excel, cheaply of course.
    by youngmum
    Have you tried using open office? They have a spreadsheet program in there called Calc. Open Office is FREE and open sourced

    I've just opened my spreadsheet in it and it works fine.

    http://www.openoffice.org/
    "A baby will make love stronger, days shorter, nights longer, bankroll smaller, home happier, clothes shabbier, the past forgotten, and the future worth living for."
    • countrymusicfan
    • By countrymusicfan 17th Jan 11, 11:21 AM
    • 331 Posts
    • 279 Thanks
    countrymusicfan
    sorry
    [QUOTE=Katgoddess;2576597]Ok look at this one, then make it better to suit yourself:

    http://mysite.orange.co.uk/katgoddess/Shopping_Budget.xls

    Tried it, got HTTP not found
    Time is more valuable than money. You can get more money but you can't get more time
    • Seakay
    • By Seakay 17th Jan 11, 1:58 PM
    • 4,144 Posts
    • 9,971 Thanks
    Seakay
    Well the thread does date from 4 or 5 years ago!
  • Flibsey
    lol, noticed that myself.

    create one. make a menu list of meals you like and choose to rotate them. buy according to that.
    • squeaky
    • By squeaky 24th Aug 11, 12:25 PM
    • 13,811 Posts
    • 15,845 Thanks
    squeaky
    Hmm... haven't tracked down all the old links

    http://www.squeaky.org.uk/spreadsheets/spreadsheet.html

    The spreadsheets are still available.
    Hi, I'm a Board Guide on the Old Style and the Consumer Rights boards which means I'm a volunteer to help the boards run smoothly and can move and merge posts there. Board guides are not moderators and don't read every post. If you spot an inappropriate or illegal post then please report it to forumteam@moneysavingexpert.com. It is not part of my role to deal with reportable posts. Any views are mine and are not the official line of MoneySavingExpert.

    Never ascribe to malice that which is adequately explained by incompetence.
    DTFAC: Y.T.D = 5.20 Apr 0.50
Welcome to our new Forum!

Our aim's to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

129Posts Today

1,998Users online

Martin's Twitter
  • Just a quick goodbye (for now)... https://t.co/00uuzdpqAv

  • Still fighting - hoping for chinks in the armour as there's a new administration https://t.co/XMYOGshhI0

  • About to speak to talented teens from underprivileged backgrounds re student finance. Far more difficult to be +ve after retrospective hikes

  • Follow Martin