Blog | Product features | News

Track cash & fixed interest investments via Xero

by Doug Morris, CEO, Sharesight | Aug 13th 2014

We’re happy to announce that Sharesight now integrates with all bank accounts that are available using Xero bank feeds! This means that within Sharesight you can track your cash balances and display reconciled buys, sells, and dividends automatically.

Xero Cash for Sharesight

We’ve been on a cash kick lately. After all, last time we checked, cash was still considered king. Recently we announced that Sharesight integrates with Macquarie Cash Management Accounts (CMAs) so that Sharesight's professional clients can properly reconcile and track their clients’ cash positions. Now the same is true for any bank or broker-linked cash account for all Sharesight clients using Xero.

We receive a lot of feedback regarding cash handling. Cash means different things to different investors. While we could’ve gone down the road of building a Xero-lite and offered some basic reconciliation and double-entry accounting, it was clear that letting Xero do what they do brilliantly was the smarter move.

So what does this mean for your Sharesight portfolios?

Ultimately, when you add a cash account to Sharesight via Xero, we’ll pull back your cash balance and the transactional details at the end of each day. So if you set up a bank feed in Xero to your broker’s cash account (e.g. the Commsec CDIA account), this means that your cash position, including reconciled buys, sells, and dividends will be displayed automatically throughout Sharesight and on our reports.

Sharesight & Xero Cash

To get started, add a cash account from our new Add Holding dropdown menu.

Add Cash Account

Next you’ll want to connect to Xero. You’ll be asked to login to Xero directly on Sharesight if you haven’t done so already for sending your portfolio data to Xero. You’ll be prompted to select which Xero organisation you want to use:

Xero Organization

And to pick which bank account to connect to. Just give the account a name, which will be used across Sharesight:

Select Bank Account

Once the account is created, Sharesight will pull in the historical bank transactions and the current balance. You can search for particular transactions and export it into Excel or PDF. The cash data on Sharesight will now automatically update itself each day with no manual intervention required. On the Portfolio Overview page, your cash balance will be displayed. Clicking into this holding will show you the latest transactions.

Sharesight Cash Accounts

Clients of Sharesight and Xero now have a full, 360 degree solution. Trade and dividend data collected by Sharesight is pushed, in real time, to Xero for accounting purposes. While cash data is now pushed from Xero back into Sharesight for portfolio tracking purposes.

What’s more, we’ve created an Unsettled Trades Adjustment option. If the cash account is used as the trade settlement account, using this feature will automatically offset for the T+3 rule. In other words, Sharesight will temporarily adjust your cash balance until the cash is debited/credited for the trade so that an accurate cash balance is always maintained. If you don’t use the cash as the settlement account, you can switch this feature off within the Portfolio Settings tab.

The age of siloed financial data and client ownership is over

We talk a lot about an ecosystem of connected, best-of-breed apps and about encouraging our clients to try them on. Let Sharesight do what we do best and let Xero do what they do best. We’ll handle the connection behind the scenes, and all you have to do is have two tabs open in your browser. We think you’re up to the challenge.


Top20 NZX monthly Oct23
Market insights

Top 20 NZX trades by Sharesight users – September 2023

by Stephanie Stefanovic | Sep 27th 2023

Welcome to the September 2023 edition of Sharesight’s monthly NZX trading snapshot, where we look at the top 20 trades Sharesight users made on the NZX.

Get ausbiz market insights in Sharesight
Product features

Get ausbiz market insights in Sharesight

by Stephanie Stefanovic | Sep 27th 2023

Stay on top of your ASX investments with convenient access to the ausbiz news feed, right in your Sharesight portfolio.

Track Webull trades with Sharesight
Product features

Track your Webull trades with Sharesight

by Stephanie Stefanovic | Sep 26th 2023

If you trade via Webull, you can automatically import your trading data to Sharesight, making it easy to track the performance of your investment portfolio.