• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

rounding on CT600

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    rounding on CT600

    Hi,
    On my Directors' Report and Financial Statements I've used the exact figures everywhere.
    The online / PDF CT600 only accepts whole numbers and then does calculations based on them
    This causes an issue trying to get the CT600 it all matched up with reality.
    How do you all normal solve it? Remove the fractional part of all numbers in your calculation s/sheets?
    I'm not sure how you format that in Excel.
    Thanks Olly
    Last edited by Olly; 2 January 2014, 20:22.

    #2
    The accounts should also be in round numbers, I believe the iXBRL will fail if this is not the case.

    The figures on the CT600 should therefore be the same numbers used in the accounts.

    I hope this helps.

    Martin

    Comment


      #3
      Originally posted by Martin at NixonWilliams View Post
      The accounts should also be in round numbers, I believe the iXBRL will fail if this is not the case.

      The figures on the CT600 should therefore be the same numbers used in the accounts.

      I hope this helps.

      Martin
      Hi Martin,
      Thanks for the reply
      I'm not using iXBRL (at least not knowingly, the HMRC PDF my generate that though)
      I think you can set an Excel worksheet to perform calculations using the displayed precision which I'll set to 0 decimal places. I'll configure that and then the numbers should match (bit daft though).
      Fingers crossed.

      Comment


        #4
        =rounddown(whatever,0)

        Then do all your sums with the rounded numbers
        bloggoth

        If everything isn't black and white, I say, 'Why the hell not?'
        John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

        Comment

        Working...
        X