Ditutup

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

Kemahiran: Excel VBA, Excel Macros, Excel, Kejuruteraan Perisian, Destop Windows

Lihat lagi: 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

Tentang Majikan:
( 44 ulasan ) Montreux, Switzerland

ID Projek: #22321692

38 pekerja bebas membida secara purata $159 untuk pekerjaan ini

schoudhary1553

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 Lagi

$250 USD dalam 4 hari
(341 Ulasan)
7.9
P0L

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 dalam 3 hari
(332 Ulasan)
7.3
shikhamehta

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 Lagi

$250 USD dalam 10 hari
(273 Ulasan)
7.2
valor312

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 Lagi

$140 USD dalam 7 hari
(135 Ulasan)
6.8
TonmoyRoy111

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 Lagi

$200 USD dalam 3 hari
(346 Ulasan)
6.9
StormLion227

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 Lagi

$155 USD dalam 3 hari
(50 Ulasan)
6.5
aimefx

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 Lagi

$140 USD dalam 7 hari
(78 Ulasan)
6.0
ironstar20311

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 Lagi

$250 USD dalam 3 hari
(76 Ulasan)
5.7
sonarkaushik

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 Lagi

$177 USD dalam 3 hari
(52 Ulasan)
5.7
imteyazkhan85

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 Lagi

$140 USD dalam 7 hari
(34 Ulasan)
5.2
bhupendrayadav

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 Lagi

$250 USD dalam 4 hari
(36 Ulasan)
5.4
sajidkhan45

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 Lagi

$250 USD dalam 7 hari
(59 Ulasan)
5.5
rIbrarahmed

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 Lagi

$40 USD dalam sehari
(16 Ulasan)
4.4
arash18k

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 Lagi

$250 USD dalam 7 hari
(10 Ulasan)
4.0
hkh581e5c8f1cb8a

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 Lagi

$120 USD dalam 3 hari
(13 Ulasan)
3.9
pakistansolution

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 Lagi

$200 USD dalam 4 hari
(5 Ulasan)
3.5
rjmijares

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 Lagi

$200 USD dalam 7 hari
(3 Ulasan)
3.2
corporatessc

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 Lagi

$135 USD dalam 5 hari
(6 Ulasan)
3.0
habibadmd

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 dalam sehari
(2 Ulasan)
1.1
pradeep890

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 Lagi

$140 USD dalam 7 hari
(2 Ulasan)
3.1