Timesheet Tracking and Payroll Calculation System

Single-file simulated SQL analytics app with approval workflow, dashboard charts, CSV export, and date-range filtering.

Start Date

End Date

Department

Project

Status

Role

Date filters apply to all queries. Fixed SQL windows such as “last 30 days” and “last 90 days” are intersected with the selected date range.

Executive Summary

Analytics Dashboard

Timesheet Entry

Recent / Filtered Timesheets

Approval Workflow

Manager can approve or reject pending timesheets. Approved timesheets are used in the Project Budget Tracking query.

Export Payroll Report

SQL Query Definitions