How do I make a Budget Sheet in Excel?

Microsoft Office excel 2007 home & stude...
June 3, 2010 at 15:57:54
Specs: Windows 7, 2/2
I have several people living in a house with me and we're trying to make a spreadsheet to keep track of who owes money for what etc. An individual should be able to enter that they paid for something, how much they paid for it, who it's being split between, and it should automatically fill in what each person owes and update everyone's balance etc. I'm not sure how to do that, or what to even look up to figure out how to do that. Thanks

See More: How do I make a Budget Sheet in Excel?

Report •

June 3, 2010 at 16:10:16
Look here for a 4 person 6 month budget:

Here's a 5 person budget:


Report •

June 3, 2010 at 16:32:36
Thanks for the reply. That's alot more specific then I'm looking for. Basically I want to be able to specify 1) something that someone bought 2) which people are responsible for paying, 3) how much each person owes 4) and update amounts that people owe each other

Report •

June 3, 2010 at 17:05:32
Actually, what you are asking for might be pretty hard to build, mainly because of this requirement:

4) and update amounts that people owe each other

If I spend $4 and want to split it with you, Bob and Sue, everyone owes me $1.

If Bob buys spends $3 and splits it between himself, Sue and me, Sue owes him $1 but him and I are even.

If Sue spends $8 and splits it between herself, you, me and Steve, you and Steve owe her $2, but I only owe her $1.

Of course, you still owe me $1, so why not just give it to Sue for me and I'll be square with everyone?

Do you see how it can get pretty complicated really fast? I'm not sure how you would set that up in a spreadsheet with the ability to keep adding items and constantly updating who owes who what.

In addition, the spreadsheet would also have to account for payments made between the parties.

If I have time to play, I might give this a shot, but nothing jumps right out at me at this time.

Report •

Related Solutions

Ask Question