Đã Đóng

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

Kĩ năng: Excel VBA, Excel Macros, Excel, Kiến trúc phần mềm, Màn hình Windows

Xem nhiều hơn: 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

Về Bên Thuê:
( 44 nhận xét ) Montreux, Switzerland

ID dự án: #22321692

38 freelancer đang chào giá trung bình $159 cho công việc này


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 Thêm

$250 USD trong 4 ngày
(341 Nhận xét)

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 trong 3 ngày
(332 Nhận xét)

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 Thêm

$250 USD trong 10 ngày
(273 Nhận xét)

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 Thêm

$140 USD trong 7 ngày
(135 Nhận xét)

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 Thêm

$200 USD trong 3 ngày
(346 Nhận xét)

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 Thêm

$155 USD trong 3 ngày
(50 Nhận xét)

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 Thêm

$140 USD trong 7 ngày
(78 Nhận xét)

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 Thêm

$250 USD trong 3 ngày
(76 Nhận xét)

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 Thêm

$177 USD trong 3 ngày
(52 Nhận xét)

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 Thêm

$140 USD trong 7 ngày
(34 Nhận xét)

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 Thêm

$250 USD trong 4 ngày
(36 Nhận xét)

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 Thêm

$250 USD trong 7 ngày
(59 Nhận xét)

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 Thêm

$40 USD trong 1 ngày
(16 Nhận xét)

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 Thêm

$250 USD trong 7 ngày
(10 Nhận xét)

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 Thêm

$120 USD trong 3 ngày
(13 Nhận xét)

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 Thêm

$200 USD trong 4 ngày
(5 Nhận xét)

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 Thêm

$200 USD trong 7 ngày
(3 Nhận xét)

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 Thêm

$135 USD trong 5 ngày
(6 Nhận xét)

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 trong 1 ngày
(2 Nhận xét)

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 Thêm

$140 USD trong 7 ngày
(2 Nhận xét)