
Closed
Posted
I have three extensive Excel files—each packed with multiple worksheets—that currently hold all of our internal financial reports. I need these merged into a single, well-structured database that can automatically pull the latest data, tabulate it against our budget lines, and generate clear, executive-level dashboards focused on performance assessment. The scope is large (about 120 hours) and hands-on collaboration is essential. I will work closely with you to map every worksheet, define the budgeting logic, and agree on the look and feel of the summary views. Advanced Excel skills—think Power Query, PivotTables, dynamic array formulas, and VBA for tighter automation—will be required to keep maintenance simple after hand-over. Key deliverables: • A master workbook that consolidates the three source spreadsheets, with refreshable links to every underlying tab. • Robust budgeting tables that reconcile planned versus actual figures in real time. • Management and financial report templates (charts, slicers, and printable summaries) aimed squarely at performance assessment. • A brief user guide and a walk-through call so my team can update and expand the model confidently. Because frequent check-ins are vital, I’m only considering experts located in the Philippines or Thailand (English fluency is a must for applicants in Thailand). If you have deep experience building complex financial models in Excel and can commit the focus this project deserves, I’d love to hear how you would tackle it and see samples of similar work.
Project ID: 40633275
21 proposals
Active 15 hours ago
Location: Philippines
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $50 USD/hour for this job

Hi. I'm interested in your available job. You can check my portfolio in my profile for some works that I did in the past in relation with this kind of job. I am also located in the Philippines. Thank you. Bryan
$50 USD in 40 days
4.4
4.4

One of the key reasons clients choose me is my end-to-end execution approach which aligns perfectly with your need for hands-on collaboration. I undoubtedly understand the necessity of mapping out every worksheet, defining budgeting logic to the tee, and ensuring that the summary views are bespoke to your executive-level needs. Additionally, as an adept problem solver with a commitment to customer satisfaction, I can provide you not just the deliverables you have described but also a user guide that empowers your team to confidently update and expand the model post-handover. In terms of my work ethic, reliability and consistent communication are my hallmarks. You won't have to chase up on progress or worry about missed deadlines - my work is conducted efficiently and reported-on regularly. The size of this project demands precision from someone who genuinely respects its magnitude; someone who will save time now while maximizing the future efficiency of your operations. I believe that person is me. Let’s have a chat so you can further visualize how I can revolutionize your budget reporting process!
$50 USD in 40 days
4.1
4.1

I’m a Senior Data Analyst based in the Philippines with over 10 years of experience in the BPO industry, supporting complex operations across multiple global businesses. My background heavily focuses on data modeling, Power Query ETL pipelines, and VBA automation. I can deliver your consolidated financial database and executive dashboards comfortably within your estimated 120-hour scope. Being in the Philippines, I offer full timezone alignment for the frequent syncs, mapping sessions, and hands-on collaboration this project requires.
$50 USD in 40 days
2.4
2.4

Hi! PH-based Excel & Automation Specialist here, ready for hands-on collaboration. I will consolidate your 3 multi-sheet financial files into a scalable master workbook using Power Query for seamless data refresh and dynamic formulas/VBA for real-time budget vs. actual reconciliation. Key Deliverables: Automated data integration Executive-level dashboards with slicers & KPI charts Custom VBA for effortless maintenance Clear User Guide & walk-through session Being in PH, time zone alignment for check-ins is seamless. Let's connect to review your files!
$50 USD in 30 days
1.4
1.4

Hi there! I'd love to help consolidate your financial reports. Merging three massive, multi-worksheet workbooks into one clean, automated database is right in my wheelhouse. Being based in the Philippines, coordinating schedules, jumping on quick syncs, and doing hands-on mapping together won’t be an issue at all. Here is how I approach a project like this: Mapping & Cleaning: We'll audit your current files to map every worksheet and set up a standardized structure. Power Query Automation: I’ll set up Power Query in a master workbook to pull and refresh data seamlessly. Budget vs. Actual Engine: I'll build backend models using PivotTables and dynamic arrays to reconcile figures in real time, adding VBA for automation. Executive Dashboards: I'll design clean summary views with slicers, charts, and printable summaries for leadership. Hand-over: I'll provide a user guide and walk-through call so your team can update the model confidently. With my extensive background in managing complex data processes and building structured workflows, I can ensure a seamless transition.
$50 USD in 40 days
0.0
0.0

Hi, I’d be happy to help with this project. I have experience working with Excel, Google Sheets, data organization, reporting, and maintaining accurate records across different workflows. I’m comfortable working with large datasets, organizing information from multiple sources, and creating clear, easy-to-maintain reports. I understand that this project requires careful mapping of the three workbooks, budget-versus-actual reconciliation, refreshable data, and management dashboards. I’m also comfortable with hands-on collaboration and regular check-ins to make sure the final model matches your requirements. I’d be glad to review the workbooks, understand your budgeting structure, and help build a clean and practical master file your team can confidently maintain after handover. Thank you, and I’d be happy to discuss the project further. Peachy ?
$50 USD in 40 days
0.0
0.0

Hello there. I have extensive experience with Excel, Sheets, Data Management, and process improvement. I can consolidate your 3 complex workbooks into a structured model. As this project requires close collaboration and careful mapping of each worksheet, I am available to work on this for full time with you. I can build the master file, separate reports and main dashboard. I will endorse the SOP and user guide upon project completion.
$50 USD in 40 days
0.0
0.0

You should hire me because I communicate clearly, work well with others, build strong teams, socialize easily, and learn quickly.
$50 USD in 40 days
0.0
0.0

Hi, I’m based in Thailand and fluent in English, with experience in data consolidation, reporting automation, database-driven workflows, and business process systems. For a project of this size, I would begin by mapping all three workbooks and every relevant worksheet, identifying source data, calculations, budget structures, dependencies, PivotTables, queries, and existing automation before rebuilding the reporting model. My approach would be to create a clean master workbook using Power Query, Excel Tables, PivotTables, dynamic formulas, and VBA where it genuinely improves automation. I would also build reliable Actual vs Budget reporting, reconciliation controls, management dashboards, slicers, charts, and printable executive summaries. A key priority would be maintainability. The goal is for your team to update the source files, refresh the model, and have the reports update with minimal manual work. I can commit approximately 10–12 focused hours per week, mainly during evenings and Sundays, and I am comfortable with regular scheduled check-ins to review worksheet mapping, budgeting logic, dashboard requirements, and progress. I would be happy to work closely with you throughout the project and provide clear documentation and handover guidance once the model is completed.
$50 USD in 12 days
0.0
0.0

Thailand
Payment method verified
Member since May 17, 2014
$250-750 USD
£18-36 GBP / hour
₹400-750 INR / hour
$30-250 USD
€12-18 EUR / hour
₹12500-37500 INR
$250-750 SGD
$15-25 USD / hour
₹12500-37500 INR
$30-250 USD
₹750-1250 INR / hour
$250-750 USD
₹750-1250 INR / hour
$15-25 USD / hour
₹600-1500 INR
₹12500-37500 INR
$10-30 USD
min $50 USD / hour
$30-250 USD
$15-25 USD / hour
₹1500-12500 INR