Skip to main content
October 1, 2022
Question

Invoices created via csv import have payments (ACH and Credit Card) turned off. How can I make sure payments are automatically turned on?

  • October 1, 2022
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

October 1, 2022

Hello, chaseanthonyross.

 

Before we take care of those invoices, I'd like to ask some more details. 

 

Do you use our QuickBooks Payments service? Or do you have a third-party processor that takes care of the payments? 

 

More details would definitely help. 

October 2, 2022

Sorry for being so vague. Yes, I am using QBO payments. When creating an invoice manually, I can see my settings (see below) apply and ACH and CC payments are automatically turned on.

 

Account and Settings >> Sales >> Invoice Payments >> Accept Credit Cards (on) and Accept ACH (on)

 

However, when using the csv import feature to import invoices, regardless of my payment settings turned on, ACH and CC payments are turned off in the imported invoices. This must be something that can be automatically applied when importing and invoice csv. I shouldn't have to manually edit each imported invoice to turn payments on.

 

Your example import seems to be the exact solution I'm looking for. Can you confirm the following?

 

ToBeEmailed: Once uploaded, each invoice will be auto emailed to the customer email on file?
AllowIPNPayment: Instant Payment Notification, correct? What does this accomplish?
AllowOnlineCreditCardPayment: Will this turn on Credit Card payments?
AllowOnlineACHPayment: Will this turn on ACH payments?

 

Fiat Lux - ASIA
October 1, 2022

@chaseanthonyross 

You can prepare your Invoices data with the following template

RefNumberCustomerTxnDateDueDateShipDateShipMethodNameTrackingNumSalesTermLocationClassBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgBillEmailBillEmailCcBillEmailBccCurrencyExchangeRateDepositToBePrintedToBeEmailedAllowIPNPaymentAllowOnlineCreditCardPaymentAllowOnlineACHPaymentShipAmtShipItemDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y MP3 PlayerBlue MP3 Player255  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y HandheldsPortable Game Player1100  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y Software1 Year Warranty125  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y Extended Warranty1 Year Extended Warranty15  TAX
103Lisa Smith01/10/2020    Net 30  19 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!     0NYNNY        Gift Certificate$50 Gift Certificate150  NON

 

then utilize an importer tool to proceed

https://transactionpro.grsm.io/qbo