Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Did this ever get fixed?
Did this get resolved yet?
Has this been resolved
Welcome to the QuickBooks Community, SLD24.
Please know that the option to export the Oregon Form 132 directly to Excel or CVS format is still unavailable in both QuickBooks Online and Desktop versions. However, let me still ensure you can achieve your goal by performing an alternative way to organize the said form smoothly.
If you're using the QuickBooks Online version, you can export the data needed for Oregon Form 132 by going to the Payroll tax tab. Before doing so, please make sure you have a payroll subscription to access the said section. You also need to make sure all needed information is entered into the program for the form to be generated correctly.
Then, follow these steps:
You can also pull up the Payroll Liability Balances report as another option. Then, you can fill out the form outside QuickBooks.
If you're using the QBDT, you can follow the instructions mentioned Anonymous or RaymondJayO.
In case you need steps on how you can run a specific report to quickly view your payroll totals, including employee taxes and contributions, you can read this article: Create a payroll summary report in QuickBooks.
Feel free to add a comment below if you have further questions about Form 132. I'll be glad to help further, SLD24. Have a good one!
To my knowledge it has not been fixed. We came up with our own time consuming process to get the data and manipulate it in Excel so it works as an upload. It is that or you have to type everything in.
To my knowledge it has not been fixed. We came up with our own time consuming process to get the data from various reports and manipulate it in Excel to get it to upload. Otherwise you have to type everything in.
There is no "forms" tabs anywhere in payroll tax, or under employees?
? There is no forms tabs in payroll tax or employee section anywhere?? We have online and payroll. Need forms 132 and OQ .
I appreciate your responding and providing an update on the outcome of your troubleshooting methods.
Please know that understand the urgency of you being able to find the forms and export them. No need to worry, @Ksblaster. I am here to help you.
In QuickBooks Online Payroll, you can go to the Filings tab to export the Oregon Form 132. Feel free to follow these steps:
Additionally, here are some articles to help you keep track of your payroll activities and ensure all data entered inside the program remains accurate:
Please let me know if you need further assistance with exporting 132 forms. Your satisfaction and smooth payroll processing are our top priorities. We're here to assist you every step of the way.
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
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
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
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
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here