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.
- Go to theSpecial Allocationsworksheet and enter the special allocation codes and descriptions.
- On theControlworksheet, selectSetup Codesfor theSpec Allocationsstatus.
- Go back to theSpecial Allocationsworksheet and selectSetup Codes, then go through the prompts. This step applies formatting properties to the cells.
- 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.
- On theControlworksheet, selectAudit Codesfor theSpec Allocationsstatus.
- Go back to theSpecial Allocationsworksheet, and selectAudit Codes, then go through the prompts. This step confirms that special allocation codes meet system requirements.
- If no terminal errors are encountered, the worksheet process control option is automatically set toCopy Partnersback on theControlworksheet.
- Next copy the partner names and numbers from thePartner Informationworksheet to theSpecial Allocationsworksheet.
- 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..
- On theSpecial Allocationsworksheet, selectCopy 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.
- If the Special Allocations DIF file is successfully completed, set the Spec Allocations process control drop list on the Control worksheet to theCompletedoption. This prevents the audit process for the worksheet if the Make DIF button is inadvertently clicked.
Related Content
-
About partner bridge
Format:
Article
