Time Tracking & Billing System for Developer Support Hours
Project Title:
Google Sheets / Web App – Time Tracking & Billing System for Developer Support Hours
Project Overview:
I am a consultant managing a US client and an Indian developer.
The Indian developer provides support hours to the US client, and we track work sessions (login/logout) currently sent via WhatsApp. I need a system to log these sessions, automatically calculate total time worked, and generate two separate billing reports:
- Payout for Indian Developer – in INR (₹1200/hr)
- Bill for US Client – in USD ($25/hr)
Core Requirements:
1. Session Logging
- Fields:
- Date
- Start Time
- End Time
- Duration (hrs) – auto-calculated
- Developer Rate (₹) – fixed at ₹1200/hr
- Client Rate ($) – fixed at $25/hr
- Developer Payout (₹) – auto-calculated
- Client Bill ($) – auto-calculated
2. Calculations
- Automatically compute Duration from Start & End time.
- Automatically compute:
- INR payout (Duration × ₹1200)
- USD bill (Duration × $25)
3. Weekly Summary
- Show weekly totalsfor:
- Total hours worked
- Total INR payout (developer)
- Total USD bill (client)
- Automatically group by week
4. Reporting
- Ability to export weekly/monthly reports as PDF:
- Report for Developer (INR payout only)
- Report for Client (USD bill only)
5. Input Methods
- Option A: Directly enter into Google Sheets/Web App form
Deliverables:
- Fully functional Google Sheets system (or small Web App if preferred)
- Weekly Summary dashboard
- PDF export feature
Preferred Skills:
- Google Sheets automation (formulas, scripts, Apps Script)
Applications 1
Current freelance projects in the category Databases & SQL
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 3 hours 16 minutes back ∙ 5 proposals |
Vibe coding through Claude Code
350 USD
Develop a closed web platform for corporate events with personal invitations via unique links and QR codes. After scanning the QR code, the user is directed to a personal invitation page with a welcome message, a greeting by name, a photo and a message from the CEO, a countdown… AI Art, Databases & SQL ∙ 6 hours 25 minutes back ∙ 31 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 10 hours 17 minutes back ∙ 29 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 4 days 10 hours back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 4 days 13 hours back ∙ 19 proposals |
Mukachevo