Property Management System in Excel -- 2

Property Management System, multiple buildings, (Cloud based) with source code

Project Description


I am looking for a programmer that is able to program a web base property management with multiple properties, that does the following.

Occupancy Calendar


Daily / Weekly / Monthly rental

Multiple Rate & Rate Type per Stay

Reservation, Check-In and Check-Out from single screen


Generate invoices for any outstanding balance - combine multiple receivables per tenant or across multiple properties into one invoice, or split by due date, tenant, etc.

Rent Roll

Print complete tenant balances and payment histories, for all tenants, or a single one. Group by building, property, etc and show group totals and grand totals. Export to PDF, Word, Excel.

Search, Sort, & Print

Most lease terms are supported, including monthly, bi-monthly, weekly, bi-weekly, daily, quarterly, and yearly leases. Enter specific start & end dates, specify rent amount, and when first payment is due. You can also add secondary tenants to any lease.

Payment Schedule

Easily generate a handy payment schedule of every due date and how much is due on the lease.

Payment History

Balances and Statements

Filtering Capability

Generate reports how you want them - run reports for an entire building or for one property or tenant - or run the report for all

Payment & Accounting Reports

Payment History, Current Balances, Current Balances & Payments, Complete Statements, Complete Statements + Payments, All Accounting Entries

Backup / Restore

Owner User & Shift Management program user privileges

Admin Users

Control access to accounting periods and account codes, owner & vendors, and other system-wide settings by specifying which users have Admin access.

Owner-Specific Views

You can restrict user access to a specific owner's data only - this is great to allow owners read-only access to their portfolio data!


Guest & Room Reports

Daily Reports

Monthly Reports

Yearly Reports

Reservation and CRS Reports

Ability to transfer reports to Excel and Word files

I would like to add some new functions.

We can call it Property Management System:

Check in date ________ ( Nights, Weekly, Bi-weekly, Monthly) Tenant’s Name ____

Check out date: __(auto date)__ Total Cost: __(auto $ amount according to setting weekly, monthly stored for the specific tenant)

Rooms: I should be able to add more rooms and they should be updated in Occupancy Calendar Map automatically

I should be able to edit or delete reservations and payments,

After the payment is made, Occupancy Calendar Map color, if paid full, light green, if balance is due, light pink color in cells.

In the Database sheet, it should be sorted by the date the payment made

Also, in the Database sheet, Payment due column, should be same colors as Occupancy Map, light green if paid in full, light pink if balance is due

In the main Tenant Menu, to enter the payments, when I write tenants name, if it is stored before, it should come up automatically, also, room number or address, recurring payment amount (pays $200 weekly or $700 monthly) and duration (weekly, bi-weekly or monthly) according to stored Tenant’s name.

Maybe there should be another database sheet to store recurring Tenants, their repeat payment dates (weekly, bi-weekly, monthly) and recurring rent amount, so when I enter the Tenant’s name, all that info comes up auto. I should be able to change recurring dates or amounts if it may be any changes in the future with the same tenant.

Tenant sheet colors are very dark, you could use soft light colors.

In the HD sheet, I should be able to add more units in order, and they should be updated in all Excel sheet and, Occupancy Map. I should be able to make changes in the future also.

Application similar to, but simple version of them, [login to view URL] [login to view URL] [login to view URL] .....

Skills: Excel, PHP, Software Architecture, SQL, Visual Basic

See more: property management excel spreadsheet free, free property management forms templates, rental property record keeping template, free rental income spreadsheet template, rental property excel spreadsheet free, rental property spreadsheet template, free property management spreadsheet excel template for tracking rental income and expenses, free rent payment tracker spreadsheet, hospital management system excel, work management system excel, property management system jsp java, PROPERTY MANAGEMENT SYSTEM, order management system excel web query, school management system excel vba, leave management system excel, php property management system, schools management system excel sheet, stock management system excel macros, want property management system, estate property management system project

About the Employer:
( 1 review ) OCEAN, United States

Project ID: #19300795

Awarded to:


Hello, Dear. I have just read your job post. Indeed, very interesting for me. So I think both of us could discuss details about this project with each other via chatting. Look forward to you. Thanks a lot, please More

$111 USD in 3 days
(58 Reviews)

5 freelancers are bidding on average $202 for this job


Hello, First of all, its my pleasure to bid on your project, I have gone through your requirements and understand that you need a property management system developed. We are a highly skilled team to provide you the More

$250 USD in 10 days
(76 Reviews)

Feel fee to contact me for Property Management System in [login to view URL] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] pay More

$150 USD in 3 days
(49 Reviews)

Hello, Greetings from Rehan Arshad :) I will definitely create a property management system in excel as per your requirements. I am expert in Developing and Designing for a website with great experience of mor More

$400 USD in 15 days
(71 Reviews)

hey i have build property management system in web ... message me so we i can show you ..................thanks..............

$100 USD in 1 day
(92 Reviews)