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.

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.

돈을 벌기 원하시나요?

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

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

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

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

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

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

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

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

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

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

(. ❛ ᴗ ❛.)
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더 보기

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

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

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

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

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

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

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