Skip to main content
J
jennrobe
January 9, 2020
Question

Oregon Form 132 Export

  • January 9, 2020
  • 4 replies
  • 0 views

Is there a way to export the info needed for Oregon Form 132 from QuickBooks.  Although QuickBooks prepares the form the State requires the info to be entered into their online system OPRS and if we could export the Form 132 that would be a huge time savings. 

4 replies

A
Anonymous
January 9, 2020

Yes,there's a way we can export the Form 132, Jenn. 

 

Let's make sure you've downloaded the latest payroll update before pulling up the tax form. Then, here's the steps to get it:

  1. Click on the Employees menu.
  2. Select Employee Center.
  3. Go to the Payroll tab.
  4. Go to the File forms tab. 
  5. Double-click on OQ- Quarterly Tax Report and select the filing period.
  6. Click on Next to go to the Form 132. 
  7. Click on Save as PDF.
  8. Save the file on your computer. 

Let us know if you have any payroll questions. We are here to help. 

J
jennrobeAuthor
January 9, 2020

I think I was not clear.  I meant exported in Excel or CVS format.

R
RaymondJayO
January 10, 2020

Let me clear out the confusion for you, @jennrobe. 

 

Right now, the option to directly export Form 132 to the Oregon Payroll Reporting System (OPRS) is unavailable. The supported filing method of this form in the program is via print and mail. For more details, select Tax Forms and click View from the Form 132 (Filing) panel through this article: Oregon Payroll Tax Compliance. Then, go to the Send Methods Available in QuickBooks Desktop Payroll section. This link also covers more details about your tax forms, withholdings, unemployment, e-file and pay information, and employer registration.

 

Since your state requires the info to be entered into their online system, I'd first suggest saving the form as PDF by performing the steps provided by my peer GarlynGay above. Then, print the form so you can use it for your reference in manually entering the information in the OPRS. 

 

January is one of the most essential months for every business, just like yours. I'd suggest checking out this link: Year-end Checklist. This article provides you important dates and tasks to help you complete the year-end payroll process. 

 

Visit the Community again if you need anything else. I'm always here and ready to help. Have a good day, @jennrobe. 

S
SL303
January 7, 2023

Is there an update on this?  We pay a premium for payroll service and we should be able to get the info in the format required by the state without jumping thru all these hoops.  I see this convo is from 2020.  Is there any update?

    A
    AileneA
    January 7, 2023

    Hello, SL303. 

     

    The Print Quarterly Payroll Reports option has been updated to generate electronic files suitable for uploading Form 132 and Schedule B information to the Oregon Payroll Reporting System (ORPS) website. It will also now generate printed reports according to the blank paper specifications provided by Oregon.  

     

    Also, let's make sure you downloaded the latest payroll update to have most current tax table and product enhancement. You can check that by following these steps to make sure you have the correct tax table version. 

     

    1. Go to the Employees tab.
    2. Select Get Payroll Updates.
    3. You'll see the tax table version beside the Payroll Update Info button. 

     

    Here’s an article for your reference:  Oregon Payroll Tax Compliance. 

     

    You can add a comment below if I can provide any assistance while working in QuickBooks. Please know that I'll be here to help.

    S
    SL303
    January 7, 2023

    These instructions look like they are for QB Desktop.  How do I access these with QB Online?

      S
      SLD24
      April 28, 2024

      Did this get resolved yet?

       

      J
      JenDol
      August 1, 2024

      In QBDT:

      Reports/ Employees & Payroll/ More Payroll Reports in Excel/Tax Form Worksheet,

      Select State Wage Listing

      Select Last Quarter

       

      This will give 90% of the information you need and the rest is easy to add.

       

      I open the draft example from Frances to see the correct headers, and in the QB sheet, delete the first 9 rows, and all rows below the first set of employee info, delete/move columns around to match the format, and add a column for middle initial. The only piece of information it doesn't have is the STT Withholding, so you'll have add a column and create an equation (=G2*.001) and drag down, or manually type the values in. I format all the columns as "accounting"

       

      *SSNs* - you have to remove the dashes, it can only contain numbers

       

      I rename the tab "EmployeeDetailReport" and save the file to my computer.

      Then its ready to upload in Frances

       

      Come January, I think its the same report to process the spreadsheet for W2s

      Terms & ConditionsAccessibility statement