Skip to main content
November 24, 2020
Question

Hi, I have imported invoices for our sales on Shopify. Is there any way to import mass receipt or batch "receive payment" for these invoices in quickbooks online?

  • November 24, 2020
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

PatriciaT
November 25, 2020

Hi radha,

 

Good job on importing your invoices in the program. QuickBooks Online has several tools to ensure you don't start from scratch in your bookkeeping. I'll be happy to share more on this.

 

At the moment, there's no option available to import invoice payments in QuickBooks Online. While you can import invoices, manually adding the associated payments is the way to go to make sure everything is entered correctly. Here's an article to assist you with that: Record invoice payments in QuickBooks Online

 

Feel free to also check out our Apps menu to explore any third-party application that could better assist you with your task. 

 

I hope this helps to clarify things for you! Don't hesitate to reach out if you have more questions.

Fiat Lux - ASIA
November 25, 2020

@radha 

You may utilize TPImporter

https://transactionpro.grsm.io/qbo

 

Prepare the Sales Receipt data with the following template

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