Entering Payment on Estimate

We are a company that is paid on estimate and I am trying to figure out how we enter actual revenue vs. cash receipts.  We currently bill the cash receipts as is and in excel create a spreadsheet to identify what we have actually made and what is still owed/overpaid.  Suggestions?