We are currently using Quickbooks Enterprise and we need a financial model that can produce visual metrics (line chart), consolidate data by company by month (or show all months).
In the workbook this was the best case I could come up with in terms of building this model.
Data Reference - the coding that would be needed (text in columns A and B need to be able to adjust on demand (so the data can be grouped for the chart presentation in the All Companies | All Months worksheet).
Extracts from Quickbooks (Data) - Examples BS Month Mar | BS Month Apr | IS Apr (All) etc. obviously we'll need all months (maybe even consider life to date ie. 2015 J,F,M,etc. - 20xx).
Output - All Companies | All Months is the final product we are looking for will be used for presentation purposes/analysis.
If this can be built on Google Docs that would be great.
Thanks!
Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and macro. Please check my profile to confirm the quality of my work. Please connect with me to discuss more
$250 USD v 10 dnech
5,0 (57 recenze)
5,8
5,8
18 freelanceři nabízejí v průměru $384 USD za tuto práci
Hi, I'll be happy to help you with this project. I take pride in accuracy, timely completion and support within reasonable time after completion. Please feel free to message me if you need to discuss any questions
Hi! I've used QuickBooks and have been preparing Management reports in excel s well. Please send me chat to discuss the project in detail and I'll share sample as well.
Having more than 11 years of experience in data banking /accounting and data analysis. Expert in MS EXCEL, formulae, Graphs, macros, pivot, shortcuts, templates, etc. Hence I can complete the task very effectively without compromising the quality.
Sir,
I am using QB since last 8 years. We are using this kind of FMC for our clients very often.
We use excel macro to make done this kind of reports. If you allow me to make this done for you then I can make this done for sure.
Expecting your ping on chat to discuss the same.
Thanking you
Umesh R
Hello,
Taking a look at the spreadsheet, I can produce what you need using drop down menus to select the different companies and pull through the relevant data on your output page. If selected, I would probably build this from scratch in excel. I have loads of experience building financial models in excel usually providing analysis on budget vs actual data with graphs and commentary. Once complete, I would be happy for you to review the completed work and I can make further adjustments if needed.
Thanks for your time
Karl
I am an experienced professional accountant and auditor, article writer, researcher, resume writer and academic writer. I am also about finishing my MBA course in the university. I read your project description and perfectly understand what you need. I am hardworking and committed, so you can expect a high quality work from me.
Thank you for reading my bid.
Jonaboy.
I have a lot of speriencie with financial excel and graphical analysis. I worked for two years at Delphi Automotive Systems doing financial analysis for new projects and may create any kind of financial excel table for you.
If you prefer I may create a online table in google docs that will fit any time space that you want.
I have done my MBA in finance area. I can handle balance sheet problems. Also I took Financial Modeling using spreadsheets as one of my subjects in my MBA and achieved A grade in the same. With reference to given sheet, I believe with a few doubt clearing,I can make this sheet of your use easily.