SB Express Help Center

How Do I Create PFML & Long Term Care Reports?

Updated on

*** Please note:  If the basis for LTC is different than the PFML basis, one of 2 things happened. ***

1.  Was Long Term Care deducted from employee's paychecks starting July 1st, regardless of when the hours were actually worked? If there was no deduction the first payroll of July, this will cause the long term care basis to be different than PFML. The district or city or town is responsible for what wasn't deducted from employee's paychecks.

2. Maybe PFML has a custom earning item basis that's different than LTC's earning item basis. In the payroll setup, under benefits and deductions, click on PFML then click the Custom Basis button toward the top of the window. Is the Custom Basis earning items blank or does a list of earning items come up?

If the earning items are blank (Image 1 below), exit the custom basis, click the LTC deduction and click custom basis and make sure the LTC custom basis is also blank.

If earning items are listed (image 2 below) when the custom basis button is clicked under PFML, click the selected head to sort the list then make note of all the earning items selected. Exit the Custom Basis window, click the Long Term Care deduction then click Custom Basis. Make sure the same earning items that were selected under PFML are also selected under Long Term Care list of earning items in the custom basis.  

If any help is needed, please contact support.

PFML Reporting functionality has been updated in the latest release of SBX. If you're an on-prem user, please make sure your program is on the latest update. From the program, choose Help>About SBX. Make sure the version is at least date on or after 8/22/2023

For information related to reporting PFML please visit the paid leave website https://paidleave.wa.gov/reporting

PFML/LTC Reporting in Advanced Payroll

Please note: The WA State Employment Security Department wants PFML and Long Term Care (LTC) filed together in one CSV file. In the program, the payables for PFML and LTC are created separately.

Go to: Advanced Payroll > Reports > Benefits

  1. Enter date range for quarter needed
  2. Enter PFMLA or PFML (the name your entity calls the PFML deduction in the program)
  3. Click Generate
  4. Click on Excel button

If you've saved the PFML Export report in a previous quarter double click the report name, verify the selected fields and click the CSV button the skip to step 10. If there isn't a saved report, continue to step 5. (If this is the first time including LTC in the PFML Export, there are additional fields needed for the Export. The additional fields are Exempt and DOB.

5.  Click Clear All and Select only the fields needed for reporting. (These are: EmployeeSocialSecNum, EmployeeLastName, EmployeeFirstName, EmployeeMiddleInitial, vRounded Hours, mReportableWages, Exempt and DOB. )

6.  Check Selected Only

7.  Re-order using the Move_Up or Move_Down tool. The order for reporting needs to be EmployeeSocialSecNum, EmployeeLastName, EmployeeFirstName, EmployeeMiddleInitial, vRoundedHours, mReportableWages, Exempt and DOB.

8.  Save the PFMLA report for future use.

9.  Click CSV button. Save CSV file.

10. In the Print Name column, name the EmployeeSocSecNum to SSN

  1. The CSV File should automatically open for editing. If it doesn't open, find the file and open the file and edit the file.

Before preceding any further, review hours and wages for accuracy. Salaried employee hours are estimated based on 160 hours worked per month. Make any changes needed. It is critical that this report is reviewed prior to submission.

  1. Remove employee rows that are not applicable (i.e. volunteers or 0 hours or wages). To do this right click on the row that needs to be deleted and select delete.

13.  Add 2 decimal places to the wages (column F). To do this click on letter F to highlight entire column.

14.  Click on Increase Decimal button. Make sure that all wages go out to 2 decimal places.

15.  After formatting save file and close CSV file.

16.  Repeat this process if additional quarters are needed.

17.  To test this file prior to submission go to https://paidleave.wa.gov/reporting/ and log in.

18.  The CSV file should be uploaded to the https://paidleave.wa.gov/reporting site by logging into their site and filing the quarter's report. This files both the PFML and the LTC reporting information.

19. Return to the Benefits Splits window and click the Create AP button to create the PFML AP.

The next step is to create the payable for Long Term Care or LTC.

1. From the Benefits Splits window, double check the dates and choose WA Cares or LTC or Long Term Care or whatever name your entity named the benefit/deduction.

2. Click Generate

3. Create AP.

If needed, make corrections to the Accounts Payable entry to correct for any rounding differences between BIAS and Employment Security numbers.

PFML/LTC Reporting in Basic Payroll

Please note: The WA State Employment Security Department wants PFML and Long Term Care (LTC) filed together in one CSV file. In the program, the payables for PFML and LTC are created separately.

  1. Go to Basic Payroll > Reports > Benefits Splits
  1. Enter date range for quarter needed
  2. Select PFML in the Plan
  3. Click Generate
  4. Click Employee Totals
  1. Click on Export to Excel
  1. Select the following fields: mtSS#, LastName, FirstName, Middle Initial, Rounded Hours, Wages, Exempt and DOB
  2. Click Selected Only
  3. Use the Move Up or Move Down buttons to arrange the fields in the order shown below
  4. Rename mtSS# in the Print Name field to SSN
  5. Click the CSV button
  1. Open CSV File

Before preceding any further, review hours and wages for accuracy. Hours are pulled in exactly as they were entered. Make any changes needed. It is critical that this report is reviewed prior to submission.

  1. Remove employee rows that are not applicable (i.e. volunteers). To do this right click on the row that needs to be deleted and select delete.
  1. Add 2 decimal places to the wages (column F). To do this click on letter F to highlight entire column.
  2. Click on Increase Decimal button. Make sure that all wages go out to 2 decimal places.
  1. After formatting save file and close CSV file.
  2. Repeat this process if additional quarters are needed.
  3. To test this file prior to submission go to https://paidleave.wa.gov/single-employer-filing
  4. Exit the Export Benefits Window in SBX
  5. Exit the Employee's Window in SBX
  6. Click Create AP's.
  1. From the Benefits Splits window, choose the Long Term Care plan (LTC, WA Cares, whatever your entity calls it).
  2. Click Generate
  3. Verify that the amount is correct and print then click the Create AP's button

If needed, make corrections to the Accounts Payable entry to correct for any rounding differences between SBX and Employment Security.

Previous Article How Do I Create PFML In Basic Payroll
Still Need Help? Contact Us