cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
sanober-bhojani-
Level 1

I download stripe transactions from stripe and manually create sales reciepts for each customer. Is there a way to upload the excel and generate receipts automatically?

 
2 REPLIES 2
4Gal
Level 11

I download stripe transactions from stripe and manually create sales reciepts for each customer. Is there a way to upload the excel and generate receipts automatically?

You can prepare 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

 

then use an importer tool to proceed.

https://get.transactionpro.com/qbo

 

IrishNinoJ
QuickBooks Team

I download stripe transactions from stripe and manually create sales reciepts for each customer. Is there a way to upload the excel and generate receipts automatically?

Hello there, sanober.

 

Yes, you can import Excel using a CSV file. Open the Import sales receipts tool. 

 

Here's how:

 

  1. Select the Gear icon.
  2. Under Tools, choose Import data.
  3. Select Sales receipts.

 

Once done, upload a CSV file, and you can check out this article to see the example data file available:  Preview what's required to import sales receipts

 

Lastly, you can map your column headings and import sales receipts. Refer to step 3 and step 4 for a step-by-step guide: How to import sales receipts

 

Keep us posted if you have other questions or concerns. Feel free to come back here in the Community, we're here to assist you 24/7.

Need to get in touch?

Contact us