Time Tracking and Invoicing Integration | Client Billing
Convert tracked hours into invoice line items automatically. GitScrum logs time per task and adds entries to invoices with rates and totals.
9 min read
Connecting time tracking to invoicing eliminates the friction between logging work and billing clients. When developers track time on tasks, that data should flow directly into invoicesβno spreadsheets, no copy-pasting, no lost billable hours.
Time-to-Invoice Workflow
| Step | Action | Result |
|---|---|---|
| 1 | Track time on tasks | Hours logged with context |
| 2 | Review unbilled time | Filter by project, date, team |
| 3 | Create invoice | Add time entries as line items |
| 4 | Send to client | Professional invoice with details |
| 5 | Mark as billed | Prevent duplicate billing |
Tracking Time on Tasks
TIME TRACKING IN GitScrum
βββββββββββββββββββββββββ
LOGGING HOURS ON A TASK:
βββββββββββββββββββββββββββββββββββββ
Task Detail View β Time Tracking Section
βββ Click "Log Time"
βββ Enter hours worked
βββ Select date
βββ Add optional description
βββ Save entry
TIME ENTRY DETAILS:
βββββββββββββββββββββββββββββββββββββ
βββββββββββββββββββββββββββββββββββββββββββββββββββ
β Log Time β
βββββββββββββββββββββββββββββββββββββββββββββββββββ€
β β
β Hours: [2.5 ] β
β Date: [Dec 15, 2024 βΌ] β
β Description: [API integration work ] β
β β
β [Cancel] [Save Entry] β
βββββββββββββββββββββββββββββββββββββββββββββββββββ
WHAT'S CAPTURED:
βββββββββββββββββββββββββββββββββββββ
For each time entry:
βββ Hours (decimal or h:mm)
βββ Date worked
βββ Task reference
βββ Project context
βββ Team member
βββ Description (optional)
βββ Billing status
Viewing Time Reports
TIME TRACKING REPORTS
βββββββββββββββββββββ
FILTERING OPTIONS:
βββββββββββββββββββββββββββββββββββββ
Reports β Time Tracking
βββ Date range: [Last 30 days βΌ]
βββ Project: [All projects βΌ]
βββ Team member: [All members βΌ]
βββ Billing status: [Unbilled βΌ]
βββ [Apply filters]
TIME REPORT VIEW:
βββββββββββββββββββββββββββββββββββββ
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β Time Report - December 2024 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Filter: Acme Corp | All members | Unbilled β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β β
β DATE TASK MEMBER HOURS STATUS β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
β Dec 15 API integration John 2.5 Unbilled β
β Dec 14 Bug fix login Sarah 1.0 Unbilled β
β Dec 14 Dashboard design John 3.0 Unbilled β
β Dec 13 Database migration Mike 4.5 Unbilled β
β Dec 12 Code review Sarah 2.0 Unbilled β
β β
β TOTAL UNBILLED: 13.0 hours β
β β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
Creating Invoices from Time Entries
INVOICE CREATION WORKFLOW
βββββββββββββββββββββββββ
STEP 1: START NEW INVOICE
βββββββββββββββββββββββββββββββββββββ
Invoices β Create Invoice
βββ Select client
βββ Invoice number (auto-generated)
βββ Invoice date
βββ Due date
βββ Payment terms
STEP 2: ADD TIME ENTRIES
βββββββββββββββββββββββββββββββββββββ
In invoice editor:
βββ Click "Add from Time Tracking"
βββ Filter by date range, project, member
βββ Select entries to add
βββ Time converts to line items
βββ Hours Γ Rate = Amount
ADDING TIME TO INVOICE:
βββββββββββββββββββββββββββββββββββββ
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β Add Time Entries β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Project: [Acme Dashboard βΌ] Date: [Dec 1-15 βΌ] β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β β
β β Dec 15 - API integration (John) 2.5h $250.00 β
β β Dec 14 - Bug fix login (Sarah) 1.0h $100.00 β
β β Dec 14 - Dashboard design (John) 3.0h $300.00 β
β β Dec 13 - Database migration (Mike) 4.5h $450.00 β
β β Dec 12 - Code review (Sarah) 2.0h $200.00 β
β β
β Selected: 8.5 hours Total: $850.00 β
β β
β [Cancel] [Add to Invoice] β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
STEP 3: REVIEW LINE ITEMS
βββββββββββββββββββββββββββββββββββββ
Invoice with time entries:
βββ Each entry becomes a line item
βββ Edit descriptions if needed
βββ Adjust rates if required
βββ Add non-time items (expenses, fixed fees)
βββ Review totals
Invoice Preview
COMPLETED INVOICE
βββββββββββββββββ
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β β
β YOUR COMPANY INVOICE #INV-2024-047β
β 123 Tech Street β
β San Francisco, CA Date: Dec 16, 2024 β
β Due: Jan 15, 2025 β
β β
β BILL TO: β
β Acme Corporation β
β 456 Business Ave β
β New York, NY β
β β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β DESCRIPTION QTY RATE AMOUNT β
β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
β API integration work (Dec 15) 2.5 $100 $250.00 β
β Login bug fix (Dec 14) 1.0 $100 $100.00 β
β Dashboard design (Dec 14) 3.0 $100 $300.00 β
β Code review (Dec 12) 2.0 $100 $200.00 β
β β
β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
β Subtotal: $850.00 β
β Tax (0%): $0.00 β
β β
β TOTAL: $850.00 β
β β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Payment Terms: Net 30 β
β Notes: Thank you for your business! β
β β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
Setting Hourly Rates
RATE CONFIGURATION
ββββββββββββββββββ
PROJECT-LEVEL RATES:
βββββββββββββββββββββββββββββββββββββ
Project Settings β Billing
βββ Default hourly rate: $100
βββ Currency: USD
βββ Tax settings
TEAM MEMBER RATES:
βββββββββββββββββββββββββββββββββββββ
Settings β Team β Member Profile
βββ Member hourly rate
βββ Override project default
βββ Effective date
RATE HIERARCHY:
βββββββββββββββββββββββββββββββββββββ
When calculating invoice amounts:
1. Check member-specific rate
β (if not set)
2. Check project rate
β (if not set)
3. Use organization default
EXAMPLE:
βββββββββββββββββββββββββββββββββββββ
Project: Acme Dashboard ($100/hr default)
βββ John (Developer): uses project rate β $100/hr
βββ Sarah (Senior Dev): custom rate β $150/hr
βββ Mike (Contractor): custom rate β $125/hr
Result: Each person's time calculates at their rate
Preventing Duplicate Billing
BILLING STATUS TRACKING
βββββββββββββββββββββββ
TIME ENTRY STATES:
βββββββββββββββββββββββββββββββββββββ
βββββββββββββββββββββββ
β Unbilled β β Available for invoicing
βββββββββββββββββββββββ€
β Invoiced β β Added to invoice (Draft)
βββββββββββββββββββββββ€
β Billed β β Invoice sent to client
βββββββββββββββββββββββ€
β Paid β β Payment received
βββββββββββββββββββββββ
AUTOMATIC STATUS UPDATES:
βββββββββββββββββββββββββββββββββββββ
Time entry logged β Unbilled
Added to invoice draft β Invoiced
Invoice sent β Billed
Payment recorded β Paid
FILTERING BY STATUS:
βββββββββββββββββββββββββββββββββββββ
When adding time to invoice:
βββ Only "Unbilled" entries shown
βββ Already invoiced entries hidden
βββ Prevents accidental duplicate billing
βββ Clear audit trail
VISUAL INDICATORS:
βββββββββββββββββββββββββββββββββββββ
In time reports:
βββ π΅ Unbilled - Available
βββ π‘ Invoiced - In draft invoice
βββ π’ Billed - Sent to client
βββ β Paid - Payment received
Integration with External Systems
EXTERNAL INVOICING TOOLS
ββββββββββββββββββββββββ
EXPORT OPTIONS:
βββββββββββββββββββββββββββββββββββββ
If using external invoicing:
βββ Export time report (CSV/Excel)
βββ Filter by billing status
βββ Import into QuickBooks, Xero, etc.
βββ Mark as billed in GitScrum
ZAPIER/PABBLY INTEGRATION:
βββββββββββββββββββββββββββββββββββββ
Automate with triggers:
βββ New time entry β Add to spreadsheet
βββ Invoice created β Notify accounting
βββ Payment received β Update CRM
βββ 3000+ app connections
API ACCESS:
βββββββββββββββββββββββββββββββββββββ
For custom integrations:
βββ Time entries endpoint
βββ Invoices endpoint
βββ Webhooks for events
βββ Full API documentation
Reporting and Analytics
BILLING ANALYTICS
βββββββββββββββββ
REVENUE DASHBOARD:
βββββββββββββββββββββββββββββββββββββ
βββββββββββββββββββββββββββββββββββββββββββββββββββ
β Billing Overview - Q4 2024 β
βββββββββββββββββββββββββββββββββββββββββββββββββββ€
β β
β Total Hours Logged: 842 β
β Billable Hours: 756 β
β Utilization Rate: 89.8% β
β β
β Invoiced: $72,400 β
β Collected: $65,200 β
β Outstanding: $7,200 β
β β
βββββββββββββββββββββββββββββββββββββββββββββββββββ
BY PROJECT:
βββββββββββββββββββββββββββββββββββββ
βββββββββββββββββββββββββββββββββββββββββββββββββββ
β Project Hours Billed Outstanding β
β βββββββββββββββββββββββββββββββββββββββββββββββ β
β Acme Dashboard 245 $24,500 $2,100 β
β Beta Platform 189 $18,900 $0 β
β Client Portal 322 $29,000 $5,100 β
βββββββββββββββββββββββββββββββββββββββββββββββββββ
BY TEAM MEMBER:
βββββββββββββββββββββββββββββββββββββ
βββββββββββββββββββββββββββββββββββββββββββββββββββ
β Member Hours Rate Revenue β
β βββββββββββββββββββββββββββββββββββββββββββββββ β
β John 312 $100 $31,200 β
β Sarah 278 $150 $41,700 β
β Mike 166 $125 $20,750 β
βββββββββββββββββββββββββββββββββββββββββββββββββββ
Implementation Steps
SETUP GUIDE
βββββββββββ
STEP 1: CONFIGURE RATES
βββββββββββββββββββββββββββββββββββββ
Settings β Billing
βββ Set organization default rate
βββ Configure currency
βββ Set payment terms
βββ Add tax settings if applicable
STEP 2: SET PROJECT RATES
βββββββββββββββββββββββββββββββββββββ
For each client project:
βββ Project Settings β Billing
βββ Set project-specific rate (or use default)
βββ Configure client information
βββ Set invoice prefix
STEP 3: CONFIGURE TEAM RATES
βββββββββββββββββββββββββββββββββββββ
For variable pricing:
βββ Settings β Team β Members
βββ Set individual rates where needed
βββ Document effective dates
βββ Communicate to team
STEP 4: TRAIN THE TEAM
βββββββββββββββββββββββββββββββββββββ
Share with team:
βββ How to log time on tasks
βββ Required description detail
βββ Billing expectations
βββ Non-billable vs billable work
STEP 5: ESTABLISH BILLING WORKFLOW
βββββββββββββββββββββββββββββββββββββ
Define process:
βββ Billing frequency (weekly/monthly)
βββ Review before invoicing
βββ Invoice approval workflow
βββ Payment follow-up