• 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!

Dividend Voucher and Minutes Template Available Here

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

    Dividend Voucher and Minutes Template Available Here

    Public Service Post!

    Here's a little Excel thingy I put together a few years ago for generating that all important paperwork when you declare a dividend. I've used it for years and my (picky) accountant says it's spot on.

    You enter a few values and presto! All the paperwork you need. Keep your accountant happy and/or save money because the accountant doesn't have to clean up your paperwork at the end of the year.

    DATE OF DIVIDEND = the date you're declaring the dividend, usually today
    YEAR ENDING = Your company year end date
    Dividend Number = 1 for the first divi of the year, 2 for the 2nd and so on.
    Pay via Director's Loan (Y/N) = See Note
    Enter Total Amount of Div = The total amount of cash you're removing from the company back account.
    Signatory for Certificates = Usually your name

    If anyone finds this useful, then you're welcome.


    Note.

    Pay via Director's Loan (Y/N)

    Usually N=No which means you're going to actually draw the money out of the company account. In this case minutes of the meeting agreeing the dividend are produced.

    But can be Y=Yes if you're doing a (notional) transfer of funds from the current account to the director's loan account. i.e. You're not drawing the cash out of the company but moving it to be your money rather than the company's money. i.e. the money stays where it is, it's just the ownership which changes. This can be useful if the current account doesn't contain enough cash to cover the dividend maybe because you've already taken a director's loan. In this case, an EGM is required to approve the transfer into the DLA and the spreadsheet produces appropriate minutes. The minutes only take into account one shareholder, so I wouldn't use this option if you have 2 shareholders. In this case speak to your accountant. In general, it's pretty unusual that you would use this option.

    Linky:
    http://dl.dropbox.com/u/4309554/Divi...rtificates.xls
    Last edited by Platypus; 29 September 2010, 08:39.

    #2
    Nice one Platypus, looks good to me. My accountant provides all this gubbins for me tho (and a similar DIY spreadsheet if I so choose to do it that way) but I'm sure some on here will benefit from your skills.
    It's about time I changed this sig...

    Comment


      #3
      Many thanks - just what I need.

      Comment


        #4
        Fantastic. The most helpful thing I've seen on this board ever.
        Well, level pegging with "if your accounts are out by a multiple of 9 it's because you've swapped 2 figures around somewhere".

        Comment


          #5
          Originally posted by Platypus View Post
          Public Service Post!

          Here's a little Excel thingy I put together a few years ago for generating that all important paperwork when you declare a dividend. I've used it for years and my (picky) accountant says it's spot on.

          You enter a few values and presto! All the paperwork you need. Keep your accountant happy and/or save money because the accountant doesn't have to clean up your paperwork at the end of the year.

          DATE OF DIVIDEND = the date you're declaring the dividend, usually today
          YEAR ENDING = Your company year end date
          Dividend Number = 1 for the first divi of the year, 2 for the 2nd and so on.
          Pay via Director's Loan (Y/N) = See Note
          Enter Total Amount of Div = The total amount of cash you're removing from the company back account.
          Signatory for Certificates = Usually your name

          If anyone finds this useful, then you're welcome.

          .....

          Linky:
          http://rapidshare.com/files/10923066...rtificates.xls
          Hi Platypus,

          Just found your handy spreadsheet, thanks very much for sharing that. Could you tell me whether the year ending value is supposed to be for the current year, or the previous year in which the profits were made?

          Thanks, T.

          Comment


            #6
            Hallelujah, I've been asking question after question about voting dividends, and this is just what I could do with as well.

            Many thanks, Platypus.

            Comment


              #7
              Excellent Platypus, Thanks
              Confusion is a natural state of being

              Comment


                #8
                Great little spreadsheet. On question;

                Total Amount Per Dividend £2000
                Per Share £2000
                Share Holder : Mr Bloggs
                Shares : 1
                Amount of Dividend £20 ??????? Should this not be £2000
                Amoutn of tax credit £2.22 Should this not be £222

                Am I missing something silly

                Comment


                  #9
                  Originally posted by Solent View Post
                  Great little spreadsheet. On question;

                  Total Amount Per Dividend £2000
                  Per Share £2000
                  Share Holder : Mr Bloggs
                  Shares : 1
                  Amount of Dividend £20 ??????? Should this not be £2000
                  Amoutn of tax credit £2.22 Should this not be £222

                  Am I missing something silly
                  Formula in E16 assumes 100 shares in the company.

                  =$E$11*C16/100

                  Just change it to

                  =$E$11*C16/1

                  oh, and good work platypus, you strange amalgam of duck and otter with funny claws
                  ‎"See, you think I give a tulip. Wrong. In fact, while you talk, I'm thinking; How can I give less of a tulip? That's why I look interested."

                  Comment


                    #10
                    Originally posted by ittony View Post
                    Hi Platypus,

                    Just found your handy spreadsheet, thanks very much for sharing that. Could you tell me whether the year ending value is supposed to be for the current year, or the previous year in which the profits were made?

                    Thanks, T.
                    Glad a few more people got some benefit from Platypus' original post following my question above. I'm still none the wiser though...

                    Comment

                    Working...
                    X