What it is
Multi-year pledges are discounted to present value under the entity’s policy, with an allowance for uncollectible amounts. The schedule works installment by installment.
The workbook discounts outstanding amounts at the rate you enter, ages them past due, applies allowance rates by bucket, summarizes maturity within one year, one to five years and over five years, and ties to the ledger.
When to use it
- Nonprofits with multi-year pledges and campaigns.
- Auditing contributions receivable.
- Preparing the contributions receivable note.
What’s inside
- Pledges tab by installment
- Summary tab with net receivable, maturity and tie-out
- Aging and allowance rate inputs
- Legend tab
Standard cited
This template follows ASC 958-605 / AU-C 540. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use. See AU-C 540 explained.
Questions
Which discount rate should I use?
The one your policy requires. The workbook applies one rate to all rows, so run it by year of origination if your policy uses the rate in effect at the promise date.
Are allowance rates provided?
No. They are your inputs, supported by collection history.
Related templates
- Nonprofit Contributions and Grants Audit Program
- Nonprofit Grant and Contribution Conditions Tracker
- Accounts Receivable Aging and Allowance Workpaper
- Disclosure Checklist: Not-for-Profit Entities (ASC 958)
Last updated 11/06/2026. All free templates.