Groceries Spreadsheet to help me budget?

[mleonard79]

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

[Katgoddess]

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.

[wigginsmum]

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.

[Katgoddess]

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.

[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

[Katgoddess]

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.

[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.

[Pink.]

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

[madauri]

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]

Originally Posted by Katgoddess

You can add mine if you like.

OK, will do, thanks

[Katgoddess]

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/

[countrymusicfan]

[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

[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]

Hmm... haven't tracked down all the old links

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

The spreadsheets are still available.