Main site > MoneySavingExpert.com Forums > Household & Travel > Old Style MoneySaving > Groceries Spreadsheet to help me budget? (Page 1)

IMPORTANT! This is MoneySavingExpert's open forum - anyone can post

Please exercise caution & report any spam, illegal, offensive, racist, libellous post to forumteam@moneysavingexpert.com

  • Be nice to all MoneySavers
  • All the best tips go in the MoneySavingExpert weekly email

    Plus all the new guides, deals & loopholes

  • No spam/referral links
or Login with Facebook
Groceries Spreadsheet to help me budget?
Reply
Views: 35,637
Thread Tools Search this Thread Display Modes
# 1
mleonard79
Old 28-07-2006, 3:57 PM
Serious MoneySaving Fan
 
Join Date: Feb 2006
Location: Glasgow
Posts: 1,612
Default Groceries Spreadsheet to help me budget?

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.
mleonard79 is offline
Reply With Quote Report Post
# 2
Katgoddess
Old 28-07-2006, 5:52 PM
Serious MoneySaving Fan
 
Join Date: Mar 2005
Location: Suburban London
Posts: 1,780
Default

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."
Katgoddess is offline
Reply With Quote Report Post
# 3
wigginsmum
Old 28-07-2006, 5:59 PM
Fantastically Fervent MoneySaving Super Fan
 
Join Date: Nov 2005
Posts: 3,878
Default

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.
wigginsmum is offline
Reply With Quote Report Post
The Following 2 Users Say Thank You to wigginsmum For This Useful Post: Show me >>
# 4
Katgoddess
Old 28-07-2006, 6:19 PM
Serious MoneySaving Fan
 
Join Date: Mar 2005
Location: Suburban London
Posts: 1,780
Default

Ok look at this one, then make it better to suit yourself:

http://mysite.orange.co.uk/katgoddes...ing_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.
"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."

Last edited by Katgoddess; 29-07-2006 at 3:34 PM.
Katgoddess is offline
Reply With Quote Report Post
The Following 10 Users Say Thank You to Katgoddess For This Useful Post: Show me >>
# 5
squeaky
Old 28-07-2006, 6:31 PM
Deliciously Dedicated Diehard MoneySaving Devotee
 
Join Date: Dec 2004
Location: Sunny Suffolk
Posts: 13,814
Send a message via MSN to squeaky
Default

I'm hosting quite a few Old Style spreadsheets here:-

http://www.squeaky.demon.co.uk/sprea...readsheet.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
squeaky is offline
Reply With Quote Report Post
The Following 6 Users Say Thank You to squeaky For This Useful Post: Show me >>
# 6
Katgoddess
Old 29-07-2006, 2:43 PM
Serious MoneySaving Fan
 
Join Date: Mar 2005
Location: Suburban London
Posts: 1,780
Default

Quote:
Originally Posted by squeaky
I'm hosting quite a few Old Style spreadsheets here:-

http://www.squeaky.demon.co.uk/sprea...readsheet.html

I'll be happy to add more to the page
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."
Katgoddess is offline
Reply With Quote Report Post
# 7
youngmum
Old 29-07-2006, 2:57 PM
MoneySaving Stalwart
 
Join Date: Mar 2005
Posts: 241
Question

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.
youngmum is offline
Reply With Quote Report Post
# 8
Pink.
Old 29-07-2006, 3:01 PM
Deliciously Dedicated Diehard MoneySaving Devotee
 
Join Date: May 2004
Posts: 17,524
Default

Quote:
Originally Posted by youngmum
Sorry to hijack this thread slightly but does anyone know where I can get a copy of Excel, cheaply of course.
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
Hi. I'm a Board Guide on the In My Home (Includes DIY), I wanna buy-it or do-it, Greenfingered MoneySaving and Old Style MoneySaving boards, which means I'm a volunteer to help the boards run smoothly and can move and merge posts there. However, do remember that Board Guides 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.
Pink. is offline
Reply With Quote Report Post
The Following 2 Users Say Thank You to Pink. For This Useful Post: Show me >>
# 9
madauri
Old 29-07-2006, 3:10 PM
MoneySaving Stalwart
 
Join Date: Mar 2006
Location: Devon
Posts: 618
Default

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.
madauri is offline
Reply With Quote Report Post
The Following User Says Thank You to madauri For This Useful Post: Show me >>
# 10
squeaky
Old 29-07-2006, 3:14 PM
Deliciously Dedicated Diehard MoneySaving Devotee
 
Join Date: Dec 2004
Location: Sunny Suffolk
Posts: 13,814
Send a message via MSN to squeaky
Default

Quote:
Originally Posted by Katgoddess
You can add mine if you like.
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
squeaky is offline
Reply With Quote Report Post
# 11
Katgoddess
Old 29-07-2006, 3:25 PM
Serious MoneySaving Fan
 
Join Date: Mar 2005
Location: Suburban London
Posts: 1,780
Default

Quote:
Originally Posted by youngmum
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.
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."
Katgoddess is offline
Reply With Quote Report Post
The Following 2 Users Say Thank You to Katgoddess For This Useful Post: Show me >>
# 12
countrymusicfan
Old 17-01-2011, 11:21 AM
MoneySaving Stalwart
 
Join Date: Jul 2007
Location: Inverness
Posts: 326
Default sorry

[QUOTE=Katgoddess;2576597]Ok look at this one, then make it better to suit yourself:

http://mysite.orange.co.uk/katgoddes...ing_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
countrymusicfan is offline
Reply With Quote Report Post
# 13
Seakay
Old 17-01-2011, 1:58 PM
Fantastically Fervent MoneySaving Super Fan
 
Join Date: Sep 2005
Location: Cardiff
Posts: 3,983
Default

Well the thread does date from 4 or 5 years ago!
Seakay is offline
Reply With Quote Report Post
# 14
Flibsey
Old 24-08-2011, 10:59 AM
MoneySaving Stalwart
 
Join Date: Jul 2011
Posts: 568
Default

lol, noticed that myself.

create one. make a menu list of meals you like and choose to rotate them. buy according to that.
Flibsey is offline
Reply With Quote Report Post
# 15
squeaky
Old 24-08-2011, 12:25 PM
Deliciously Dedicated Diehard MoneySaving Devotee
 
Join Date: Dec 2004
Location: Sunny Suffolk
Posts: 13,814
Send a message via MSN to squeaky
Default

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
squeaky is offline
Reply With Quote Report Post
The Following User Says Thank You to squeaky For This Useful Post: Show me >>
Reply

Bookmarks
 
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
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  

Contact Us - MoneySavingExpert.com - Archive - Privacy Statement - Top

Powered by vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

All times are GMT +1. The time now is 4:53 PM.

 Forum Jump  

Free MoneySaving Email

Top deals: Week of 30 July 2014

Get all this & more in MoneySavingExpert's weekly email full of guides, vouchers and Deals

GET THIS FREE WEEKLY EMAIL Full of deals, guides & it's spam free

Latest News & Blogs

Martin's Twitter Feed

profile

Cheap Travel Money

Find the best online rate for holiday cash with MSE's TravelMoneyMax.

Find the best online rate for your holiday cash with MoneySavingExpert's TravelMoneyMax.

TuneChecker Top Albums

  • VARIOUS ARTISTSNOW THAT'S WHAT I CALL MUSIC! 88
  • ED SHEERANX (DELUXE EDITION)
  • VARIOUS ARTISTSTHE HOUSE THAT GARAGE BUILT - MINISTRY OF SOUND

MSE's Twitter Feed

profile
Always remember anyone can post on the MSE forums, so it can be very different from our opinion.
We use Skimlinks and other affiliated links in some of our boards, for some of our users.