Find Jobs
Hire Freelancers

Create Reports Template in Excel

$30-250 USD

Completato
Pubblicato circa 7 anni fa

$30-250 USD

Pagato al completamento
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.
Rif. progetto: 13942023

Info sul progetto

19 proposte
Progetto a distanza
Attivo 7 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 in 3 giorni
5,0 (19 valutazioni)
5,2
5,2
19 freelance hanno fatto un'offerta media di $116 USD
Avatar dell'utente
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 in 0 giorno
5,0 (442 valutazioni)
7,4
7,4
Avatar dell'utente
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 in 1 giorno
4,9 (133 valutazioni)
6,2
6,2
Avatar dell'utente
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 in 1 giorno
4,9 (102 valutazioni)
6,1
6,1
Avatar dell'utente
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 in 0 giorno
4,8 (77 valutazioni)
5,2
5,2
Avatar dell'utente
Hi Rest Assured that I can finish the said job on the timeline that I committed. Kind Regards, Kate
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
hey,i would like complete your project. thank you
$55 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$155 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$100 USD in 5 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 5 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
Sunnyvale, United States
5,0
3
Metodo di pagamento verificato
Membro dal apr 10, 2017

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.