Vendor Details - Bill Pay ACH Report

Hi, Kylemitchell. It's my priority to get this sorted out. To include Bill, Pay ACH details in your Vendor Detail Report in QuickBooks, you may have to follow specific steps, as ACH details are currently unavailable directly in the standard report customization options. Here’s how you can approach this:
 

1. Go to the Reports menu and select Vendors & Payables.
2. Choose the Vendor Detail report.
3. Customize the report. Click on the Customize button on the top right of the report. In the customization window, navigate to the Filters tab.

Look for any filters related to Payment Method or Transaction Type.

• Under the Columns section of the customization interface, you can check for any available columns related to payments or ACH transactions.
• If “ACH” is unable to appear as an option, you might need to run separate reports to gather this information.
• If the ACH details aren't applicable in the Vendor Detail Report, consider running the Transaction List by Vendor report or the Bill Payment List.
• Customizing these reports may allow you to see which bills were paid via ACH.

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

Lastly, if you've entered the advertent ACH details, you can modify it. Check out this article for the steps: Change a vendor payment method.

You may also browse these articles for other related topics: Online Bill Pay - Adding a Private Vendor.

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

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

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:

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.

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