BIAS Help CenterPayroll PFMLAHow Do I Create PFML Reports?

How Do I Create PFML Reports?

PFML Reporting functionality has been updated in the latest release of BIAS. Please update to the Vulcan 7/8/19 or Rydell 7/8/19 Release.

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

Due to the fluidity of reporting requirements be sure to review this report thoroughly prior to submitting. Reportable hours for salaried employees are estimated. This needs to be reviewed.

PFML Reporting in Advanced Payroll

Go to: Advanced Payroll > Reports > Benefits

  1. Enter date range for quarter needed
  2. Select PFMLA in the Plan Name
  3. Click Generate
  4. Click on Excel button
  1. Click Clear All and Select only the columns needed for reporting. (These are: Rounded Hours, Reportable Wages, Last Name, First Name, Middle Initial, SocialSecNum, Employee Deduction, Town Cost.)
  2. Check Selected Only
  3. Re-order using the move up tool. The order for reporting needs to be SocialSecNum, Last Name, First Name, Middle Initial, Rounded Hours, Reportable Wages, Employee Deduction, Town Cost.
  4. Save the PFMLA report for future use.
  5. Click CSV button. Save CSV file.
  1. Open the CSV 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.
  1. Remove Row 1 containing column names. To do this right click on the row that needs to be deleted and select delete.
  1. Remove employee deduction and town cost columns. Click on the letter G, Right Click, Delete. Repeat with town cost.
  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

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

PFML Reporting in Basic Payroll
  1. Go to 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. Click 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. Remove Row 1 containing column names. To do this right click on the row that needs to be deleted and select delete.
  1. Remove employee deduction and town cost columns. Click on the letter G, Right Click, Delete. Repeat with town cost.
  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

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

0 Comments

Add your comment

E-Mail me when someone replies to this comment