Property Management System in Excel

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] ..... https://www.rentecdirect.com.

Keahlian: Excel, PHP, Perancangan Perangkat Lunak, SQL, Visual Basic

Lihat lebih lanjut: excel macro cells column name, hospital management system excel, work management system excel, rental property excel spreadsheet free, property management templates excel, free property management spreadsheet excel template for tracking rental income and expenses, rent spreadsheet template excel, free property management forms templates, property management excel spreadsheet free, free property management maintenance checklist template, rental property excel spreadsheet free uk, 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

Tentang Pemberi kerja:
( 1 ulasan ) OCEAN, United States

ID Proyek: #19029015

10 freelancer menawar dengan rata-rata $790 untuk pekerjaan ini


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Lebih banyak

$1000 USD dalam 3 hari
(349 Ulasan)

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Lebih banyak

$1666 USD dalam 30 hari
(50 Ulasan)

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agree Lebih banyak

$188 USD dalam 3 hari
(107 Ulasan)

Hi there, I’d like to be considered for your Website developer position. I’m a strategic developer with a strong coding background, including Api Integration, Software Architecture, Laravel, Codeigniter, API Integrati Lebih banyak

$1666 USD dalam 60 hari
(184 Ulasan)

Hello. I have good skills in "Excel, PHP, Software Architecture, SQL, Visual Basic". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully Lebih banyak

$155 USD dalam 3 hari
(98 Ulasan)

I am swatik. I was looking through your project requirements property management website I have strong knowledge in { Website Design, PHP, Wordpress, Ecommerce, Magento, Opencart, HTML5, Jquery, Ajax, Javacript, Lebih banyak

$1974 USD dalam 15 hari
(62 Ulasan)

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$222 USD dalam 10 hari
(53 Ulasan)

Dear sir, I'm sure that I can complete your project 'Property Management System in Excel' as soon as possible. I am senior software developer and always provide fast service. I promise a high quality and punctual work Lebih banyak

$155 USD dalam 1 hari
(16 Ulasan)

I am confident I am the right candidate for this project as I have done many similar projects in the past. With years of experience in this field, I believe this project will be very easy for me.

$756 USD dalam 10 hari
(6 Ulasan)

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly c Lebih banyak

$122 USD dalam 3 hari
(2 Ulasan)