household accounts on computer

[Steve]

Does anyone have any particular software they use to do this? I have openoffice, and was considering setting up a spreadsheet but I dont have any idea where to start!! Basically I want something where I can tell it all my outgoings and frequency and dates, and all my incomings with dates, and then I can "ask" it how much money I'm going to have at any one time. Does anyone have anything like this set up? I dont have any qualifications in IT, but I have done (very basic) excel formulae before.

Any ideas would be great. Cheers.

 

[JohnD]

I use Microsoft Money. It holds its own accounts and does reports. You don't have to write your own calculations or reports. It is obsolete now but you can get old disks on fleabay. The licence no is not restricted and it can be reinstalled multiple times.

You can enter your own accounts for banks, credit cards, building society, other assets, and you can set up regular outgoings and incomings in a sort of calendar, saying who to, where from, how often, how much. You confirm each when it occurs and it updates your accounts and puts the next one in the calendar for next month, next week or next year. You can amend the amount anytime if it varies. It will reconcile to bank statements which you can download electronically from most banks and credit cards.

Most home-made spreadsheets have errors in them.

 

[maltaron]

It is simple with excel.
Set up one column for income, then one for amount. Select the number of cells in the column for amounts plus a few extra, go to format, cells and select currency. Repeat for expenses. At the bottom of each currency column format a cell for the column total (=sum(b2:b20)) change the cell reference to suit your sheet. Then format a cell with the total income minus total expenditure.
This will give you a basic spreadsheet for household accounts.
To link this to dates is a bit more complicated and beyond an answer here.

 

[glue2]

http://extensions.openoffice.org/en/project/pfbudget

 

[wreckedit]

http://www.freewarefiles.com/category_8_78.html

 

[foxhole]

Never have my dosh long enough to enter it on a spreadsheet.