Monthly Rents for Residential and Commerical

I need an Excel sheet that consolidates about 11 tenants /home and commercial properties with each month's rent and if it's been paid or not for this year 2023. There are 6 different addresses. One commerical property has one tenant. The other commerical property has five tenants.