Excel Cost Sheet Consolidation
Budget / Salary€8–30
TypeFreelance project
LocationRemote
Posted6 hours ago
I need a clean, well-structured Excel workbook that shows our full cost picture at a glance. The main sheet should pull in two data sources—current supplier quotations and our latest internal financial reports—and calculate consolidated figures for each supplier.
Key elements I must see in the file:
• Expenses captured line-by-line, mapped to the appropriate supplier.
• Automatic Profit/Loss computation for every supplier and an overall total.
• Clear supplier-based layout (this is the primary way I want to navigate the data).
Please link all calculations so I can update source numbers without breaking formulas, and use straightforward Excel functions (SUMIFS, INDEX/MATCH or XLOOKUP, pivot tables where helpful). Deliver the finished workbook plus any supporting import sheets you create so I can trace how each figure is produced.
Key elements I must see in the file:
• Expenses captured line-by-line, mapped to the appropriate supplier.
• Automatic Profit/Loss computation for every supplier and an overall total.
• Clear supplier-based layout (this is the primary way I want to navigate the data).
Please link all calculations so I can update source numbers without breaking formulas, and use straightforward Excel functions (SUMIFS, INDEX/MATCH or XLOOKUP, pivot tables where helpful). Deliver the finished workbook plus any supporting import sheets you create so I can trace how each figure is produced.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.