This is an automated expense tracker for households that want to track shared expenses. All you and your housemates have to do is input expenses and then the expense tracker does the rest: shows you how much each person has spent and who owes who what.
I've used it for about five years and shared it with friends, and everyone loves it!
There are three tabs on the spreadsheet:
- The first tab is a dashboard that shows how much each person in the house has spent and how much each person owes or is owed.
- The second tab is where you input your shared expenses and indicate (with an "x" under each housemates name) who is sharing the expense. It gives you a breakdown of how much each person owes of each item.
- The third tab is to track payouts (when someone cuts another person a check)
It's fun and simple and a transparent way to make sure everyone is contributing their fare share.
I can give you the tracker as a Google Spreadsheet or Excel Spreadsheet (the Google version allows everyone in your house easy access to input their own expenses).