Cash Accounts now sync transactions with your portfolio
Tracking your trading cash account as part of your Sharesight portfolio has been a highly demanded feature by our users. We released our Cash Account feature in 2018, as well as additional improvements in 2019, and have just released another update that automates the previously manual data entry required to record dividend/distribution payouts in your Cash Account.
You can now elect to have one of your Sharesight Cash Accounts be your nominated trading Cash Account (as long as the Cash Account currency matches your portfolio currency).
Now, you can elect to have the following transactions from your portfolio automatically synced to your Cash Account:
Buy and sell trades.
Payouts (dividends and distributions).
Why track your trading cash account?
A Cash Account helps you monitor the movement of your money (cash flow) into and out of your portfolio, and allows you to see your investable cash at any given moment. This gives you the complete picture of your investments including the value of cash you have on hand that is not fully invested.
For more information on the role of cash in a portfolio, refer to the blog on the topic written earlier.
How to set up a Cash Account in Sharesight
The “Add Cash Account” button is on the Portfolio Overview page. From there you can specify the name and currency of the Cash Account which will be tied to the portfolio (including its tax residency).
After you have added transactions to the account, the balance of the Cash Account will appear at a glance on the Portfolio Overview page.
With Sharesight’s new and improved Cash Account feature, you can now elect to have one of your manual Cash Accounts linked to your portfolio as a trading Cash Account (as long as the Cash Account currency matches your portfolio currency).
To enable this feature, go to your “Settings” -> “Basic details” in your Sharesight portfolio. You have the ability to set the following parameters.
Select the Cash Account to which you want your buy and sell trades to sync with.
Select the Cash Account to which you want the payouts to sync with. In this example, I have selected the same Cash Account to sync both. You can choose to sync them to two separate accounts.
Syncing historical transact to your Cash Account
After you have linked your Cash Account to a portfolio you can then sync historical transactions from your portfolio automatically by clicking on ‘Manage Synced Trades’ when viewing your Cash Account. You can then choose the date to sync trades from automatically.
For example, by selecting a date of 07/04/2010, you can get all transactions after that date to sync with the Cash Account then clicking “Sync all trades”.
You can expect to view the cash records in the nominated Cash Account as below:
Please note that only the dividend payouts that have been confirmed for each holding will appear in the Cash Account here.
Cash Account notes
The value of your Cash Account is included when calculating your portfolio’s value, but does not impact the percentage return figure.
You can only use this feature with Sharesight’s built-in Cash Account feature. Due to the way Xero connected cash accounts and Macquarie cash accounts push data into Sharesight automatically, these accounts sync automatically already.
Clicking on a Cash Account transaction that has been created from a synced trade will bring up the trade “edit” form. Cash Account transactions will update automatically when the trade is edited. As these transactions are linked, it is not possible to edit the cash transaction separately from the underlying trade.
The Cash Account’s currency has to match the currency of your portfolio.
Updating a linked payout will result in an update to the Cash transaction value.
Deleting a linked payout will delete the corresponding linked cash transaction.
If the Payout cash account is the same as the Trade cash account then the ‘Manage Synced Trades’ label on the cash account screen will read ‘Managed Synced Trades & Payouts’.
If the Payout cash account is the same as the Trade cash account then the ‘Sync all trades’ button on the Manage Synced Trades modal will read ‘Sync all trades & payouts’.
If the Payout cash account is not the same as the Trade cash account then the existing ‘Manual Synced Trades’ will read ‘Manage Synced Payouts’.
If the Payout cash account is not the same as the Trade cash account then the ‘Sync all trades’ button on the Manage Synced Trades modal will read ‘Sync all payouts’.
Deleting the payout cash account should delete all the corresponding cash transactions and remove the link to each payout.
If a payout has been reinvested then it will not be linked to a cash transaction.
Net dividend amount for FX payouts will be calculated using the exchange rates at the time of the payout.
Upgrade today to track your cash
Sharesight’s Cash Accounts are a premium feature available only on Sharesight Investor and Expert plans. Upgrade your Sharesight plan to add a Cash Account to your portfolio and get the full picture of your investment portfolio today.