Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Employee Direct Deposit Report

We are integrating our payroll to another payroll provider and need to send them a Direct Deposit report with each employee's individual bank account numbers, but in QB, the numbers are hidden except for the last 4 digits of the account number. 

 

I'm trying to figure out how to generate a report with each employee's bank routing and account numbers into an Excel spreadsheet. Is there a way to do this?  I greatly appreciate any help I can get. 

Solved
Best answer November 13, 2020

Best Answers
QuickBooks Team

Employee Direct Deposit Report

Thank you for adding a post, @lauracritt.

 

For the security of your account and your employee's information, the system only displays the last four digits of the bank account numbers. The good news is, yes, you can export the employee details or direct deposit report to Excel, then customize the numbers from there. I can guide you on how.

 

  1. Log in to your IOP account, then look for the report you need.
  2. Open the report you need, then tap on the View in Excel button.
  3. Customize the information, and add the bank details from there.
  4. Save the data.

Just in case you want to export your IOP data to QBO, you can as well open this article for your reference.

 

If you need related resources while working with QuickBooks in the future, you can as well open the topics from our help articles.

 

I'm more than happy to help if you have any other QuickBooks questions aside from payroll. Just add a comment below. Have a great day!

View solution in original post

3 Comments
QuickBooks Team

Employee Direct Deposit Report

Thank you for adding a post, @lauracritt.

 

For the security of your account and your employee's information, the system only displays the last four digits of the bank account numbers. The good news is, yes, you can export the employee details or direct deposit report to Excel, then customize the numbers from there. I can guide you on how.

 

  1. Log in to your IOP account, then look for the report you need.
  2. Open the report you need, then tap on the View in Excel button.
  3. Customize the information, and add the bank details from there.
  4. Save the data.

Just in case you want to export your IOP data to QBO, you can as well open this article for your reference.

 

If you need related resources while working with QuickBooks in the future, you can as well open the topics from our help articles.

 

I'm more than happy to help if you have any other QuickBooks questions aside from payroll. Just add a comment below. Have a great day!

View solution in original post

Level 2

Employee Direct Deposit Report

Thank you so much for your response. Unfortunately, I think I'm using a different version of quickbooks. When I chatted with support, they stated I'm using full service payroll and they don't have access to help me. I'm waiting to speak with someone else, so hopefully this will be resolved soon!

Level 2

Employee Direct Deposit Report

Apparently it is not possible to unhide the routing and account numbers using full service payroll. I will have to manually pull the hard copy forms and enter all of the information myself. I'm very disappointed that there is no other option. Again, I do thank you for your help and wish I was using the other platform. 

Need to get in touch?

Contact us