Timesheet & Billing Dashboard
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed, bonus, paid and outstanding amounts with charts.
- Industry
- Legal Services
- Deliverable
- Task Calendar.xlsm
- Built with
- Excel VBA, UserForms, Charts
Before
Hours, bonuses and payouts were tracked in scattered sheets.
After
Role-based logins record hours and the admin dashboard shows billed, bonus, paid and outstanding amounts.
More like this
Related projects
Automated Cashflow & Bank Categorisation
Accounting
Downloads bank and QuickBooks data, classifies every transaction into a ledger using a keyword table and produces a monthly cashflow statement with payroll summary. New vendors…
View project
Survey Completion Dashboard
Housing & Property Surveys
A one-page management dashboard that tracks property survey progress against yearly and monthly targets. Weekly exports from the survey platform are imported with one click and…
View project
Staff Leave & Attendance Manager
Human Resources
Tracks staff attendance and seventeen leave types with yearly allowances. Monthly attendance grids, period and yearly reports and PDF and CSV exports are all generated by…
View project