Sending Payroll Data to Payroll Processor

In situations where companies use a third-party payroll company, it is possible to export payroll information for a given payment period and submit it to the payroll company. This data can be sent to the payroll company as a .txt or Excel file depending on the preferred method. Another option would be using application programming interfaces, or APIs, which are protocols between the main DEACOM application and external software used to ensure data integrity. An API may include specifications for routines, data structures, object classes, and variables. The most common APIs in use are the FedEx and UPS APIs, which support the creation of Shipping Labels during the Sales Order shipment process. For more information on the development, setup, and use of APIs, please contact a member of the Implementation team.

Configuration

The only configuration required is that there are Workers with existing timesheets. For information on these items, refer to the Managing Workers, Entering Worker Time, and Scrubbing and Posting Worker Time pages.

Process

When using DEACOM to track hours for payroll, workers must always be logged into a job, so that all hours are accounted for. Administration jobs should be used for times when a worker in on the clock, but not logged on to a production job. These jobs can be created for activities such as morning stretching, and paid breaks.

  1. Navigation to Production > Payroll Reporting.
  2. On the pre-filter, select a report type of "Job Payroll Summary" or "Job Payroll Detail", depending on the information required by the payroll processing company.
  3. Select appropriate values in the "Start Date" and "End Date" fields.
  4. Choose the correct value in the "Display" field. The default value is "Non-posted". Typically, this report would be run using posted time, which has been reviewed and approved by supervisors.
  5. Click the "View" button to display the report.
  6. Click the "Export" button.
  7. The system will display a "Save As" window allowing the user to choose where they text file will be saved.
  8. Select the appropriate locations and click the "Save" button.
  9. The system will display a confirmation prompt with the location the file was saved to specified.
  10. Click "Ok" to close the prompt and complete the process.

FAQ & Diagnostic Tips

How do I export the payroll data to excel instead?

Click the excel icon instead of the export button and it’ll report the payroll data to excel instead.