
Closed
Posted
Paid on delivery
I need an Excel-based procurement tracker that will help manage and streamline our procurement process. The tool should be intuitive and easy to use, with the following key features: I am building a powerline division for a client, I would like the first page to have the graph and costing info to each supplier and a spreadsheet with all of the order and costs. - Order Status Tracking: Visualize and update the status of all orders in real-time. - Supplier Details Management: Maintain a comprehensive database of suppliers with all relevant information. - Cost Analysis: Analyze and track costs to aid in budgeting and financial planning. The tracker must be able to handle daily and weekly updates on: - Product Details: Include specifications, quantities, and any other necessary product-related information. - Supplier Information: Update as needed based on changes or new suppliers. - Delivery Dates: Adjust and track all delivery timelines. - Comparison between competitors for justification report. Ideal Skills and Experience: - Proficiency in Excel, including advanced functions and data visualization tools. - Experience in creating custom Excel trackers and main dashboard with macros. - Strong organizational skills and attention to detail. - Familiarity with procurement processes is a plus. Please provide samples of previous work. Attached is my spreadsheet, I have the main page with items, to the right is other quotes.
Project ID: 40403768
45 proposals
Remote project
Active 20 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
45 freelancers are bidding on average $157 AUD for this job

Great to e-meet you, I'm Muhammad, an Excel guru with a versatile background in Finance, Accounting and Data Analytics. Your project aligns perfectly with my top-notch skills in creating efficient and tailored Excel tools. Having built numerous trackers and dashboards before, your procurement tracker will be managed with utmost professionalism and delivered on time. My mastery of multiple Excel functions combined with my experience in data visualization through Power BI and Tableau will ensure the tracker you receive is endowed with every feature needed for effective procurement management. Let me make things easier for you. I can provide you with a free demo of what I intend to achieve for your project - a fully functional sample custom-built according to your specific requirements. This way, you will witness the potential of a tracker that optimizes daily/weekly product updates, supplier information as well as delivery dates tracking effortlessly. Furthermore, I am well-acquainted with financial planning and analysis which will no doubt enhance the quality of cost analysis using the tool to aid in budgeting and financial planning. Lastly, my dedication to client satisfaction is unprecedented. Hiring me guarantees continuous free support even after the project has ended. Always ready to go above and beyond, let me show you how Excellency is done in data analytics; choose me for this project!
$60 AUD in 1 day
7.7
7.7

Hi there, I’ve carefully reviewed your project and understand you need a structured Excel-based procurement tracker for your powerline division, combining order tracking, supplier management, cost analysis, and a front-page executive dashboard with visual insights and comparative supplier costing. I’m confident I can redesign your workbook into a clean, scalable, and decision-ready procurement system. My approach is to restructure your file into a relational Excel model using structured tables for orders, suppliers, and cost breakdowns, ensuring all inputs feed directly into a dynamic dashboard. The first sheet will act as an executive overview, featuring visual charts for supplier spend, order status distribution, and cost comparisons between vendors to support procurement justification decisions. I’ll implement automated status tracking using dropdown-driven workflows, allowing real-time updates across all orders (e.g. pending, ordered, delivered, delayed). Supplier data will be centralized for easy updates and consistency, while delivery timelines and product details will be fully traceable across the system. For cost analysis, I’ll build dynamic comparison logic that evaluates competitor quotes side-by-side, highlighting variances and supporting budget decisions. Do you want this system to remain fully formula-driven, or are you open to lightweight VBA automation for faster updates and cleaner usability? I’m ready to start immediately. Warm regards, Aneesa.
$150 AUD in 1 day
6.9
6.9

I ALREADY MADE SIMILAR PROJECT LIKE THAT BEFORE. I can build a clean procurement tracker + dashboard with supplier comparison, cost analysis, and real-time order status tracking. • Main dashboard (graphs + supplier cost comparison) • Structured order database (products, suppliers, delivery, status) • Dynamic cost analysis + competitor comparison • Easy updates (daily/weekly) with automated calculations • Clean, user-friendly design with optional light VBA Ready, scalable, and easy to maintain. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$120 AUD in 2 days
6.5
6.5

⭐⭐⭐⭐⭐ Create an Effective Excel Procurement Tracker for Your Business Needs ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project requirements and noticed you're looking for an Excel-based procurement tracker. Look no further; Zohaib is here to help you! My team has successfully completed 50+ similar projects for Excel solutions. I will create an intuitive tracker that includes order status tracking, supplier management, and cost analysis, all within your budget. ➡️ Why Me? I can easily create your Excel procurement tracker as I have 5 years of experience in Excel development, including advanced functions, data visualization, and dashboard creation. My skills also cover automation and organization, ensuring your tracker meets all your needs. ➡️ Let's have a quick chat to discuss your project in detail. I can show you samples of my previous work and how I can add value to your procurement process. Looking forward to discussing this with you in chat. ➡️ Skills & Experience: ✅ Excel Proficiency ✅ Data Visualization ✅ Dashboard Creation ✅ Macros Development ✅ Order Tracking ✅ Supplier Management ✅ Cost Analysis ✅ Data Organization ✅ Automation Techniques ✅ Attention to Detail ✅ Procurement Knowledge ✅ Reporting Skills Waiting for your response! Best Regards, Zohaib
$150 AUD in 2 days
6.5
6.5

Hello, With over 7 years of experience in Data Processing, Excel, Excel VBA, Data Visualization, Excel Macros, and Financial Planning, I have the expertise to develop a customized Excel procurement tracker for your powerline division project. I have carefully reviewed your requirements and am confident in delivering a solution that meets your needs. For this project, I propose to create a dynamic Excel-based procurement tracker that includes a visually appealing dashboard with graphs and cost analysis for each supplier. The tool will feature: - Real-time order status tracking - Supplier details management - Cost analysis for budgeting and financial planning - Product details and specifications tracking - Supplier information updates - Delivery timeline tracking - Competitor comparison for justification reports I will leverage my advanced Excel skills, including VBA and data visualization tools, to design a user-friendly tracker that streamlines your procurement process. Let's discuss further details in the chat to ensure the tool aligns perfectly with your requirements. You can visit my profile for more information: https://www.freelancer.com/u/HiraMahmood4072 Thank you.
$100 AUD in 2 days
6.4
6.4

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
$140 AUD in 1 day
6.1
6.1

Hi I can surely assist you in writing or drafting or creating a professional Excel-based procurement tracker tailored for your powerline division. I will design an intuitive dashboard with graphs for supplier costing, real-time order status tracking, supplier database, cost analysis tools, and a comparison section for competitor justification. The sheet will be structured for daily and weekly updates, making procurement management simple and efficient, with clear visuals and easy navigation. I have strong experience in advanced Excel dashboards, automation, and data visualization, including macros and KPI tracking systems. Two questions: Do you want automated reports (PDF/email) generated from the tracker? How many suppliers and products do you expect to manage initially? I can also review your attached sheet and improve its current structure for better performance. Thanks
$30 AUD in 1 day
5.3
5.3

Hi, I am an Excel automation specialist with 8 years of rich experience with a background in procurement trackers and cost dashboards. I am familiar with Excel, VBA, macros, data visualization, cost analysis. For this project, the most important part is creating a clear dashboard that shows supplier costs, order status, delivery dates, and competitor comparisons in one place. I will focus on structured order tracking, supplier database setup, automated summaries, and visual cost reports for daily and weekly updates. This ensures the procurement process is easier to manage and justify. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
$250 AUD in 7 days
5.2
5.2

Hi there, I understand you need a robust Excel-based procurement tracker for a powerline division that centralises order management, supplier tracking, cost analysis, and competitive comparison in one intuitive dashboard. My goal is to create a live, decision-ready tool that supports daily and weekly procurement updates with clear financial visibility. My approach will begin by restructuring your existing workbook into a clean data model with separate tables for orders, suppliers, pricing quotes, and delivery tracking. I will then build a dynamic dashboard as the first page, featuring visual graphs and key KPIs such as total spend per supplier, cost breakdowns, order status distribution, and comparison views across competing vendors for justification reporting. Advanced Excel functions (XLOOKUP, SUMIFS, INDEX/MATCH) will be used to ensure real-time updates, while structured tables will keep the system scalable as new suppliers and orders are added. I can also integrate VBA/macros to automate status updates, refresh dashboards, and reduce manual input where needed. Conditional formatting and data validation will ensure accuracy and easy usability for daily operational updates. QUESTION: Do you want the dashboard designed for senior-level reporting (high-level KPIs only), or operational use with detailed drill-down into each order and supplier? Let’s get started and turn your spreadsheet into a powerful procurement management system. Regards, Shehwani.
$75 AUD in 1 day
4.8
4.8

HI, I have 15+ years of experience in excel VBA and business intelligence includes data processing ETL, data analysis, data modellkng and building interactive dashbaords. As an expert I can help build a professional Excel procurement tracker with dashboard graphs, supplier costing, order status tracking, delivery timelines, and competitor comparison reports. I specialize in Excel dashboards and automation, and will ensure the file is easy to update daily and weekly. Ready to start right away. Ready to start immediately. Thanks Shivani
$140 AUD in 7 days
4.7
4.7

Hi there, I've reviewed your spreadsheet. I can see the full order list across all suppliers, costs, lead times, and quote statuses. I'll build this into a clean procurement tracker with a dashboard on the first page showing cost per supplier, total CAPEX breakdown, and quote status overview with charts. The order sheet will be fully structured with all your existing data, ready for daily and weekly updates. Cheers
$195 AUD in 2 days
4.0
4.0

✨✨✨ ✨✨✨ ✨✨✨ ✨✨✨✨✨✨ ✨✨✨ ✨✨✨ ✨✨✨✨✨ Hi, Dear. Portfolio : https://www.freelancer.com/u/seandinwiddie I’m confident I can build a structured, automated Excel procurement tracker with a clear dashboard for your powerline division, including supplier costing comparisons, order tracking, and visual reporting. I focus on clean, scalable spreadsheets that are easy to maintain and update daily. I will start by reviewing your existing spreadsheet and restructuring it into normalized tables for orders, suppliers, and costs. Next, I will build a dynamic dashboard with graphs, supplier comparison views, and real-time order status tracking. Finally, I will implement formulas, validation rules, and optional macros to streamline updates and ensure data accuracy. The final tracker will support clear procurement visibility, fast cost comparisons, and structured reporting for decision-making and justification analysis. Best Regards. Sean D.
$240 AUD in 3 days
3.4
3.4

Greetings from Toriqul Global Solutions! I’m Engineer Toriqul Islam, a B.Sc. graduate in Computer Science & Engineering from Rajshahi University of Engineering & Technology (RUET), with over 10 years of professional experience in developing smart, efficient, and user-friendly digital solutions. I have carefully reviewed your requirement for an Excel-based Procurement Tracker, and I fully understand your need for a structured, automated, and visually insightful system to manage your powerline division procurement workflow. I have developed multiple Excel-based systems including: Procurement & inventory trackers Sales & commission dashboards Financial analysis tools with automated reporting We would be honored to discuss your project requirements and help bring your ideas to life. Thank you for your time and consideration. Warm Regards, Toriqul Global Solutions
$200 AUD in 3 days
3.3
3.3

Hello, With over 5 years of experience in Excel, Data Visualization, and Data Analysis, I specialize in creating custom Excel solutions tailored to specific needs. I have reviewed your requirements for the Excel-based procurement tracker and am confident in delivering a user-friendly tool that streamlines your procurement process efficiently. I have completed over 150 data-centric projects, focusing on data integrity and workflow efficiency. My expertise includes Advanced Excel Engineering, VBA & Macro Automation, Business Intelligence with Power BI, Web Scraping, Data Extraction, and Data Cleansing & Management. You can view my portfolio here: https://www.freelancer.pk/u/Musab360 I would love to discuss your project further and how I can assist you. Let's connect in chat to explore the details. Best regards, Musab
$30 AUD in 1 day
1.4
1.4

Hi, ⭐⭐⭐15+ Yrs Sr Developer here⭐⭐⭐ I can build a clean Excel procurement tracker for your powerline division with a main dashboard, supplier costing, order tracking, and competitor quote comparison. I have strong experience with advanced Excel, VBA/macros, dashboards, cost analysis, procurement trackers, supplier databases, and visual reporting. I’ll structure the first page with graphs, supplier cost summaries, order status views, and key budget information so you can quickly see what is ordered, pending, delivered, or over budget. The workbook will also include detailed sheets for product specs, quantities, supplier details, delivery dates, costs, and quote comparisons for justification reports. I can use formulas, dropdowns, conditional formatting, pivot tables, and macros where useful, while keeping the tracker easy to update daily or weekly. I am ready to start by reviewing your attached spreadsheet and turning it into a more professional, practical procurement control tool. If you think I am a good fit, feel free to ping me anytime. — GAZMIR
$80 AUD in 2 days
1.0
1.0

I can develop an intuitive Excel-based procurement tracker tailored to your needs. This tool will include order status tracking, supplier details management, and cost analysis, ensuring it supports daily and weekly updates. I suggest breaking the project into milestones: 1) Initial design and dashboard setup, 2) Implementation of tracking features, 3) Final adjustments and user acceptance testing (UAT). I can also offer ongoing support if needed. Looking forward to collaborating on this project!
$140 AUD in 6 days
0.0
0.0

Hello, I hope you’re well. I’m Billy Bryan, a solo Excel-focused developer who creates powerful, easy-to-use dashboards and procurement trackers. I specialize in building intuitive main dashboards with macros, data visualization, and robust data processing so teams can manage orders, suppliers, and costs without friction. I’ve designed end-to-end Excel trackers that cover supplier databases, real-time order status visualization, and cost analysis to support budgeting and financial planning. I’ve implemented daily/weekly data refreshes, product details, delivery dates, and supplier updates, plus comparison reports to justify supplier selection, all while keeping the interface clean and user-friendly and ensuring it scales with new data. I can deliver a reliable, highly usable procurement tracker tailored to your Powerline division. Once we align on scope, I can start with a prototype for key suppliers and expand to full deployment quickly. Best regards, Billy Bryan
$250 AUD in 2 days
0.0
0.0

Hi, I’m Everett, an Excel expert with extensive experience in developing custom procurement trackers. I am excited about the opportunity to create a streamlined, intuitive tool tailored specifically for your powerline division. I understand you need a procurement tracker that not only manages supplier details and order statuses but also provides robust cost analysis features. My approach will involve designing a user-friendly dashboard on the first page, incorporating graphs and cost breakdowns for each supplier. I will utilize advanced Excel functions and macros to ensure real-time order status updates, easy supplier information management, and comprehensive delivery date tracking. The tool will be flexible, allowing for daily and weekly updates while facilitating competitor comparisons to enhance your decision-making process. I am available for real-time communication according to your time zone and can provide a demo or initial portion of the tracker within 12 hours of starting the project. Q1: What specific metrics do you want displayed on the dashboard? Q2: How frequently do you expect updates on supplier information? Q3: Are there any additional features you’d like to include in the tool? Looking forward to your response! Best regards, Everett
$200 AUD in 3 days
0.0
0.0

I am a procurement and cost control professional based in Qatar, with active experience building Excel-based tracking systems for construction and infrastructure projects — including powerline and MEP divisions. What you will receive: Dashboard Page — supplier cost comparison charts, total committed vs budget, order status summary, all visible on one screen Procurement Tracker — full order register with product specs, quantities, unit rates, total costs, supplier, delivery dates, and status Supplier Database — centralised supplier information, contact details, lead times, payment terms Cost Analysis Sheet — budget vs committed vs actual, cost breakdown by supplier and category Competitor Comparison Table — side-by-side quote comparison per item for justification reporting Status Tracking — colour-coded order status (pending, ordered, delivered, delayed) with daily/weekly update capability Built on your existing spreadsheet — I will work from the file you have already started, not replace it All built with Excel tables, pivot charts, and targeted macros. No overengineering — practical and easy for your team to update daily. Bid: $250 fixed. Delivery: 5–7 working days. Qatar-based, available immediately, familiar with GCC procurement practice and construction supply chain management.
$250 AUD in 7 days
0.0
0.0

Brisbane, Australia
Payment method verified
Member since Apr 28, 2026
₹750-1250 INR / hour
₹12500-37500 INR
₹12500-37500 INR
$30-250 USD
₹12500-37500 INR
₹600-1500 INR
₹750-1250 INR / hour
$10-30 USD
₹600-1500 INR
$15-25 USD / hour
₹200-450 INR / hour
$25-50 AUD / hour
₹750-1250 INR / hour
$30-250 CAD
₹1500-12500 INR
₹600-1500 INR
$115-200 HKD / hour
$8-15 USD / hour
₹12500-37500 INR
₹750-1250 INR / hour