Massachuestte paid family leave export to excel

Hi there, @map2.

Great seeing you here in the Community. I have the information you need for Massachusetts Paid Family Leave.

If the customer changed tax rates after creating paychecks, they must make a per employee liability adjustment. Follow the steps to Adjust payroll liabilities to complete the alterations. Auto adjustments (Control 4/w or Payroll Checkup) will not work for this tax.

 Notes:

• The account number is the FEIN number.
• For Assisted payroll, the account number is the MA DOR Account Number with PFM in front of it (for example, PFM-12345678-123).
• The wage base on this new tax is the same as the Social Security wage base.
• For QuickBooks Desktop DIY payroll, filing and payment information will post as the agency provides further details on how to file and pay the tax in January 2020.
• For QuickBooks Assisted payroll: Intuit will pay and file for you, excluding 1099 Contractors. See the FAQ below.

For more information, view Massachusetts Paid Family Leave.

Please reach out if there's anything else I can do to help, I'm determined to be your number one resource for QuickBooks.

I have the same question - how do I create the excel file to download to Mass DOR?  You did not answer the original question.

I have two reports that you can pull up as your reference, otis2.

QuickBooks prepares a Paid family and Medical Leave Reporting Worksheet as your basis in filling out the MA DOR form. Let me show you how to run it: 

1. Go to the Employees menu and click Payroll Center. 
2. Select the File Forms tab. 
3. In the File Forms section, look for PFM - Paid family and Medical Leave Reporting Worksheet. 
4. Select Create Form. 

Another way to run an Excel report showing the same data, is the Tax Form Worksheets. 

1. Still in the Payroll Center, click the File Forms tab.
2. At the bottom, click the Tax Forms Worksheets under the Report section.
3. An Excel window will open, click Enable Editing. 
4. From the prompt, select State Wage Listing. 
5. Select the necessary information.
6. Click Create Report. 

If you need more help with running your payroll reports, let me know. I'll be here!

I was able to make this work - but it's very cumbersome and required some copy/paste to get the info into the proper format for submission to Mass.  Seems that Quickbooks should be more efficient with a download option that is as simple as the other state filing requirements.