We are looking for a skilled professional to clean and optimise our Google Sheet that tracks our subscriptions to tools and platforms within the business. The current sheet is filled with the correct data, but we need to create template formulas and make it a coherent and uniform working document. Additionally, we need to optimize the sheet to run more efficiently and provide accurate and up-to-date data.

We would also like to create a more dynamic dashboard that details key insights across our departments spending patters – I’m open to gaining insight on your recommendations here, but the below additional items should be incorporated into the spreadsheet.

1. Total Costs (Current vs. Previous Periods): Showing a comparison against previous periods (monthly, quarterly, annually) helps in understanding trends and forecasting future expenses.

2. Cost Changes (% Change):  Formulas need to correctly calculate the percentage changes based on the relevant time periods.

3. Renewal Dates and Types: For software and subscriptions, knowing when renewals are due and what type of renewal agreements are in place (e.g., monthly, annual) is critical for cash flow planning. Can we integrate a cell highlight formula when an expiry date is approaching?

4. Budget Allocation vs. Actual Spending: Including a comparison of planned budget against actual spending would be useful for tracking financial discipline and the accuracy of financial forecasting.

The ideal candidate should have experience in Google Sheets and be able to follow instructions carefully. This is a small job that should take less than a couple hours of work to complete. The level of expertise we are looking for is intermediate.

Skills required:
– Google Sheets
– Data cleaning
– Data organization
– Data optimization

Hourly Range: $10.00-$45.00

Posted On: January 22, 2024 11:23 UTC
Category: Scripting & Automation
Skills:Google Sheets, JavaScript, Google Docs, Microsoft Excel

Country: United Kingdom

click to apply