PORTFOLIO PROJECT USING SYNTHETIC DATA
Billing Exceptions Audit
In development
A synthetic billing review that compares expected charges with actual billing, flags duplicates and missing records, and presents discrepancies in a Google Sheets review queue.
SQL / Google Sheets
Business Question
Which billed charges differ from expected charges, and which exceptions need operational review?
Data and Scope
Synthetic expected-charge and actual-billing records. No real account or billing information.
Validation
Planned evidence: verify join coverage, investigate missing records, test duplicate keys, and reconcile charge totals before marking an exception resolved.
Investigation log template · populate with actual checks and resolutions
Issue
How I checked it
How I handled it
Duplicate
Add the key, query, and affected records.
Add the decision and audit trail.
Missing value
Add completeness checks and source review.
Add the recovery or exclusion rationale.
Reconciliation discrepancy
Add source-to-output count and amount checks.
Add the root cause and resolution.
Workflow
Planned workflow: join expected and actual charges, detect duplicate and missing records, calculate variances, and route exceptions to a Google Sheets review queue.
Documentation
Planned documentation. Supporting files will appear when the project work is ready.
Data dictionary
KPI definitions
Business requirements
Source notes
Query notes
Assumptions and limitations
Refresh procedure