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
From Oman, Muscat
Acknowledge(0)
Amend(0)
Thank you.
Regards,
G. Khurshid Hussain
From Oman, Muscat
Acknowledge(0)Amend(0)
plz suggest me ragarding How to maintain Rent a/c in Excel Format when there was 125 flots.
From Oman, Muscat
Acknowledge(0)Amend(0)
From Oman, Muscat
Acknowledge(0)Amend(0)
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
From India, Visakhapatnam
Acknowledge(1)Amend(0)
9If 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
From India, Visakhapatnam
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Form 9 (Excel Format).xls
10 ways to format Excel data.pdf