A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do you do payroll on excel 2007



 
 
Thread Tools Display Modes
  #1  
Old June 18th 09, 04:54 PM posted to microsoft.public.excel.newusers
Geneo
external usenet poster
 
Posts: 1
Default How do you do payroll on excel 2007

When I did spreadsheets in class they never tought us how to do payroll. Well
now I have an assignment doing payroll and I am needing help with it. I am
needing to know how to do an excel 2007 payroll on one employee. Can anyone
show me an example of how to do one?
Ads
  #2  
Old June 18th 09, 05:01 PM posted to microsoft.public.excel.newusers
Eduardo
external usenet poster
 
Posts: 2,276
Default How do you do payroll on excel 2007

Hi
Look into the Microsoft templates

http://office.microsoft.com/en-ca/te...roll&av=TPL000

if you want information on Timesheet look into CPearson web
http://www.cpearson.com/excel/overtime.htm

If this helps please click yes, thanks

"Geneo" wrote:

> When I did spreadsheets in class they never tought us how to do payroll. Well
> now I have an assignment doing payroll and I am needing help with it. I am
> needing to know how to do an excel 2007 payroll on one employee. Can anyone
> show me an example of how to do one?

  #3  
Old June 18th 09, 06:17 PM posted to microsoft.public.excel.newusers
Gordon[_9_]
external usenet poster
 
Posts: 56
Default How do you do payroll on excel 2007


"Geneo" > wrote in message
news
> When I did spreadsheets in class they never tought us how to do payroll.
> Well
> now I have an assignment doing payroll and I am needing help with it. I am
> needing to know how to do an excel 2007 payroll on one employee. Can
> anyone
> show me an example of how to do one?



Because there are state and/or country taxes involved in Payroll this is not
really the place to get help. A template may not be of much assistance
either as has been suggested - it all depends on where you reside, which you
didn't tell us.
Payroll is NOT a simple thing. I suggest you go to see a commercial
accountant who will be able to help you far more than any newsgroup.

  #4  
Old June 18th 09, 08:41 PM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 2,204
Default How do you do payroll on excel 2007

I suspect the solution may not be quite so complex (I had the same thoughs
about taxes, withholding, and other deductions) but then I realize the OP is
talking about a classwork assignment, which presumably is not in an
accounting class. Probably needs basic hours worked x pay rate type setup.
Which the templates and site that Eduardo pointed to should help him with
quite well.

Geneo: typically we don't actually do homework for folks in these forums; it
defeats the purpose of the class. As Eduardo has done, and also Gordon,
we're happy to point you to potential solutions and occassionally give a
little help in getting over some rough spots.

For some help with the 'rough spot' he the templates should give you the
example of how to set things up to record/calculate time worked and then
compute wages earned from that.

"Gordon" wrote:

>
> "Geneo" > wrote in message
> news
> > When I did spreadsheets in class they never tought us how to do payroll.
> > Well
> > now I have an assignment doing payroll and I am needing help with it. I am
> > needing to know how to do an excel 2007 payroll on one employee. Can
> > anyone
> > show me an example of how to do one?

>
>
> Because there are state and/or country taxes involved in Payroll this is not
> really the place to get help. A template may not be of much assistance
> either as has been suggested - it all depends on where you reside, which you
> didn't tell us.
> Payroll is NOT a simple thing. I suggest you go to see a commercial
> accountant who will be able to help you far more than any newsgroup.
>
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
we have 200 people how can we do the payroll in excel Masasa Excel Discussion (Misc queries) 1 September 6th 07 11:36 AM
Adding payroll stubs payroll calculator Sable New Users to Excel 2 August 5th 06 05:37 PM
Payroll Calculator Excel Template Eagle View Excel Discussion (Misc queries) 0 May 1st 05 02:38 AM
Templates Excel Payroll Raj Excel Worksheet Functions 1 March 2nd 05 09:22 PM
use of excel for payroll Juan Otto Excel Worksheet Functions 1 November 20th 04 06:11 AM


All times are GMT +1. The time now is 01:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.