Payroll database needed

[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

 

[Harold Druss]

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

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

 

[John W. Vinson]

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

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]

 

[Brendan Reynolds]

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

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