IPG Payroll Interface Xref

Before information can be imported, the following cross-references must be set up in the IPG Payroll Interface Xref option in the browser's FINANCIALS System to translate information being imported to Mediaocean. Cross-references to IPG payroll codes provided from PeopleSoft are set up as well as cross references to accounts used by Mediaocean to make journal entries.

1. Select Financials|Export/Import|IPG Payroll Interface Xref.

2. Key codes as explained below:

Explanation of Column Headings:

Exp/Liab: IPG Codes used to identify expenses and liabilities.

• BE=Benefits Expense. If BE is selected, a Deduction Class Code and a Deduction Code must be keyed to be in keeping with the IPG coding structure. Leave Earnings Code and Tax Class Code fields blank.

• BL=Benefits Liability. If BL is selected, a Deduction Class Code and a Deduction Code must be keyed to be in keeping with the IPG coding structure. Leave Earnings Code and Tax Class Code fields blank.

• EE-=Earning Expense. If EE is selected, an Earnings Code must be keyed. Leave Deduction Class, Deduction Code, and Tax Class fields blank.

• TE=Tax Expense. If TE is selected, a Tax Class code must be keyed. Leave Earnings Code, Deduction Class, and Deduction Code fields blank.

• TL=Tax Liability. If TL is selected, a Tax Class code must be keyed. Leave Earnings Code, Deduction Class, and Deduction Code fields blank.

Earnings Code: (from PeopleSoft, no lookup available): Code used to identify employee earnings. Required if EE is selected from the Exp/Liab drop-down list.

Deduction Class: (from PeopleSoft, no lookup available): Code used to identify the class in which deductions from employee earnings belong. Required if BE or BL is selected from the Exp/Liab drop-down list.

Deduction Code: (from PeopleSoft, no lookup available): Code used to identify the employee deduction. Required if BE or BL is selected from the Exp/Liab drop-down list.

Tax Class: (from PeopleSoft, no lookup available): Code used to identify the class in which tax deductions on employee earnings belong. Required if TE is selected from the Exp/Liab drop-down list.

Account Number: (Required) Account number used by Mediaocean to update the appropriate account when posting.

Account Description: (Display Only) Account description for the Account Number entered and which is used by Mediaocean.

Wildcard: An optional value that can be entered and used to perform internal queries.

3. After keying information, click the Calculator icon to validate your entries and display any error messages. If errors are found, correct errors.

4. To add more entries, select the number you want to add from the Counter drop-down list then click the Add icon. Rows are added according to the number you specified..

5. When finished, click the Save icon to save your entries.

6. Print the IPG Cross Reference Listing to verify your entries.