Custom interfaces and data extraction for HR and payroll systems

Professional services for data extraction and reporting

Apptech writes the extracts, reports and interfaces that get data out of HR and payroll systems and to the people and vendors who need it. We work from ADP Enterprise, PeopleSoft, Workday and older in-house systems, for internal use or for outbound files to benefit, 401(k) and garnishment providers.

Interfaces to outside providers

Outbound files that leave your payroll or HR system on a schedule and have to be correct every time.

Benefit carriers

Enrollment, eligibility and deduction files in the layout each carrier requires.

401(k) recordkeepers

Payroll contribution and employee data files, scheduled to run with each payroll.

Wage garnishment processors

Order, deduction and payment data exchanged with the garnishment processor.

General ledger and banks

Payroll journal files for the general ledger, plus ACH and positive pay files for the bank.

Timekeeping systems

Employee data going out to the time clock and hours coming back into payroll.

Extraction and reporting for internal use

Reports for HR, finance and payroll

Payroll registers, audit trails, headcount and cost reports, and statutory filings.

Historical data from retiring systems

Extracting the employee, pay and tax history you need to keep before a legacy system is shut down.

Data for conversions

Extracts that are cleaned and formatted to load into ADP, Workday, PeopleSoft or another target system.

Ongoing extracts

Scheduled files for internal systems, auditors or analysis, without manual exports.

How a project runs

We write in SQR, ADPR, ReportSmith, Crystal Reports, PSQuery, OTBI, BI Publisher, T-SQL and PL/SQL, depending on the system.

  1. 1
    Scope

    We review the source system, the receiving party's file specification and your schedule, then send a written cost estimate.

  2. 2
    Build

    We program the extract or interface in the tools your system uses.

  3. 3
    Test

    We compare the output to your payroll results and test the file with the receiving party.

  4. 4
    Schedule and hand over

    We set the job to run on its own and document it so your staff can support it.

Related services

Tell us what you need extracted or connected

Describe the source system and where the data has to go. We will follow up with questions or a written cost estimate.

Office
Minneapolis, Minnesota
Verify you are human *

Drag the handle until the piece fits. Keyboard: arrow keys, then Enter. Trouble? Call 612-377-2550.