Skills

Communication VBA Data Cleaning Attention to detail

Job Specifications

A law firm is seeking a freelance application developer with expertise in Excel automation to streamline the process of generating client invoices from Toggl Track exports. The primary objective is to develop a robust Excel template that automates the workflow from importing Toggl Detailed Reports to producing professional, client-ready invoices. The solution should minimize manual intervention, ensuring efficiency and accuracy in invoice creation. The project requires a quick turnaround and clear user guidance to ensure seamless adoption by the team.

Deliverables

Design and build an Excel template that enables easy import of Toggl Track Detailed Report exports (.xlsx format).
Implement automated data cleaning and formatting processes within Excel to prepare time-tracking data for invoicing.
Develop calculations for total hours and billable amounts per project, ensuring accuracy and transparency.
Create a pre-formatted invoice sheet that auto-populates with relevant client and project details.
Integrate a VBA-powered button to refresh calculations, generate invoices, and export them as PDFs.
Provide clear documentation or a concise video walkthrough demonstrating how to use the template and its features.
Ensure the solution is user-friendly and can be operated by non-technical staff.

Requirements

Proven experience in Excel automation, including advanced use of VBA and Power Query.
Strong understanding of data processing, transformation, and reporting within Excel.
Ability to design intuitive, professional invoice templates suitable for legal or professional services.
Experience integrating data from third-party sources (such as Toggl Track) into Excel workflows.
Excellent attention to detail and commitment to delivering error-free outputs.
Strong communication skills for providing clear documentation or video instructions.
Availability to complete the project within 3–5 days, with an estimated workload of 5–7 hours.
Prior experience working with law firms or professional services is a plus.

About Twine

Twine is a leading freelance marketplace connecting top freelancers, consultants, and contractors with companies needing creative and tech expertise. Trusted by Fortune 500 companies and innovative startups alike, Twine enables companies to scale their teams globally.

Our Mission

Twine's mission is to empower creators and businesses to thrive in an AI-driven, freelance-first world.

About the Company

Twine is home to a network of over 750k+ freelance experts and 50k+ clients across 195 countries. We connect talented people with flexible work and help businesses find the perfect expert for any project - big or small. For Businesses & Clients: Tired of endlessly searching for the right talent? We've got you covered. Twine makes it easy to find and hire freelance experts in tech, creative, AI and more. From software developers and graphic designers to animators and content creators. Our global network means you can hire the... Know more