Over / Under Report

This report lists budgeted versus actual visits, hours, and revenue for Contracts and Installment Plans.This report must be filtered by customer and additionally by a customer's contract:

mceclip0__22_.png

The information in the table will be divided into three sections with columns in each:

Contract Services

  • Service - the line item on the Contract/Installment Plan
  • Budgeted Visits – quantity or visits on the Contract/Installment Plan
  • Actual Visits – completed visits that were billed to the Contract/Installment Plan
  • Budgeted Hours – total budgeted hours for the Contract/Installment Plan
  • Actual Hours – the actual recorded time spent on the visits billed to the Contract/Installment Plan
  • Budgeted Contract Revenue – the total projected revenue for each month of the Contract/Installment Plan
  • Actual Contract Revenue – sum of yearly invoiced amount for Contract/Installment Plan invoices
  • Non-Contract Revenue – sum of non-contract line items on Contract/Installment Plan invoices

Earned Income

  • Contract Value – shows the invoice amount for the month for the Contract/Installment Plan (Does not include added Products)
  • Contract Earned – originates from the service rate or added products to an invoice on the Job (regardless of the Contract/Installment Plan amount)
  • Over / Under – compares the difference between the rate applied for a visit versus the rate applied to a Contract/Installment Plan
  • Non Contract Earned –the rate for the same service not completed under the Contract/Installment Plan
  • Total Earned – combines the Contract Earned and Non Contract Earned columns
  • Contract Payments – This field shows the Contract/Installment Plan payment amount and the month it was was recorded in the system. It’s possible to divide this payment and apply portions of it to multiple months, but only the original contract payment amount appears in this field, under the month when it’s recorded. This is the only field that includes any tax paid.

Service Details

  • Service - the Service completed for the client
  • Date - the date the Service was completed
  • Resource - the Resource assigned to the Job
  • Budgeted Hours - the budgeted hours on the Job
  • Actual Hours - the actual hours it took to complete the Job
  • Rate - the rate assigned on the Job
  • Contract - whether or not the Job was assigned to the Contract/Installment Plan on the current filter
Was this article helpful?
0 out of 0 found this helpful

Still looking for your answer? How Can We Help?