Inventory Data Reporting Admin
Budget: $250 – $750 USD
My priority is to keep our inventory numbers accurate and our management team fully informed. Every day raw data arrives from several warehouses in mixed formats; it must be cleaned, consolidated, and turned into a concise report that highlights stock on hand, low-stock alerts, and any discrepancies discovered.
There is no existing SOP or template, so the first step will be to observe the current files I share (Excel sheets, CSV exports from our system), then draft a clear, repeatable workflow we can both follow. Once the workflow is agreed upon, you will run it autonomously, delivering the finished report by 10 a.m. WIB each business day.
Deliverables
• A one-page SOP or checklist that documents the data-to-report process
• A daily inventory report in Excel or Google Sheets, including:
– summary table of total stock by SKU
– highlighted items below reorder level
– notes on any mismatched or missing entries
• A weekly archive folder containing all source files and the compiled reports
Acceptance criteria
• Formulas are transparent—no hidden cells or hard-coded numbers
• All figures reconcile with the raw warehouse data (±0.1 % tolerance)
• Report is consistently delivered before the agreed cut-off time
Preferred tools are Excel, Google Sheets, and, if you like, a lightweight script in Apps Script or Python for faster data cleaning—feel free to suggest improvements as long as the final output remains readable by any team member.
Clear communication, responsibility, and a friendly attitude are essential; I will always reciprocate the same.
There is no existing SOP or template, so the first step will be to observe the current files I share (Excel sheets, CSV exports from our system), then draft a clear, repeatable workflow we can both follow. Once the workflow is agreed upon, you will run it autonomously, delivering the finished report by 10 a.m. WIB each business day.
Deliverables
• A one-page SOP or checklist that documents the data-to-report process
• A daily inventory report in Excel or Google Sheets, including:
– summary table of total stock by SKU
– highlighted items below reorder level
– notes on any mismatched or missing entries
• A weekly archive folder containing all source files and the compiled reports
Acceptance criteria
• Formulas are transparent—no hidden cells or hard-coded numbers
• All figures reconcile with the raw warehouse data (±0.1 % tolerance)
• Report is consistently delivered before the agreed cut-off time
Preferred tools are Excel, Google Sheets, and, if you like, a lightweight script in Apps Script or Python for faster data cleaning—feel free to suggest improvements as long as the final output remains readable by any team member.
Clear communication, responsibility, and a friendly attitude are essential; I will always reciprocate the same.