Bulk Allocation Upload for Orion Connect

How to Use the Orion Bulk Allocation Upload Template

This guide will walk you through how to properly complete and submit the bulk allocation upload template for Orion. Following these steps will help ensure your allocations are updated accurately and without delays.

Getting Started

Use the attached template to submit allocation updates for multiple accounts at once. You will need to fill out one row per account that you would like updated in Orion.

Step by Step Instructions

1. Enter Client and Account Information

• Client Name:
  Copy and paste the name directly from Orion Connect to ensure accuracy.
  Navigate to:
  Portfolio Audit > Registrations > Client Name
  Use the full client name exactly as shown.
• Account Number:
  Double check that each account number is correct before submitting. Incorrect account numbers will prevent updates.

2. Build the Allocation

• Allocations must total 100 percent.
  • Column S in the template will automatically validate this for you.
  • If the total does not equal 100 percent, the allocation will not be updated.
• Do not include cashin your allocation.
  • Instead, you can:
    • Add SWVXX as a cash equivalent, or
    • Handle cash at the registration level
• If you want the same cash allocation applied across all accounts, you can reach out to Lucas for assistance.

3. Sleeve Ancorato Models Correctly

• Any Ancorato models must be sleeved out individually.
• This is required for the accounts to rebalance properly in Orion.

4. Using Custom Models

• If you have created your own model:
  • Add it to the Model Sheet in the template
  • This ensures the model appears in the dropdown when assigning sleeves

Final Checklist Before Submitting

Before sending your template, confirm the following:

• Client names are copied exactly from Orion
• Account numbers are accurate
• Allocations equal 100 percent
• No cash is included in allocations
• Ancorato models are properly sleeved
• Any custom models are added to the model sheet

Need Help?

If you have any questions or would like help walking through the template, please reach out to Lucas Meyer directly.

This process will help ensure your bulk allocation updates are completed smoothly and without delays.