Struggling to Manage Rent Accounts for 125 Units in Excel? Need Format Suggestions!

Please suggest or provide any formats for maintaining rent accounts in an Excel sheet for our company with 125 units. How can I maintain this in an Excel format? Could you kindly provide me with a suitable format for this?

Thank you.

Regards,
G. Khurshid Hussain

Please suggest to me how to maintain a rent account in Excel format for 125 units.

To create a base sheet of the cash book, you simply have to maintain it with deposit entries, referencing the flat number. Subsequently, a monthly liability should be established for the monthly rent. Against this provision, you need to display the collected amounts directly in the cash book itself.

If there is a necessity to manage individual accounts, utilize a separate sheet for each flat. After entering all the required information in the cash book, you can employ a pivot table for quick and easy reference.

Regards,
Jagan