Reformat Inventory Excel Sheet
Budget / Salary₹1,500–12,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I will send you two files:
1. My current master inventory Excel with multiple excel workbooks in it.
2. A template generated by the billing software that shows the required column order and formatting.
Your job is to rebuild the master sheet inside a fresh workbook so it mirrors the template’s structure of the billing software, while still preserving every piece of inventory information I have. That means copying all columns - even those the software doesn’t strictly demand— into the matching positions shown in the example.
Before pasting anything, please run a quick sense-check on the following critical areas:
• Item names and codes (spelling, extra spaces)
• Prices and any tax-related figures
• Stock quantities and their units
If you spot blanks, odd characters, or figures that don’t look right, just flag the row and ping me so I can confirm or correct it; don’t invent placeholders or delete data.
Deliverable: One clean, import-ready .xlsx file that drops straight into the billing system without further tweaks, along with a short note listing any rows you flagged for clarification.
No macros or fancy add-ins are necessary— standard Excel tools are fine, though you’re welcome to use formulas for speedy checks. Let me know if anything in the template is unclear and I’ll clarify right away.
1. My current master inventory Excel with multiple excel workbooks in it.
2. A template generated by the billing software that shows the required column order and formatting.
Your job is to rebuild the master sheet inside a fresh workbook so it mirrors the template’s structure of the billing software, while still preserving every piece of inventory information I have. That means copying all columns - even those the software doesn’t strictly demand— into the matching positions shown in the example.
Before pasting anything, please run a quick sense-check on the following critical areas:
• Item names and codes (spelling, extra spaces)
• Prices and any tax-related figures
• Stock quantities and their units
If you spot blanks, odd characters, or figures that don’t look right, just flag the row and ping me so I can confirm or correct it; don’t invent placeholders or delete data.
Deliverable: One clean, import-ready .xlsx file that drops straight into the billing system without further tweaks, along with a short note listing any rows you flagged for clarification.
No macros or fancy add-ins are necessary— standard Excel tools are fine, though you’re welcome to use formulas for speedy checks. Let me know if anything in the template is unclear and I’ll clarify right away.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.