Find Jobs
Hire Freelancers

Create Reports Template in Excel

$30-250 USD

Terminado
Publicado hace alrededor de 7 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 13942023

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
5,0 (19 comentarios)
5,2
5,2
19 freelancers están ofertando un promedio de $116 USD por este trabajo
Avatar del usuario
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 en 0 día
5,0 (442 comentarios)
7,4
7,4
Avatar del usuario
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 en 1 día
4,9 (133 comentarios)
6,2
6,2
Avatar del usuario
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 en 1 día
4,9 (102 comentarios)
6,1
6,1
Avatar del usuario
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 en 0 día
4,8 (77 comentarios)
5,2
5,2
Avatar del usuario
Hi Rest Assured that I can finish the said job on the timeline that I committed. Kind Regards, Kate
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hey,i would like complete your project. thank you
$55 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$155 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$100 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Sunnyvale, United States
5,0
3
Forma de pago verificada
Miembro desde abr 10, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.