Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Nonprofit companies

Conditional Promises to Give

This workbook may be used to summarize conditional promises to give for disclosure in the financial statements and to document audit testwork performed.  

Entering Data

The input worksheet provides columns to document conditional promises to give, certain audit procedures performed for significant conditional promises, and other information necessary for financial statement disclosure. In the top section of the Input worksheet, the “financial statement date” entry is necessary for certain financial statement disclosures. Also, the “threshold [amount] for significant items is over” should be entered for the audit procedure related columns to function properly. See the section “General Workpaper Functionality and Tips for Entering Data” for further information concerning data validation.
In the main input area, the “promise date” and “name of potential donor” are simply data entry areas. The next column, “description of condition”, should be selected from one of the four options. When a cell in this column is entered, a “down arrow” appears to the right of the cell. When the down arrow is selected, the four options will appear. If an entry other than one of the four selections is attempted, a warning box will appear to inform the user of the invalid entry. One of the four options must be selected for the financial statement disclosure information to function properly.  See the section "General Workpaper Functionality and Tips for Entering Data" for further information concerning data validation.  
The next column, “promise amount” is a simply numeric entry that must be greater than $0. Based on the amount entered, the worksheet automatically determines if the promise is a “significant item” based on the “threshold [amount] for significant items is over” cell entry previously made (see above). Depending on the amount of this entry, the cells in the entry row for the next two columns may turn to grey color. If so, these cells should be skipped. If the cell immediately to the right of the promise amount does not have a grey shade, the item is considered a significant amount and the cursor should automatically move to that cell. This column heading, amount and condition agreed to supporting documentation” cell is an audit program step that should be performed for conditional promises to give. This column only allows a “Yes” or “No” response based on the results of the audit results. If the amount and condition were agreed to supporting documentation the related cell in the “exception” column remains grey and is not a valid input cell. However, if the response is “No” the cursor automatically moves to the next column, which cell is now not shaded. In this cell, exception amount should be entered.
If any amount of the conditional promise to give was received from the potential donor (without any consideration provided in return to the potential donor), enter that amount in the column labeled “nonreciprocal amount received from potential donor”. The amount entered in this column must be no greater than the amount of the conditional promise. If the cell is left blank, the workbook assumes the amount is $0. The final column, “is condition substantially met?” must be answered as “Yes” or “No”. If “Yes” is selected, the item is not a conditional promise to give and should be removed from the Input worksheet. Even it is not removed it will not be included in the Financial Statement Information worksheet. A note at the bottom left of the worksheet serves as a warning reminder for such items.
Certain columns of the main input area must be completed for each item for the Financial Statement Information worksheet to work properly. A warning at the top and bottom of the main input area appears if at least one of the necessary columns is empty for a particular item. These warning will disappear when the all necessary columns are completed for all line items that have data entries.  See the section “General Workpaper Functionality and Tips for Entering Data” for further information concerning conditional formatting.

Inserting and Deleting Line Items

Rows should not be added to the Input worksheet. However, excess rows may be deleted.  See the section “General Workpaper Functionality and Tips for Entering Data” for information concerning the tips for and potential effects of inserting and deleting workbook line items.