There are four of us sharing rent, groceries, utilities, etc., and we would like a software product that lets us easily keep track of who paid what so we can settle up monthly, or bi-monthly, or whatever. It is very hard to keep track of bills and receipts get lost, so sometimes there are doubts. Does anyone know of a software? I have looked at quicken and quickbooks but they do not accomodate multiple payers from what I can see.
So, I am also wondering if I need to create this. I have tried something in Excel, but it is somewhat limited. I either end up with tons of worksheets for each specific category, and on top of that, if all four of us use it, we each have to have our own Vehicle Expenses sheet, or Electronics sheet, etc., and then when I run the program to move data around, it takes a long time with all those sheets to read from and to.
Would a database be better? And if so, how would I design such a thing? I could have a Bill table which would contain the Bill Number for the Primary Key, the date, company name, amount, but then I would have to add categories as they are created, and each person's name as they are added (as people move in and out), and I was thinking of tracking each person's portion per bill - meaning that it wouldn't always be dividing the grocery bill into four equal parts, sometimes it woulld be divided among three of us, and maybe in unequal amounts.
This is getting really complicated for me, and I am having trouble sorting it out in my head. Anyone have some ideas? I would love to have a reason to learn a programming language if it would help me. I learned excel VBA to try my hand at making this in Excel, but ran into limitations. I do not know enough about Access to jump right in, so before I do, I would love to have a clear plan and know it is doable.
Start Free Trial
