Re: Week Numbers for Tax Year
- From: "mlv" <mike.safetycatchvincent@xxxxxxxxx>
- Date: Fri, 8 Jun 2007 10:25:32 +0100
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-
.
- Follow-Ups:
- Re: Week Numbers for Tax Year
- From: Rick Rothstein \(MVP - VB\)
- Re: Week Numbers for Tax Year
- From: Roger Govier
- Re: Week Numbers for Tax Year
- References:
- Week Numbers for Tax Year
- From: mlv
- Re: Week Numbers for Tax Year
- From: Rick Rothstein \(MVP - VB\)
- Re: Week Numbers for Tax Year
- From: Roger Govier
- Re: Week Numbers for Tax Year
- From: mlv
- Re: Week Numbers for Tax Year
- From: Roger Govier
- Week Numbers for Tax Year
- Prev by Date: Date format
- Next by Date: Hyperlink Query
- Previous by thread: Re: Week Numbers for Tax Year
- Next by thread: Re: Week Numbers for Tax Year
- Index(es):