I am looking for advice on making sense of a mess of transactions for a 'flat account' which a previous tenant was operating and has handed over to me.
Our landlord had notified me that to my surprise we were behind in rent, and it turns out the person in charge has been pretty slack - not paying bills on time, paying from seperate accounts, not recording transfers/payments in and out.- and then mentioned hes been paying some bills out of his own money.
I am trying to figure out who hasn't paid, and who's owed what. (5 people paying in at different times, paying out to one landlord and four utilities.)
Im trying to think of the best way of going about this but was seeking some advice. I will use a spreadsheet and match up rent payments (from bank records), but I am unsure on how to best balance all the deposits and withdrawals from the various accounts, with payments going out. They all seem to be very asynchronous. Is the timeline (building a chronological order of accounts) approach the only way? Is there any computer software that may help?