Skip to main content
C
columbinerose
January 23, 2025
Question

Colorado FAMLI Report and Quarterly Wage Report Export

  • January 23, 2025
  • 1 reply
  • 0 views

I was wondering if there was a way to export the FAMLI report and the Quarterly Wage report in .csv to the compliance of the state. Since they changed to electronic filing only, we've been manually doing all the data entry from the PDF report (PAYROLL > PAYROLL CENTER > PAYROLL > FILE FORMS > UI I QUARTER... or PFML - PAID FAMILY.... > CREATE FORM), so I've been trying to find a simpler way to do it without spending 3 days each quarter doing data entry. I contacted support and the instructions they gave me where not what I needed: 

  1. Open QuickBooks Desktop and navigate to the Reports menu.
  2. Select Employees & Payroll.
  3. Choose Payroll Summary or Payroll Detail report.
  4. Set the date range to cover the quarterly period you need.
  5. Set the columns to show the Total Only
  6. Double click the specific area you needed from your report, you have the gross pay, Deductions and many more covered in payroll.
  7. Customize any additional filters as necessary.
  8. Run the report to view the quarterly wages.

 

When attempting to use this method, the information is not where it needs to be and there are fields missing. I am aware that if we had QB Payroll, then it would be done for us but it's not in our company's budget, so here I am. Thank you for any help.

1 reply

Bryan_M
Bryan_M
January 23, 2025

I'm glad you posted here, @columbinerose. At the moment, exporting a FAMLI and Quarterly Wage report via CSV is unavailable in QuickBooks Desktop (QBDT). 

 

Since QBDT doesn't have this report, you can use the workaround our live support team provided. Then, for the lacking details, you can run a different report that consists of the information you want to have in your FAMLI and Quarterly Wage report.

 

Once done, you export it via Excel and modify it outside to compile the details needed in your report. The export to Excel tab is located above the report page, and select Create New Worksheet. Feel free to see the screenshot below for reference:

 

 

In the meantime, I recommend submitting feedback to our Product Development Team. Once done sending, they'll evaluate this feature request. If they see that it can improve your experience in QBDT, they can add it to our future product updates. Here's how:

 

  1. Go to the Help tab.
  2. Pick the Send Feedback Online option.
  3. Choose the Product Suggestion tab. Enter your suggestion from the pop-up window display.
  4. Once done, click Send Feedback.

I'll also add this article to help you save the modifications of your report: Create, access, and modify memorized reports.

 

Don't hesitate to reply to this post if you have additional questions about generating a Famli and Quarterly Wage report. We'll assist you as soon as possible. Keep safe always.

Terms & ConditionsAccessibility statement