How to input monthly rent received from tenants?

[Nishant_Bafna]

Hello,

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.

[Kamille_Parks]

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.