cancel
Showing results for 
Search instead for 
Did you mean: 
accountant-syrom
Level 1

Hello, Is there a way to enter ACH payment received (200 ) details without manually entering each customer?

 
4 Comments 4
AileneA
QuickBooks Team

Hello, Is there a way to enter ACH payment received (200 ) details without manually entering each customer?

Hello, accountant-syrom. 

 

Welcome to the Community. I can share some information about applying ACH payments in QuickBooks Online. 

 

In QuickBooks, You'll need to enter his/her bank information to process ACH payments. Once your customer already provided his/her bank information. You'll have the option to save it for future use. This way, you don't have to re-enter every time they pay you via ACH. 

 

Please note that you must sign up for QuickBooks Payments first to enable ACH bank transfer.

 

Here's how to set it up:

 

  1. Go to the +New icon and pick Sales Receipt or Receive Payment.  
  2. On the Payment method section, click the drop-down, then Add new.
  3. Enter ACH as a new payment method, then select Enter bank info to open the Enter bank account info window.
  4. Enter the necessary information, then check the Use this account information in the future box.
  5. Click the signed authorization link to open the Bank Transfer Authorization Form or select the authorization script link to open the authorization script, then have your customer fill out and sign the form or read the script.
  6. Check the I have signed authorization box, then Save.

 

Once done, make sure to check the box beside the I have authorization and would like to process this transaction under Payment method section before sending it to your customer. Here's an additional article for future reference: Receive ACH bank transfers

 

To learn more about QuickBooks Payments, you can read through these articles. It also provides links that will you guide in navigating your QuickBooks account.

 

 

Please let me know if you have other concerns with ACH payments or questions about QuickBooks. I'll be around to help you out. Take good care and stay healthy.

Fiat Lux - ASIA
Level 15

Hello, Is there a way to enter ACH payment received (200 ) details without manually entering each customer?

@accountant-syrom 

You may utilize an importer tool to import (i) Receive Payments data to apply to your existing Invoice data, or (ii) Sales Receipts if you didn't create the invoice.

https://transactionpro.grsm.io/qbo

 

Prepare data with the following template

Receive Payments

RefNumberTxnDatePaymentRefNumberCustomerPaymentMethodDepositToAccountInvoiceApplyToLineAmountPrivateNoteCurrencyExchangeRate
128/11/202050245Janice JohnsonCheckChecking101100.00   
228/11/20204908Leonard Walker IncCheckChecking102138.78   
328/11/20204908Lisa SmithCheckChecking103126.50   

 

Sales Receipts

RefNumberCustomerTxnDateShipDateShipMethodNameTrackingNumLocationClassBankAccountPaymentMethodPaymentRefNumberBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgCurrencyExchangeRateBillEmailToBePrintedToBeEmailedShipAmtShipItemTipAmtDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y HandheldsPortable Game Player1100  TAX

 

emericaskate0707
Level 1

Hello, Is there a way to enter ACH payment received (200 ) details without manually entering each customer?


@AileneA wrote:

Hello, accountant-syrom. 

 

Welcome to the Community. I can share some information about applying ACH payments in QuickBooks Online. 

 

In QuickBooks, You'll need to enter his/her bank information to process ACH payments. Once your customer already provided his/her bank information. You'll have the option to save it for future use. This way, you don't have to re-enter every time they pay you via ACH. 

 

Please note that you must sign up for QuickBooks Payments first to enable ACH bank transfer.

 

Here's how to set it up:

 

  1. Go to the +New icon and pick Sales Receipt or Receive Payment.  
  2. On the Payment method section, click the drop-down, then Add new.
  3. Enter ACH as a new payment method, then select Enter bank info to open the Enter bank account info window.
  4. Enter the necessary information, then check the Use this account information in the future box.
  5. Click the signed authorization link to open the Bank Transfer Authorization Form or select the authorization script link to open the authorization script, then have your customer fill out and sign the form or read the script.
  6. Check the I have signed authorization box, then Save.

 

Once done, make sure to check the box beside the I have authorization and would like to process this transaction under Payment method section before sending it to your customer. Here's an additional article for future reference: Receive ACH bank transfers

 

To learn more about QuickBooks Payments, you can read through these articles. It also provides links that will you guide in navigating your QuickBooks account.

 

 

Please let me know if you have other concerns with ACH payments or questions about QuickBooks. I'll be around to help you out. Take good care and stay healthy.


Is their a way to enter multiple ACH bank account and routing numbers at once? Or, does it have to be manually entered one at a time?

 

If I wanted to split an ACH transaction into separate invoices, do I have to manually enter each bank account or can it be done all at once to save time?

 

Is it optional?

katherinejoyceO
QuickBooks Team

Hello, Is there a way to enter ACH payment received (200 ) details without manually entering each customer?

Thanks for following this thread, @emericaskate0707. It's best to enter multiple ACH bank transactions with different routing numbers in QuickBooks manually. 

 

And yes, you'll need to enter these details into separate invoices. 

 

For future references, you also want to learn more about how to manage split transactions between multiple accounts from your connected bank accounts: Categorize and match online bank transactions in QuickBooks Online.

 

Feel free to share your concerns again here in the Community. I'd be here to guide you more. 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up