This guide explains how to create Pay Slip Detail adjustments for bonuses, commissions, retro payments, and payroll corrections using two primary methods.
⚠️ Important: How "Pay Date" Works
When entering an adjustment, the Pay Date field does not refer to the actual day the employee receives funds (the check date). Instead:
Period Alignment: The date must be a date that falls within the specific payroll period's start and end dates.
Processing Example: If a payroll period runs from Jan 2 – Jan 16 with a final payout on Jan 20, you must enter a Pay Date between Jan 2 and Jan 16 for the adjustment to be processed on the Jan 20 pay date.
Method Comparison: Manual vs. CSV Import
| Feature | Method 1: Manual Entry | Method 2: CSV Import |
|---|---|---|
| Best For | Single, one-off adjustments. | Multiple adjustments at once. |
| Navigation | Payroll Administration → Payroll Activities → Enter One-Off Pay Slip Details. | Payroll Setup → Import CSV Records. |
| Timing | Before payroll is started. | Before payroll is started. Ideal for bulk retro payments or commissions. |
What Happens During a Rollback?
If you need to roll back a pay run, your work is protected for both methods:
Status Reversion: In both manual and CSV instances, the adjustments will return to an unprocessed state.
Automatic Reprocessing: These entries will not be lost; they will automatically pull through again as soon as the pay run is restarted.
Step-by-Step Instructions
Method 1: Manual One-Off Adjustment
Use this for quick, individual corrections.
| Step | Action | Details |
|---|---|---|
| 1 | Navigate | Go to Payroll Administration → Payroll Activities → Enter One-Off Pay Slip Details. |
| 2 | Enter Data | Fill in the Employee, Subtype, Amount, and a Date within the payroll period. |
| 3 | Submit | Click Submit to save the adjustment. |
| 4 | Verify | Toggle to the Existing section on the right to see the saved record. |
Method 2: Bulk CSV Import
Use this to save time when managing high volumes of data.
💡 Viewing Tip: To see the details clearly, click directly on the video to expand it, or right-click and select "Open link in new window" to watch it in full size side-by-side.
| Step | Action | Requirements |
|---|---|---|
| 1 | Prepare File | Create a CSV with headers: Employee, Subtype, Amount, Tax Year Ending, and Created Step (set to "Processing").
|
| 2 | Upload | Import Type: Custom Records; Record Type: Pay Slip Details. |
| 3 | Options | Set Data Handling to Add. Enable Run Server Scripts and Validate Mandatory Fields. |
| 4 | Map Fields | Map CSV columns to NetSuite fields (e.g., Subtype to Pay Component Subtype). |
| 5 | Run & Verify | Select Save and Run. Check the Import Job Status for 100% completion. |
Best Practices for Success
Check Subtypes First: Confirm the correct Type and Subtype under Payroll Administration → Payroll Setup → Pay Component Subtypes before starting.
Test Small: Always test your CSV import with a single record first to catch mapping errors.
Pre-Payroll Review: Review adjustments in the Existing section of the manual entry page before finalized payroll is run.
Error Handling: If an import fails, download the CSV Response file to see specific error messages.