종료

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.

기술: 엑셀, 회계, 비쥬얼 베이직, 데이터 입력, 데이터 처리

확대 보기: 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

고용주 소개:
( 2건의 리뷰 ) OCEAN, United States

프로젝트 ID: #21154368

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 40명, 평균 입찰가: $272

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 더 보기

$240 USD (5일 이내)
(365 리뷰)
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 더 보기

$250 USD (5일 이내)
(248 리뷰)
7.5
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 더 보기

$600 USD (15일 이내)
(68 리뷰)
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 더 보기

$250 USD (3일 이내)
(33 리뷰)
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 더 보기

$140 USD (7일 이내)
(86 리뷰)
6.7
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 더 보기

$500 USD (4일 이내)
(128 리뷰)
6.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 (7일 이내)
(97 리뷰)
5.4
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 더 보기

$200 USD (7일 이내)
(48 리뷰)
5.6
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 더 보기

$1000 USD (10일 이내)
(41 리뷰)
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 더 보기

$250 USD (7일 이내)
(29 리뷰)
5.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 더 보기

$30 USD (1일 이내)
(33 리뷰)
5.2
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 더 보기

$200 USD (7일 이내)
(10 리뷰)
4.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 더 보기

$140 USD (7일 이내)
(27 리뷰)
4.2
Amrsamra

I`m interested in your project pleas contact me to discuss the other details. it`s so easy task and can be finished in less than than time determined with low rate hour. pleas contact me Thank you

$140 USD (7일 이내)
(12 리뷰)
3.3
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 더 보기

$1200 USD (7일 이내)
(1 리뷰)
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 더 보기

$100 USD (7일 이내)
(0 리뷰)
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 더 보기

$30 USD (7일 이내)
(0 리뷰)
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 더 보기

$140 USD (7일 이내)
(1 리뷰)
0.0
ascententerpris6

Thanks for sharing details of the job description. I am interested in this opportunity. Kindly find my profile summary below I have work experience of over 25 years working in the various finance segment. Expertise in 더 보기

$100 USD (7일 이내)
(0 리뷰)
0.0
multiuse27

Dear Sir/Mam, I have go through your provided excel sheet. After review i will provide you a excel sheet which is show as per required by you within 15 days.

$210 USD (7일 이내)
(0 리뷰)
0.0