Comprehensive Business Tracking Spreadsheet Design
Budget: ₹600 – ₹3,000 INR
As a business owner, I'm in need of someone skilled in spreadsheet design, data visualization and possibly proficient in using business software like MS Excel or Google Sheets. I want to create tracking sheets which cover diverse aspects of my business operations. Each of these sheets serve distinct purposes:
- IRF VS PO Entry Sheet: This will help track several invoice details including the number and date, supplier data, descriptions of product or service, quantities, unit prices, the total amounts as well as the status of payments.
- Consumption Entry Sheet: I need this to record consumption data relevant to my operations.
-Diesel Purchase and Consumption Sheet: Particularly, I manage diesel purchases and consumption. I need this reflected in an easy-to-understand 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.
- IRF VS PO Entry Sheet: This will help track several invoice details including the number and date, supplier data, descriptions of product or service, quantities, unit prices, the total amounts as well as the status of payments.
- Consumption Entry Sheet: I need this to record consumption data relevant to my operations.
-Diesel Purchase and Consumption Sheet: Particularly, I manage diesel purchases and consumption. I need this reflected in an easy-to-understand 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.