Create Reports Template in Excel

Selesai Dipasang 6 tahun yang lalu Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

We manage properties and have multiple tenants in each property. Would like someone to create reports in excel by tenant. We want to automate the report creation.

What is available:

Name of tenant, area occupied, projected costs billed to tenants each month for each activity (e.g cleaning, repair, utilities, taxes, etc).

Also, actual costs incurred at the year end, total square footage of property.

What needs to be done:

By tenant, need to create a report of what costs needs to be allocated to each tenant based on the % area and then what is the difference between billed versus actual. Then determine if there is credit or debit to tenant. Need to create a template so that in future these reports can be auto generated.

I have sample reports in pdf that need to be generated. Just need someone to automate that in excel so that in future we don't have to do this manually every time.

Excel

ID Proyek: #13942023

Tentang proyek

19 proposal Proyek online Aktif 6 tahun yang lalu

Diberikan kepada:

dgled

Hi, I prepared an application in Microsoft which manage income/cost of properties by unit and by tenants. with financial reports and statement of account for each entity. about me I am financial specialist and guru Lebih banyak

$250 USD dalam 3 hari
(19 Ulasan)
5.2

19 freelancer rata-rata menawar $116 untuk pekerjaan ini

cgullapalli

Hi, I am good at Excel and building useful scripts for my clients. In this case, my best suggestion is to use mail merge feature available in word. It creates documents as required. But, if u r specific to each file Lebih banyak

$60 USD dalam 0 hari
(442 Ulasan)
7.4
imransgd101

Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satis Lebih banyak

$98 USD dalam 1 hari
(133 Ulasan)
6.2
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lebih banyak

$35 USD dalam 1 hari
(102 Ulasan)
6.1
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start

$50 USD dalam 0 hari
(77 Ulasan)
5.2
blueberry9202

Hi Rest Assured that I can finish the said job on the timeline that I committed. Kind Regards, Kate

$155 USD dalam 3 hari
(0 Ulasan)
0.0
Ferzana123

A proposal has not yet been provided

$155 USD dalam 3 hari
(0 Ulasan)
0.0
WorldAccountants

Hi, I can help you prepare your Automated Excel file as i am advance level excel user with experience in Accountancy being a Chartered Accountant. I have worked on projects like these, I will make you dashboards Lebih banyak

$250 USD dalam 3 hari
(0 Ulasan)
0.0
nitinagarwal1990

I can also automate this report and add a a macro to it for further make it more intuitive and easier for you next time. You can add me on Whatsapp (+91-8800560561)

$88 USD dalam 2 hari
(0 Ulasan)
0.0
Riz31

hi....i hope you are doing great...I am an engineer with more than 13 years of experience.... I work as a PMO head for a Telco....I am an expert in excel based automation and dashboards....Please allow me to offer you Lebih banyak

$250 USD dalam 3 hari
(0 Ulasan)
0.0
dhaarunsaaikavi

hey,i would like complete your project. thank you

$55 USD dalam 2 hari
(0 Ulasan)
0.0
ridhikandoi

A proposal has not yet been provided

$155 USD dalam 2 hari
(0 Ulasan)
0.0
paulagdumadapat

A proposal has not yet been provided

$100 USD dalam 5 hari
(0 Ulasan)
0.0
rohitnag92

Respected Recruiter, I am writing in response to the above mentioned job requirement. I have read your job details and I can assure you that I can complete the work before the mentioned time Please find below th Lebih banyak

$111 USD dalam 3 hari
(0 Ulasan)
0.0
wadudf1985

Hello Sir, I am very interested in your job post. I have excellent experience in web research, data mining and extracting email address. I have excellent experience in managing the extracted data in MS Excel, MS Word, Lebih banyak

$36 USD dalam 3 hari
(0 Ulasan)
0.0
abhigyandev

hey, at this cost i can make a complete software for you which can easily generates excel and pdf reports for you , it will be fully automated. Will provide you all kinda monthly, quarterly and yearly reports . It can Lebih banyak

$50 USD dalam 5 hari
(0 Ulasan)
0.0