Complete the Allocation overview worksheet

The 1-303 Not-for-profit dimension allocation worksheet summary worksheet is designed to assist in managing your fund balances to implement fund reporting in the financial statements. You can set automated allocation methods to easily allocate your trial balance accounts to the appropriate funds and identify any unallocated balances.

Before you start, ensure you have implemented fund reporting in your engagement.

To complete the 1-303 Not-for-profit dimension Allocation worksheet summary:

  1. From the drop-down, select the dimension category that contains the dimensions you want to allocate your account balances to.

    Not-for-profit dimension Allocation worksheet summary.

  2. Select Populate table.

  3. In the confirmation dialog, select Continue.

  4. Select Create worksheet to create your allocation worksheet.

  5. In the worksheet, notice you can select to either automatically or manually allocate your balances in the Settings tab. Select Automated to select your allocation methods and automatically calculate the correct values for your financial groups.

    Note that if you select Manual, the Allocation methods tab does not display and you must manually enter the correct values in the Allocation worksheet tab.

    1-304 Not-for-profit dimension allocation worksheet.

  6. In the Allocation methods tab set your allocation methods from the pre-defined list. You can use the plus and minus buttons to the right of the table to add and delete methods.

    1-304 Not-for-profit domension allocation worksheet.

  7. For each method:

    1. Enter the Method name in the corresponding column.

    2. Select the Method type from the drop-down.

    3. In the columns for each dimension, enter the correct value for each dimension. For example, if you select the # of employees method, indicate the number of employees associated with each dimension. The values you enter are used when calculating the percentage breakdown to allocate your balances.

    1-304 Not-for-profit dimension allocation worksheet.

  8. Once you have finished setting your methods, select the Allocation worksheet tab.

  9. For each financial group, select the allocation method you want to use from the drop-down. Note that any unallocated balances are indicated in the Unallocated column.

    Allocation method.

  10. After you select an allocation method for each group, select Post adjustment at the top right of the worksheet.

    You can view the details of the adjustment on the Adjustments page.

After you complete the allocation worksheet, you can update your financial statements to implement fund reporting. To learn more, see Modify dynamic tables in the financial statements.