I’m annyed

How do I record my cash holdings

Hi
I suggested a year ago that it would be good to provide a cash holdings facility in your software. The performance of the user's holdings is incorrectly skewed without this.
Can you please provide a method that I can do this (if not an upgrade).
52 people have
this question
+1
Reply
  • Although we don't have specific support for cash accounts within Sharesight at the moment, it is possible to record a cash holding (such as a term deposit) by manually recording it as a fixed interest security.

    You can do this as follows:
    1. Click the 'add new security' button and select 'OTHER' in the dropdown list for Market.
    2. tick the 'add new' tickbox
    3. You will need to make up a name and code which will appear in your portfolio (eg code: ANZ name:ANZ Term Deposit)
    4. In the 'type' dropdown box, choose 'Fixed Interest'
    5. Record the deposit as $1 units, for example a $10,000 term deposit should be recorded as quantity: 10000, price:$1
    6. You can choose whether Sharesight auto calculates the interest payments or not by ticking or un-ticking the 'Interest payment population' tickbox. If you don't want Sharesight to try and calculate the interest payments, you can just record the interest payments manually, in the same way as you can manually record a dividend payment for a share.
    7. If you selected the automatic interest payment population option, record the relevant details for the interest payment calculation (face value per unit should be recorded as 1 here).

    Please also refer to our help documentation on recording "unquoted instruments" here: www.sharesight.com/help/page_help/unq...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • How do I record cash in my Online Multi Currency Accounts and the associated FX transactions?

    This reply was created from a merged topic originally titled
    OMCA / FX.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • 1
    The simple way to do this is integrate Sharesight with Xero.. (www.xero.com) Sharesight handles the portfolio management side and Xero is an online accounting system. Data flows between the two either automatically or you can specify a single transaction. So in your accounting system you have a single account with the cost base of your portfolio and you can run the historical cost report in Xero to manage this and ensure they are balanced.

    For the super fund I've also integrated this with the Fixed Asset Account within Xero. A bit of overkill but when selling the asset its easier to record the gain or loss. And I have to keep recording the market movement within the superfund.. I find Sharesight quite useful for this..

    Prior to this I ran this in MYOB using Inventory and it was a real headache.

    In addition you can get Xero in the Large option which will give you multi currency with a live feed to FX exchange rates..

    I find this combination a terrific solution with my Self Manged Superfund.. If you need assistance I'm a Xero Certified Adviser and Sharesight Partner. www.goldminebookkeeping.com.au
    • view 4 more comments
    • I agree with Duncan Owen. Sharesight is Portfolio Software, not a bookkeeping or accounting package.
      With this in mind, it needs to measure the gain/loss in asset value and the income from a defined pot of funds which is divided up into investments and cash. That is it.
      As has been noted here that there are oodles of features which can be added (data feeds, exchange rates, multi-currency and on it can go) but really aren't necessary for most investors. If someone really does need these additional features, Sharesight needs to measure the importance of these features to their clientele. I guess it will be small because if you are doing business this way you are a sophisticated investor perhaps you should be using Zero.
      The problem with Xero from a small investor perspective is that you are taking an automatic machine gun to a knife fight. Ie It is an expensive, complicated and overkill for most people's requirements. As the CEO implied, they did not survey what their users need and they picked a software package that was easy for Sharesight, which hardly inspires confidence. Xero fanboyism?
    • Agree totally with above two posters. This easy basic facility should not be difficult to implement. Most of the information is already in Sharesight.
      Cost of shares bought, money received from share sales and dividends received.
      Money allocated to this portfolio can be added manually
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Cash accounts are not easy.
    We have four :
    1. An Australian bank account for direct credit of ASX dividends
    2. An OMCA account for ASX dividend cheques and trading in ASX shares
    3. An NZ bank account for direct credit of NZX dividends
    4. An NZD Trading Account for NZX shares
    The first two require a "daily" exrate calculation.
    Thus I would need a new portfolio for CASH
    with four "Fixed Interest" accounts, to be manually updated as required.
    Anyone else with the same problem ?
    Alan
    • Alan, the first two could be overcome by opening an ETrade account through ANZ Bank in Australia. This way your dividends are posted to your interest bearing savings account from where all trades are also debited/credited. Keeps it all nice and tidy. Jon
    • Thanks - that is more or less how I do it, but I don't think the ANZ Aus account is E trade. I think there is only one ASX company in our portfolio that still sends out dividends as cheques - can't remember which - so the OMCA is only for buy/sell ASX shares.
      The Sharesight CASH portfolio works well, but I still have to login to ANZ Aus and Direct Broking to get the AUD totals at the end of each month, then change the amount, date and the exrate of the "trade". I guess its possible to add a new "trade" each month to record fluctuations, but that option seems fraught with problems. An end of year statement from the bank should show all that except for the exrate for each deposit.
      A further login is required to get the NZD values.
      In spite of all this, the CASH portfolio is a lot easier than my previous spreadsheet method !
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Hi,

    Do you support investment loans in terms of tracking portfolios? E.g. LTV, interest-to-date, etc.

    This reply was created from a merged topic originally titled
    Investment loans.
    • Hi Callum,

      You can record loans as a fixed interest security as above and track interest payments etc, however we don't have any functionality around calculating loan to value ratios.
    • Hi Callum,

      I did set up a bond for Aged Care so it did not produce interest in a positive sence but there was an out going each month for the statutory fee that the home can retain. So it became an effective way to track this inside Sharesight as there was only one movement per month on this loan.

      If you were trading through the loan and having purchases and sales then I think Xero would be a better option.. You can get a Cashbook Xero subscription though a Xero partner or if you want you can get a Xero subscription yourself.

      I've connected Xero and Sharesight and can tell you that it works quite well. In fact I'd say very well.. There are active links through the documents so from Xero you can then get back to the sharesight document you can store with the transaction... And if your talking super funds where you have to have these audited then you have a full system if the auditor also has access sharesight.

      I've not tried the cash book approach but in that case I guess you'd have only the one bank account that you could deal with.. By creating a purchase or a sale document then you can then make the payment from multiple bank accounts and currency depending on what you do..

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

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

  • I would echo Mike Deam's comment about using Xero to track your cash accounts. You then get access to bank feeds through Xero which is a fantastic features and makes reconciliation to the bank very easy. A simple ashbook account from Xero is about $10 per month so it's not expensive.

    One idea we are toying with is bringing back some cash data from Xero through the API which would then sow up as a cash asset in Sharesight. Technically it's a bit complicated but we are looking at it.

    Andrew Bird
    • view 1 more comment
    • anyone looked at anz money manager, depending on your trading platform you should be able to pull in your cash balance and shares and then group your accounts, best of all its totally free, on a side note I use it to also do by BAS every quarter as you can customize the categories and group accounts...
    • Hi Darren, I see this topic was merged recently so it came up on my radar again and saw your comment..

      The issue I can see right off the bat with ANZ will be that you will have to do everything again or twice as it were.. I presume you use sharesight to keep your portfolio which is why you posted here. That being the case the issue is then that you want to add some accounting function to it to do interest and other expenditure and have a full accounting system.

      Given that, because Sharesight has already written the code to integrate with Xero then this option is automated to a certain degree. So I enter the trade or the dividend in sharesight, click on the Xero option and the trade or dividend is now in existence in Xero ready to reconcile within the accounting system. Even better is if I use the broker interface within sharesight then a lot of this work is already done for me offering me further savings.

      If I want to choose another accounting system at the backend other than Xero then I loose all the advantages that Sharesight brings in that regard as it would be unlikely to interface. If I had too do something else then I'd get someone else to write some integration for me or use a program like Zapier (zapier.com) and see if they can offer some assistance. But any interface you develop its up to you or Zapier to maintain and this needs to be added to the cost.

      Likewise if you use Xero and you want a portfolio manger then Sharesight is the logical choice because they integrate. If you want to compare apples to apples then you'd have to look for a portfolio manager that integrates to an accounting system. And while they do exist most are targeted towards Superfunds.

      What people tend to do in this situation in particular if they are doing it themselves is look at the software cost and forget to value their time. So if you are doing this twice ... once in sharesight and again in the accounting system you are spending time repeating a task. The key question in this is to work out how long it will take you versus doing this once - what is the time saved and is that worth the price of the software. And its not just data entry but accurate data entry because if you are entering the transaction twice there is the possibly of getting on side incorrect and you need to include the time required to find and fix it.

      Therefore the most expensive part of any accounting system is not the software it's generally the labour required to drive it. That said I'm not a big fan of odesk etc (getting an overseas bookkeeper on the cheap hr rate) with your accounting system because a smart bookkeeper will save you thousands

      If you look at it logically taking a Xero subscription even at $50 a month if you value your time at the same rate you only have to save 12 hours a year to break even. If you value your time at a higher rate its even less.

      The key word in all of this is integration. There are things I don't like about Sharesight but at present I'm sticking with it for the integration. I have more than 10 sharesight portfolios that have integrated into various xero files on the whole the integration works well - but as I said there are things Sharesight could do to make portfolio side better. So just because ANZ offer you something for free does not mean its a good deal depending on how you value other things including your time.

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

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

  • Mike is right -- To get cashbook you need your accountant to be a Xero partner/user and then they can create a cashbook account for you.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • This reply was created from a merged topic originally titled
    Adding fixed interest.


    How to add NZ corporate bonds/bank TD's etc to this portfolio.... ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Hi
    Just learning about your product at the moment. It looks very good, though in relation to cash accounts (and this thread) does it or will it have the capability to settle share trades (buy/sell) with a cash account? I am looking for something that will report and track the whole portfolio including cash. The solution mentioned at the beginning of this thread would entail a double entry. For example if you sell some shares you would then need to 'buy' cash otherwise selling shares will result in a drop in portfolio value which is not real.
    Thanks
    • view 3 more comments
    • Yes, I read you loud and clear. Cash reconciliation is a tough feature to get right - not from an interface or calculation perspective, but from a data perspective. Specifically, gathering the cash data from the various financial institutions and then being able to track or tag what transaction is what. Xero do a great job of this and it's really one of their killer features. If you need this level of granularity, my encouragement would be to use Sharesight and Xero side by side in 2 tabs...
    • Thanks Doug but I am not sure I am asking the right question (as it is not very difficult at all).
      Simply, when you purchase some shares the transaction amount could be automatically deducted from a cash settlement account. When you sell some shares the transaction amount could be credited to the settlement account. That way, when you buy and sell shares your 'whole portfolio' is properly reflected. You could also then cross check (reconcile) that your cash account in Sharesight matches your actual cash balance after the 3 day settlement period of course.
      As an option you could opt to direct dividends automatically to your cash account, if this is where they are actually paid (so you get ''accumulation" of the whole portfolio for benchmarking against indices).
      I can do it myself manually but its really monkey work and for software as clever as Sharesight it should be a cinch to code it up...
      This is embedded a long way down now so perhaps if I started a new thread on the topic we might get a feeling for how useful this would be for other people?
      Thanks Steve
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • This reply was created from a merged topic originally titled
    cash facility needed.


    Please add a function that helps me keep track of my holdings in cash. The shares and automatic dividends are brilliant, but I need to keep track of the cash too if it's all to make sense.
    • Hi Jane

      I asked the same question quite some time ago and may be able to make the answer clearer by giving you a help file. This is for us more modest ‘mom and pop’ investors who don’t have the luxury of access to ZERO or similar systems. Apologies to SHARESIGHT if the YouTube video gives the same information.

      Simple Cash recording method for SHARESIGHT
      Click CREATE NEW PORTFOLIO named ‘CASH’ or similar. Other details are not very relevant so just used the defaults. Select the new portfolio, then :-
      Click ADD HOLDING
      Click dropdown – select OTHER
      Enter a suitable name, ie ‘OMCA AUD.Balance’
      Check Box ADD NEW
      Enter a suitable name, ie ‘AUD cash’
      Click dropdown – select FIXED INTEREST
      Click dropdown – select AUSTRALIA
      Click BUY
      DATE select todays date
      FACE VALUE is always 1
      MATURITY DATE set 10 years out (you may have to edit it in 10 years time ?)
      COUPON RATE = 0
      FIRST PAYMENT select todays date
      UNCHECK Automatically Calculate Income
      Click dropdown – select ON MATURITY
      QUANTITY is the account balance in $$ on the selected date
      SHARE PRICE is always 1
      EXCHANGE RATE click the ex.rate. for the selected date
      BROKERAGE is always zero
      Click SAVE

      Repeat to add all NZD and AUD cash accounts.

      I do a monthly summary of my portfolio, so at the end of each month I get the balance of all relevant accounts, select my CASH portfolio in SHARESIGHT, then, for each account, change the DATE, the QUANTITY and the EX.RATE and SAVE.

      Setting up is laborious, but once completed the monthly update is pretty simple. If you have created a CONSOLIDATED VIEW, add the CASH portfolio to it and get an accurate portfolio performance record every month.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Hi Jane,

    Please refer to my response from just a few minutes ago (Monday, 23 June, 9:30AM Syd time).

    Cheers,

    Doug
  • (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

  • Been doing this for years with the Xero interface .... Works well. No double entry because of the API and I can handle non-share transactions at the same time within Xero or have I entirely misses this thread.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • 2
    This reply was created from a merged topic originally titled
    Settlement of Trades.


    Congratulations Sharesight, great software that I have just started using. It can do a lot. One idea though...
    All commercial brokers require you to have a cash settlement account which settles share trades. When you buy shares, cash is debited from it, when you sell, proceeds are credited to it. The portfolio value is the sum of the share valuations and the cash account.
    Currently this is one thing that seems lacking in Sharesight. For example, if you sell some shares your portfolio reduces in value (when it hasn't at all).
    I'm aware there are some manual ways around this, but it would be very handy to have an automatic feature to credit/debit a cash holding in Sharesight with share sale/purchase transaction amounts, respectively. This ensures an accurate statement of the total portfolio value at any given time. Dividends could also (optionally) be automatically credited to this cash holding within Sharesight, to model what is often done in practice.
    I wonder if any other users would also find this of use?
    Thanks
  • (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

  • EMPLOYEE
    I’m happy
    Hi All,

    Just to update on this thread as well...good news on handling cash...

    Sharesight will soon be supporting the Macquarie CMA product and ANY cash/bank/settlement/TD account maintained in Xero.

    Integrating with either will be handled in a one step process on the Sharesight interface.

    Essentially, we'll pull back the transactional histories and end of day balances for the cash account so you can see your cash balance and your portfolio(s) balance together on Sharesight.

    Adding a cash account will be available via the "Add New" button and the cash balance will be maintained in a dedicated section on the Portfolio Overview page.

    This is in beta now (I've tested, it's working well) and will be released soon. If you'd like beta access (and would be willing to help test), please reply to this post.

    Cheers,

    Doug
    • Doug.

      I would be willing to give it a test with my Macquarie CMA, so please send me the details for beta access. Its not quite what I was looking for but worth a go - the only minor issue being a 3 day lag between transactions and when they are effected in the cash account (T+3).

      I currently don't subscribe to Xero and not inclined to go that way for the time being.

      Thanks
      Steve
    • Please expand the "Macquarie" feature to other Banks - starting with ASB and make the feature available to regular (non Pro) subscribers.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Hi Doug,
    Re the Macquarie CMA and other cash account integration.
    It appears that this functionality has been only released to Sharesight Pro subscribers.
    Is this new functionality to be quarantined to only those subscribing to the Pro version?

    Cheers,
    Darryl
  • (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

  • HI Darryl,

    That's correct, for the time being Macqaurie CMA integration is only available via Sharesight Pro as you can only connect to Macquarie adviser-level CMA accounts.

    We are waiting on a response from Macquarie re offering their retail-level CMAs via other Sharesight plans. This comes down to which accounts they're willing to make available.

    Stay tuned this week - we'll be announcing another option for integrating all types of cash accounts.

    Cheers,

    Doug
    • view 1 more comment
    • This comment was removed on 2014-08-18.
      see the change log
    • Hi Darryl,

      Thanks for the reply.

      We have discussed the retail CMA account availability with Macquarie and we're told it is possible, but our guys need to do more investigating and planning before this can be launched.

      There is a workaround, which provides a wider solution than just these CMA accounts - check out our new cash handling feature via Xero:

      http://www.sharesight.com.au/2014/08/...

      This would provide you with a conduit for reflecting retail Macquarie CMA data in Sharesight. This does require you to have a Xero account. The good news is that this works for ANY Xero-supported bank feed (which is also Yodlee technology btw).

      We're familiar with Yodlee's ANZ product. In all likelihood ANZ is paying Yodlee a huge licensing fee to white-label that product. With that fee comes the ability to integrate any bank account that Yodlee supports. Since we don't license Yodlee technology, gaining access to individual cash accounts is just that I'm afraid - an individual effort on our part across disparate technologies.

      Cash is important to investors - that's not lost on us. If you're keen to treat cash properly (from a performance & reconciliation standpoint) you should really try Xero and then pull that data back into Sharesight. Their bank integration and reconciliation engine is excellent. Plus their technology + Yodlee covers over 5,000 banks...

      Cheers,

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

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

  • 3
    Reading this thread, it's clear that there is huge demand to have some means of tracking cash, and the automatic drawdown when purchasing stocks. Not all of us want to spend $25/mth with Xero. Are the Sharesight developers working on such a feature that does not require us subscribing to Xero??

    Sorry if this has been answered, but I could not seen any specific response to this issue which has been raised numerous times.

    The sharesight product is first class and I highly recommend it, but this is an obvious feature which is lacking and is clearly in demand by a large number of users.

    Cheers
    Dave
    • view 3 more comments
    • I agree with John. The manual method I use is detailed in the Jane Rowe thread above. Having recently witnessed Xero at work, and its very good, is it worth their lowest rate of $300 p.a. just to get bank feeds for us retired Mom and Pop investors ? (bank feeds is all you get for $300). Since Bank entries take less than 30 minutes/month using the manual method, I don't think it is. I reconcile the bank accounts by copying from their PDF statements into a spreadsheet for sorting.
    • Any chance we can get a response from one of the Sharesight reps? Is such a feature in the wings or should we look at alternative plans to manage this?
      Thanks
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • EMPLOYEE
    I’m happy
    2
    Hi All,

    Thanks to everyone participating in this discussion, we appreciate your feedback! I've reached out to some of you individually already, but given the popularity of this topic, it's best that I post a public message.

    While this isn't a silver bullet for everyone, nor does it mark the end of this discussion, we hope that this announcement will offer a solution for some:

    We've teamed up with Xero to offer their Cashbook product for just $15 per month, including a free one month trial. We're the first Add-On partner to be given this opportunity by Xero:

    http://www.sharesight.com.au/cashbook

    This means that within Sharesight you can add on a Cashbook account to your Sharesight subscription and we'll invoice you for both concurrently.

    This offer is only available to our Investor Plan and Expert Plan clients.

    Xero integrates with hundreds of banks to bring in your transactions and balances, with a best-in-class reconciliation tool. This info can then be displayed on Sharesight for up-to-date cash tracking. Doing your recs is painless - most will be auto-identified by Xero so it's just a matter of clicking a button.

    With Cashbook you also have access to other Xero functionality like reporting, budgeting, access to their Add-On Marketplace, and the option to share access with your accountant or adviser.

    In our opinion, if cash is mission-critical (e.g. for an SMSF or someone set to retire) so as to require proper portfolio tracking, it's worth $180 a year. Perhaps you disagree, but this is just one more option for you - so why not take a free trial?

    Our thinking is that an ecosystem of connected applications, such as your broker, Sharesight, and Xero is more effective for switched on DIY investors than a product that spreads itself too thin (like an expensive platform).

    Cheers,

    Doug
  • (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

  • I have recently switched to Sharesight from TopShare and Sharesight does seem to be a better product.

    However i really don't understand the need to push another companies (Xero) product in terms Cash management? $180 pa to do this seems a bit excessive. Leaves a bit of a sour taste in my mouth.

    Even a simple integration of a "cash in investment account" which can be entered manually would suffice and wouldn't be hard to do.

    Without it, it makes it hard to gain a holistic overview of our portfolios.

    I guess the question people keep asking but don't seem to be getting an answer on is,

    Does Shareshight plan to develop cash managament integration into their software? Or is Sharesight commited to partnering Xero for this, thus the extra charges will continue going forward.

    Cheers

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

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

  • Jon,

    Thanks for your feedback. We already have the feature you're asking for.

    You can setup a "cash investment account" manually using the "Other" dropdown from the Market menu when adding a new holding. You can enter principle, yield, payment frequency, maturation, and so forth. The interest payments can be added to this holding automatically. This security will then visible across the product and report output.

    Here's a video showing how to do this (in this case for a property security): https://www.youtube.com/watch?v=cm6Rx...

    And a link to our help section: http://help.sharesight.com.au/unquote...

    We probably need to do a better job making this feature stand out!

    The point of us offering Xero is not a "money grab." We offer one of (if not the only) conduit for non-professionals to purchase what we think is a terrific accounting and cash tracking product. In future you'll see us connecting to more add-ons offering specific features (perhaps technical charting, research etc.). We believe in the strength of connected and specialised applications.

    Our plans re (non-Xero, non-Macquarie) cash management continue to evolve, and are heavily dependent on the banks' willingness to send us the cash data.

    What was TopShare's cash management solution?

    Cheers,

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

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

  • 2
    I agree with Jon but just to add another point..
    ..the power of modelling cash accounts is so that you can reconcile your bank accounts and if you import that data you can't do that.
    Also, you can do manual changes to an 'other' account buy 'buying cash' when you sell shares and vice versa but it's such a mechanical task it could be added very easily. I've asked this question a number of times and have not received an answer as to why it's not being pursued. If nobody else thinks its useful then that's fine, but to date the response has been to purchase xero (which I think defeats the reconciliation purpose, and doesn't answer my suggestion).
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Thanks Steve,

    You bring up an interesting point - are you only wanting to reconcile cash for buys and sells, or are you needing a fully-functional reconciliation interface that is powered by your real bank account?

    The former could be achievable and if I didnt pick up on this initially my apologies. Obvisouly Sharesight knows the cash "received" or "spent" based on the holdings we're tracking so presenting you with some options here would be fairly simple.

    If you do need the latter, however, we could build a slick reconciliation interface but where does the data come from to populate it? I've mentioned the difficulty in getting the data from the banks. Would you be willing to download a bank statement and then upload it, and then do the reconciliations? To us, this sounds like a good deal of manual effort, which sits outside our core competency.

    Please let me know.

    Cheers,

    Doug
    • view 2 more comments
    • Hi Steve, please get in touch directly and we can chat further: support@sharesight.com
    • Doug - All I would want is your first option "to reconcile cash for buys and sells". That would be excellent. Use Google Finance's portfolio as the example. One can setup a cash balance and then buys/sells are debited/credited against it. This would really make Sharesight significantly better than it currently is.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Just wading in on this topic as well. At Sharesight we have spent quite a lot of time considering this and we are still working through the best range of solutions.

    There is no question in my mind that integrating with Xero is the best solution: It provides all the functionality that Steve N and John are looking for.

    For users interested in better Cash handling we would really encourage you to try the Xero solution. It's a free trial. If at the end you feel it's not what you are after or it's not worth the extra money we would appreciate knowing that as well

    Xero also does a whole lot more than basic cash handling. It extends the functionality in a number of really valuable ways. Things like

    --It lets you automatically connect a bank account from any bank and downloads the transactions so that you can reconcile these against the Sharesight with very little effort

    -- It lets you track any other expense and income that are relevant to you, like interest income, rental property income etc... From this you can build a full profit and loss if you wish. You can use it to easily track all your personal, business, or investment income and expenses. Few people are able to do this effectively because the traditional ways are very time consuming and tedious. With Xero it really become quite easy.

    -- If you have an SMSF or other entity that requires annual accounts, Xero will do this as well.

    The downside to this, of course is that it does cost extra on top of Sharesight. We think for many users, even if they don't use all the functionality the value it creates is well worth it. The combination is still far cheaper than any other alternative which provides similar functionality.

    Because we think the integration with Xero is so good, we wanted Sharesight users the chance to try it for themselves. We know that if we were to build a fully functional solution ourselves we would end up with something like Xero anyway. And it would take us a great deal of time and divert development resources away from more portfolio-oriented functionality. And I don't think we would be able to afford to include it at no additional cost

    As Doug has said we are still open to extending our own functionality to provide better cash handling. We think offering the Xero option is a part of that process. Your feedback is vital in determining how we move forward on this and other product improvements.
  • (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

  • did Sharesight look at other packages like myob online or quikcbooks? why Xero?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Since we already had an integration with Xero, and because their bank feed support is very broad it just made sense for us to roll this out by leveraging Xero first. Our developers are familiar with their people and API. But with that in mind we're always keeping an eye on other solutions...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • thanks. Interestingly I just had a dividend payout this morning - great to see how this is synced between Sharesight and Xero. Easy.

    I just think that Xero could do with some more dashboards, budget analysis, etc. Good accounting (of course), but could have some more UI and reporting improvements.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Xero has announced more in the way of dashboards and widgets. You might want to check out Spotlight or Fathom for better reporting.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • 3
    Hi, reading the responses from the Sharesight team I think you're looking at the cash management with more complexity that you need to.

    All I require (and I imagine some of the others here) is a simple 'shareholding' that I indicate is cash and turn on checkboxes indicating whether dividends and buys/sells get added/deducted from this shareholding.

    I then manually add/remove the cash value that I allocate to my portfolio and then Sharesight automatically adds transactions based on my instructions (the checkbox settings).

    I don't want a far more complex solution like Xero for a very simple field, which gives me a total portfolio value including cash (which could be 5% or 50% of my portfolio at any given time).
    • view 1 more comment
    • Agreed! It's just silly that I look at the portfolio performance chart in Sharesight since inception and over the last 5 months it looks like my portfolio has gone down in value when in fact I've just been taking profits and growing my cash holdings to represent 20% of the portfolio value.

      The portfolio actually grew 1.5% over the last quarter, not dropped by 18.5%.
    • Hi,
      I am new to Sharesight and I will use Xero for one of the portfolios. However, a simple cash interface to settle the trades and add dividends would give the true returns and is a great control account for those portfolios I would not use Xero
      Cheers,
      Ed
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • 1
    I am trying Sharesight for the month and the cash balances will be a major factor in continuing. Xero means nothing to me in Canada and very little in the N America world. If this is an important market to you (and why not, you cover the stocks well) then we need another solution. Simple cash pluses and minuses in 2 currencies with no need to reconcile with banks is all I, and others on this feed, need. I'll input the initial cash balances and then buys and sells and dividends should add automatically. I think your users are clear on this need and the responses have not shown great empathy. Please consider.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Hi Carr,

    Thanks for your post! I will ask either our CTO or CEO to respond to your feedback as they have more insight into this matter.

    Thanks ever so much for your patience!

    Have a lovely morning.

    Cheers,

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

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

  • 3
    Please do! I'm still waiting for this feature to be built within Sharesight.

    Feature dev of late has been pretty mundane for the end user as well fyi ...... hint, hint devs. Time to take a break from focusing so much on dev to connect 3rd party systems and support international expansion. Using a 3rd party package like Xero is overkill for a simple cash management process.

    Come on guys! We don't a complex solution using API's to connect to my bank account or anything. Just a simple solution to add/subtract funds automatically from a designated cash holding within Sharesight.

    If this is way down your production queue, I'd want to see some pretty useful enhancements this year that benefit me. I'm feeling unloved.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • 1
    I agree with Duncan. The Xero interaction is great for sending transactions straight into the accounting system if that is what you use. However, a simpler cash management account directly within Sharesight is required for portfolio tracking of cash.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I have to add my voice as I agree with the other users that a simple function would add significantly to the functionality. Something along the lines of how Google Finance works would be sufficient.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I’m excited
    I also agree with the suggestion for a simple cash function. I just want to enter cash in the bank (actually banks) on a selected date to get a complete picture of Portfolio Value plus Cash value on that date in "Consolidated View". Once the banks are set up in Sharesight, they can easily be updated manually - see past contributions to the debate. Cheers, Alan
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I also agree with other recent posters that a simple cash account tracking system is desirable. Xero (I am currently trialling it) is overkill for what I need and does not support all banks (eg a BellDirect cash account). If you have an account that is not supported the whole solution falls down. All I need is a simple system that
    - allows cash accounts
    - allows transfers between these accounts
    - allows transactions to be recorded to keep the account reconciled with the real accounts.
    - allows interest to be added that can be included in performance reports and income reports.
    - allows the accounts to be used for purchases/sales, dividends to be specified to allow auto update
    If you have access to a StockDoctor account you will see a good model of how this can be achieved
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • 3
    Looking back on this thread, it seems to have a four year history and still a lot of unhappy users.
    The need for a simple plus and minus cash holding is clear to many of us. For me, it is the rather large swings in currency exchange rates (between USD and CAD for me) that can swamp changes in stock values. Just looking at stock price changes, that are adjusted for currency rates, and not looking at the cash holdings at all is not giving the whole picture. I can easily gain or lose hundreds of dollars a day in exchange rate swings in my cash holdings.
    The Sharesight package does so many things well that it is a true shame that this 4 year old request cannot be met. Again third party solutions are overkill and those suggested are not valid here anyway.
    Anyway, 3 weeks left in my free trial and still sitting on the fence.
    Thanks to all who added support to my request (many for the umpteenth time).
  • (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

  • Hi All,

    We're listening. Thank you for your continued participation on this thread. We've been talking internally about a cash feature for some time based on the comments posted here and we recognise that it's important.

    I've created a fresh post to gather & organise information on what this feature may look like: https://getsatisfaction.com/sharesigh...

    There are in fact a handful of seperate ideas and features being introduced in this existing thread (and some merges from other topics). Some clients have suggested a simple approach, whereas others suggest that a cash feature should also impact their portfolio performance, and others mention debt securities.

    We've been cautious with cash because we don't want to get drawn in to building an alternative accounting system when there are other purpose built applications that do it well. Nor do we want to spend developer time building something that doesn't hit the mark.

    Please link to the new post and record your thoughts there.

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

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

  • I’m Disappointed
    Just spent a few hours trying to get my cash balances to show, which is really annoying considering my situation is SO simple.

    Date / Total Cash

    01-01-1990 - $1
    01-02-1990 - $6
    01-03-1990 - $11

    I managed to create some formulas in excel to bring over the values into sharesight, but sharesight fails to do a 'current balance' for CASH, so I've had to modify my values to sort the 'BUY' per month to the values below:

    01-01-1990 - $1
    01-02-1990 - $5
    01-03-1990 - $5

    This works, but it's painful. Also, I can't import interest payments per month? Urgh, How am I suppose to add interest for 5 years worth of data without an import function on income?! :(

    Also, no option to 'Turn off' Cash from being included in my performance figures. I use sharepoint first as a share tracker, but having a stackable graph of my cash helps me track my total wealth.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I’m frustrated
    just sad that this hasn't been resolved. my portfolio has taken a dive because i chose to close a few positions and stay in cash for a while.
    • view 4 more comments
    • I have moved on ... absolute joke.
    • This comment was removed on 2017-05-24.
      see the change log
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • 1
    +1 for a cash feature.

    I found this site after learning that Google Finance would be shutting down its portfolio feature. I would like something similar to Google Finance's cash function:

    1. Cash can be deposited or withdrawn.
    2. Shares can be purchased with cash, or proceeds from sale go into cash.
    3. Dividends not used for DRIP purchases go into cash.
    4. Cash holdings are calculated in overall portfolio returns.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • 1
    Your cash balance should be reflected in your portfolio, especially for SMSF, if it isnt then how are you processing your year-end tax return & audit.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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