종료

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

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

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일 이내)
(343 리뷰)
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일 이내)
(224 리뷰)
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 더 보기

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

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

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

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

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

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

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

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

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

$500 USD (60일 이내)
(0 리뷰)
0.0