Reconciliation Status
The Reconciliation Status application that possess all of your downloadable interface data within one place. This application offers insight into any issues that might be occurring with account data downloading into Orion or any accounts that are in need of being reviewed. This application also shows when which interfaces are downloading properly. This data is being brought in and allocated on a daily basis by the Orion Reconciliation team.
Important tools within this app are:
- Recon Status Dashboard: This Audit shows the Reconciliation progress for each of your download sources. All reconciliation should be complete by 6:00 AM EST. If you see any interface on this audit that does not show 100% in the Transaction and Position Confirmed Ratio columns after this recon deadline please reach out to the Orion Reconciliation Team via the Contact Us option.
- Accts Not Downloading: This audit displays accounts that are active and hold a value on the Orion platform. However, Orion is not receiving any position files for the account as of the previous business day. Most commonly, these are accounts that you need to cancel. If the account should be downloading into Orion, reach out to both Orion and the custodian immediately for them to review.
- Accts Downloading - On Exclusion Table: This audit shows accounts excluded from reconciliation, but Orion is still receiving files from the custodian. Determine if the accounts should remain on exclusion or if they should be actively downloading into your database.
- Excluded Accounts: This will show a list of all accounts that are being excluded within Orion. Most commonly these will be accounts that have been canceled. However, occasionally there may be new accounts added to this list due to incomplete or missing name files from the custodian.
- Monthly ACR: The Monthly ACR (Asset Comparison Report) displays all accounts actively downloading in your database where Orion did not receive a position file for at least one asset within the account. This audit checks the last business day of the previous month by default. You must compare all results on this report against your custodial month-end values to ensure accurate balances within Orion for billing and statement delivery. Similar to the Accts Not Downloading audit, review the ACR to determine if the account(s) should be downloading onto the Orion platform or if you need to cancel them. To ensure accurate results, do not adjust the date range on the right-hand panel; this feature is primarily used to adjust the report when a holiday or closed-market day lands on the last business day of the previous month. Review the ACR monthly, even if you bill on a quarterly basis so you can stay on to of any accounts that may need attention.
- Placeholder Transaction Audit: The Placeholder Transaction Audit returns a list of placeholder transactions that Orion creates to balance out the daily position files where a custodian did not send the appropriate transactional data. To adjust these placeholders to the correct transaction type, either manually update the transactions yourself or provide the correct transaction data to Orion's SME Data Reconciliation team. Please Note: The custodians will not resend previous transaction files to Orion so you will need to provide the transactions via an export if you would like the placeholders removed.