Add a Macquarie Cash Management Account (CMA)
Note: Macquarie CMA is only available on Sharesight Pro.
There are three ways to track cash investments such as bank accounts, term deposits, fixed interest securities, and broker-linked cash accounts in Sharesight Pro:
- Integrate a Macquarie Cash Management account (see information below)
- Integrate a Xero cash account
- Create and track them manually by using a Custom Holding
Macquarie Cash Management Accounts (CMAs) can be integrated into individual portfolios on Sharesight Pro meaning that an up to date and on-going cash balance will be automatically displayed within Sharesight. Macquarie requires that you establish ESI credentials between your Macquarie account and your Sharesight account. These credentials will need to be renewed every 12 months. Once you’ve connected your ESI credentials, adding additional CMAs to portfolios is a simple, one step process.
Connecting your Macquarie Cash Account
Note: Only the account owner or staff with owner level access can create the connection. All other staff members can only add the account from step 5 onwards.
1 When logged into your Sharesight Pro Dashboard, click the account menu and select the ‘Connections’ option.
2 Click to add a connection
3 Select the Macquarie Cash Account option and enter your ESI credentials. To obtain these, follow the below steps:
Log into Macquarie Adviser Online
Select the user profile icon from the right-hand side of the top menu and select ESI details
Click Generate new code
If you’ve registered for Macquarie Authenticator:a) Open the Macquarie Authenticator push notificationb) Review the detailsc) Click Approve
If you’re not registered for Macquarie Authenticator:a) You’ll receive a one-time SMS code on your registered mobile number. Enterthe secure code
Copy and paste the Authentication Code and Password displayed in MacquarieAdviser Online into Sharesight to authorise the ESI data feeds
ESI access codes expire one year from the date they are created. Onceexpired, any data sharing under these credentials will cease. Macquarierecommends updating your ESI access code with Sharesight before it expires.
If you require further assistance with accessing your ESI credentials pleaserefer to the Macquarie Help Pagehereor contact Macquarie
4 Once entered, click to create the integration.
5 To add your newly created CMA account to your Sharesight portfolio, go to the portfolio you wish to add it to from your Pro dashboard.
6 Click on ‘Add Cash Account’.
7 Click on the Macquarie option.
8 Select the Macquarie account you wish to add and enter the account number and a name to appear in Sharesight. The account number must match the account number of the CMA.
9 Once entered, click create to add the account to your portfolio.
Once added, Sharesight will retrieve your CMA transaction history from Macquarie and display your current balance. This also serves as the cash holding detail page. On this page you can search for cash specific transactions or export the data to Excel or PDF.
Back on the Portfolio Overview page, you’ll now see a new section called Cash Accounts, which includes your CMA. This balance will be automatically updated every day. Clicking into this holding will display the CMA transactional history.
Unsettled Trades Adjustment
If you use the Macquarie CMA account for funding trades, you can also use a feature that will automatically account for any portfolio balance discrepancies due to unsettled trades. Since trades appear in Sharesight in a matter of seconds, but the cash is not debited from the funding account for up to three days (T+3 rule), this feature will automatically offset the value of the newly purchased shares with the appropriate amount of cash.
This unsettled cash balance will then automatically reverse itself after three days. When this is in effect you’ll notice a new line item under the CMA titled Unsettled Trades Adjustment.
To toggle this feature on or off, go to the Settings menu within the portfolio and tick the box next to Calculate Cash Accounts Adjustments.
Adding Subsequent Macquarie CMA Accounts
Once you’ve established your ESI connection with Macquarie you will not need to repeat this step. Adding subsequent CMA accounts can be done by selecting Existing Credentials on the setup page. Simply enter the account number and give the cash holding a name.
Last modified on August 26, 2022 UTC