Payroll Export

In companies where IPS is used as the local payroll application, this feature allows the user to generate specific reports which are commonly used by the Finance / Accounting departments. These reports can be filtered by different levels: Company Code, SBU, Location, and Team, and in some cases, they can be sent directly to the user mailbox.

Since payroll regulations vary from country to country, the Payroll Export reports are configured according the local company requirements. Therefore, specific characteristics, such as report names, layouts and contents may differ from one company to another.

In order to view some of these reports, a component named Crystal must be installed in user's computer (please see IPS welcome page for instructions on downloading this component).

Generating a payroll export report:

Go to Management, select Payroll Management, click on Payroll Export.
Select Pay Period: Select it from drop down menu. User can also click on option 'Custom' to set a date which does not refer to a particular pay period end date.
Set Division / SBUID / Location / Team, or leave an asterisk (*), so that the report includes ALL employees within that level.
Select the the desired report -or reports- by clicking on the corresponding checkbox. Depending on the nature of the selected reports, IPS may allow user to choose more than one report at the time. Some common Payroll Export reports include:
- Payroll Detail - This report is customized to fit the particular local company requirements. Report layout and labels can be shown in company local language, and it may display the following payroll information:
  - Employee earnings
  - Employee deductions
  - Employee net pay
  - Employee worked hours: regular and overtime
- Payroll Export: This report can be customized to fit the particular company local requirements, and it is available at the Company Code level only. Report layout, labels and currency symbols will be shown in company local language. Report may display the following information:
  - Employee earnings
  - Employe deductions
  - Total Net Pay
  - Authotization Signature of Site Manager, Site HR Manager and Site Controller
- Payroll Checks & Deposit - When this report is selected, the system will generate three files including the layout which will be used for bank transactions. The generated files will contain a list of payroll checks issued and direct deposits made. Employees with net pay = 0.00 will be included as well.
  NOTE: For Dominican Republic, this report will include a fourth file named PREPAID-RELATION-DOMR-mmdd-yyyy.csv, listing all employees who will be paid via a prepaid card.
  Employees listed in this file must meet the following conditions, otherwise they will appear in the CHECKS-RELATION file:
  - Pay Type must be Prepaid Card.
  - Employee must have a 16-digit prepaid card number.
  - Employee Status must be Active, or have a Termination Date within the period which had been set for report.
  - Employee pay must be greater than zero (>0.00).
- Payroll Journal - This report contains all pay period payroll expenses which are reviewed by the accounting department. NOTE: If user needs to run this report for current pay period, it will be necessary to run a Payroll Process first, so the pay period employee earnings and deductions are correctly generated. The Payroll Journal may also include benefits accrual, or tax accrual amounts.
  The common columns contained in this report are:
  - Pay Period Date
  - Account Name
  - Debit
  - Credit
Enter a valid email in the 'Return email address' box.
Click on Submit. Depending on which report had been requested, the file will be sent via email, or shown on the next screen.

Related Topics

Payroll Transactions

Freeze HR Transactions

Payroll Process