cancel
Showing results for 
Search instead for 
Did you mean: 
lrhmail451
Level 3

classes

is there any way to add classes to hundreds of transactions by exporting them out the QBO and then inputting them back into QBO without causing duplications inside QBO of these same transactions

 

 

if this can be done; please let me know 

 

 

Solved
Best answer July 28, 2022

Best Answers
Fiat Lux - ASIA
Level 15

classes

1. Create a backup point by using a backup restore application. Please note, You should continue to create multiple backup points at every step if needed

https://rewindio.grsm.io/quickbooks


2. Export transactions to XLS with the exporter tool. You should start from only 2-3 transactions to learn the process.

https://transactionpro.grsm.io/qbo


3. Delete transactions in your QBO account with the deleter tool

4. Modify the exported transaction in XLS to add Class. You will get to prepare the modified transactions 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


5. Re-import transactions to your QBO account.

 

Hope it helps.

View solution in original post

7 Comments 7
ChristineJoieR
QuickBooks Team

classes

Hi there, @lrhmail451.

 

I understand the importance of this function of being able to change class by batch action. I'm here to drop you some information.

 

We need to change it at a time since this option isn't available in QuickBooks Online. 

 

Here's how:

 

  1. Go to Sales
  2. Choose the Invoices tab.
  3. Find the invoice from the list and click it.
  4. Change the Class of the invoice.
  5. Click Save and close.

 

Feel free to visit this article for a piece of additional information: Get started with class tracking in QuickBooks Online.

 

Alternatively, check out this article for your guide on how to run the report by class in QuickBooks Online Plus and Advance.

 

We We can also look for an application that meets your needs and is compatible with QuickBooks. It is available from our QuickBooks App Center. Enter the app name or keyword into the search bar, and QuickBooks will automatically filter the apps for you.

 

Feel at ease to comment below if you have other questions about pulling up reports in QuickBooks. I'll be happy to assist you again. Keep safe and enjoy the rest of the day.

Fiat Lux - ASIA
Level 15

classes

@lrhmail451 

You need to utilize the exporter, importer, and deleter to speed up the process.

https://transactionpro.grsm.io/qbo

 

Utilize the trial version of a backup restore app during the process.

https://rewindio.grsm.io/quickbooks

 

lrhmail451
Level 3

classes

i have too many transactions i need something for QuickBooks Online

Fiat Lux - ASIA
Level 15

classes

Utilize the 3rd party apps as I mentioned earlier. Otherwise, consider purchasing a 3rd party service to do so.

lrhmail451
Level 3

classes

i am sorry but you did not explain what to do

step 1

step 2

and so on

 

by the way i do have transaction pro for imports and exports we use it for payroll

ive done alot of imports and exports on the dest top version but not on line

i find it hard to test when you have an account online 

you can not make a test back up online and use that to test with like you can with a desktop version

but if i had the steps i think i can work from that

 

#1 how do i get all transactions that do not have a class downloaded

or do i download all transactions class and no classes

 

#2 when i am done adding the class where i need it can i import those same transactions back to system and not have my transaction duplicated in the process

 

 

 

 

 

Fiat Lux - ASIA
Level 15

classes

1. Create a backup point by using a backup restore application. Please note, You should continue to create multiple backup points at every step if needed

https://rewindio.grsm.io/quickbooks


2. Export transactions to XLS with the exporter tool. You should start from only 2-3 transactions to learn the process.

https://transactionpro.grsm.io/qbo


3. Delete transactions in your QBO account with the deleter tool

4. Modify the exported transaction in XLS to add Class. You will get to prepare the modified transactions 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


5. Re-import transactions to your QBO account.

 

Hope it helps.

FritzF
Moderator

classes

Hi there, Fiat Lux - ASIA.

 

I appreciate you for always sharing your knowledge about QuickBooks. This will definitely help other users as well in the future.

 

Keep safe and have a great rest of the day.

Need to get in touch?

Contact us