Dividend Voucher and Minutes Template Available Here

[Platypus]

This is my first visit to this website so apologies if I am not too familiar how this works. Can you advsie how I can access the Excel worksheet mentioned in this thread?

You can now access the file here:
http://dl.dropbox.com/u/4309554/Divi...rtificates.xls

[Disc0pants]

Dividend Voucher

This is my first visit to this website so apologies if I am not too familiar how this works. Can you advsie how I can access the Excel worksheet mentioned in this thread?

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:
RapidShare: 1-CLICK Web hosting - Easy Filehosting

[Ashwin2007]

This is a very useful template. Thanks.

The Signatory for the certificates - Should this be the Secretary of the company or the Director?

[ittony]

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...

[Moscow Mule]

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

[Solent]

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

[Diver]

Excellent Platypus, Thanks

[Gros]

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.

[ittony]

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.

[thunderlizard]

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".

[Peoplesoft bloke]

Many thanks - just what I need.

[MrRobin]

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.

[Platypus]

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