Larder inventory.

Alison_Funnell

Does anyone know of any spreadsheets that deal with this? I definitely need to organise all my AP deliveries but despite searching all sorts of places I have been unable to find anything. What should details should I put on such a list?

Any advice or help would be greatly appreciated.

TIA

GreyQueen

I just use a Table doc in Word.

Word-Table-Insert Table and then choose how many columns you want and if you want to autofit to contents or fit to window. You can also drag the lines of the columns with the mousepointer.

I just keep a tally of what, where (my stock is in several nooks and crannies around the flat) and the number and the date I checked them. I have a Toiletries Inventory, too.:o

I print a hardcopy with the food headings and then fill it in (and adjust it in pencil). The template is on the PC if I want a fresh one.

I guess if you want to itemise each thing with price paid you might be better using an Excel spreadsheet so you can use the Autosum function. HTH.

daisiegg

Not really sure what you're asking...surely only you know what information you want to record?

I suppose if it was me (I only have a freezer inventory, not store cupboard) I might list the item, where it is, and perhaps the expiry date if that is relevant. As the other poster has said, just use a word document with a table!

rachbc

I use a peice of paper and a pen - proper OS ;. That way I can tick things off when I use them and write them on when I add them - easier that firing up the laptop everytime I take a tin of the shelves!

Butterfly_Brain

I use a spreadsheet that I made on excel, but it would be just as simple to do a table in word.

LameWolf

I use an Excel spreadsheet. I have one sheet for the meal plan, another for the cupboard inventory (what items are there and how many of each), another for the freezer, divided into the four individual drawers, and a final one for grocery costs.

I don't bother printing it out; it's on a flash drive. I fire up the netbook every day anyway, to get my email, and I just put in the flash drive, call up the spreadsheet and adjust it to reflect the day's use and/or purchases.

If I use something and the netbook or one of the other computers isn't on, I make a note in my PDA, and adjust the sheet next time I'm using a computer. I prefer it to bits of paper that I would assuredly mislay.

Works for me!;)

Linda32

I use a piece of paper and a pen as well.

I just keep it in the kitchen drawer. It has a list of things we have in for dinners, and I just knock something of as we eat it.

When it comes around to making the weeks shopping list, as I have done today, I simply look to see what we need.

HTH

lostinrates

Some one on OS recommended some glass marker boards from ikea, but my idea had sold out and said they think they have been discontinued.

For me it has to be something like that...pen/paper or board /pen, because it needs to be instant ly recordable.

cheerfulness4

I'm a pen and paper sort of girl too.

I have various drawn tables in a ring binder folder headed:

Basic store cupboard items
Baking
Meat/proteins
Dairy
Treats/puddings
Veg/fruit
laundry
drinks
Can't think if anymore

Then on each sheet I make columns headed:

Item
How many
Where

Works to get me organized but I'd be interested to hear others methods.

Linda32

cheerfulness4 wrote: »

Baking
Meat/proteins
Dairy
Treats/puddings
Veg/fruit
laundry
drinks
Works to get me organized but I'd be interested to hear others methods.

For these sort of items, I have a piece of paper held on the fridge with a magnet, say if I finish the bag of flour, I write this on the list for next weeks shopping, same with coffee, tea, laundry the sort of things you don't buy every week.

Alison_Funnell

Thanks all. I was hoping there was one already in existance on the ether (time saving as well as money saving lol).

Like LameWolf and Butterfly Brain I have to admit I far prefer the none paper route. Don't have to keep writing out the entire list if you use paper? How do you keep on top of changes?

Definitely the Excel route then. I was going to keep a price list but to be honest as prices are changing so much and AP/YS stock is an ad hoc thing that so long as I am keeping with in my budgets when restocking there seems little point of keeping a meal/portion tally, just adding to the hard work. Like the idea of your catagories Cheerfulness4.