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

Compétences : Excel VBA, Excel Macros, Excel, Architecture Logicielle, Bureau Windows

en voir plus : 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

Concernant l'employeur :
( 44 commentaires ) Montreux, Switzerland

Nº du projet : #22321692

38 freelance font une offre moyenne de $159 pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(341 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(332 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(273 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(135 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(346 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(50 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(78 Commentaires)

Hi, Nice to meet you. I am sure for your project. I have read your 3 step development requirement. Please see product I made recently using VBA. I can show my product right now. I have a lots of experiences in Excel, A Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(76 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(52 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(34 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(36 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(59 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(10 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(13 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(5 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(6 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)

Hi there, I just saw your project detail that you need to the Development of Excel/Google Sheet to help predict date for issuing new payment. I am very well with project work . As , I have checked the work detail...I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)