Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to input monthly rent received from tenants?

225 1
Showing results for 
Search instead for 
Did you mean: 


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.