How to input monthly rent received from tenants?

583 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I have created a property management base where I have multiple properties and for each property, I have multiple tenants. In the “Tenants” table I have all the information of the tenants (rent, deposit, move-in date etc.).

In addition to that, I want to enter monthly rents received by the tenants and also their electricity bills.

I have thought enough but not able to figure out a way to do the same. Please help me out with this one.

1 Reply 1

You likely need another table for Payments, where each record has fields for the Tenant, the item (perhaps a single-select field with options for Rent and Electricity), and the date received.