Task Codes per Matter: SUMIFS and a Cross-Tab
This lesson is part of the course
In this lesson
You turn fourteen time entries into a matter × task-code grid with one copyable SUMIFS, measure the share of document work and find each matter's effective hourly rate.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Time Entries: 6-Minute Increments and Time-Keeper Rates Locked
- Task Codes per Matter: SUMIFS and a Cross-Tab Locked
- Write-Downs, Write-Offs and Realisation Rates Locked
- Comparing Fee Arrangements: Hourly, Blended, Fixed, Capped and Success Fees Locked
- Contingency Fees by Recovery Band and the Costs-First Rule Locked
- Matter Budget vs Actual: Burn Rate, Forecast and Overrun Locked
- Client Trust Ledgers: Running Balances and the Overdraft Check Locked
- Three-Way Reconciliation: Bank, Journal and Client Ledgers Locked