Payroll database needed

  • Thread starter Thread starter Sammie
  • Start date Start date
S

Sammie

Does anyone know where I can find a database model for paycheck calculation?
I am looking for tax tables, queries & expressions to calculate Federal
withholding.
Thanks
Sammie
 
Sammie said:
Does anyone know where I can find a database model for paycheck
calculation?
I am looking for tax tables, queries & expressions to calculate Federal
withholding.
Thanks
Sammie
Click to expand...

Hi Sammie
If you don't find a database model get Publication 15 from the IRS website.
All the calculations are explained.
Good luck
Harold
 
Does anyone know where I can find a database model for paycheck calculation?
I am looking for tax tables, queries & expressions to calculate Federal
withholding.
Thanks
Sammie
Click to expand...

I would really, really recommend that you NOT try to do this in Access. Tax
and payroll calculations are complex and constantly changing, and a real
programming nightmare to manage.

You can purchase commercial programs which do this - Microsoft Money Home &
Business, Peachtree Accounting, Quickbooks, on and on. These have MANY
person-years of programming and development invested; they provide hot links
to the IRS and (in most cases) to state tax agencies to keep the calculations
up to date. It would be penny wise and pound foolish to try to replicate these
programs' functionality on your own.


John W. Vinson [MVP]
 
Sammie said:
Does anyone know where I can find a database model for paycheck
calculation?
I am looking for tax tables, queries & expressions to calculate Federal
withholding.
Thanks
Sammie
Click to expand...


As someone who used to be responsible for maintaining a payroll app, I would
very much echo John's advice. Don't do it. There are good inexpensive
payroll apps available, I really can't think of any good reason not to use
one of them.

That said, there is a partial model at the following URL ...

http://www.databaseanswers.org/data_models/payrolls/index.htm
 
Back
Top