Back to brokers & apps


Macquarie is a leading provider of financial, advisory, investment and funds management services in Australia.

How we work together

Sharesight leverages Macquarie to provide Cash Management Accounts (CMA) for Sharesight Professional partners, allowing them to track their clients’ cash balances alongside their listed investments.

Read the official partnership announcement:
Sharesight Pro Integrates with Macquarie Cash Management Accounts

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:

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.

add a macquarie cash account

2 Click to add a connection

add a macquarie cash account - 2

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 notification b) Review the details c) Click Approve

If you’re not registered for Macquarie Authenticator: a) You’ll receive a one-time SMS code on your registered mobile number. Enter the secure code

Click Submit

Copy and paste the Authentication Code and Password displayed in Macquarie Adviser Online into Sharesight to authorise the ESI data feeds

ESI access codes expire one year from the date they are created. Once expired, any data sharing under these credentials will cease. Macquarie recommends updating your ESI access code with Sharesight before it expires.

If you require further assistance with accessing your ESI credentials please refer to the Macquarie Help Page here or contact Macquarie

4 Once entered, click to create the integration.

add a macquarie cash account - 3

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.

add a macquarie cash account - 5

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.

add a macquarie cash account - 6

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.

add a macquarie cash account - 7

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.

add a macquarie cash account - 8

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.

add a macquarie cash account - 9

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.