cancel
Showing results for 
Search instead for 
Did you mean: 
mbutts4901
Level 2

Sending 401k data directly to American Funds

Hi, my regional payroll service provider was acquired by ADP & I'm now thinking about adding payroll to my QBE installation.


I can't  get a straight answer from Intuit on the ability of QBE to send an electronic file to Capital Group: American Funds after each payroll to show employees, SSNs, salaries, deferrals, matches, etc.


I know I can probably put together a QB report to export to Excel, make any changes needed by American Funds, and then transmit it, but I wanted to see if there was already some type of bridge created for this.

Solved
Best answer November 20, 2019

Best Answers
Jen_D
Moderator

Sending 401k data directly to American Funds

Glad you're here, @mbutts4901,

 

We currently don't have a bridging tool to transfer payroll data from QuickBooks to American Funds. You must have a third-party tool that integrates with both programs to complete this action.

 

What you can do in QuickBooks is export a customized report that has all the information required by the agency.

 

Pull up a Payroll Summary report to get the wage detail per employee. Here's how:

  1. Go to the Reports menu.
  2. Choose Employees & Payroll.
  3. From the drop-down, click the Payroll Summary.
  4. Update the report date at the top to see the pay period you want to view, then Refresh.
  5. Tap the Customize Report button.
  6. In the Display tab, enter the quarter date of the report.
  7. Go to the Filters tab.
  8. In the Filters list, choose Payroll Item. Select Multiple payroll items in the Payroll Item drop-down.(See screenshot.)
  9. From the Select Payroll Item window, mark the taxes you want to export.
  10. Once done, hit OK twice.
  11. Press the Excel button to start a new worksheet.

If you'd like to view the report again without going through all the customization, use the Memorize button at the top. To access them, go to Reports menu and select Memorized Report


To know more creating this report, please check out this article: Create a payroll summary report.

 

While the said report doesn't have the employee details such as SSN and other contact information, use the Employee Contact List. Here's how:

 

  1. Go to the Reports menu and click Employees & Payroll.
  2. Select Employee Contact List from the list.

If you have any other issues or concerns, please let me know in the comment section. I'm always here to help. Have a lovely week!

View solution in original post

4 Comments 4
Jen_D
Moderator

Sending 401k data directly to American Funds

Glad you're here, @mbutts4901,

 

We currently don't have a bridging tool to transfer payroll data from QuickBooks to American Funds. You must have a third-party tool that integrates with both programs to complete this action.

 

What you can do in QuickBooks is export a customized report that has all the information required by the agency.

 

Pull up a Payroll Summary report to get the wage detail per employee. Here's how:

  1. Go to the Reports menu.
  2. Choose Employees & Payroll.
  3. From the drop-down, click the Payroll Summary.
  4. Update the report date at the top to see the pay period you want to view, then Refresh.
  5. Tap the Customize Report button.
  6. In the Display tab, enter the quarter date of the report.
  7. Go to the Filters tab.
  8. In the Filters list, choose Payroll Item. Select Multiple payroll items in the Payroll Item drop-down.(See screenshot.)
  9. From the Select Payroll Item window, mark the taxes you want to export.
  10. Once done, hit OK twice.
  11. Press the Excel button to start a new worksheet.

If you'd like to view the report again without going through all the customization, use the Memorize button at the top. To access them, go to Reports menu and select Memorized Report


To know more creating this report, please check out this article: Create a payroll summary report.

 

While the said report doesn't have the employee details such as SSN and other contact information, use the Employee Contact List. Here's how:

 

  1. Go to the Reports menu and click Employees & Payroll.
  2. Select Employee Contact List from the list.

If you have any other issues or concerns, please let me know in the comment section. I'm always here to help. Have a lovely week!

kcopco
Level 1

Sending 401k data directly to American Funds

Were you able to find a a third-party tool that integrates for the payroll data transfer?

kcopco
Level 1

Sending 401k data directly to American Funds

Were you able to find a third party tool that integrates for the payroll data transfer?

DivinaMercy_N
Moderator

Sending 401k data directly to American Funds

Thank you for joining this thread, @kcopco.

 

You can use the QuickBooks Apps store to search for third-party apps that can help you integrates payroll data to QuickBooks Desktop. Let me guide you how:

 

  1. Head to QuickBooks Apps store at this link.
  2. From the Find the right apps for your business field, enter a keyword of the app you need. app2.JPG
  3. You'll see a list of apps and from there, and then choose which suits best for your business.

 

You might also want to visit our help page to browse articles that can guide you with your QuickBooks tasks. To get started head to our QBDT help articles at this link.

 

Don't hesitate to post here again if you have further questions about this. I'm always here to help you in any way I can. Have a wonderful day ahead.

Need to get in touch?

Contact us