Compares how much of each job has been completed against how much has been invoiced. Flags underbilled jobs (earned but uncollected cash) and overbilled jobs (invoiced ahead of work done).
Using my Knowify data, run the JobsReport for active jobs within [date range]. For each job, compare PercCompleted to the billing percentage (Invoiced divided by ContractTotal times 100). Flag jobs where billing percentage is more than 15 points behind completion (underbilled) or more than 15 points ahead (overbilled). Show the dollar gap for each.
