Find Jobs
Hire Freelancers

Development of Excel/Google Sheet to help predict date for issuing new payment

$30-250 USD

Cerrado
Publicado hace más de 4 años

$30-250 USD

Pagado a la entrega
We have a requirement which is as follows: We have an excel project that should be completed in three phases, this excel/google sheet will complement or maybe in the future even replace an existing “cash forecast and daily sales” that we have. The intention is to have a new sheet that will help in predicting the date for issuing new payments based on pre-set conditions and other metrics defined in other sheets. Background on existing sheet: The existing sheet is used by managers at a quick service restaurant (like fast food) to allow easier and more accurate projection of future shortfall in cash. The sheet gathers data from a “daily sales sheet” that staff enter daily sales split by branch and split by cash and credit card sales. The sheet also includes other columns on sales made to other companies on credit basis. The data on the “daily sales sheet” flows through a “cashflow forecast sheet” which forecasts future sales trend using “trend line” function. The “cashflow forecast sheet” also takes into account all scheduled payments and gives management net cash figures available for spend on a daily basis. The purpose behind the existing sheet is to provide better visibility Incase there is future shortfall in cash and allows management to better control how to manage cash. Phase 1 or new requirement: The first phase of this project is we need to create a sheet that automatically determines which date a new Cheque payment can be scheduled for. The new sheet must take into account cashflow forecasts from existing sheets, and use parameters (entered manually) of maximum cheque payments allowed per month. Example: monthly cheque payment limit = 100,000 Employee enters new payment to be issued by cheque on a sheet, this information is then used based on the limit determined above and the forecasted cash available to suggest and recommend a date for payment and so forth. Phase 2: revamp existing “cashflow forecast sheet” to estimate better and more accurate forecasted sales figures based predominantly on pre-existing data Phase 3: combine all information into single dashboard to allow better decision making and better cash management
ID del proyecto: 22321692

Información sobre el proyecto

36 propuestas
Proyecto remoto
Activo hace 4 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
36 freelancers están ofertando un promedio de $157 USD por este trabajo
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$200 USD en 3 días
4,9 (461 comentarios)
7,9
7,9
Avatar del usuario
Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can definitely help you in this project. Kindly contact me for further details. Roy
$200 USD en 3 días
4,9 (441 comentarios)
7,3
7,3
Avatar del usuario
Hello there, This bid is for the first Phase of your project only. Can you share your existing spreadsheet perhaps with some sample data please? This will allow me to review the current structure and recommend the changes to be able to more accurately predict the cheque payment data as required. Once this phase is completed as per your needs, we may work on the other phases. I am an expert in Excel (completed more than 500 projects successfully here on Freelancer itself) and can assure you of excellent quality work. Are you available for a quick chat to go over the requirements in detail? Do let me know. Best Regards, Rishi Mehta (Automyze Consulting)
$250 USD en 10 días
4,9 (274 comentarios)
7,3
7,3
Avatar del usuario
Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not bid on projects which I am not sure. I will not disappoint you and I will do my best for give you a perfect solution. If I have an opportunity to work with you, That's my pleasure. No milestones required in advance, please pay me once the job is 100% complete. Also, before you consider awarding me the project, I can provide you with some sample files via your requirements. Please message me, so we can discuss here as I may have some questions. Thank you. Marko R.
$155 USD en 3 días
4,9 (58 comentarios)
6,6
6,6
Avatar del usuario
Hello Sir/Madam, I read your project brief and want to do your project. I have done similar task in the past successfully. The highly professional and master in excel, excel VBA field and I will do a great job on your project if you give me the chance and will make you 100% satisfy from my work.
$140 USD en 7 días
5,0 (58 comentarios)
6,0
6,0
Avatar del usuario
I have recently completed similar assignment for one of my client who is owner of restaurant chain in United States, please initiate chat to discuss this in detail or to show you demo. Please find below a brief introduction of myself. I am postgraduate (MBA) in finance with more than 6 years of experience in financial modeling, financial forecasting & analysis, advanced excel based tools, dynamic dashboards, graphs & charts, Pivot tables, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based financial forecasting models and dashboards for Ernst & Young and Landmark group also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$250 USD en 4 días
4,9 (49 comentarios)
5,8
5,8
Avatar del usuario
Respected,      I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks and regards 
$177 USD en 3 días
4,6 (53 comentarios)
5,7
5,7
Avatar del usuario
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$40 USD en 1 día
4,8 (23 comentarios)
5,0
5,0
Avatar del usuario
Hi, I can develop this software via Excel (suing VBA programming) or Google sheet(Via javascript). Please send me your current Excel file, I need to see how you gather information from other Excel workbooks. We can automatically read those data from other Excels, update current data in file and then based on trend line (or smooth average method) we can predict next payment. Please send me message to discuss more about each phase.
$250 USD en 7 días
5,0 (15 comentarios)
5,1
5,1
Avatar del usuario
Hi, I am an excel VBA expert and have worked for various financial institutions. I found the project interesting and can start with phase 1 right away. I also would like to know how what are the forecasting techniques used in phase 2 or whether those techniques are already applied in the current sheet that you have. I would like to see your current sheet and list of charts,slicers and graph that you want to be displayed on the dashboard. Hope to chat with you soon mate! Thanks Sajid Khan
$250 USD en 7 días
4,2 (64 comentarios)
5,8
5,8
Avatar del usuario
Hi Sir, I’m a professional accountant in KSA, who have 6+ years of experience. With high MS excel and financial management knowledge. I can provide you free samples with high quality and in a fair price. Please, feel free to contact me. Thanks
$120 USD en 3 días
5,0 (14 comentarios)
4,2
4,2
Avatar del usuario
Thank You for taking the time to review my proposal! After going through your project details, I have found that it’s totally according to my interest and expertise, which you can see through my profile as well. I’m confident that I can deliver fantastic results. If you have any questions after reviewing my proposal, feel free to touch via click on CHAT button and we can discuss this further. Regards Shahzaib
$200 USD en 4 días
5,0 (5 comentarios)
3,5
3,5
Avatar del usuario
Dear Sir, I trust you are well, *** Cash flow report & other needed. I am a chartered accountant and an expert in excel as well. I can prepare your all reports perfectly as per your requirements. you can check my skills on relevant fields. I am waiting for your hearing. Many thanks, Kajee
$150 USD en 4 días
5,0 (3 comentarios)
3,6
3,6
Avatar del usuario
Sir/Madam, Just a clarification, this project will be done in MS Excel or Google sheet? or both? If both, will both files communicate with each other? Both technology have different scripting tools to be used. So it is important to know this small detail. I can do both though using VBA in Excel and Apps Script in google sheet. Send me a sample of your spreadsheet and I will give you sample code. If you're interested, please do let me know. Regards, Ronald
$200 USD en 7 días
4,8 (3 comentarios)
3,2
3,2
Avatar del usuario
Greeting! My name Vipin Garg and I am a software engineer (MCA). I have 13+ Yrs. Exp. in MS Access (SQL), MS Excel VBA Macro & G suite (Google sheets) which is used for automation. I would love to have the opportunity to discuss your project with you. I believe my skills are a match with your project. I have a good grasp of working with VBA & SQL, I would be easily able to achieve the task. I have developed 300 macro & modules for global sales team, paper mill, manufacturing companies and upload data on websites, send Emails by automation. Examples: -  Market, Portfolio, Funnel, Revenue, Vision and True North for (Sales Playbook)  Module for paper size cutting (stop for wastage) I have experience in the following data and MIS tools:- MS Excel 2016 (vlookup, hlookup, offset, index, pivot table, if, match, countif, sumif, counta, subtotal, charts, substitute, len, trim, conditional formatting, datedif, exact, concatenate, text, sumproduct) & G Suite (Google Sheets) Please let me know a time that works best for you and I will make sure that I make myself available. Best Regards, Vipin Garg
$200 USD en 7 días
3,8 (1 comentario)
2,0
2,0
Avatar del usuario
I have thoroughly read your post. I think I'm the best at this job. I have enthusiasm towards doing this work please give me a chance to prove my talent through this opportunity
$30 USD en 1 día
5,0 (2 comentarios)
1,1
1,1
Avatar del usuario
Hello, I am pleasure with your job for Development of Excel/Google Sheet to help predict date for issuing new payment. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like to make you an offer and some background so you can check my work out. I have been developing kind of project within 10+ years so I’m fluent experience to handle project. You’ll get all the expected stuff like a great professional service and a fast turnaround, at a bit less, and I get a bit more exposure. If the above offer sounds like something you would be interested in, I’d love to hear from you. Best regards
$140 USD en 7 días
5,0 (2 comentarios)
1,3
1,3
Avatar del usuario
HI dear, we are a team of qualified people (ICEAW, CPA, ICAP, ACCA) with big4 background, we would be happy to take your project and we can assurance you quality of work. Regards
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello! My name is Essraf . I have read your description and I'am Excited to work on your project. Chat with us. Please send me a message for more discussion, I work at any time just to satisfy the customer Confidence, speed at work, mastery Thanks & Regards,
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have enough knowledge and enough type speed for your work, I have knowledge about system, I mean computer knowledge
$222 USD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SWITZERLAND
Montreux, Switzerland
4,9
44
Forma de pago verificada
Miembro desde abr 11, 2006

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.