cancel
Showing results for 
Search instead for 
Did you mean: 
Mferron01
Level 1

Is there a way to create a report with all employee direct deposit information?

I am needing to create a report that contains all direct deposit information for all of my current employees.  Is this possible within the quickbooks system?

20 Comments 20
Anonymous
Not applicable

Is there a way to create a report with all employee direct deposit information?

Start at Reports | Employees & Payroll | More Payroll reports in Excel | Employee Direct Deposit Listing

John B
Level 2

Is there a way to create a report with all employee direct deposit information?

can you generate the same report for vendor direct deposit and routing numbers somewhere?

 

thanks

 

John B
Level 2

Is there a way to create a report with all employee direct deposit information?

is there a way to get the direct deposit information for vendors in an excel file?

IamjuViel
QuickBooks Team

Is there a way to create a report with all employee direct deposit information?

Thank you for joining this thread, @John B.

 

Allow me to share information on how you can generate reports with your vendor information in an excel file.

 

With QuickBooks Desktop, you have the ability to customize and filter the data included on the report you're viewing. While doing so, it still maintains the confidentiality of your vendors bank account information by not including personally identifiable information (PII) on the reports.

 

You can still run reports for the payments you've made to vendor. Here's how:

  1. Click the Reports  menu.
  2. Choose Vendors and Payables.
  3. Select Transactions list by Vendor.
  4. Go to the Filter tab.
  5. Look for Payment Method.
  6. Under Payment Methods drop-down, choose All Payment Methods.
  7. Click Ok. 1212121.gif

     

That should do it!

 

Fill me in if you have other questions about generating reports in QuickBooks Desktop. I’m always here to help.

John B
Level 2

Is there a way to create a report with all employee direct deposit information?

Thanks for the reply and the information.  I ran this report but it still won't include the vendor ABA routing number and the vendor bank account number.  Any thoughts?

 

thanks

 

John

PreciousB
Moderator

Is there a way to create a report with all employee direct deposit information?

Thanks for coming back to the Community, John B.

 

Let me share some details about the vendor's report that shows their bank account information.

 

Currently, we don't have an option to include the vendor's bank account details on any report in QuickBooks Desktop. You'll want to go to the vendor's profile to see their account and routing numbers.

 

Here's how:

  1. Go to Vendors at the top, then choose Vendor Center.
  2. Double-click the vendor's name.
  3. Select the Additional Info tab.
  4. Click the Direct Deposit box to see the bank account details (refer to the screenshot below).
  5. Select OK twice.

image.png

 

Following these steps should get you back in line. Please keep me posted and reach out to me if there is anything else you need about QuickBooks Desktop. I'd be happy to help. Have a lovely day!

IPA
Level 1

Is there a way to create a report with all employee direct deposit information?

This is not what the client was asking to do. We both need to see and then export a list of all our vendors with their ABA and Account numbers listed, all at once. We are trying to avoiding having to go into EVERY vendor's profile to get this information. Is there or is there not a way to do this?

Rose-A
Moderator

Is there a way to create a report with all employee direct deposit information?

Hi, IPA.

 

You can pull up the Vendor Contact List report to show the Account No. However, the ABA code will not appear in the report. To show this, as a workaround, you can manually add the ABA under the Other 1 field in the vendor profile.

 

 

After that, let's filter the report to show this information. See the steps below.

 

  1. Click Reports at the top menu bar.
  2. Select Lists and choose Vendor Contact Listx.PNG

     

  3. In the report screen, click Customize Report.
  4. Search and select the Other 1
  5. Hit OK.c.PNG
  6. You'll have this information in the reportv.PNG

To learn more about customizing reports in QuickBooks Desktop, here's some article for your reference:

 

Please get back to me if you have any other questions, I'd be glad to provide you additional insights. Have a good one.

wbriney
Level 1

Is there a way to create a report with all employee direct deposit information?

I ran the transaction list by vendor and the bank account number, ABA routing number and the CHK/SAV fields do no populate. I need to create a NACHA file for upload into bank and need the information

 

 

Tori B
QuickBooks Team

Is there a way to create a report with all employee direct deposit information?

Hey there, @wbriney

 

Thanks for following the thread and trying the steps provided by my colleagues above. 

 

Since the report isn't working for you, I recommend checking into a third-party app to obtain a NACHA file to upload into your bank. This way, you can get the most accurate details on the report that you need. Such as the CHK/SAV fields. 

 

In the meantime, I've submitted a feedback request to our Product Development Team to have further options to use for NACHA files. Our product developers review each request and consider them for future updates. 

 

Please let me know if you have further questions or concerns. Take care and have a great day! 

CHONU
Level 1

Is there a way to create a report with all employee direct deposit information?

Hi , I do not have employee & payroll, only have Payroll under the report and none of the standard report have direct deposit to customize. Where should i look into pull direct deposit info of our employee.

CHONU
Level 1

Is there a way to create a report with all employee direct deposit information?

I do not see employee and payroll under the report. There is a Payroll and none of the standard report carries direct deposit info data to customize. where should i look into to pull the DD info of employee.

ZackE
Moderator

Is there a way to create a report with all employee direct deposit information?

Thanks for joining the Community, CHONU.
 

If you're referring to the steps posted by Anonymous, you can find your Employee Direct Deposit Listing report in More Payroll Reports in Excel.
 

Here's how:

  1. In the top menu bar, go to Employees & Payroll, More Payroll Reports in Excel, then choose Employee Direct Deposit Listing.
  2. If you see an Excel security warning saying macros aren't enabled, follow your displayed directions to to enable macros.
  3. Select Get QuickBooks Data.


You can also export QuickBooks-based reports as Excel workbooks or CSV spreadsheets, then open them in Excel to further customize them.
 

Here's how:

  1. In your top menu bar, go to Reports, then Reports Center.
  2. Find and open the appropriate report.
  3. Click your Excel option on the toolbar.
    Save,
  4. Choose Create New Worksheet or export it as a CSV file.
  5. If you'd like to format your data in a specific way, hit Advanced. The report must have less than 256 columns. If you see a message saying it has too many, press Advanced, tick Space between columns, then untick its checkbox and hit OK.
  6. Select OK to export your file, or Export to automatically open it in Excel.


I've additionally included a few detailed resources about working with reports which may come in handy moving forward:


I'll be here to help if there's any questions. Enjoy the rest of your day!

Chuck1966
Level 1

Is there a way to create a report with all employee direct deposit information?

Can you modify this report QB_DD_Rpt1 that works perfectly for employees

 

How can I modify the parameters to pull from vendor list and not employee list?

 

odwally
Level 1

Is there a way to create a report with all employee direct deposit information?

Is there a way to do this in QBO? I need to extract DD info for all employees. 

JessT
Moderator

Is there a way to create a report with all employee direct deposit information?

Thank you for joining the conversation, odwally.

 

We're unable to extract employees' direct deposit information in QBO Payroll. In fact, you'll only see the last four digits when you check their account and routing numbers in the Pay section of their profiles. It's a way of protecting their bank information.

 

If the goal is to only create a report, you can pull up the Employee Directory and export it to Excel. Then, add columns for the bank and routing numbers, which can be checked from the employees' direct deposit authorization forms.

 

  1. Go to Reports.
  2. Search for Employee Directory.
  3. Click Export and then Export to Excel. Remove the columns that you don't need.

 

On the other hand, if you want to update the direct deposit details of the employees, you can follow these steps:

 

  1. Go to Payroll, then Employees.
  2. Select your employee.
  3. From Payment method, select Start or Edit.
  4. Update the numbers and click Done.

 

Let me know if you have any other concerns about your employee's direct deposit. Have a good one!

Mandee1
Level 1

Is there a way to create a report with all employee direct deposit information?

We do not have direct deposit on the vendor: additional information.  Is there a way to activate this?  ALso, I want to create a report that includes our payments batch for vendors that include routing and banking to export in excel.   Is this possible?  I will get an app that creates our NACHA file for the bank.

SirielJeaB
QuickBooks Team

Is there a way to create a report with all employee direct deposit information?

Hi, Mandee1. Thank you for dropping by the Community.

 

You can use direct deposit to pay your vendors in QuickBooks Desktop. To do this, you'll need to set up your vendor's direct deposit. I'd love to walk you through the process:

 

  1. Open the Vendor Center, then choose a vendor and double-click their name.
  2. Click the Additional Info tab, then select the Direct Deposit button.
  3. Type in your Direct Deposit PIN. Hit Continue.
  4. Follow the on-screen instructions.

 

If you want to view the detailed steps, check out this article: Set up and manage direct deposit for your contractors.

 

Moreover, the report you want is unavailable. However, you can run the vendor transaction list, then customize it to have the payment transactions. Here's how:

 

  1. Select the Reports menu, then type Transaction List by Vendor in the search bar.
  2. Click the Customize option. Tap the Filter dropdown button.
  3. Under Transaction Type, choose Payment.
  4. Hit Run report.

 

You may want to visit this article to help you handle reports in QuickBooks Desktop: Create, access, and modify memorized reports.

 

Please feel free to comment below if you have further concerns. I'll be here to assist you anytime, Mandee1. Have a nice day, and take care!

MLWDFW
Level 1

Is there a way to create a report with all employee direct deposit information?

How about pulling a report that can be exported of vendors that are paid by direct deposit, along with their banking information...anyone know how to do that?

DivinaMercy_N
Moderator

Is there a way to create a report with all employee direct deposit information?

Welcome to the Community, @MLWDFW. I'll share some information about running the report you need in QuickBooks Desktop (QBDT).

 

The specific report that can show those vendors paid by direct deposit along with their banking information is unavailable. As a workaround, you can run separate reports to show those details. Then export them to Excel and combine them there. 

 

Let's start with pulling up the Vendor Contact List report to see their Account No. Here's how:

 

  1. Select the Reports menu and hover over the Vendor & Payables section.
  2. Next, choose Vendor Contact List.
  3. Once opened, click Customize Report. 
  4. Then, type and select Account No. in the Columns field. You can also add other details you need.
  5. When done, click OK.
  6. After that, click the Excel drop-down and choose Create new worksheet. Then, select in new workbook.
  7. Once ready, select Export.

 

After that, run a Custom Transaction Detail Report to see the payment method used for each vendor. Refer to these steps:

 

  1. Go to the Reports menu and hover over the Custom Reports section. Then, choose Transaction Detail.
  2. In the Columns field in the Display tab, type and select Pay Meth.
  3. Then, in the Filters tab type and select Preferred Vendor (you can choose All vendors or Multiple vendors).
  4. Once done, click OK.
  5. After that, export it again (refer to Steps 6-7 above).

 

You can use this article as a reference in modifying the details of your report: Customize reports in QuickBooks Desktop.

 

I understand how this will benefit your business. While this is not yet available, I recommend sending feedback to our product developers to request the addition of this report. Here's how:

 

  1. In your QBDT account, select the Help tab.
  2. Next, click the Send Feedback Online option.
  3. Then, choose Product Suggestion. A pop-up window displays.
  4. From there, input the details of your product comments, suggestions, and requests. 
  5. Click the Send Feedback button to submit.

 

Should you have other concerns about running reports showing the details you need, please add a reply below. I'm here to provide additional assistance. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us