Inventory Tracker Transaction Log

Job ID: 38316243

Budget: ₹600 – ₹1,800 INR

As a business owner, I'm in need of someone skilled in xl design (vba,macros,developer options,formulas must known, data visualization and possibly proficient in using business software like full knowledge with MS 365 or Google Sheets. I want to create tracking sheets which cover diverse aspects of my business operations. Each of these sheets serve distinct purposes:
-Invoice entry sheet
- IssuesEntry Sheet
- Finished Sheet Should Include :
- A Summary of all sheets
- A Dashboard with graphic Transaction Log
- GANTT Chart

Beyond the design, I want the sheets to generate detailed summary reports such as: invoice summaries by date or supplier, consumption summaries by product or department, diesel purchase and consumption summaries by date or location, an overall financial summary, and a customizable summary report.

I'm looking for a freelancer with strong attention to detail, a background in data management, business operations and a proficiency in visual data representation.