Find Jobs
Hire Freelancers

Create Reports Template in Excel

$30-250 USD

Завершено
Опублікований about 7 years ago

$30-250 USD

Оплачується при отриманні
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.
ID проекту: 13942023

Про проект

19 пропозицій(-ї)
Дистанційний проект
Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 in Excel and VBA. I create creative and complex financial models in a simplified and logical manner including clear assumptions, drivers, financial statements, valuations, suitable sensitivity analysis, scenarios and dashboards that are easy to understand by the client and their investors. over 35 years, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a variety of businesses including, startups, retailers, power plants, farms, equipment manufacturers, among others.
$250 USD за 3 дні(-в)
5,0 (19 відгуки(-ів))
5,2
5,2
19 фрілансерів(-и) готові виконати цю роботу у середньому за $116 USD
Аватарка користувача
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 with filename then, it is better to go withe programming. I would like to get in touch to discuss further. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$60 USD за 0 день
5,0 (442 відгуки(-ів))
7,4
7,4
Аватарка користувача
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 satisfaction. I have also good experience for Website designing, product listing for various forum, magenta, word press, PDF branding (like designing, Branding, editable PDF & conversion etc), web research and searching, Adobe Photoshop/ Corel graphic designing. I have ALISON certified for MS Excel, Excel & Formula, Powerpoint, Word & office 2010. 10 year computer operator and Administrator in an organization. My Freelancer profile and portfolio also show my experience. I am really interested in this project so please give me chance, I hope it will be nice experience for both of us. I will provide you best service in lowest budget with complete accuracy. ready to start now. I have very cooperative nature person and I always give preference to clients satisfaction Regards
$98 USD за 1 день
4,9 (133 відгуки(-ів))
6,2
6,2
Аватарка користувача
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. Next steps: Lets discuss/validate the complete requirement,budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$35 USD за 1 день
4,9 (102 відгуки(-ів))
6,1
6,1
Аватарка користувача
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 за 0 день
4,8 (77 відгуки(-ів))
5,2
5,2
Аватарка користувача
Hi Rest Assured that I can finish the said job on the timeline that I committed. Kind Regards, Kate
$155 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
$155 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 in Excel and you will have whatever you need. Even if my project is completed and you needed any changes afterwords I will do it for free. There is no cost associated with discussion. Buzz me in chat for detailed discussion. Best regards.
$250 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 my services...
$250 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
hey,i would like complete your project. thank you
$55 USD за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
$155 USD за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
$100 USD за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 the brief description about my Education and Technical Expertise: I have done Bachelor of Engineering in Computer from the top most reputed university in India. I was university topper. My work experience during the last 24 months in Data Analytics Firm includes supporting world largest Retail Giant in improving performance and optimizing processes all-round the globe. I have worked hands on on Microsoft Excel, VBA, Web Scraping using VBA, Tableau and SQL. I have advanced level knowledge of Excel which comprises of: • All basic Excel formulae • Array Formulae, Conditional Formatting • Creating dashboards and charts in excel • Pivot Tables and Pivot Charts • Using Excel VBA for automation of the repeated process • Linear Regression Analysis, Time Series-Moving Average Analysis, t-Test, z-Test, ANOVA Analysis etc using Excel Also, I have created many different Macros in Excel to automate the entire process of Raw Data transformation to user understandable form. The macros that I have created, works as follows: The macro normally starts with pasting the raw data in Excel sheet from Data Server, like SQL, ACCESS etc. After getting the raw data from the server, macro performs the data transformation such as rolling up of data to higher level etc
$111 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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, Google Docs, Google Spreadsheet, Google Document and other related applications. I have fast internet connection at home. I have strong written and verbal communication skills. Moving ahead, I can dedicate 70 hours/week for your job and my daily hours are negotiable. I can work full time and will focus to this project. I am able to start right now. I am mostly online at Skype. We can discuss there in details, if you are interested. Thank you in advance for your time and consideration. Regards
$36 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 also mail all tenants and sms as well. Let me know if you are interested in free demo :) I am a passionate software developer who loves to provide solutions for the common problems :) Feel free to discuss
$50 USD за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
Sunnyvale, United States
5,0
3
Спосіб оплати верифіковано
На сайті з квіт. 10, 2017

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.