Portfolio revaluation sync to Xero?

Hi
I'm looking at integrating with my Xero cashbook edition (which is already setup). I would like to be able to journal a portfolio revaluation each quarter, is there a way to setup this sync with Xero to automatically revalue and pass adjustment jounral entries for gains/losses? So that my "balance sheet" in Xero is a true market value at end of each quarter?
2 people have
this question
+1
Reply
  • Hi Mary,

    Currently Sharesight only sends transaction level data (buys, sells, dividends etc) to Xero. Asset revaluations need to be recorded manually via a manual journal in Xero. You can get the figures to calculate revaluations from the historical cost report in Sharesight.
  • (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’m confident
    Hi Scott,

    Following on from the above...

    I'm trying to record my current Market Value of my portfolio in Xero. (I understand this must be done via General/Manual Journal) on say an annual basis e.g. 30/06/2014...30/06/2015...etc.

    I would like to know whether the 'Closing Market Value' on the historical cost report excludes such items as:
    - Franking Credits (Asset)
    - TFN Withholding Tax
    - Non Resident Withholding Tax
    - Dividend Reinvestment Plan (DRP) Balance

    and whether the 'Closing Market Value' on the historical cost report is meant to agree to the 'Share Market Investments' mapping account through to Xero.

    Could you please provide me with a template general journal for annual use to reflect the Unreaslied Capital Gains & Losses each year (taking into account the items mentioned above) with the idea that the unreleased gains and losses will flow through to retained earnings on the balance sheet at the end of each year.

    My aim is to capture a full and accurate reflection of the true market value of my share portfolio and cash holdings in Xero each year.

    Your prompt reply is greatly appreciated,
    Kind Regards,
    Daniel K.
  • (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

  • 1
    Hi Daniel,

    The "Closing Market Value" on the Historical Cost Report is calculated for each holding as quantity on the closing date * market price on the closing date.

    Prior to any revaluation adjustments, the "Closing Balance" on the Historical Cost Report should match your Share Market Investments account in Xero. (Franking Credits, Withholding tax and DRP balance are reconciled to different asset accounts in Xero and do not form part of the asset value in the Sharesight Historical Cost Report).

    To revalue your Share Market Investments account to reflect the Market Value of your investments (as opposed to the purchase cost) you would make a journal entry such as:
    Dr Share Market Investments
    Cr Investment Revaluation Reserve

    Initially the journal entry amount would be the difference between the "Closing Market Value"" and "Closing Balance" on the historical cost report. Going forward the market value can be kept up to date by making additional journal entries to reflect any change in this difference for the period.
  • (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