Complete the Special Allocations Worksheet

This worksheet includes partner identification (names and numbers), special allocations codes and descriptions, and allocation ratios and dollar amounts applicable to each partner.
The worksheet is populated in stages, each of which must be completed in sequence.
  1. Go to the
    Special Allocations
    worksheet and enter the special allocation codes and descriptions.
    1. On the
      Control
      worksheet, select
      Setup Codes
      for the
      Spec Allocations
      status.
    2. Go back to the
      Special Allocations
      worksheet and select
      Setup Codes
      , then go through the prompts. This step applies formatting properties to the cells.
    3. Complete entry of special allocation codes and descriptions. If you copy and paste this information from another spreadsheet, make sure to use the paste special values function.
  2. On the
    Control
    worksheet, select
    Audit Codes
    for the
    Spec Allocations
    status.
  3. Go back to the
    Special Allocations
    worksheet, and select
    Audit Codes
    , then go through the prompts. This step confirms that special allocation codes meet system requirements.
  4. If no terminal errors are encountered, the worksheet process control option is automatically set to
    Copy Partners
    back on the
    Control
    worksheet.
  5. Next copy the partner names and numbers from the
    Partner Information
    worksheet to the
    Special Allocations
    worksheet.
  6. Enter the partner allocation ratios and dollar amounts either manually or copy the ratio and dollar amounts from an Excel source and paste the copied data into the cells on the worksheet using the Paste Special > Values function..
  7. On the
    Special Allocations
    worksheet, select
    Copy Partners
    , then go through the prompts. This is the only method of completing this information and worksheet. Other methods of bringing this information in isn't supported.
  8. If the Special Allocations DIF file is successfully completed, set the Spec Allocations process control drop list on the Control worksheet to the
    Completed
    option. This prevents the audit process for the worksheet if the Make DIF button is inadvertently clicked.

Related Content

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close