Skip to main content
S
seth15
April 19, 2023
Question

FAMLI Report for Colorado NOT there in Quickbooks!!

  • April 19, 2023
  • 6 replies
  • 0 views

This is so surprising, there's no way to download an xml or csv report from Quickbooks and upload it to Colorado website for FAMLI act. Talked to Qbooks and they acknowledged they DON'T have it. If I have to manually enter 400 employees in FAMLI website not sure what use Quickbooks payroll is.

    6 replies

    BigRedConsulting
    BigRedConsulting
    April 21, 2023

    I'm not surprised. Do you have a link to the file format? It might be something we can build for you, or in general.

    S
    seth15Author
    April 21, 2023

    https://drive.google.com/file/d/1-4ZwTfyqtYw0vTvAgFWZ3ARHxhZv0pRo/view

     

    Link for the XML schema

      BigRedConsulting
      BigRedConsulting
      May 2, 2023

      @seth15 

      The file format looks doable, though there appear to be quite a few data fields that aren't tracked in QuickBooks, which would probably need to be captured in some sort of interview.

       

      Questions:

      - Are there built-in items in QuickBooks for the FAMLI?  Or, do you have to set the items up manually as custom taxes?

      - Are both employee and employer amounts tracked on the paychecks you create in QuickBooks?

      Z
      zambini
      April 29, 2023

      Not only is there not a generation of the CSV or XML file to upload, there is no liability payment shown to pay  in the "Pay Taxes & Other Liabilities".  e.g. like you would see for Colorado wage or unemployment reporting.

       

      And, while we are on this subject, did you know that the FTP file that QBD payroll generates is incorrect? One has to fix the year and quarter reporting in the right hand most field in order for the file to be compliant with Colorado filing requirements. I spoke with QB payroll support a couple of years ago and they said this might get fixed but that was in 2020.

       

      Come on Quickbooks, you seem to have no problem rapidly increasing your cost for QB Payroll but don't seem to be actually addressing the problems your customers have using it.

        BigRedConsulting
        BigRedConsulting
        May 2, 2023

        @zambini  RE: there is no liability payment shown to pay in the "Pay Taxes & Other Liabilities"

         

        This likely means a payment schedule has not been set up.  You can set up a schedule for any tax or deduction, built in or custom.  Do it using the button just below the table of liabilities to pay.

         

        RE: And, while we are on this subject, did you know that the FTP file that QBD payroll generates is incorrect?

         

        I've never heard of a feature that generates an "FTP file". FTP is short for "File Transport Protocol" - a communication standard used to send files, much like a browser uses HTTP.

         

        How are you creating this file for Colorado within QuickBooks? Perhaps there's an update to the feature you're using...

         

        F
        Fangdoctor
        May 2, 2023

        This has been a challenge from the beginning.  I set mine up well before the deadline.  Then I got an email from Quickbooks telling me that I had not set it up, that I couldn't run payroll until I did and by the way, since it was my fault they were going to deduct all of it from me rather than doing payroll deductions from my employees.  Then after multiple help sessions they admitted that it was their fault due to a "glitch" and it was now fixed.  I followed up a week later and they assured me that it was setup correctly and that the state report and payment would be accomplished on time.  It is now 2 May after the 30 April deadline and nothing has happened yet.   Every time I have gotten assistance, the person is clueless about this program and we have to start all over again.  I understand that this is a Colorado specific program that they have get their heads around but they need to assign a team dedicated to this problem and not expect their average chat person to know all of the details.

          M
          marie20
          October 19, 2023

          I fully agree with Seth!!  That was last April, so now that we are to be submitting our 3rd quarter please let me know if there is currently a csv file that can be downloaded from QB so we can upload to our state website for required reporting!!  We are in the same mess here because we have over 300 employees that have to be manually entered!!!  Please let your clients know how to download a file to report our FAMLI contributions. 

            H
            HollWhiteJenks
            October 23, 2023

            FAMLI has made it darn near impossible to upload reports. I tried to onboard people and the parameters of the CVS file headers makes ZERO sense. Either QB has to get the parameters outlined and solidified with the state OR the state needs to make it simpler (i.e. the W2 wage reporting upload filed with Colorado Department of Revenue).

              BigRedConsulting
              BigRedConsulting
              October 23, 2023

               

              @baraco  Posted this link to the file formats, which include the CSV format.

              https://drive.google.com/file/d/1-4ZwTfyqtYw0vTvAgFWZ3ARHxhZv0pRo/view

               

              Are you saying it no longer works? Or, that creating it is difficult?

              R
              ReymondO
              October 19, 2023

              Thanks for joining the thread,

               

              Currently, there is no specific report available in QuickBooks that can be directly uploaded to the Colorado website for the FAMLI Act. I understand the importance of having this option when submitting your employee's data to the state. I will make a note of this to enhance your experience with QuickBooks.

               

              In the meantime, I recommend running payroll reports within the program to gather the necessary data for uploading to the Colorado website for the FAMLI Act.

               

              I also suggest providing feedback to our developers regarding this concern. They can review your request and potentially include it in future updates. Here's how you can send your suggestions:

               

              1. Click the Help option.
              2. Select the Send Feedback Online option.
              3. Click the Product Suggestion option. A pop-up window displays.
              4. Enter your feedback suggestion and select the Send Feedback button.

               

              Additionally, you can track feature requests through the QuickBooks Online Feature Requests website.

               

              Furthermore, you can customize payroll reports in QuickBooks to generate the specific data you need for your business.

               

              If you have any other questions regarding payroll and taxes, please let me know. I'm here to help. Stay safe!

              M
              melanieinskeep
              January 4, 2024

              This is completely unacceptable that we do not have a report still!  And also unacceptable that we do not have a csv file to upload to the state. It takes me days to enter the employee data by hand.  DAYS! My hands ache and I have to go get therapy afterwards.  

              AlverMarkT
              AlverMarkT
              January 4, 2024

              I understand how crucial it is to have access to all the necessary payroll reports including the FAMLI report in QuickBooks Desktop (QBDT) Payroll for Colorado, @melanieinskeep.

               

              As of now, the report isn't available. In the meantime, I suggest working with an accountant or a payroll specialist familiar with FAMLI reporting requirements to generate payroll reports and manipulate the data in Excel to meet the requirements of the FAMLI submission format. 

               

              I also encourage submitting feedback to our product engineers, as it is crucial for the software to meet the needs of its users, especially when it comes to generating payroll reports. Here's how:

               

              1. Click the Help option.
              2. Select the Send Feedback Online option.
              3. Click the Product Suggestion option. A pop-up window displays.
              4. Enter your feedback suggestion and select the Send Feedback button.

               

              Additionally, let me add this guide about exporting payroll reports outside of QBDT to generate further insights: Export reports as Excel workbooks in QuickBooks Desktop.

               

              We're always here in the Community should you have further updates on generating the FAMLI Report for Colorado. We'll do our best to assist. Take care.

              A
              arittintec
              October 30, 2023

              AGREED, ridiculous for the amount of money paid for "payroll" that Intuit cannot be up to date on required payroll reports.  Intuit also cannot handle the Washington CARES tax either.  Intuit is losing a lot of client base but not keeping up with payroll requirements.

                L
                LostGenXer
                January 7, 2024

                I'd love to say what I'm thinking about Intuit right now...

                 

                But, as of Q3, this format uploaded correctly to MyFamli+ Employer for the clients that I serve.

                CO FAMLI .csv File Format (links to Google Drive location).

                Be sure that the dates are formatted EXACTLY as shown in the example. Also, don't open this in Google Sheets, it won't show you how the formatting should be. Open in Excel, and when the window pops up, choose "Don't Convert." Hope this helps someone. 

                 

                Now, if anyone can tell me where in the **** I can find the report in QB Desktop that generated that.csv in Q3, you will have my undying gratitude and I'll buy you a beer.

                 

                 

                  Terms & ConditionsAccessibility statement