
Closed
Posted
Paid on delivery
Our warehouse needs a clean, reliable system that shows—at a glance—where every item has come from, how it has moved, and when it was used. I want complete traceability and a sense of orderliness, without having to sift through paperwork or scattered spreadsheets. Here’s the workflow I have in mind: • Excel will serve as the master data entry point. Each product entry or exit must be logged with item code, description, batch/lot, quantity, operator name, and time stamp. • Power Query or VBA (whichever you find more efficient) should handle the heavy lifting: append new transactions, prevent duplicate IDs, and instantly update current stock levels. • Power BI will pull directly from that Excel file—no manual exports—to produce interactive dashboards. I need visual cues for low stock, trend lines for product usage over time, and a searchable order history that lets me drill from summary down to individual transaction records. Deliverables 1. A fully-formatted Excel workbook with automated data-capture forms and locked formulas that calculate real-time stock on hand. 2. A connected Power BI report (.pbix) with at least these pages: Current Inventory, Product Usage, Order History, and Exceptions (e.g., negative stock or expired lots). 3. A short hand-off guide or screen-share recording so my team can refresh data, add new SKUs, and publish the Power BI reports without outside help. Acceptance criteria • Every product addition or usage event is uniquely time-stamped and traceable within two clicks in Power BI. • Stock variances between Excel and Power BI do not exceed one unit after refresh. • The solution runs on standard Microsoft 365—no premium or paid add-ins. If you have creative ideas on visualizing traceability or streamlining the Excel data entry form, I’m open to them, as long as the core requirements above are met. Any input needed from my side will be delivered upon demand.
Project ID: 40775035
30 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
30 freelancers are bidding on average ₹7,825 INR for this job

Hi, PURE CODE here, from Saudi Arabia. What matters most in building your Excel and Power BI warehouse tracker with Microsoft 365 is numbers people trust and use to make decisions. I'm a senior software developer with 10+ years of experience working with Data Processing, Data Visualization and Data Analysis. The real challenge is the data behind the charts: messy sources, mismatched definitions and refresh failures in Power BI. A common issue: building visuals before agreeing how each number is calculated, so reports disagree. My plan: first, agree each metric, its definition and its data source. Then, clean and model the data, and build the report pages in Power BI. Finally, check totals against the source and set up scheduled refresh. I'd start with the main dashboard pages as phase one. I've done reporting work before. A few questions to better understand the scope: 1. Is any source a spreadsheet updated by hand? Manual sheets often break scheduled refreshes. 2. Start with one page that answers the top question? I'd recommend it, one trusted page comes first. 3. Who reads the dashboards, managers or analysts? The readers decide the level of detail. I can start right away. Happy to go over the details here in chat and suggest the best approach. Looking forward to hearing from you, PURE CODE
₹7,000 INR in 7 days
4.1
4.1

Your core constraint is the one most bids will miss: keeping the Excel master and the Power BI refresh in sync so stock variance never exceeds one unit. I'd make Excel the single source of truth with a structured table plus a data-entry form that validates item code, batch/lot and quantity on entry, blocking duplicate IDs and negative stock at the point of capture instead of fixing them later. Power Query (not VBA) loads that table into the .pbix, so there are no manual exports and it refreshes cleanly on standard M365 with no paid add-ins. The report has the four pages you listed: Current Inventory, Product Usage, Order History and Exceptions, with drill-through from summary down to a single timestamped transaction, so any item is traceable in two clicks. Low-stock cues, usage trend lines, and negative-stock/expired-lot flags are built in. You get the workbook with locked formulas and the entry form, the connected .pbix, and a short recorded walkthrough plus written guide so your team can refresh, add SKUs and publish on their own. One thing that shapes the build: roughly how many transactions per day do you log, and does each batch/lot carry an expiry date so the expired-lot flag can run automatically?
₹6,500 INR in 5 days
4.2
4.2

I can build an integrated Excel and Power BI inventory management system that provides accurate stock visibility, end-to-end batch traceability, and automated exception monitoring, reducing manual work and improving warehouse control. Thank you for considering my proposal. I have gone through the requirements in detail. I will create an Excel workbook with automated transaction entry, unique IDs, timestamps, duplicate prevention, protected formulas, and real-time stock calculations. The connected Power BI report will include Current Inventory, Product Usage, Order History, and Exceptions pages, with low-stock alerts, expiry tracking, usage trends, and drill-down traceability. I will also provide a handover guide so your team can maintain the solution independently, using standard Microsoft 365 tools without paid add-ins. I have uploaded samples of similar projects completed by me earlier in my profile. With 10+ years of experience as a Chartered Accountant (ICAI) and CPA, I bring strong expertise in Excel automation, Power BI dashboards, data validation, and financial reporting. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Regular update related to project ✅ Timely delivery ✅ 100% commitment to project completion I am committed to delivering a reliable, user-friendly solution that meets your acceptance criteria. Do you currently maintain an SKU master and opening stock file in Excel?
₹4,000 INR in 1 day
3.7
3.7

You get an Excel entry form that logs every item in and out with a time stamp, a self-updating stock sheet, and a Power BI report on your four pages, all fed from one workbook. In this order, riskiest first: 1. Build the entry form and repeated-ID check, then test two people saving at once, since that is where stock counts drift. 2. Add stock-on-hand formulas by item code and batch, with low-stock and negative flags. 3. Connect Power BI to the workbook and build the four pages, with drill-through to single transactions. 4. Write the hand-off guide and record a walkthrough of adding a new SKU. Test a few entries and a repeated ID yourself before you release the rest. - 1,800 INR for steps 1 and 2: the entry form and live stock sheet, which you can test within a few hours of award. - 4,200 INR for steps 3 and 4, once the report, guide and variance check pass. Will the report refresh on a schedule, which needs a Power BI Pro licence, or will someone refresh it by hand? I can start today, and the entry form comes first.
₹6,000 INR in 6 days
3.4
3.4

Hi, This is a job I've done by hand. Two and a half years split between inbound operations at a cross-border warehouse and purchasing for a paper group - receiving, put-away, batch and lot tracking, and the endless argument about whether the system or the floor is right. What I'd build: Excel as the single entry sheet, one row per movement, with item code, description, batch, quantity, operator and timestamp. Everything else calculated, nothing typed twice. Append and duplicate control in Power Query rather than VBA. Power Query is easier for you to audit and doesn't break when someone renames a column, and the stock-on-hand view refreshes without anyone clicking a macro. Duplicate IDs get caught on item code plus batch plus timestamp and flagged rather than blocked, so a genuine double movement isn't lost. Traceability: a second sheet where you enter an item or a batch and get every movement it appears in, in order. That's the part people actually use when a customer asks where something came from. One honest limit - I'm comfortable in Excel and Power Query and can build the data model. If you later want a published Power BI dashboard rather than a workbook, that's where I'd need to be careful about promising polish. Roughly how many movements a day, and how many SKUs? Rong
₹12,000 INR in 7 days
2.7
2.7

- I can help build an integrated inventory tracking and reporting solution using Excel, Power Query, Power BI, and data modeling to improve warehouse visibility and traceability. - My experience includes developing Power BI dashboards, creating data models and relationships, writing DAX measures, integrating data through APIs, and configuring data refresh workflows. - I will structure the Excel workbook to record item codes, descriptions, batch or lot numbers, quantities, operators, timestamps, and stock movements in a consistent transaction log. - I will design the data structure to support unique transaction IDs, duplicate checks, stock-in and stock-out tracking, and accurate stock-on-hand calculations. - I will connect the inventory data to Power BI and develop four reporting pages: Current Inventory, Product Usage, Order History, and Exceptions. - The dashboards will include low-stock indicators, usage trends, searchable transaction history, batch-level traceability, and exception flags for issues such as negative stock or expired lots. - I will validate inventory calculations between Excel and Power BI and provide a practical hand-off guide covering data entry, refreshes, SKU additions, and report maintenance. Reference work is available in my profile.
₹7,000 INR in 5 days
1.1
1.1

The trickiest part here is ensuring the Excel data structure remains normalized for Power BI while keeping the entry form user-friendly; I will use Power Query to transform your flat logs into a relational model that avoids calculation errors. The workflow: Excel Input Form -> Power Query ETL -> Automated Power BI Refresh - Excel master data entry form with validated inputs - Power Query automation for unique ID and batch tracking - Power BI Current Inventory dashboard - Power BI Product Usage trends - Power BI Order History drill-downs - Power BI Exceptions tracking Send me a sample of your current log layout and I will return a clean, structured Excel file with the connected PBIX dashboard before you pay a cent. Delivery: 2 days I am ready to start immediately; I suggest we set up the first milestone upon my delivery of the working Excel template.
₹1,500 INR in 2 days
0.4
0.4

Hello. “A place for everything, and everything in its place.” As this saying means, in this project the important part is just clear traceability from receiving to usage, with dependable data behind every dashboard. I’ll structure the Excel workbook as the controlled transaction entry point, with guided forms, unique transaction IDs, timestamps, protected formulas, and stock calculations that remain easy for your team to maintain. The Power BI report will connect directly to the workbook and include Current Inventory, Product Usage, Order History, and Exceptions. Low-stock indicators, usage trends, searchable drill-through history, negative-stock checks, and expired-lot visibility will make issues clear without manual exports. I’ll also provide a concise hand-off guide or screen-share walkthrough covering refreshes, new SKUs, daily entries, and publishing within standard Microsoft 365. The design will prioritize reliable refresh behavior and keeping Excel and Power BI aligned. Would you prefer the Excel entry process to use a VBA form, or should it remain entirely table-based for easier Microsoft 365 compatibility? Regards, Michel
₹15,000 INR in 4 days
0.0
0.0

Warehouse Tracker starts with an Excel workbook using Power Query for duplicate-ID checks and real-time stock formulas, keeping everything inside standard Microsoft 365 without paid add-ins. This price covers the Excel master workbook with locked formulas and an automated data-capture form, delivered as a checkpoint within 3 working days; the Power BI report with Current Inventory, Product Usage, Order History and Exceptions pages follows in a next milestone once the workbook structure is approved. Power Query refresh will link Excel directly to Power BI, avoiding manual exports and keeping stock variance under one unit. Please share a sample of current item codes and a few past transaction rows so the entry form matches your real data. Price: 3300 INR fixed · Timeline: 3 working days from access/brief Konrad
₹3,300 INR in 3 days
0.0
0.0

With the rise of digital transformation and an ever-increasing need for organized data, my expertise in building practical, solution-driven web applications makes me your ideal candidate. Having developed secure Warehouse Management Systems (WMS) powered by efficient Excel tracking and Power BI Visualization dashboards, I have a deep understanding of your project's needs. Specifically, I am highly proficient in Excel and Power BI, skilled at leveraging Power Query and VBA for smooth data manipulations with minimum chances of errors like duplicates. My previous projects in warehouse management involved developing traceability systems similar to what you're looking for – streamlined data entry points and reliable, accurate real-time inventory tracking. Not only did the clients find these systems incredibly time-saving and error-proof, but they also appreciated the visually interactive nature of the Power BI reports, which enhanced strategic decision making. Additionally, my exposure to developing multi-tenant web applications has honed my skill set towards being adaptive, adaptable, and detail-oriented. Identifying with your acceptance criteria and delivering testable milestones would be like second nature to me. With no external dependencies required for implementation, I assure you an efficient solution that runs seamlessly on your standard Microsoft 365 stack. Let's work together to as we resolve this challenge!
₹7,000 INR in 7 days
0.0
0.0

Hi, I'm Thang, an Electronics & Telecommunications Engineer (5-year Engineering degree, Hanoi University of Science and Technology) with hands-on experience as a Software Engineer at Samsung R&D Center and Rikkeisoft. I'm proficient in Excel (formulas, pivot tables, data validation, structured tables) and Power BI (data modeling with Power Query, DAX measures, interactive reports), and I work with structured business data daily. For your warehouse tracker, here's my plan: 1. Build a clean, structured Excel workbook for warehouse data entry — consistent tables, dropdown validations, and formulas that keep inventory numbers accurate with no manual errors. 2. Connect it to Power BI with a clear data model, then build an interactive dashboard showing stock levels, in/out movements, and low-stock alerts at a glance — with slicers for date, product category, and warehouse section. 3. Walk through your acceptance criteria one by one before delivery, so every item you listed is verified and working. Accurate data and a dashboard you can actually use every day are my priorities, and I can start right away. One question: will the Excel file be the single data source for Power BI, or will the data come from multiple files? Thank you for considering my bid. Best regards, Thang
₹1,500 INR in 3 days
0.0
0.0

i'm a current enterprise technical architect with 10+ yrs in crm and revops - happy to take this on. the person doing your work automated 500+ contracts a year and cut contract turnaround 60%. free sample: share a small dummy or anonymized slice of your data and we'll clean it and send it back before you award. i'd start with the entry form and duplicate-id check, then the stock sheet and the four power bi pages (current inventory, usage, order history, exceptions). 5 days to a tested workbook and connected pbix plus a short hand-off guide, microsoft 365 only, no paid add-ins.
₹1,500 INR in 5 days
0.0
0.0

Hi, this is squarely in my wheelhouse - Excel automation with Power Query/VBA plus Power BI reporting. My delivery plan in two phases: Phase 1 - a formatted Excel workbook with data-capture forms, Power Query logic that appends transactions, blocks duplicate IDs, and calculates real-time stock on hand with locked formulas. Phase 2 - a connected .pbix report (Power BI reads the Excel directly, no manual exports) including: current inventory page with low-stock visual cues, product usage trend lines, and a searchable, drillable order history from summary down to individual transactions. I will share a quick mockup of the data model after kickoff so you can confirm fields before build-out. I can start immediately and will keep you updated daily. Best, Qiaofu
₹9,000 INR in 7 days
0.0
0.0

Hello, I understand your need for a clean, reliable system that provides complete traceability of warehouse items while eliminating the chaos of paperwork and scattered spreadsheets. Using Excel as your master data entry point, I will develop automated forms that ensure each entry is accurate and time-stamped. By employing Power Query or VBA, I will streamline the transaction logging process, preventing duplicates and maintaining real-time stock levels. The Power BI report will offer interactive dashboards that highlight low stock and usage trends, all pulling directly from your Excel file without manual intervention. I would love to discuss how we can enhance the visual aspects of traceability and make the data entry process even smoother. With regards, Maanie
₹4,150 INR in 7 days
0.0
0.0

Hello, I built a Shopify-to-Odoo connector that keeps stock and order records matched between two systems, so traceability by batch and time is familiar ground. In Excel I'll use a VBA entry form, since it can stamp a unique ID, operator and time on every movement and block duplicates before they're saved. I'll add an expiry date to each lot so the Exceptions page can flag expired stock alongside negative balances. Power BI will read the same workbook from OneDrive, so refresh needs no exports. Every transaction ID links to its batch and order, so any movement is two clicks from the summary. A small check page will confirm Excel and Power BI totals match after each refresh. You'll get the workbook, the .pbix and a recorded hand-off your team can follow on their own. Amul
₹3,999 INR in 3 days
0.0
0.0

Hi, Your traceability workflow maps directly onto something I build and use daily: Excel/VBA tools with Power BI on top. Here is how I would deliver it: Excel workbook — a data-entry form (item code, description, batch/lot, quantity, operator, timestamp) that appends every transaction to a protected transaction log. VBA blocks duplicate IDs, validates quantities, and stock levels are recalculated by Power Query on refresh — no fragile manual formulas. Power BI report (.pbix) with four pages: Current Inventory (stock on hand + low-stock trend lines), Product Usage, Order History (drill from summary down to individual transactions), and Exceptions (negative stock and expired lots flagged in red). A short hand-off video + one-page guide so your team can add new SKUs, refresh data, and publish the reports without outside help. Every entry is time-stamped, so any item is traceable within two clicks in Power BI; stock variance between Excel and Power BI stays within one unit after refresh because both read the same transaction log. I work in clear steps and deliver fully documented files. Happy to show a quick demo of the entry form before you decide. Free sample before you decide: I can send you a working mini-demo — the entry form with duplicate-ID blocking plus one Power BI page (current inventory + one trend chart) — built on dummy warehouse data, within 24 hours of you replying to this bid. If it doesn't look professional, hire someone else. Best regards, Longfei
₹7,000 INR in 5 days
0.0
0.0

Hi, the reliable way to build this is a transaction ledger: stock is calculated from movements, while every receipt or issue keeps its item, lot, operator and timestamp. That avoids stock figures being overwritten without a history. I’m Ahmed, an engineering-trained FP&A consultant and business-software developer. My background includes manufacturing, warehouses, multi-branch retail and SAP ERP implementation governance, so traceability and operational controls are central to my work. I’ll build a validated Excel entry form with unique movement IDs, protected calculations and duplicate/negative-stock checks. Power Query will feed an item/lot/date model into four Power BI pages: Current Inventory, Product Usage, Order History and Exceptions. Summary figures will drill through to source movements, with low-stock and expiry flags. I’ll reconcile Excel and Power BI after refresh and test repeated submissions and new SKUs. Delivery includes the workbook, PBIX and a refresh/setup guide in 8 days for INR 18,000. This is above the listed range because the scope includes both automated capture and a four-page reporting system. No paid add-ins are needed; automatic scheduled sharing depends on your existing Power BI licensing and storage setup. Ahmed
₹18,000 INR in 8 days
0.0
0.0

We recently completed a similar warehouse tracking solution and can efficiently create a clean, reliable system for your needs. The focus on complete traceability and orderliness aligns perfectly with my expertise in Excel and Power BI. With extensive experience in developing automated data capture forms in Excel, I can implement Power Query or VBA to streamline your workflow, ensuring real-time stock updates and preventing duplicate entries. The Power BI dashboards will provide interactive visual cues for low stock and comprehensive order history, allowing your team to navigate through data seamlessly. I would love to explore your project further and discuss how to optimize your data entry and visualization processes. Best Regards, AlexanderWC
₹9,400 INR in 7 days
0.0
0.0

Hi! Excel + Power Query + Power BI is exactly the stack I work in, and with traceability projects, one thing decides success: the data model. Most warehouse dashboards fail not because of visuals, but because stock is calculated from a flat sheet and drifts after a few refreshes. How I'd build it: → Excel as the single entry point: one transactions table (item code, description, batch/lot, qty in/out, operator, time stamp) with an entry form, dropdowns, and validation that blocks duplicate IDs. Formulas locked, real-time stock on hand per item and lot. → Power Query to append new transactions and clean types. I'd keep VBA to a minimum so the file works on any Microsoft 365 machine without macro warnings. → Power BI: a proper star schema (Transactions fact + Items, Lots, Operators, Date dimensions) and DAX measures for stock on hand, usage over time and low-stock thresholds. That's what keeps the Excel vs. Power BI variance at zero, not just within one unit. → The 4 pages you listed: Current Inventory with low-stock flags, Product Usage trends, Order History with drill-through from summary to a single transaction in 2 clicks, and Exceptions (negative stock, expired lots) → Hand-off: a short written guide plus a screen recording covering refresh, adding SKUs and publishing Standard Microsoft 365 and free Power BI Desktop only, no paid add-ins. Roughly how many SKUs and movements per day do you have, and will the Excel file live on OneDrive/SharePoint or a local drive? The second one matters for automatic refresh in Power BI Service.
₹12,000 INR in 5 days
0.0
0.0

Good evening, I hope you're doing well! Thank you for sharing this project. From the description, you need a spreadsheet for entering warehouse data that feeds a Power BI report with views for stock, usage, orders and exceptions. I have experience with data modeling and databases, and that's what makes the biggest difference in a report like this. When the data is well organized from the spreadsheet onward, the report stays reliable and easy to maintain as the warehouse grows. Before starting, I'd like to understand a few things. How many items and how many records per month do you expect? Who will be filling in the spreadsheet? And what counts as an exception for you, for example stock below the minimum level or a mismatch in a count? You'll receive the spreadsheet, the Power BI file and a simple guide on how to refresh the data. I prefer to keep our communication through messages here on the platform, so everything stays on record and I can reply quickly. Thank you for your time, and I'm happy to help! Tuany Fortunato
₹10,900 INR in 7 days
0.0
0.0

Mumbai, India
Member since Oct 19, 2026
₹750-1250 INR / hour
$10-30 USD
$30-250 USD
₹1500-12500 INR
$250-750 USD
$1500-3000 USD
£10-15 GBP / hour
₹1500-12500 INR
$250-750 USD
₹37500-75000 INR
$10-30 USD
$1500-3000 USD
$100-125 USD / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
₹37500-75000 INR
$25-50 USD / hour
$30-250 USD
₹1500-12500 INR
₹1500-12500 INR