Closed

Property Management with multiple buildings and units

Hello, I have a property management company. I manage 9 and more properties with around 100 units and tenants.

I would like to enter daily simple rent receipt info to Excel sheet, Accounting money transfers, expenses.

I would like to see all my properties and all tenants in Occupancy Calendar.

I would like to see reports for selected dates Transactions and Rent Rolls in Word or Excel form.

I would like someone completes the macros algorithms or if you have any other options to complete the project.

Thank you

Property Management System, multiple buildings, with source code

Project Description

Occupancy Calendar

Rates

Daily / Weekly / Monthly rental

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, 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

Payment & Accounting Reports

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

Reports:

Daily Reports

Monthly Reports

Yearly Reports

Ability to transfer reports to Excel and Word files

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.

Skills: Excel, Accounting, Visual Basic, Data Entry, Data Processing

See more: design property management, property management website joomla, property management llc portland, quickbooks property management information 2008, joomla property management, illinois accounting property management inc, asterisk property management integration, profolio property management real estate portal, gnucash property management, property management companies san francisco bay area, property management san francisco bay area, event management multiple choice question databank, property management scripts, list property management companies, mailing list property management companies, property management cleaning checklist

About the Employer:
( 2 reviews ) OCEAN, United States

Project ID: #21154368

43 freelancers are bidding on average $271 for this job

schoudhary1553

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. Pl More

$240 USD in 5 days
(343 Reviews)
8.0
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application filled with macros to automate the processes you describe ab More

$250 USD in 5 days
(224 Reviews)
7.4
gregorybair

Greetings! Ranked the #1 technical and business provider on www.Freelancer.com since 2010, I thank you for the opportunity to work on this important project. Since 2010, I have completed more than 1,600 projects total More

$600 USD in 15 days
(68 Reviews)
7.4
hits

Firstly, this is a placeholder bid that I will revise after your response to my bid message. I understand you want a desktop application? It will run from a single system? or you need a web application? The requireme More

$250 USD in 3 days
(33 Reviews)
6.3
muzammil21

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. Please vis More

$140 USD in 7 days
(82 Reviews)
6.6
younus15

I can do your project according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. I have extensive experience in Excel, Data Entry and More

$500 USD in 4 days
(120 Reviews)
6.0
kanchana1974

Hi, I am a Finance & Accounting Professional with MBA Finance, CMA qualification and have experience in Finance & Accounting & functions. I have knowledge & working experience in Accounting Software, MS Office fun More

$200 USD in 7 days
(48 Reviews)
5.6
GopalJp

Hello Sir, I am an experienced Bookkeeper. I have management accounting for many property management company on excel as well as accounting software. I am sure to manage yours as well. I will generate all the requi More

$250 USD in 7 days
(26 Reviews)
5.1
bhupendrayadav

I am postgraduate with more than 6 years of experience in advanced excel based tools, web automation, macros, VBA automation, Google spreadsheets, Google scripting. I have completed similar projects, please have a look More

$1000 USD in 10 days
(34 Reviews)
5.1
usamafca71

I am a Chartered Accountant & Business Consultant. I have more than 5-year experience in the field of FINANCE, ACCOUNTING, AUDIT, RISK ASSESSMENT and BUSINESS MANAGEMENT. I have performed more than+50 accounts and busi More

$140 USD in 7 days
(26 Reviews)
4.2
ironstar20311

(. ❛ ᴗ ❛.) Hello, sir! I am happy to put my bid on your project. I have read your project description carefully. I have a full of experience with data processing using Excel formula and VBA. Here are projects I have do More

$30 USD in 1 day
(19 Reviews)
4.1
rashedkhanrubel

Hi, I have understand the project requirement & interested to make dynamic project management template for this project. Please send a message so we can discuss more & start the project. Thanks.

$150 USD in 7 days
(20 Reviews)
4.1
LilianDev

I have developed this software for windows platform with most of the features you mentioned, I can customize it for you within the shortest time possible, kindly message me for a demo, thank you

$500 USD in 5 days
(7 Reviews)
4.0
Aragornsan

Hi there, I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in excel report design, but can do most tasks needed in excel. I have a solid understanding of accounting More

$200 USD in 7 days
(5 Reviews)
2.9
sahumk2000

Hi Greetings of the Day, I CAN DO IT BUT IT WILL BE A BIT EXPENSIVE as it has multiple modules. I am interested in this task, I am full time freelancer carrying 15 yrs of experience in Web and Windows development and More

$1200 USD in 7 days
(1 Review)
1.8
umeshnath8

Good Morning. Thanks for reading my proposal. I am a detail-oriented bookkeeper with a plethora of experience, I have 10+ years in the accounting field and I am very familiar and comfortable with the functions this More

$100 USD in 7 days
(0 Reviews)
0.0
Varshini323

i have around 12+ years of experience in IT industry and I also work a lot with excel macros. I will create a form which will allow you to update the daily entry and the macro will take care of everything. You will als More

$30 USD in 7 days
(0 Reviews)
0.0
Ssamar123

I am [login to view URL] graduate in Geomatics ( Geographical Information System and Remote Sensing). I would like you to explore the power of GIS that will definitely help you to manage,analyze and visualize your properties with a More

$250 USD in 7 days
(0 Reviews)
0.0
ITSolution24x7

I Will Be Your Virtual Assistant Ready to get more done, let me shave hours off of your workweek. Whether it is business or personal, I am here to help you. ⭐No advance payment. ⭐Pay once project completed # Customer More

$140 USD in 7 days
(1 Review)
0.0
kashidxb

Hi dear, My name is kashif and I am senior accountant in asset management company in dubai handling three properties having more than 550 units. I saw your attached sheet and it is bit a mix up from which getting any r More

$500 USD in 60 days
(0 Reviews)
0.0