Confirmation Summary

This template is designed to help auditors track positive and negative confirmations for plan receivables and to summarize and evaluate the results of their procedures.  If sampling was used in the confirmation procedures, the template will also project the misstatements relating to the sampled confirmations.
Note:  This template will accommodate up to 1,000 positive confirmations and 1,000 negative confirmations.
The template consists of the following sheets:
  • Confirmation Summary -  This sheet automatically summarizes the results of all confirmation procedures based on detailed information entered into the Positive Confirmations and Negative Confirmations sheets.
  • Misstatement Summary  - Automatically projects misstatements from sampling procedures on positive confirmations based on the dollar value of the sample strata, as entered on this sheet, and the detailed information entered on the Positive Confirmations sheet.
  • Positive Confirmations - Enter the information about the confirmation requests sent, responses received, and the results of the positive confirmation procedures.
  • Negative Confirmations - Enter the information about the confirmation requests sent, any responses received, and the results of the negative confirmation procedures.