Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Listing fixed interest maturity dates in reports.

Hi.
In my portfolios I have quite a few term deposits (entered under "other" as fixed interest) and bonds. I have already added the maturity dates for these. I was wondering if there is way to generate a report which can show the maturity dates and list the term deposits and bonds in order of the maturity dates. I do not want to have to pay for Xero as well just to get that functionality.
1 person likes
this idea
+1
Reply
  • Hi Bill,

    While there's no report to handle this currently, this is a good idea. We are taking another look at the Future Income Report so perhaps this is an area where we could incorporate more info about cash and TD's.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I’m frustrated
    I too need this feature. I see this is over 4 years old. And as far as I can see there has been no action.

    A maturity report seems like a pretty trivial report, and it's really vital for anyone running a fixed income portfolio.

    The other option would be a feature to let us download and data from our portfolio. Again pretty trivial since all it needs is a field picker and the ability to filter.

    Without these two features, I have to manually maintain a separate spreadsheet of fixed income securities in Excel.

    Please advise.
    • Hi John,

      I've just been chatting internally about your need to keep a separate spreadsheet of fixed income securities.

      We had a couple of ideas that you may or may not like to try:

      A. Using the holding comments field

      You could enter a maturity date into the comments field on each holding.

      Whenever you need to download your maturity trade info, simply run the performance report for the relevant period, export to excel and filter on the comments column.

      B. Grouping by maturity date

      You could create a fixed interest grouping and a separate category for each maturity month and year.

      This custom grouping could be used when running the performance and other reports to separate your portfolio into the relevant maturity periods.

      I hope one or the other of these suggestions might be of use.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I’m frustrated
    Hi Ben,

    Thanks for getting back to me and putting thought into this.

    That said, I can't say that your answers make me happy.

    Let's take a step back. The information required is already in your data base in the form of the maturity date field.

    So really a programmer could add the option to report on that to the future income report in a very short period of time (less than a day)—I used to run a development shop so this is an informed opinion.

    But instead of that, you are suggesting that I enter all the information again and then use a kluge to solve the problem. I just can't understand this approach, but it does worry me on a general bases.

    Sorry to be so harsh, but I think sharesight management needs to rethink your approach to this.

    And while doing that, the best approach would be to provide us members with a data base download tool with filters so we could solve these issues ourselves.

    This could be a premium feature and so a revenue source. I for one would move up to your top level to get it in a heart beat. (right now the top level features (single report) are not compelling enough to justify the money.

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

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

  • Adding separate categories for month/year is the only work around at the moment.

    However that is time consuming and untidy. As the maturity dates for the fixed interests and bonds have already been entered when established, surely it should be an easy process to enable the sorting these events according to maturity date.

    Adding information already entered into the comments field is clumsy and repetitive.

    Four years ago, a maturity report was said to be a good idea by Sharesight’s CEO Doug. Has Xero stymied the idea?

    I understand that it is SHAREsight but as the investment cycle matures I find that my portfolio includes even more fixed interest (both listed and unlisted) than four years ago. The ability to be able to sort and list according to maturity date would be even more useful.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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