Tenants' rental and utility bills records

Job ID: 34497826

Budget: $10 – $30 USD

I want a spreadsheet/Excel that can easily enter data, review and automatically calculate tenant rents and utility bills for each person on a monthly basis.

1) Rental
> A 3 bedroom house with different sizes where each room can accommodate up to 2 people (max).
> The house can accommodate up to six people (max.).
> Each room has different rental prices.
>Most of the tenants moved in and moved out different dates.

2) Utility bills
> Utility bills consist of Internet, electricity and water.
> Utility bills are split equally between current tenants.
> Each utility bills received on a different date with a different duration.