The Fund Payout Report allows users to calculate the grant payout for funds using different payout formulas.
-
Build a custom report.
- The only required field is Funit ID.
- When Funit ID is added to the report, bulk actions, including the Fund Payout Report, appear in the left-side menu.
- When Funit ID is added to the report, bulk actions, including the Fund Payout Report, appear in the left-side menu.
- The only required field is Funit ID.
- Click Bulk Action in the left-side menu.
- Click Fund Payout Report.
- Enter the Fund Payout Report information, and then click Generate Report.
- Calculation Date - The date the Fund Payout Report will be calculated for.
-
Payout Formula - The different formulas that can be used to calculate the grant payout.
- Candid Method - Based on grants made this year divided by assets held at the end of last year.
- One Year Method - This year’s grants divided by this year’s end-of-year assets plus this year’s grants, with the assumption that all money in a DAF at any point of the fiscal year was available for grantmaking.
- 3-Year Averaging of Assets to Last Year (LY) - Grants this year divided by the average value of assets last year, the year before last, and two years ago.
-
5-Year Averaging of Assets to Last Year (LY) - Grants this year divided by the average value of assets from five years ago to last year.
- For 2024, this means grants made in 2024 divided by the average of assets held at year-end in 2019, 2020, 2021, 2022, and 2023.
- For 2024, this means grants made in 2024 divided by the average of assets held at year-end in 2019, 2020, 2021, 2022, and 2023.
The report will populate based on the Fund Payout Report information entered.