Handling cash investments with Sharesight
Cash is king, right? Not anymore. On a recent trip to Chicago, I noticed that Chase bank were offering a 24 month term deposit at 0.15%, which beats the pants of a savings account rate of 0.01%.
Even so, whether you invest in term deposits, fixed interest funds, or cash ETFs, cash is a critical asset class for investors and savers. So how do you account for cash in Sharesight?
The first option is to simply click “+ Add New Holding” on the portfolio overview page.
Using the “Market” dropdown, select “Other,” then tick the box for “Add New?”
Then give the investment a name, e.g. “August 2013 Cash Deposit,” and then set the dropdown to “Fixed Interest and you’re able to enter all the details necessary for a cash holding including coupon rate, payment date and frequency. Because the form is also designed to support bonds and other tradable fixed interest securities, the form contains a “quantity” “price” and “face value” field. For a term deposit, set the price and face value to $1 and record the dollar value of the initial investment in the quantity field (i.e. for a $10,000 term deposit assume 10,000 $1 units).
Once entered, this investment will be incorporated into the portfolio and your interest payments are automatically calculated and recorded in the same way as dividends are for your share holdings.
For transaction accounts such as your trading account, the best option is to take advantage of our connection with Xero, which is ideal for accountants (Business Plans) and DIY investors (Partner Plans).
Within the Sharesight Settings menu, click “Xero settings”, then click “connect to XERO,” and follow the prompts from here.
Once hooked up Sharesight and Xero talk to one another automatically. You can then map all Sharesight transaction activity to the Xero chart of accounts. Since Xero works directly with banks to reconcile account activity (including the cash accounts hooked up to brokerage accounts), Sharesight transactions such as dividends, interest income, or asset sales will be synchronised to Xero where you can reconcile them against the line items in your bank statement. Within Xero, you can even link back to the specific transaction record in Sharesight. No matter which method you use, Sharesight makes handling cash easy.
FURTHER READING
How InstructAnt improves client service with Sharesight and AdviserLogic
We talk to InstructAnt, a small accounting and financial planning firm that uses the Sharesight/AdviserLogic integration to improve client service.
Australian ETF distribution components now available for FY22/23
Sharesight now has updated ETF distribution component information for the FY22/23 Australian tax year for most Australian ETFs.
Sharesight product updates – September 2023
Major updates for the past month include the rollout of our new exposure report, plus support for five new brokers and over 80,000 Luxembourg funds.