Skip to main content

Step 4: Create SSP Period Linking - Basic Timesheet (CSV Import)

Overview

Once individual SSP time entries have been created (Step 3), they must be linked using Period Linking Basic Timesheets. These records are the "intelligence" behind NetSuite's SSP engine, enabling:

  • Linking of sick periods separated by 8 weeks or less.

  • Calculation of the remaining 28-week entitlement.

  • Application of Average Weekly Earnings (AWE).

Step 1: Prepare Your CSV File

To ensure proper mapping, use the following headings exactly as they appear in the template.

Template Rules

  • Yellow columns: You must provide this data for each row.

  • Green columns: Predefined values – must NOT be changed.

📎 How to get the template: Scroll to the Attachments section at the very bottom of this page to download UK_SSP_Period_Linking_Template.csv.

Field Requirement Table

Field Name Data Value Format/Notes
Employee 428 Internal ID
Pay Period Monthly Matches Payroll Cycle
Period Start Date 3/1/2026 M/DD/YYYY or M/D/YY
Period End Date 3/31/2026 M/DD/YYYY or M/D/YY
Time Type Statutory Sick Pay (SSP) Exact List Value
Hours 22.5 Total hours for period
Days 3 Total SSP days
Processed Yes (Imports as TRUE)
No. of Weeks 0.6 Calculation: 3 \div 5 (if 5-day week)
NS Time Records

547241|547242|547243

 

Note no spaces around pipes
SSP Entitlement Weeks 27.4 Remaining balance (28-0.6)
SSP AWE [If Leave Blank] Will use employee salary data
⚠️ Critical: Formatting NS Time Records

This field links the time entries from Phase 1 to this summary record.

  1. Find IDs: Run the PR – Payroll Time Records Results report.

  2. Format: Use a pipe separator without spaces before and after: ID|ID|ID.

  3. Result: 547341|547342|547343

Step 2: Import into NetSuite

Access the CSV Import Assistant via your assigned role.

  • Payroll Administrator Role: Payroll Administration → Payroll Setup → Import CSV Records.

  • Administrator: Setup → Import/Export → Import CSV Records.

Import Settings

Step Action Required Settings Visual / UI Reference
1 Scan & Upload

Import Type: Employees


 

Record Type: Basic Timesheet
2 Import Options

Data Handling: Add


 

Form: Standard Basic Timesheet
3 File Mapping Ensure all CSV columns align with NetSuite fields.
4 Field Mapping Map Employee to Internal ID (click the ✏️ icon).
SSP_ph2_ID.gif
5 Save & Run Name: UK_SSP_Period_Linking_Import
SSP_Save_Run.gif
 

Step 3: Validation & Troubleshooting

After the import is complete, navigate to Employee → Time Tracking / Basic Timesheets to confirm:

  • Linking: The NS Time Records field is populated.

  • Calculation: The number of weeks is calculated correctly.

  • Balance: Entitlement weeks are updated (e.g., if a user had 28 weeks and you imported 1, the balance should show 27).

  • Date Format:

    • ⚠️ Important Note on Date Formats: > The required format for Period Start/End Dates depends entirely on your specific NetSuite Configuration Preferences. Ensure your CSV file matches the date format set in your User Preferences (e.g., DD/MM/YYYY or MM/DD/YYYY) to avoid import rejection.

BS TS validation.gif

Common Troubleshooting

  • Periods not linking: Check for extra spaces around the pipe (|) symbol in your CSV.

  • Incorrect Entitlement: Validate the No. of Weeks calculation against the employee's working pattern.

  • AWE Issues: If AWE is blank, ensure the employee has 8 weeks (weekly) or 2 months (monthly) of historical payslip data in NetSuite.

🎥 Video Walkthrough

For a step-by-step visual demonstration of the mapping and import process: 👉 Link: Period Linking CSV DEMO

Next Step: Once validated, these records will automatically drive the SSP payment amounts in your next payroll run.

Related to

Was this article helpful?