473,903 Members | 3,390 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Payroll DB

Hi all,
New to Access......
Trying to create a payroll database for employees
who are paid on the 1st and the 15th of the month.
This is quite different than every 2 week pay periods.

Employees work all hours of the day, any day of the
week, depending on their assignment, and this can change
from day to day. But employees must remain under
40 hours per week. The 1st and 15th pay periods,
of course, lead to carryover hours from one week
to the next. This needs to be tracked to avoid overtime.

As an added twist, some employees work in multiple
categories at differing rates of pay during any given week.

Any pointers, ideas or clues?

Thanks!

Mark
Nov 13 '05 #1
4 1952
Per Mark T.:
As an added twist, some employees work in multiple
categories at differing rates of pay during any given week.

Any pointers, ideas or clues?


My first reaction is that payroll sounds like such a bread-and-butter
application that there must be hundreds - if not thousands - of off-the-shelf
applications that can do it cheaper, faster, and better than one person can.

The one payroll app that I've done was extremely complicated (state/local taxes,
various withholdings, special payments, medical coverage, direct deposit....the
list goes on).

Something like that can eat you alive - and often for no good reason bc there's
a canned solution that will do 90% of what the users want for 5% of the cost of
rolling your own.
--
PeteCresswell
Nov 13 '05 #2
Hi Pete,
Thanks for the info. I'm pretty sure that Peachtree
or something else could do it. We don't internally
process the taxes, etc. We sub that out to a payroll
company. All we do is compile hours
in various categories at different rates of pay for
multiple employees, from time sheets they fill out
in the field and fax over. We do this internally so that
we can audit the managers who sign off on the timesheets
and ensure accuracy / validity.
Example:
Sam worked 5 hours at B House on Tues. the 3rd
and 7 hours on Friday the 6th @ $12.00 / hr.
Sam also worked 2 hours at C House on Tues. the3rd.
at $11.25 / hr.
He also worked 2 hours at D House on Tues. the
3rd @ $13.75 per hour.
This happens with about 100 employees working
on various assignments.

Thanks again,
Mark
Nov 13 '05 #3
Per Mark T.:
employees
who are paid on the 1st and the 15th of the month.
This is quite different than every 2 week pay periods.

Employees work all hours of the day, any day of the
week, depending on their assignment, and this can change
from day to day. But employees must remain under
40 hours per week. The 1st and 15th pay periods,
of course, lead to carryover hours from one week
to the next. This needs to be tracked to avoid overtime.


In the couple of apps I've done like that, it's been:

tblEmployee
tblTimeSheet
tblHours
tblPayPeriod

With supporting tables like:
tblDepartment
tlkpCostCenter
tlkpHoursType
tlkpJobCode
tlkpHoursTypeDi fferentialFacto rs

Employees have TimeSheets: one for each pay period.

A TimeSheet has PayPeriodID, plus other ingredients added to the user's taste
like ApprovedBySuper visor, ApprovedByPayma ster, PaymentMade, CheckNumber,
DirectDepositCo ntrol#, and so-forth.

PayPeriods have a PayPeriodID (PK), PayPeriodNumber , and PayPeriodDate.

An hours record has HoursType, DateWorked, NumberOfHours, HourlyRate, and a
bunch of other stuff, depending on what is desired.... like WorkLocation,
StartTime, and so-forth.

Seems to me that as long as you have the date for every hour worked, you can do
40-hour/week validation, even on a rolling basis...
--
PeteCresswell
Nov 13 '05 #4
Per (PeteCresswell) :
An hours record has HoursType, DateWorked, NumberOfHours, HourlyRate, and a
bunch of other stuff, depending on what is desired.... like WorkLocation,
StartTime, and so-forth.


The one 'gotcha' is a pivot-table presentation of hours. Generally, the
timekeeper or other user wants a pay period's hours presented in a seven-column
grid where columns are Monday, Tuesday, Wednesday, and so-forth. In the
two-week period that would expand to 14 columns - more or less depending on
end/beginning year periods.
--
PeteCresswell
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
8682
by: Randi | last post by:
Hi, Looking for some help with this payrool project I have for class. This is what the instructor asks for so far. I have it working without errors but am getting some funky numbers. I am not sure if they would be correct anyways. Below is the instructions. and below that is what I have. Any tips or hints would be highly appreciated. Regards, Kelsey
0
1474
by: zexx | last post by:
Need some advise.... Payroll program Access97. Payroll is printed then posted to a hx table thro' a query with the payroll calculations that freeze that payroll's numbers for that period. The weekly payroll period reports are produced from the Payroll table by queries that are linked to the Employee details table...salary, base rate, lead rate, wh allowances, status etc...so this is real time data with the current information in the...
1
1936
by: kgatchell2001 | last post by:
Hello, I am using Access 2002 to track payroll. I am trying to carry a person's Sick time accrued into the next record for an individual. I am a beginner with access. I am using the following terms: SickUsed: Sick time used in a given pay period. (Cannot exceed SickAccumulated)
1
5329
by: cheungs7 | last post by:
Hi all, Wondering whether you can anyone help me. We have Sage Payroll (and accounting/payroll software), which has a MS Access database where the data is stored. Now I want to access the data in this database but whenever I do (without using the Sage payroll client application) I get a permission problem. Now I have the correct username and password, and I tried importing it in a new Access database, but with no luck. Maybe I'm...
1
1593
by: Akinyemi | last post by:
I am developing a payroll program.. The data generated will be saved in an Access Database. I want a situation whereby when an employee leaves the organization or retires, instead of deleting his name from the Payroll it is made INACTIVE. This is to ensure that his/her name does not appear in subsequent payroll.
8
2932
by: John Sitka | last post by:
Hi, There are four pay types standard shiftpremium doubletime doubletimepremium each hour a person books can be one of these types
1
1626
by: Akinyemi | last post by:
I have almost finished writing my Payroll Program. But I am wondering how the program can be used for different months. For example, after, say January 2007 Payroll, the user would want to prepare February 2007 Payroll. How will the user close January payroll and then start that of February? I cannot figure out how to write the Program for that. Please kindly help me. Thank you. Akinyemi.
0
1298
by: sajithamol | last post by:
In perspective of PeopleSoft what is the basic difference between the Pay roll of North America and Global payroll? Are there any possibilities that Global payroll applied to U.S.A?
4
8577
by: jnce | last post by:
hi everyone! im a student and im trying to make a basic employee payroll system using ms access 2007. can anyone give me an idea on how to create a employee payroll system using ms access 2007... all i just need is a background on how to start them, what should i include and put on my table and a little idea on how to pay the employee using access 2007..
0
9847
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10875
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10501
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9685
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5894
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6093
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4727
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4308
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3324
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.