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

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

Skills: Excel VBA, Excel Macros, Excel, Software Architecture, Windows Desktop

See more: excel work sheet design, transfer data excel multiple sheet access table, excel shiftwork sheet, google adword help, excel formula sheet, microsoft excel formula sheet, website development excel doc, google base help, department reports companies pakistan using excel work sheet, excel spread sheet date converted numbers, excel sheet worker project date, sdlc software development excel sheet, google spread sheet help, excel macros convert google sheet, excel macros google sheet, real estate development excel sheet, projects development excel sheet, google sheet help, mixed use development excel sheet

About the Employer:
( 44 reviews ) Montreux, Switzerland

Project ID: #22321692

37 freelancers are bidding on average $157 for this job


Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$250 USD in 4 days
(376 Reviews)

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 in 3 days
(377 Reviews)

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 c More

$250 USD in 10 days
(274 Reviews)

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, MS Word, Access, Outlook, Google Sheet, Access, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management ht More

$140 USD in 7 days
(142 Reviews)

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 More

$200 USD in 3 days
(393 Reviews)

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 and I do not More

$155 USD in 3 days
(58 Reviews)

Hi, I am an expert in Excel, Access, Powerpoint, VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interact More

$140 USD in 7 days
(84 Reviews)

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 More

$140 USD in 7 days
(44 Reviews)

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 introdu More

$250 USD in 4 days
(42 Reviews)

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 More

$177 USD in 3 days
(52 Reviews)

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 aut More

$250 USD in 7 days
(13 Reviews)

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 More

$250 USD in 7 days
(64 Reviews)

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 myse More

$40 USD in 1 day
(17 Reviews)

Google spreadSheet + Macros Hi There, I can provide you with a smart google sheet which will give a date for the new cheque payment by analyzing the existing sheet. Phase 2 can also be achieved to give you accurate f More

$135 USD in 5 days
(12 Reviews)

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 f More

$120 USD in 3 days
(14 Reviews)

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 co More

$200 USD in 4 days
(5 Reviews)

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 More

$200 USD in 7 days
(3 Reviews)

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 More

$200 USD in 7 days
(1 Review)

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 in 1 day
(2 Reviews)

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 thi More

$140 USD in 7 days
(2 Reviews)