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

Vendor Details - Bill Pay ACH Report

Hello,

 

I am trying to run a Vendor detail report including bill pay ACH details. Currently, I do not see an option to add bill pay ach details to customized report.

4 Comments 4
GianSeth_A
QuickBooks Team

Vendor Details - Bill Pay ACH Report

Hey there, Kyle. 

 

Currently, the ability to include an ACH payment field in the Vendor Detail Report is unavailable in QuickBooks Online (QBO).

 

As a workaround, you can manually edit each paid bill and type ACH in Bill No. Field. Here's how:

 

  1. Go to Expenses
  2. Select Bills. Then, click the Paid tab below.
  3. Find the transaction that has an ACH payment method.
  4. Once done, click the dropdown icon below the Action column.
  5. Select View/edit bill.
  6. Enter ACH in the Bill no. field. This way it will show in the report as it is paid via ACH in the NUM field on your report.

 

 

image_720.png

 

 

Additionally, you can export the reports to Excel and combine or manipulate the data manually to include both Vendor Details and ACH transactions.

 

You may also browse this article to combine bill payments, so your bill data moves seamlessly: Online Bill Pay - Adding a Private Vendor.

 

Keep me posted if there's anything else you need help with by managing your vendor's ACH payments. I'm always right here to answer your questions.

KyleMitchell1
Level 1

Vendor Details - Bill Pay ACH Report

Thank you. Unfortunately, I still cannot find a way to run a report containing the ACH details.

Jovelyn_M
QuickBooks Team

Vendor Details - Bill Pay ACH Report

I appreciate your commitment to being able to pull up a Vendor detail report including bill pay ACH detail, Kyle. I'm here to help you resolve concerns you have. Let's work together to find an effective solution for your specific needs.

 

To ensure accurate vendor payment tracking and reporting in QuickBooks Online, it's crucial to consistently use the correct payment method designation. When processing ACH (Automated Clearing House) payments to vendors, always enter "ACH" in the check number field for each transaction. You can do this by pulling up the Transaction List by Vendor.

 

Here's a sample look when you have entered ACH in a check number field:

 

image (5).png

 

However, I recommend you send this as a feature for QuickBooks Online to have a dedicated field or option for ACH payment details. This way, our engineers can check on it so they might consider this feedback.

 

Here's how:

1. Go to the Gear Icon.

2. Select Feedback, then feel free to share your thoughts.

3. Click Next.

 

For future reference, I've added this link if ever you want guidance in entering bills: Enter and manage bills and bill payments in QuickBooks Online.

 

Please don't hesitate to ask for clarification or guidance. I'm here to provide detailed support tailored to your specific needs and ensure you're making the most of QuickBooks Online's Payment methods.

KyleMitchell1
Level 1

Vendor Details - Bill Pay ACH Report

I'll submit via feedback. I still an unable to run a report listing vendors with bank account and routing number. Thank you

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us