Date Created: April 24, 2024 Last Updated: Click here to enter a date.
Overview:
Campus Life generates revenue with employees for Cornell Retail store purchases. All employee payroll deduction billing is processed through local systems and fed to the Payroll System. FTC reconciles NetSuite and the payroll transactions and the general ledger to ensure revenue is recorded accurately in the financial statements for the month that the income is earned.
Criticality: High | Frequency: Other | Turnaround: Other |
Employee: The employee signs a contract for technology purchase at a retail location. This initiates an invoice in NetSuite that the employee is responsible for paying. Unit Staff: The unit staff are responsible for creating a contract with the customer and processing transactions in their local system. Payroll Staff: Manage payroll deductions and submit transaction details to FTC for reconciliation. Follow up on contract variances as needed. Financial Transaction Center (FTC): Responsible for the sending new contracts to Payroll and reconciliation of employee receivables in NetSuite and the Payroll Office transactions. Issues identified must be brought to the attention of the Payroll Office so they can be addressed appropriately and corrected. |
|
|
|
Cornell Retail Services Employee Payroll Deduction
|
Key Risks | Key Controls |
Employee leaving university prior to full payment | 1. FTC mails 30/60/90 day reminder letters to former employees to collect outstanding balance. 2. Low collection rate, typically less than 10%. |
Risk of variances between payroll transactions and balance in NetSuite | 1. FTC performs bi-weekly reconciliation to validate fully paid contacts or minor variances in balances. 2. Minor variances are written off and larger variances are researched with the store team. |
Risk of the same individual collecting and authorizing approval for write off | 1. FTC submits the invoice and collection letters to store management and University Controller for write off approval. 2. Back up documentation showing approval is required to be attached to the write off entry. |
Data Security and Privacy: Handling sensitive customer information, such as payment details and personal data, exposes the university to risks of data breaches, and potential FERPA violations. | 1. Access to protected data is limited to only information needed by individual position. 2. All staff who handle credit cards and managers who have staff that handle credit cards reporting to them must complete CASH 200 in CULearn annually for PCI. |
Metrics:
Glossary of Key Terms/Acronyms:
![]()