Project goal:Automate the financial tracking and reporting process for a digital agency
What was done:
Set up automatic data export from the TimeDoctor tracker to Google Sheets every morning.
Developed a Google Sheets system with lists of staff, projects, hourly wages, and fixed salaries.
Automated daily cost and revenue calculations using Google Apps Script, with dedicated tables for employees and clients.
Established daily Telegram reports for employees and clients, summarizing time worked and financial data for the day, week, and month, with customization options.
Created a payment tracking spreadsheet with automatic calculations and proper distribution to individual employee and client sheets.
Developed a range of performance and financial reports:
Dashboard for key financial balances
Monthly and weekly summary reports
Detailed reports by employee and project for any selected period
Cross-check report (Revise) to reconcile project and employee metrics
Report identifying missing cost/sell prices
Monthly P&L
Employee productivity report
Achievements:
Achieved full automation of employee task time tracking.
Financial reports for the day, week, and month are calculated automatically each morning, with no manual involvement.
Employees can easily track their hours worked and earnings.
Clients receive daily reports on project hours, costs, and balances.
Errors have been minimized through comprehensive reconciliation reports.
The system provides valuable insights into the agency’s performance, enabling timely management decisions.
