Skip to the main content of the page

Modernization

​​​​​​​​​​​​
Frances Online has replaced the Oregon Payroll Reporting System (OPRS) and Employer Account Access (EAA). Go to Frances Online now to get started!​​​

​File Specifications

IMPORTANT: Please review the example tab in each file format to ensure your file matches the example format. In addition, make sure your column headings are labeled appropriately to avoid errors when importing your file. 

Special Cases: Bulk File Specifications

​Bulk File Specifications: BulkSpreadsheetSpecswithexamples.xlsx

  • ​​Description: File specifications for Third Party Administrators who currently or have in the past uploaded multiple reports through the FTP process. This file specification in Frances Online will allow you to import the payroll reports without being associated to the clients. 
  • Please note: You must have an account created as a Third Party Administrator (TPA) to use this file specification.
Multiple BIN/Businesses File Specifications 
  • ​EFW2 File Specifications: MultiEFW2SpecswExample.xlsx
    • ​Description: File specifications using the EFW2 format to import reports for multiple BIN/businesses into Frances Online.
  • Fixed Width File Specifications: MultiFixedWidthSpecswexample.xlsx
    • ​​Description: File specifications using the Fixed Width format to import reports for multiple BIN/businesses into Frances Online. 
  • Excel File Specifications: MultiExcelSpecswexample.xlsx
    • Description: File specifications using the Excel format to import reports for multiple BIN/businesses into Frances Online. 
  • Comma Separated Value (CSV) File Specifications: MultiCommaDelimitedSpecswExample.xlsx
    • Description: File specifications using the Comma Separated Value format to import reports for multiple BIN/businesses into Frances Online. ​
Employer File Specifications 
In most cases, Employer designations file for a single BIN/business at any one time.

Important information: 
You will only be able to import the Form 132-Employee Wage Detail if the account you created is designated as an Employer.

File Naming Requirement: The file does not require any specific naming convention, however the tab must be named EmployeeDetailReport.

  • 2022 Employer-Single BIN CSV Form 132 Specifications: 2022 Employer CSV Specs wexample.xlsx
    • ​Description: File specifications using the CSV format to import reports for a single BIN/business into Frances Online.​
  • 2022 Employer-Single BIN Excel Form 132 Specifications: 2022 Employer Excel wexample.xlsx
    • ​Description: File specifications using the Excel format to import reports for a single BIN/business into Frances Online.​
  • 2022/2023 Employer-Single BIN EFW2 Form 132 Specifications: Employer_EFW2_132_Specs.xlsx
    • ​Description: File specifications using the EFW2 format to import reports for a single BIN/business into Frances Online.​
  • 2023 Employer-Single BIN CSV Form 132 Specifications: 2023 Employer CSV Specs Wexample.xlsx
    • ​Description: File specifications using the CSV format to import reports for a single BIN/business into Frances Online.
  • 2023 Employer-Single BIN Excel Form 132 Specifications: 2023 Employer Excel wexample.xlsx
  • ​Description: File specifications using the Excel format to import reports for a single BIN/business into Frances Online.​

Domestic Employer File Specifications 
In most cases, Domestic household employers with employees doing only in-home services may file the comibined payroll tax reports annually using Form Oregon Annual (OA) Domestic. 
  • 2022 OA 132 CSV Specifications: OA_2022_132_CSV_Specs.xlsx
    • ​Description: File specifications using the CSV format to import reports for a Domestic filing into Frances Online.​
  • 2022 OA Excel Specifications:  2022 132 Domestic Excelwexample.xlsx
    • ​​Description: File specifications using the Excel format to import reports for a Domestic filing into Frances Online.​
  • 2023 OA 132 CSV Specifications: OA_2023_132_CSV_Specs.xlsx
    • ​​Description: File specifications using the CSV format to import reports for a Domestic filing into Frances Online.​
  • 2023 OA Excel Specifications: 2023 132 Domestic Excelwexample.xlsx
    • ​​Description: File specifications using the Excel format to import reports for a Domestic filing into Frances Online.​
​​New Client Template
    • Download the Bulk New Client Template now to prepare your client list for Frances Online.

Project Updates

Read the latest Modernization Updates here and download past ones you may have missed.​​

Need help getting started with Frances Online?

​​​Visit our Help and Support page
to learn about things like creating an account and filing your payroll report.​






​​​​​Need Help?

icon.jpg
Our team is here to help you!

Phone: (503) 947-1488

Email: Contributions.Unit@employ.oregon.gov​


​Address:
Oregon Employment Department
875 Union St. NE
Salem, Or 97311-0024​​​