all labs
Module 05 · Payroll Support and Bank Reconciliation
BrightPath Month-End Audit and Reconciliation Lab
It is month-end close at BrightPath. You must verify technician hours against clock-in/clock-out times, reconcile the internal ledger to the bank statement, identify an unrecorded bank service fee and a deposit in transit, then document the audit trail for your supervisor.
60 minIntermediate 3 outcomes 6 steps · 3 checkpoints
lab progress0/9 · 0%
AI Tutor
Stuck or unsure? Ask about any step, concept, or checkpoint in this lab. Your conversation is saved to your account.
No questions yet. Try one of the starters below.
Check my work
Not sure if you're doing it right? Paste what you've written or done so far and get instant feedback scored against this lab's rubric.
Dataset
brightpath_financial_audit.csv
Combined timesheet and bank reconciliation rows for BrightPath's month-end close, in decimal time.
Clock times are in decimal hours (e.g. 16.5 = 4:30 PM). One technician over-reported hours.
| Row_Type(string) | Reference(string) | Clock_In(number) | Clock_Out(number) | Reported_Hours(number) | Internal_Ledger_Amt(number) | Bank_Statement_Amt(number) |
|---|---|---|---|---|---|---|
| Timesheet | Technician A - Smith Account | 8 | 16 | 8 | 0 | 0 |
| Timesheet | Technician B - Smith Account | 9 | 15.5 | 8.5 | 0 | 0 |
| Timesheet | Technician C - Chen Property | 7.5 | 16 | 8.5 | 0 | 0 |
| Bank | Customer_Deposits | 0 | 0 | 0 | 4820 | 4820 |
| Bank | Bank_Service_Fee | 0 | 0 | 0 | 0 | 35 |
| Bank | Deposit_In_Transit | 0 | 0 | 0 | 450 | 0 |