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

Import class

I am importing invoices from excel into QB. It works well but I cannot import "Class" onto invoices.

Can anyone help with this ?

Solved
Best answer May 17, 2022

Accepted Solutions
JamaicaA
QuickBooks Team

Import class

Congratulations on making your first post here, @JB1234567. I'm here to share some insights about importing invoices with classes that will surely clear things out for you.

 

I can see the importance of being able to add a class to the invoice. I also understand how this option would benefit your business as well as others. However, this is currently unavailable in QuickBooks Online.

 

If you used the sample file for importing invoices and you added a class column, you’re unable to map it to QuickBooks. That's the same even if you created the excel file on your own.

 

As a workaround, you’ll need to assign classes manually after the importing process. You can also look for a third-party application that suits your needs. Just visit the QuickBooks App Center through this link: https://apps.intuit.com/.

 

The option to add a class when importing invoices is a great idea to implement in the future. I’d suggest sending feedback request to our product development team. They will evaluate these and pick some of them to include in future updates. This way, we can cater to your business needs better. 

 

Here’s how:

 

  1. Go to the Gear icon.
  2. Under the Profile column, click on Feedback.
  3. Share your feedback. Then, click Next.

 

QBO feedback.png

 

You'll want to track your suggestion through this website. You can also visit our blog to keep up with all of our recent events and developments.

 

To learn more about importing your invoices, you can check out this reference: Import multiple invoices at once. This includes the data you can add into the program along with its process. 

 

I’ve included these additional resources for receiving invoice payments and to learn more about how class works in QuickBooks: 

 

 

Let me know if you need more help with importing invoice transactions. I'll be here to help. Have a great day.

View solution in original post

6 REPLIES 6
JamaicaA
QuickBooks Team

Import class

Congratulations on making your first post here, @JB1234567. I'm here to share some insights about importing invoices with classes that will surely clear things out for you.

 

I can see the importance of being able to add a class to the invoice. I also understand how this option would benefit your business as well as others. However, this is currently unavailable in QuickBooks Online.

 

If you used the sample file for importing invoices and you added a class column, you’re unable to map it to QuickBooks. That's the same even if you created the excel file on your own.

 

As a workaround, you’ll need to assign classes manually after the importing process. You can also look for a third-party application that suits your needs. Just visit the QuickBooks App Center through this link: https://apps.intuit.com/.

 

The option to add a class when importing invoices is a great idea to implement in the future. I’d suggest sending feedback request to our product development team. They will evaluate these and pick some of them to include in future updates. This way, we can cater to your business needs better. 

 

Here’s how:

 

  1. Go to the Gear icon.
  2. Under the Profile column, click on Feedback.
  3. Share your feedback. Then, click Next.

 

QBO feedback.png

 

You'll want to track your suggestion through this website. You can also visit our blog to keep up with all of our recent events and developments.

 

To learn more about importing your invoices, you can check out this reference: Import multiple invoices at once. This includes the data you can add into the program along with its process. 

 

I’ve included these additional resources for receiving invoice payments and to learn more about how class works in QuickBooks: 

 

 

Let me know if you need more help with importing invoice transactions. I'll be here to help. Have a great day.

Fiat Lux - ASIA
Level 15

Import class

@JB1234567 

Prepare your Invoice data with he 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

 

then utilize an importer tool to proceed.

https://transactionpro.grsm.io/qbo

 

JB1234567
Level 2

Import class

Thanks very much. Will look at TransactionPro. Appreciate you taking the time to respond

Phil_UK
Level 3

Import class

Hi JB1234567,

 

Thanks for asking this question - I'm now asking the same one! Did you take TransactionPro, and does it work as you expected?

 

I have to say I find this option looks rather expensive - £440 per year for all of QBO Plus, but another US$299 per year just because want to import data with class information (if we had less than 200 rows per month, we could do it manually, so their "Essentials" package isn't really essential). Since QBO Plus can import journals with class and location information, I really can't understand why they can't allow users to import transaction data with the same information - it's not that different!

Ashleigh1
QuickBooks Team

Import class

Hello Phil_uk, thanks for posting on this thread, we will pass this feedback onto the relevant team. 

 

copycareoffice
Level 2

Import class

Look at Zed Axis. I have used it with desktop version for years and am now using it to import over to online.

Need to get in touch?

Contact us