Tracking Cash

Based on customer feedback, I've created this post to collect ideas on what our cash feature might look like.

In your responses, it would be most helpful if you:

1. Describe the PROBLEM that you face as an investor that you're wanting solved.

2. Help us define the feature by providing SPECIFIC details about what you'd want it to do.

***

"Cash" in the context of a portfolio application can mean different things to different people. We're keen to triangulate the challenges you face as investors, your expectation of what you want this feature to do, and what we're capable of building.

On one hand this feature might allow you to create, modify, and track a simple cash balance in the context of your portfolio, or maybe you expect your cash holding to affect your overall performance calculation. You may want an interface to reconcile a cash balance to each transaction. Additionally, some clients may define cash as the amount available for investment, or from dividends received, whilst others may view this is as a way to track fixed interest securities.

By gathering this information we can identify the most common requirements, and what sort of development effort is required.

Doug
93 people like
this idea
+1
Reply
next » « previous
  • This reply was removed on 2018-02-17.
    see the change log
  • First, congrats on getting this up and running.

    A few suggestions for later iterations (some have already been suggested and I agree):

    1. Bulk Uploading / Import
    2. Recurring Transactions - e.g. fees, interest (can be done on an exact or "estimated" basis - with the estimate able to be easily updated for actuals). Permit any periodicity i.e not limited to just monthly, weekly, daily etc.
    3. Ablity to transfer cash between accounts in different FX - perhaps have a "FX rate" and a "fee" field (With fee specifiable in either target or origin currency)
    4. Agree with auto posting of dividends, buys/sells (I know this is planned in the second phase) - although would want buy/sells to be specified by trade (as may be funded from different sources)
    5. On "negative" balances - i.e. loan accounts / margin loans, permit an interest rate to be set for a period, and a compounding period. e.g. daily compounding, interest rate for period 1 January 2017-30 June 2017 to be x%, interest rate for 1 July 2017-31 Dec 2017 to be y% etc. Guess the same could apply for positive balances... but I am always in debt!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • Hi,

    Thank you for the new cash item.
    I have understood stage 2 will allow for automatically posting of cash transactions as a result of buys, sells..etc.
    Wondering if cash affecting the overall performance will also be available on stage 2.

    Thanks,

    Ignacio
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • I use Commsec which has an attached CDIA trading account and the new cash account facility is a great start and when developed should allow all investment to be managed in the one place.

    For the next stage I would like to see the buy, sell and dividend boxes have a selection button to allow the cash component of a deposit or withdrawal to be automatically applied to the trading account. The taxable income report should include interest so the accountant receives all income in the one report.

    If there is a feature to allow bank data to be downloaded and imported some smarts would be needed to avoid duplications.

    Personally I do not mind manually entering monthly interest and the occasional "special" entries although I appreciate that anyone who uses their trading account for day to day personal use would not agree.

    A great start and I will be interested to see how it progresses.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • In terms of tracking non AUD Cash...

    I use CommSec International a lot and therefore have cash sitting in USD, HKD, GBP etc. Hence without the ability to enter and FX rate for moving cash either to from Australia (which will have a different rate than what you guys use due to it being the bank's wholesale rate at that point in time when the transfer occurs) it doesn't help alot with overseas cash holdings. Good initiative otherwise.

    PS: I currently track my overseas cash using a Custom Instrument for each currency set to Fixed Interest, Interest on Maturity (@0% because there is none) with Maturity Date set way in the future. That allows me to track my FX balances along with FX rates at the time of Deposit, Withdrawal, Buys, Sells and Divs in each currency along with Comments etc. I can also see my FX holdings in any reports.

    To be honest it would be great if you just created/added a Custom Investment Category for Cash allowing for various overseas currencies. This also has the benefit of seeing holdings in both AUD and Native Ccy.

    Cheers,
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

next » « previous