Skip to main content
L
lauracritt
November 13, 2020
Solved

Employee Direct Deposit Report

  • November 13, 2020
  • 1 reply
  • 0 views

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. 

Best answer by Angelyn_T

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!

1 reply

Angelyn_T
Angelyn_TAnswer
November 13, 2020

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!

    L
    lauracrittAuthor
    November 13, 2020

    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!

    L
    lauracrittAuthor
    November 13, 2020

    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. 

      Terms & ConditionsAccessibility statement