Käynnissä

Payroll System

A fully functioning payroll system developed in ACCESS to handle input files and process various payroll taxes, deductions, allowances, payslips and accounting analysis reports.

Every period we receive an excel file downloaded from quickbooks online, showing hours worked on each day in the period for each employee. The system should upload this file based on the period and not duplicate any entries. If an entry does not find an employee record then we should receive a report to add the employee etc.

We have sumbitted specs using an access database to show information we need to capture, you are free to create tables, forms, queries etc. using good programming conventions/syntax.

We will need the source code for future minor modification if necessary.

WORKFLOW

Input

- excel file from Quickbooks Online

o Activity Date - ActivityDate

o Employee - Employee

o Product/Service - PaymentSchedule

o Duration - Duration

File is usually for specific pay period (either 1st to 15th of month, or 16th to end of month) but may be for different period.

Check for duplication in upload and prevent duplication – report for action by user.

Tables

See sample database. [url removed, login to view]

Processing

Gross pay

NIS

PAYE

Net pay

See query “qryEmployeeTaxNISCalc”

Output

• Payslips – see Report “rptPayslips”

• Payroll details report to be exported to excel:

o Employee – FirstName, LastName

o Position

o Rate

o Regular hours

o Overtime hours

o Sick hours

o Sunday hours

o Holiday hours

o Vacation hours

o Other hours

o Special hours

o Total hours

o Gross pay

o NIS employee

o PAYE

o Other deductions

o Total deductions

o Net pay

• Payroll export file – see table “tblDBFormat-Header”, “tblDBFormat-Detail”, “tblDBFormat-Trailer”. This file will be used by the recfeiving bank to upload amount to pay employees by direct deposit.

Forms

- need professionally-designed forms to allow changes to all the tables

Taidot: .NET, tietojenkäsittely, Excel, testaus/laadunvarmistus, Visual Basic

Näytä lisää: visual workflow, visual basic programming service, visual basic online programming, total bank, taxes accounting, syntax programming, rate visual basic, programming conventions, payroll system sample excel, payroll processing excel, payroll position, payroll online free employee, payroll 1, online payroll accounting, online accounting system, online accounting service, free accounting system, free accounting excel, find good employee, excel programming online, excel add programming, excel access programming, employee find, direct file upload, programming syntax

About the Employer:
( 3 reviews ) Christ Church, Barbados

Projektin tunnus: #475584