Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Local governments

Estimates Review

This workbook can be used to document the accounting estimates, evaluate the degree of measurement uncertainty, select estimates for restropective review, and document the performance of the retrospective review.

Entering Data

This workbook accommodates five estimates. Multiple workbooks can be used to accommodate additional items. The Description "fields" on the Estimates worksheet and the Retrospective Review Procedures "fields" on the Retrospective Review worksheet are textboxes, and as such, are designed for easier text input than traditional Excel worksheet cells. For further information concerning text box functionality, see the section “General Workpaper Functionality and Tips for Entering Data”.
Certain areas (rows) of the worksheets will hide or unhide depending on your radio button responses (such as high/moderate/low or yes/no) to the visible questions and the completion of textboxes and input areas. A red border around an individual cell or textbox indicates that data is missing from the bordered area.
When changing a response to a radio button (such as from “moderate” to “low” or “yes” to “no”, all following questions for that series of questions are reset to an unanswered status. If a particular estimate previously selected for retrospective review on the Estimates worksheet is no longer selected for retrospective review due to a change in the response of another question, any retrospective review procedures described on the Retrospective Review worksheet for that item will be deleted unless the item is reselected for retrospective review on the Estimates worksheet before switching to the Retrospective Review worksheet.