Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel Workbook to Calculate PAYE tax, NI contributions and Net Pay

0 views
Skip to first unread message

Bryan K

unread,
Apr 12, 2000, 3:00:00 AM4/12/00
to
"Michael Fosong" <mic...@compufix.demon.co.uk> wrote
> PayrollCalc 2000/1 calculates the monthly PAYE and NICs for employees
> quickly, effortlessly and accurately, giving employers,
> consultants/contractors and Payroll bureaux the extra time to better
> serve their clients. To process a typical employee's payroll all you
> need is their Tax Code, National Insurance number and Gross pay for
> the current period. PayrollCalc 2000/1 does the rest!

Except that according to your web site it doesn't handle contracted-out NI
yet. Bit of an oversight there I would have thought....

Just to mention in passing that, following a recent conversation in this
group, I'm mulling over writing a tax and NI calculator as a Java applet -
stick it on the web, see how many people go out of business....


--
Bryan Kennerley mailto:bry...@btinternet.com
North Wales Index - The Web Index for North Wales
http://www.northwalesindex.co.uk (1036 links and rising)
news:uk.local.north-wales

Adrian Pearson

unread,
Apr 13, 2000, 3:00:00 AM4/13/00
to
Why use any software yourself when you can get the whole administrative
burden of payroll done for about £2 per employee per month? - our
all-inclusive payroll service includes all end-of -year documentation in the
price.
--
Adrian Pearson FCA
Pearson & Associates
Chartered Accountants specialising
in helping small businesses
www.pearsonasc.co.uk

The Icon

unread,
Apr 13, 2000, 3:00:00 AM4/13/00
to
Already been done, implemented and been running for 12 months at
www.digita.com

In article <8d2if0$qn1$1...@uranium.btinternet.com>,

--

www.fallscountanywhere.com
...wrestling in the real world


Sent via Deja.com http://www.deja.com/
Before you buy.

Mark Carroll

unread,
Apr 13, 2000, 3:00:00 AM4/13/00
to
In article <38f59...@news2.cluster1.telinco.net>,

Adrian Pearson <adrian.deletet...@totalise.co.uk> wrote:
>Why use any software yourself when you can get the whole administrative
>burden of payroll done for about £2 per employee per month? - our
>all-inclusive payroll service includes all end-of -year documentation in the
>price.

Because once you have a competent in-house employee organised with
some software and paperwork, they can normally do a fair few in an
hour: much cheaper. (You'd charge around L2 regardless of whether they
were paid weekly or monthly? 'per month' is a lot less common than
'per payslip'. What about BACS payment, etc.?)

-- Mark [ followups trimmed ]

Tony Wilkinson

unread,
Apr 13, 2000, 3:00:00 AM4/13/00
to
And just what does this £2 per month include? A fully managed service? a
partly managed service? a bureau service?

cheers

Tony

Adrian Pearson <adrian.deletet...@totalise.co.uk> wrote in
message news:38f59...@news2.cluster1.telinco.net...


> Why use any software yourself when you can get the whole administrative
> burden of payroll done for about £2 per employee per month? - our
> all-inclusive payroll service includes all end-of -year documentation in
the
> price.

Bryan K

unread,
Apr 13, 2000, 3:00:00 AM4/13/00
to
"Bryan K" <use...@northwalesonline.freeserve.co.uk> wrote:
> Just to mention in passing that, following a recent conversation in this
> group, I'm mulling over writing a tax and NI calculator as a Java applet -
> stick it on the web, see how many people go out of business....

"The Icon" <the...@my-deja.com> wrote


> Already been done, implemented and been running for 12 months at
> www.digita.com

Checking my pay this month, the tax is £0.09 higher than our system at work
which I know is 100% accurate. The contracted-out NI is £3.86 too much and I
can't help wondering if that is something to do with the employee's rebate.

Maybe someone else in this group would like to check that I'm not going mad.

And of course the cumulative tax is only "coming soon" and it doesn't
provide all the detail required for NI, which at least includes the
employers amount and the rebates. Not much good for an employer wanting to
calculate an employee's pay then.

Oh, and before I forget, the calculator asks for "gross salary". Tax and NI
are not necessarily calculated on gross pay, for example if you are in a
contracted-out pension scheme, or have any kind of expenses reimbursed.
Somebody in any of these situations using this site will see that the
figures disagree with their payslip and quite possibly ring their payroll
section asking why and someone, like me, will have to explain to them that
you can't believe everything you see on the internet! Cheers.

Bryan K

unread,
Apr 13, 2000, 3:00:00 AM4/13/00
to
"Michael Fosong" <Mic...@compufix.demon.co.uk> wrote
> PayrollCalc 2000/1 is written for the majority who aren't and not the
> minority who are NI contracted-out.

Ok, small employers, fair enough. But I do think that seeing as you've gone
to all this effort you may as well go all the way, it's not that hard to
write a program to do contracted-out NI, it's doing PAYE right that is the
real sod. If anyone reading this doesn't know, the book explaining the
calculation routines for PAYE produced by the IR is, IIRC, around 35 A4
pages long.

> >Just to mention in passing that, following a recent conversation in this
> >group, I'm mulling over writing a tax and NI calculator as a Java
applet -
> >stick it on the web, see how many people go out of business....
>

> If I recall correctly you did mentioned this on 29/11/1999 at 21:26
> PM. How far have you progressed with that? I would be very much
> interested in your views/suggestions on implementing those features
> PayrollCalc 2000/1 does not currently support.

Wow, what a memory. Did I really say that? I wrote a Javascript one last
year that did NI (A, B, C, D, E) and tax, although at the time the IR
weren't issuing guidance on how to work PAYE out (yes, really) and it was a
little out on the rounding side. But that was at work, if I do a Java one
then that would be at home so I can do with it as I please. The javascript
language math library is slightly less than perfect I found, if anyone is
remotely interested. I've got a payroll diploma assignment to hand in the
first week in May and a website to run, but I may look at it next month just
to prove the point I guess...

Tony Wilkinson

unread,
Apr 13, 2000, 3:00:00 AM4/13/00
to
What assignment is it?

cheers

Tony

Bryan K <bry...@btinternet.com> wrote in message
news:8d5686$4kh$1...@neptunium.btinternet.com...

Adrian Pearson

unread,
Apr 13, 2000, 3:00:00 AM4/13/00
to
Ł2 per employee per payroll run covers everything -
Calculation/Payslip/Postages/Management Reports/Starters & Leavers/Forms
P35, P14, P60, P38A/Monthly remittance reports/telephone support.

Must 'fess-up though - we have a minimum charge of Ł12 per run ( i.e.
minimum applies up to 6 employees).

I would still argue, and happy clients prove it, that those running a small
business should outsource as many non-core functions as they possibly can.

David Nicholson

unread,
Apr 14, 2000, 3:00:00 AM4/14/00
to
Try £300 for 1 week, tax code 438L, NI code A, also wrong answers.

David Nicholson.

"The Icon" <the...@my-deja.com> wrote in message
news:8d43h5$s1m$1...@nnrp1.deja.com...


> Already been done, implemented and been running for 12 months at
> www.digita.com
>

Mark Carroll

unread,
Apr 14, 2000, 3:00:00 AM4/14/00
to
In article <38f64...@news2.cluster1.telinco.net>,

Adrian Pearson <adrian.deletet...@totalise.co.uk> wrote:
>Ł2 per employee per payroll run covers everything -
>Calculation/Payslip/Postages/Management Reports/Starters & Leavers/Forms
>P35, P14, P60, P38A/Monthly remittance reports/telephone support.
>
>Must 'fess-up though - we have a minimum charge of Ł12 per run ( i.e.
>minimum applies up to 6 employees).

Wow - all told, we charge around a quid per payslip, depending on
specifics. Are we that under the going rate?

Mark.
--
Asquith Burton Ltd; burt...@zetnet.co.uk; tel/fax (01726) 823200

0 new messages