Skip to main content
December 15, 2021
Question

401k Contributions

  • December 15, 2021
  • 1 reply
  • 0 views

We use Principal for our 401k Plan.  We would like to create a file from QB and then upload the contributions directly to Principal.  Principal needs the entire SSN# in order to make the upload.  According to QB they cannot create a file with the SSN# for security purposes.  How are people circumventing this issue.

 

Thank you

 

Gary

1 reply

AlcaeusF
December 16, 2021

Hello @gn41_2,

 

I appreciate you for posting here in the Community. Allow me to assist you with the data you need in QuickBooks Online.

 

Currently, the option to show contributions and social security numbers in a single report are unavailable. As a workaround, you'll need to pull up a separate report and combine them in Excel.

 

I recommend you use the Employee Details report in QuickBooks. This report shows detailed information about your employees like the SSN and other information.

 

You can download the data over to Excel and merge any needed info. In case you need the steps, here's how:

 

  1. On the left navigation bar, click Reports.
  2. Scroll down and select Employee Details under Payroll.
  3. Make the necessary changes to the filters.
  4. Press the drop-down arrow in the upper-right corner next to Share.
  5. Choose Export to Excel

 

You can also check this article for additional guidance in personalizing reports, like how to modify the columns and display: Customize reports in QuickBooks Online.

 

Hit me up by adding a comment below if you have any other questions regarding the data you need. I'll be happy to help you some more.