cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about connecting your bank and credit cards in QuickBooks Online
mohammed3
Level 1

Is it possible to import sales receipts with a class and/or custom field?

I assign classes to all sales receipts, and it would take a long time to manually input classes by opening each transaction individually that I have imported.

2 REPLIES 2
Chrea
Level 8

Is it possible to import sales receipts with a class and/or custom field?

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

 

EduardA
QuickBooks Team

Is it possible to import sales receipts with a class and/or custom field?

Currently, it is not possible to import sales receipts with a class and/or custom field as the required QuickBooks field when importing a sales receipt is already fixed, @mohammed3. However, you can make use of Batch transactions to seamlessly manage multiple sales receipts and add classes to them. Please note that this feature is exclusively available in QuickBooks Online (QBO) Advanced. Allow me to guide you on how to do it.

 

Here's how:

 

  1. Go to the + New button.
  2. Under the Other column, select the Batch transactions option.
  3. Tick Sales Receipts from the Select entity type dropdown, then click the Import CSV/Excel option.
  4. Locate your CSV file for sales receipts on your computer, then hit Next.
  5. Map the column headers in your CSV/Excel file to the QuickBooks fields. Required fields are marked with an asterisk (*).
  6. Click Next to continue.
  7. Review the data, then click either Save or Save and send option.


Alternatively, if you're using other QBO subscriptions, you can consider using the Custom fields option in QuickBooks to add classes when creating sales receipts.

 

Here's how to do it:

 

  1. Go to the Gear icon.
  2. Under the LISTS column, select the Custom fields option.
  3. Click the Add field option.
  4. Enter the Name, then select either the Text and number or Dropdown list option from the Data type.
  5. Tick the Sales Receipts and turn on its corresponding Print on form option. Hit Save when done.


Once saved, it will be automatically applied on the sales receipts.

 

Additionally, I'd like to share this article to you gain insights into your best sellers and the status of your stock: Use reports to see your sales and stock status in QuickBooks Online.

 

If you have any further questions regarding on sales receipts or importation of your data, please feel free to leave a comment below. The Community is here for you 24/7.

Need to get in touch?

Contact us