all labs
Module 04 · Accounts Receivable, Billing, and Customer Support
Resolving Billing Discrepancies at BrightPath Home Services
A batch of service records is about to be invoiced, but the file contains a duplicate service, a missing hours value that would cause revenue leakage, and a $25 overcharge the Smith Account has already complained about. Clean the batch, calculate the credit memo, and write the customer response.
55 minBeginner 3 outcomes 7 steps · 3 checkpoints
lab progress0/10 · 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_billing_audit.csv
Pre-invoice service batch containing one duplicate service_id, one missing hours value, and one overcharged line.
BP-101 is duplicated, BP-103 is missing hours_logged, BP-105 is overcharged by $25.
| service_id(string) | customer(string) | service(string) | hours_logged(string) | rate(number) |
|---|---|---|---|---|
| BP-101 | Smith Account | AC Tune-Up | 1.5 | 95 |
| BP-101 | Smith Account | AC Tune-Up | 1.5 | 95 |
| BP-102 | Alvarez Residence | Duct Cleaning | 3.0 | 85 |
| BP-103 | Chen Property Group | Thermostat Install | 110 | |
| BP-104 | Okafor Rentals | Water Heater Flush | 2.5 | 85 |
| BP-105 | Smith Account | Filter Change | 1.0 | 120 |