Question Payroll Program

[access2010]

Hello, I volunteer at a charity that has to start using a payroll database program in the New Year.

The program is to keep track of;
- the weekly hours worked by each employee (ie: 20 hours)
- calculate the gross employee wages (ie: 20 x 10 = $200.00)
- add the three different taxes together (ie: A-$5.00 + B-$6.00 + C-$7.00 = $18.00)
- deduct from the gross wages the deductions (ie: $200.00 - $18.00) = $182.00 which is the employee's pay cheque for the week

At the end of each month create a report of all employee deductions to be remitted to the different government ministries
A - $5.00 + + + =$ remittance
B - $6.00 + + + =$ remittance
C - $7.00 + + + =$ remittance

At the end of the year create a report spreadsheet of each employee's wages and the deductions that have been remitted to the government.

Can we receive some suggestions on a MsAccess 2003 database program that we can use for this project?

Your suggestions are appreciated

 

[RuralGuy]

Even though they are not cheap, I would strongly suggest you invest in a professional payroll program such as Sage ot QuickBooks.

 

[access2010]

Thank you for your suggestion, but all of the other applications use MsAccess 2003 and the group would like to continue with their payroll system using access.

 

[gemma-the-husky]

not sure if you are in US or UK - i suspect US, as the deductions you mention dont seem like UK taxes.

Certainly in the UK, I would heartily discourage anyone trying to write a payroll programme that calculates tax, and other stoppages. There are myriads of special rules, and the rules change once or twice each year, in each govt budget.

The downside of getiing this wrong is too horrendous to comtemplate (ie any errors come back on the employer - not the employee), and if you are inexperienced, it will take you far longer in time than it would to buy a ready made package.

Even if you are competent, it would still take longer than buying a package, allthough it is not so hard technically, and there are some reasons why you still might want to go ahead. Since you are asking questions, I assume you need help

The only reasons for developing something are really
a) you believe you can re-sell the product, or reuse the code etc and/or
b) there is no appropriate commercial application

This is unlikely to apply in your case.


Therefore, my serious advice is still not to try to build a payroll package. They arent that expensive, to be honest.

 

[access2010]

Thank you for your note, the charity that I volunteer at is in Toronto Canada and they do not want to use a manual or Excel spread sheet as they had problems with their previous government remittances.

They are hoping to be able to manually enter;
Employees hours worked # [ 20 ] X the rate of pay [ $10.00 ] and have a gross amount of $200.00

Add the three different taxes together (ie: A-$5.00 + B-$6.00 + C-$7.00 = $18.00)
Deduct from the gross wages the deductions (ie: $200.00 - $18.00) = $182.00 which is the employee's pay cheque for the week.

Than at the end of the month send each of their employee’s remittances to the government

Yes, I can do the above in excel for them, but the office manager wants an MsAccess program.

Any idea as to where I could buy this type of program as a donation to the group?

 

[NigelShaw]

hi

i would look at sage as this can be accessed by access in the sense of, a 3rd party addin created for sage that allows access to post invoices & transactions to its database removing the manual input.

My quoting system does this very well and that is access based though not created by me.

nidge

 

[DRM54]

Hi

This link might be useful http://www.functionx.com/vbaccess/Lesson26.htm

Regards,

David