Connect with and learn from others in the QuickBooks Community.
Join nowWe 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! Go to Solution.
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.
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!
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.
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!
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!
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.