all labs
Module 01 · Welcome to Introduction to Bookkeeping
Performing a Financial Integrity Audit for BrightPath Home Services
It is your first day as a Billing Specialist at BrightPath Home Services. The outgoing clerk left behind a messy export containing technician timesheets and the master customer list. Before anything can be migrated to QuickBooks Online, you must verify the math, remove duplicate customers, and handle a $50 overcharge dispute on the Smith Account.
45 minBeginner 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_audit_data.csv
Mixed timesheet and customer records exported from BrightPath's legacy system, including one math error and one duplicate customer.
Technician B's Total_Reported is intentionally wrong, and Smith Account appears twice.
| Record_Type(string) | Entity_Name(string) | Hours_Worked(number) | Hourly_Rate(number) | Total_Reported(number) |
|---|---|---|---|---|
| Timesheet | Technician A | 40 | 22 | 880 |
| Timesheet | Technician B | 40 | 9 | 320 |
| Timesheet | Technician C | 35 | 20 | 700 |
| Customer | Smith Account | 0 | 0 | 450 |
| Customer | Alvarez Residence | 0 | 0 | 275 |
| Customer | Smith Account | 0 | 0 | 450 |
| Customer | Chen Property Group | 0 | 0 | 1200 |