Skip to main content
A
AJC1641
December 3, 2024
Question

Best way to move bank account data from Payroll-Contractor to Bill Pay. Can you upload through spreadsheets bank accounts data into Bill Pay?

  • December 3, 2024
  • 2 replies
  • 0 views

Intuit stated they can't port of the data and there is no report that will provide the bank account data. Therefore, my preference is to do a bulk upload to create the Bill Pay vendors once I collect all the information.

2 replies

J
JoanaC
December 3, 2024

Hi there, @AJC1641. Let me provide more insights on bulk upload to Bill Pay.

 

The option to bulk upload bank information data for contractors from payroll to Bill Pay via spreadsheets is not available at the moment. The distinctions between bill payment and payroll for contractors in QuickBooks Online. Bill payment involves settling invoices for goods and services a company receives, while payroll for contractors pertains to compensating independent contractors or freelancers hired by the company. These are two separate functionalities within the platform.

 

The option to bulk upload bank information data for contractors from payroll to Bill Pay via spreadsheets is not available at the moment. However, you can still utilize the Bill Pay feature effectively. First, you need to add your vendors to the system manually. After completing the initial setup, you can schedule multiple bill payments at once without needing bulk uploads. Additionally, if there are multiple payments scheduled for the same vendor, these will be automatically merged into a single transaction.

 

  1. Go to Expenses and select Vendors.
  2. Click New Vendor and provide the necessary information.
  3. Hit Save.

 

To schedule a bill payment:

 

  1. Create a new bill in the Expenses and then Bills.
  2. Hit Save and Schedule Payment.

 

For further details on using the Bill Pay feature, please refer to this informative article: Learn about QuickBooks Bill Pay for QuickBooks Online.

 

Additionally, you can set up roles and permissions for paying bills and control who can create, edit, approve, and pay the bills.

 

Feel free to keep your questions coming if you need more assistance with your Bill Pay setup. The Community is here to help you every step of the way.

A
AJC1641Author
December 3, 2024

@JoanaC Is it possible create the vendor via an upload spreadsheet that includes the bank routing and account number. I have 300 vendors to create in the Bill Pay function and I would rather do it by upload if possible. 

A
Anonymous
December 3, 2024

Currently, the option to upload vendors, including bank routing and account numbers, is unavailable in QuickBooks Online (QBO), AJC1641. I'll elaborate further on this matter.

 

Importing Vendor in QBO only includes, Name, Company, Email, Phone, Mobile, Fax, Website, Street, City State, ZIP Country, Opening Balance, Date, and Tax ID.

 

Moreover, you can set up roles and permissions for paying bills and control who can create, edit, approve, and pay the bills.

 

Feel free to keep your questions coming if you need more assistance with handling your vendors. Just add a reply and the Community is here to help you every step of the way.

B
bourbondog
December 15, 2024

Well here is another issue - I have contractor who  are my vendor as they are both within QB online and setup to pay ach - I have the elite payroll why do I need to pay an addtional fee to use pay within the bill payment section isn't this is to me double dipping on intuit side.

 

I have also posted yesterday about the getting locked up trying to use the contractor payment to no avail.

 

I have tried everything to get it to work and still nothing works - yes I have many contractors who are also vendors 300 plus - this is one and the same so I don't understand the double entry for ACH - Bank Setup once the bank information is under the vendor it should transfer over to contractor does not WHY?

J
Jelayca V
December 15, 2024

Thank you for your getting back to us, @bourbondog. Your concerns are valid, and I would like to clarify a few points regarding the fees for ACH payments.

 

While QuickBooks Payroll Elite offers benefits for payroll processing, it does not cover features related to payment processing, unless you’re tied to the separate Bill Pay feature. If you were subscribed to Bill Pay Elite, those fees for ACH payments would not apply. For more details, please check out the article: QuickBooks Bill Pay.

 

Additionally, I recognize that being unable to use the Pay contractors feature can disrupt your workflow, @bourbondog. I recommend contacting our dedicated Support team to investigate this behavior further. They have the tools and expertise, including screen sharing, to identify the root cause of the issue. If necessary, they can also create a support ticket for further investigation.

 

  1. Navigate to the Help menu.
  2. Click the Search tab.
  3. Type in contact support and press Enter.
  4. Click Contact Us.
  5. Choose between Callback or Chat.

 

Additionally, you can refer to this article to generate a report on all money paid to your vendor for the year: Run a report with vendor totals.

 

If you have any questions, feedback, or concerns regarding the pay stubs option for contractors, please don't hesitate to click the Reply button below and I'll be here to assist you.

Terms & ConditionsAccessibility statement