Master Project Management and Accounting Sheet Enhancement Expert Needed for Small Engineering Company

Job ID: 39297975

Budget: $30 – $250 USD

I'm looking for a high-level accountant with a strong proficiency in Google Sheets. The objective is to enhance my master accounting/project management sheet to provide real-time information. Real time information is needed on yearly/monthly sales and active projects.

Key Requirements:
- Expertise in Formulas and Calculations: The ideal candidate should be able to manipulate complex formulas to ensure accurate calculations and projections.
- Data Visualization: I need someone who can create clear and insightful charts and graphs, as well as well-structured dashboards and effective conditional formatting.
- Automation and Scripts: The project will require the implementation of scripts to automate repetitive tasks and streamline the sheet's functionality.

Accounting Functions:
- Budget Tracking: Help me keep an eye on my spending versus the planned budget.
- Expense Categorization: I need assistance in sorting expenses into appropriate categories for better understanding and tracking.
- Financial Forecasting: Use historical data to predict future financial outcomes.

Ideal Skills:
- Advanced Google Sheets Proficiency: Ability to use advanced features of Google Sheets.
- High-Level Accounting Expertise: Understands complex accounting principles and practices.
- Strong Data Visualization Skills: Can create compelling visual representations of data.
- Proficient in Automation and Scripting: Experience in using scripts to automate tasks in Google Sheets.