Xero is a market leading online accounting system. Sharesight has partnered with Xero in order to provide a seamless solution between portfolio management and portfolio accounting. Learn more about Xero at www.xero.com.
The Xero Synchronisation feature allows you to connect your portfolio to your Xero account. This allows you to send details of share purchases, sales, and dividends to Xero as draft invoices, which can then approved for inclusion in your financial accounts and used to reconcile against your bank account.
These instructions assume that you have a Xero subscription. To sign up for Xero, please visit www.xero.com.
In your Xero chart of accounts you need to have an account set up for each of the following items:
-Share Market Investments (Asset Account)
-Dividends Received (Revenue Account)
-Imputation Credits (Current Asset Account)
-Brokerage (Expense Account)
-Realised Gains/Losses (Revenue Account)
-Resident Withholding Tax (Current Asset Account)
-Non-Resident Withholding Tax (Current Asset Account)
1. Click settings, then ‘Xero Synchronisation’ for the portfolio that you wish to connect.
2. Click the ‘Connect to Xero’ button. This will direct you to log into you Xero account and authorise access to Sharesight. You’ll be redirected back to Sharesight when you’re finished.
3. Map the following items to the appropriate account from your Xero organisation’s chart of accounts:
Share Market Investments => Current Asset
Dividends => Revenue
Imputation Credits => Current Asset
Brokerage => Expense
Realised Gains / Losses => Revenue
Resident Withholding Tax => Current Asset
Non-Resident Withholding Tax => Current Asset
4. Click the save button.
Once Xero synchronisation is configured, a tick box will appear on the add and edit screens for trades and dividends. To send the trade or dividend record to Xero, simply select the tick box and then click the ‘Save’ button.
Furthermore, all automatically created dividends will be sent to Xero automatically once they reach their paid date (this applies only to dividends that are paid after you configure Xero integration). It is therefore important to ensure that the automatically generated dividends are correct before they reach their paid date. Automatically generated dividends appear in Sharesight when they reach their ‘action date’, this is typically a few weeks before the dividend is due to be paid. Enabling portfolio alerts will ensure that you are notified of upcoming dividend payments.
Trades and dividends are sent to Xero as draft invoices, which can then be approved in Xero and used to reconcile against your bank account.
Note: Each dividend or trade in Sharesight can only be sent to Xero once, and this action cannot be undone or reversed from within Sharesight. Modifying or deleting draft invoices created by Sharesight must be done from within the Xero interface.