Add a Macquarie Cash Management Account (CMA)

Content also available for tax entities or on our global site.

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:

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. This is a one-time only step (instructions below). 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.

Macquarie CMA- Screenshot Image Template

2 Click to add a connection

Macquarie1

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

Select Send

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

Click Submit

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.

Macquarie2

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’.

Macquarie3

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.

Macquarie4

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.

macquarie_3

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.

macquarie_4

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.

macquarie_5

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.

macquarie_6

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 May 30, 2022 UTC

Try Sharesight today
Track 10 holdings for free.
Sign up for Free