Question

Vendor Details - Bill Pay ACH Report

4 replies
215 views

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.

QuickBooks Online

G

GianSeth_A1

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:

Go to Expenses
Select Bills. Then, click the Paid tab below.
Find the transaction that has an ACH payment method.
Once done, click the dropdown icon below the Action column.
Select View/edit bill.
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.

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.

K

KyleMitchell1Author

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

J

Jovelyn_M

QuickBooks Team

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO