Excel Timesheet Monthly Project by fou24498

VIEWS: 89 PAGES: 16

More Info
									Dear Associate,
Dear Associate,

Please find enclosed a set of Excel based time sheets which have been developed to ease
the invoicing process

These time sheets have been designed to facilitate easy entry of the key data, such as name,
client, relevant dates of the month, etc., so that invoicing on a calendar monthly basis is
achieved.

To avoid unnecessary confusion and possible delays of processing and payment of invoices it
is essential that you only invoice for work days which fall in the current calendar month. Do
not include days from the next or previous months which fall in the same week.

Fill in your name, the client name, the contract number and the date on the first sheet only;
These will be copied through to the other sheets. Then print the timesheets off and use them
as normal.

In particular circumstances, and only where specifically arranged by Snowdon with the client,
this workbook may be used as an electronic timesheet. In other words, the completed
timesheet may be emailed to the client manager who will then forward it to Snowdon together
with his billing authorisation.

Finally, you may be wondering, why six weeks. If the first day of the month falls on a
Saturday, it is possible for the last few days to fall in week 6.

If you have any difficulty with this or if you have any processing difficulties, please email
Phil Marsh at PhilMarsh@SnowdonConsultants.com
Snowdon Consultants Ltd
PTY 6295, P O Box 024725
Miami
Florida 33102                            CLIENT'S
United States                                                       CLIENT NAME
                                          NAME
 CONSULTANT'S
    NAME
                     Your Name          CLIENT PROJECT REF NO.   SC / 0000 / XX01


                                                 CHARGEABLE DAYS            NON-CHARGEABLE
    DAYS                                               TOTAL   CUMULATIVE
                                                                            ACTIVITY   NUMBER OF
                                        LOCATION    CHARGEABLE CHARGEABLE
                                                                             CODE        DAYS
                                                       DAYS       DAYS
      (a)          (b)         (c)         (d)          (e)        (f)        (g)         (h)
SUNDAY
                                                                   0
MONDAY
                                          Place            0       0
TUESDAY
                                          Place            0       0
WEDNESDAY
                                          Place            0       0
THURSDAY
                                          Place            0       0
FRIDAY
1-Sep-2006                                Place            0       0
SATURDAY
2-Sep-2006                                                         0
                                         TOTAL CHARGEABLE
                                               DAYS                0
NON CHARGEABLE ACTIVITY CODES (used in column (g) above)
 DATE W EEK
COMMENCING
                    Fri 1 Sep 2006          To Enter 'Date
                                                 Week
                                          Commencing' date
Consultant's Comments                     data, see this cell
                                          position on Week1
                                              worksheet
                                                9/2006



                                            Enter NAME,
I confirm that the figures shown in
columns (b) to (h) inclusive, represent   REFERENCE and
my activity during this period            CLIENT NAME on
                                              sheet 1
Consultant's Signature




Client's Comments




I confirm that the total shown at the
bottom of column (f) may be invoiced at
the agreed rate.
Client's Signature
Snowdon Consultants Ltd
PTY 6295, P O Box 024725
Miami
Florida 33102                            CLIENT'S
United States                                                       CLIENT NAME
                                          NAME
 CONSULTANT'S
    NAME
                     Your Name          CLIENT PROJECT REF NO.   SC / 0000 / XX01


                                                 CHARGEABLE DAYS            NON-CHARGEABLE
    DAYS                                               TOTAL   CUMULATIVE
                                                                            ACTIVITY   NUMBER OF
                                        LOCATION    CHARGEABLE CHARGEABLE
                                                                             CODE        DAYS
                                                       DAYS       DAYS
      (a)          (b)         (c)         (d)          (e)        (f)        (g)         (h)
SUNDAY
3-Sep-2006                                                         0
MONDAY
4-Sep-2006                                Place            0       0
TUESDAY
5-Sep-2006                                Place            0       0
WEDNESDAY
6-Sep-2006                                Place            0       0
THURSDAY
7-Sep-2006                                Place            0       0
FRIDAY
8-Sep-2006                                Place            0       0
SATURDAY
9-Sep-2006                                                         0
                                         TOTAL CHARGEABLE
                                               DAYS                0
NON CHARGEABLE ACTIVITY CODES (used in column (g) above)
  DATE W EEK
 COMMENCING
                    Sun 3 Sep 2006


Consultant's Comments




I confirm that the figures shown in
columns (b) to (h) inclusive, represent
my activity during this period

Consultant's Signature




Client's Comments




I confirm that the total shown at the
bottom of column (f) may be invoiced at
the agreed rate.
Client's Signature
Snowdon Consultants Ltd
PTY 6295, P O Box 024725
Miami
Florida 33102                            CLIENT'S
United States                                                       CLIENT NAME
                                          NAME
 CONSULTANT'S
    NAME
                     Your Name          CLIENT PROJECT REF NO.   SC / 0000 / XX01


                                                 CHARGEABLE DAYS            NON-CHARGEABLE
    DAYS                                               TOTAL   CUMULATIVE
                                                                            ACTIVITY   NUMBER OF
                                        LOCATION    CHARGEABLE CHARGEABLE
                                                                             CODE        DAYS
                                                       DAYS       DAYS
      (a)          (b)         (c)         (d)          (e)        (f)        (g)         (h)
SUNDAY
10-Sep-2006                                                        0
MONDAY
11-Sep-2006                               Place            0       0           1
TUESDAY
12-Sep-2006                               Place            0       0
WEDNESDAY
13-Sep-2006                               Place            0       0
THURSDAY
14-Sep-2006                               Place            0       0
FRIDAY
15-Sep-2006                               Place            0       0
SATURDAY
16-Sep-2006                                                        0
                                         TOTAL CHARGEABLE
                                               DAYS                0
NON CHARGEABLE ACTIVITY CODES (used in column (g) above)
  DATE W EEK
 COMMENCING
                  Sun 10 Sep 2006


Consultant's Comments




I confirm that the figures shown in
columns (b) to (h) inclusive, represent
my activity during this period

Consultant's Signature




Client's Comments




I confirm that the total shown at the
bottom of column (f) may be invoiced at
the agreed rate.
Client's Signature
Snowdon Consultants Ltd
PTY 6295, P O Box 024725
Miami
Florida 33102                            CLIENT'S
United States                                                       CLIENT NAME
                                          NAME
 CONSULTANT'S
    NAME
                     Your Name          CLIENT PROJECT REF NO.   SC / 0000 / XX01


                                                 CHARGEABLE DAYS            NON-CHARGEABLE
    DAYS                                               TOTAL   CUMULATIVE
                                                                            ACTIVITY   NUMBER OF
                                        LOCATION    CHARGEABLE CHARGEABLE
                                                                             CODE        DAYS
                                                       DAYS       DAYS
      (a)          (b)         (c)         (d)          (e)        (f)        (g)         (h)
SUNDAY
17-Sep-2006                                                        0
MONDAY
18-Sep-2006                               Place            0       0
TUESDAY
19-Sep-2006                               Place            0       0
WEDNESDAY
20-Sep-2006                               Place            0       0
THURSDAY
21-Sep-2006                               Place            0       0
FRIDAY
22-Sep-2006                               Place            0       0
SATURDAY
23-Sep-2006                                                        0
                                         TOTAL CHARGEABLE
                                               DAYS                0
NON CHARGEABLE ACTIVITY CODES (used in column (g) above)
 DATE W EEK
COMMENCING
                  Sun 17 Sep 2006


Consultant's Comments




I confirm that the figures shown in
columns (b) to (h) inclusive, represent
my activity during this period

Consultant's Signature




Client's Comments




I confirm that the total shown at the
bottom of column (f) may be invoiced at
the agreed rate.
Client's Signature
Snowdon Consultants Ltd
PTY 6295, P O Box 024725
Miami
Florida 33102                            CLIENT'S
United States                                                       CLIENT NAME
                                          NAME
 CONSULTANT'S
    NAME
                     Your Name          CLIENT PROJECT REF NO.   SC / 0000 / XX01


                                                 CHARGEABLE DAYS            NON-CHARGEABLE
    DAYS                                               TOTAL   CUMULATIVE
                                                                            ACTIVITY   NUMBER OF
                                        LOCATION    CHARGEABLE CHARGEABLE
                                                                             CODE        DAYS
                                                       DAYS       DAYS
      (a)          (b)         (c)         (d)          (e)        (f)        (g)         (h)
SUNDAY
24-Sep-2006                                                        0
MONDAY
25-Sep-2006                               Place            0       0
TUESDAY
26-Sep-2006                               Place            0       0
WEDNESDAY
27-Sep-2006                               Place            0       0
THURSDAY
28-Sep-2006                               Place            0       0
FRIDAY
29-Sep-2006                               Place            0       0
SATURDAY
30-Sep-2006                                                        0
                                         TOTAL CHARGEABLE
                                               DAYS                0
NON CHARGEABLE ACTIVITY CODES (used in column (g) above)
  DATE W EEK
 COMMENCING
                  Sun 24 Sep 2006


Consultant's Comments




I confirm that the figures shown in
columns (b) to (h) inclusive, represent
my activity during this period

Consultant's Signature




Client's Comments




I confirm that the total shown at the
bottom of column (f) may be invoiced at
the agreed rate.
Client's Signature
Snowdon Consultants Ltd
PTY 6295, P O Box 024725
Miami
Florida 33102                            CLIENT'S
United States                                                       CLIENT NAME
                                          NAME
 CONSULTANT'S
    NAME
                     Your Name          CLIENT PROJECT REF NO.   SC / 0000 / XX01


                                                 CHARGEABLE DAYS            NON-CHARGEABLE
    DAYS                                               TOTAL   CUMULATIVE
                                                                            ACTIVITY   NUMBER OF
                                        LOCATION    CHARGEABLE CHARGEABLE
                                                                             CODE        DAYS
                                                       DAYS       DAYS
        (a)        (b)         (c)         (d)          (e)        (f)        (g)         (h)
SUNDAY
#REF!                                                            #REF!
MONDAY
#REF!                                     Place            0     #REF!
TUESDAY
#REF!                                     Place            0     #REF!
WEDNESDAY
#REF!                                     Place            0     #REF!
THURSDAY
#REF!                                     Place            0     #REF!
FRIDAY
#REF!                                     Place            0     #REF!
SATURDAY
#REF!                                                            #REF!
                                         TOTAL CHARGEABLE
                                          DAYS FOR MONTH         #REF!
NON CHARGEABLE ACTIVITY CODES (used in column (g) above)
 DATE W EEK
COMMENCING
                         #REF!


Consultant's Comments




I confirm that the figures shown in
columns (b) to (h) inclusive, represent
my activity during this period

Consultant's Signature




Client's Comments




I confirm that the total shown at the
bottom of column (f) may be invoiced at
the agreed rate.
Client's Signature
Snowdon Consultants Ltd
PTY 6295, P O Box 024725
Miami
Florida 33102
                                CLIENT'S               CLIENT NAME
United States                    NAME
                                            CLIENT
CONSULTANT'S
   NAME
                    Your Name              PROJECT   SC / 0000 / XX01
                                           REF NO.



    DATE                        DETAILS                              AMOUNT




                                   TOTAL AMOUNT
Consultant's Comments




I confirm that the figures shown in
columns (b) to (h) inclusive, represent
my activity during this period

Consultant's Signature and Date




Client's Comments




I confirm that the total shown at the
bottom of column (f) may be invoiced at
the agreed rate.
Client's Name, Signature and Date

								
To top