Re: Week Numbers for Tax Year

Hi Mike

Although I said I used Sage for a quick check up (saved me hunting
around the IR website), Sage operate exactly as per the IR Rules, which
is the same as Rick and I did when compiling our formulae.

ISO tax weeks have week 1 as the first week which contains a
Thursday.This year, Ist Jan happened to be a Monday, hence the start of
ISO week 1 was 01 Jan 2007. Had 1st Jan occurred on a Friday, then week
1 would have started on 04 Jan 2007.

You cannot therefore use a constant offset for Tax week number compared
with ISO week number.
The Tax week numbering always starts from 6th April in the every year,
regardless of which day of the week that happens to fall upon. For 2007,
it happens to fall on a Friday.

--
Regards

Roger Govier


"mlv" <mike.safetycatchvincent@xxxxxxxxx> wrote in message
news:f4b7ac$4d8$1@xxxxxxxxxxxxxxxxxxxx
Roger Govier wrote:

How do you calculate that?
I just loaded Sage Payroll, and for 07 Jun 2007 it gives Tax week 9.
As Sage is probably the widest used payroll package in the UK, I
don't think they will have got it wrong<g>
Tax week 10 commences on 08 Jun 2007

I accept I may have lost the week number plot :-)

Some more information:

This week number routine is required for an Excel invoice *** that I
use. I always use ISO week numbers on my invoices (this week is ISO
week 23).

My main client says they use Tax Year week numbers, but it seems that
their system assumes that the week with 1 April in it (ISO week number
13) is Tax Year week 1. This week (ISO week number 23) would then
become my client's Tax Year week number 11.

If we accept that the week with 6 April 2007 in it (2 - 8 April, ISO
week number 14) is the first week of the new Tax Year, then this week
(ISO week number 23) must be Tax Year week number 10.

However, (according to Sage) it seems that the week with 6 April 2007
in it is considered to be the last week of the old 2006-07 Tax Year,
and ISO week number 15 (9 - 15 April) is the first week of the new
2007-08 tax year. This week (ISO week number 23) then becomes Tax Year
week number 9.

I suppose it doesn't help that ISO week numbers run from Monday to
Sunday, whilst Tax Year week numbers appear to run from Friday to
Thursday (if Tax week 10 commences on Friday, 08 Jun 2007, as stated
above).
--
Mike
-Please remove 'safetycatch' from email address before firing off your
reply-





.