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! Go to Solution.
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.
RefNumber | Customer | TxnDate | DueDate | ShipDate | ShipMethodName | TrackingNum | SalesTerm | Location | Class | BillAddrLine1 | BillAddrLine2 | BillAddrLine3 | BillAddrLine4 | BillAddrCity | BillAddrState | BillAddrPostalCode | BillAddrCountry | ShipAddrLine1 | ShipAddrLine2 | ShipAddrLine3 | ShipAddrLine4 | ShipAddrCity | ShipAddrState | ShipAddrPostalCode | ShipAddrCountry | PrivateNote | Msg | BillEmail | BillEmailCc | BillEmailBcc | Currency | ExchangeRate | Deposit | ToBePrinted | ToBeEmailed | AllowIPNPayment | AllowOnlineCreditCardPayment | AllowOnlineACHPayment | ShipAmt | ShipItem | DiscountAmt | DiscountRate | TaxRate | TaxAmt | DiscountTaxable | LineServiceDate | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineClass | LineTaxable |
101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | MP3 Player | Blue MP3 Player | 2 | 55 | TAX | |||||||||||||||||||||
101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | Leather Case | Leather Case | 2 | 10 | TAX | |||||||||||||||||||||
101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | Gift Cards | Gift Cards | 2 | 5 | TAX | |||||||||||||||||||||
102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Handhelds | Portable Game Player | 1 | 100 | TAX | |||||||||||||||||||||||||||||
102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Software | 1 Year Warranty | 1 | 25 | TAX | |||||||||||||||||||||||||||||
102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Extended Warranty | 1 Year Extended Warranty | 1 | 5 | TAX | |||||||||||||||||||||||||||||
103 | Lisa Smith | 01/10/2020 | Net 30 | 19 Jerico Drive | Bensalem | PA | 84256 | 19 Jerico Drive | Bensalem | PA | 84256 | We appreciate your business! | 0 | N | Y | N | N | Y | Gift Certificate | $50 Gift Certificate | 1 | 50 | NON |
5. Re-import transactions to your QBO account.
Hope it helps.
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:
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.
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
i have too many transactions i need something for QuickBooks Online
Utilize the 3rd party apps as I mentioned earlier. Otherwise, consider purchasing a 3rd party service to do so.
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
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.
RefNumber | Customer | TxnDate | DueDate | ShipDate | ShipMethodName | TrackingNum | SalesTerm | Location | Class | BillAddrLine1 | BillAddrLine2 | BillAddrLine3 | BillAddrLine4 | BillAddrCity | BillAddrState | BillAddrPostalCode | BillAddrCountry | ShipAddrLine1 | ShipAddrLine2 | ShipAddrLine3 | ShipAddrLine4 | ShipAddrCity | ShipAddrState | ShipAddrPostalCode | ShipAddrCountry | PrivateNote | Msg | BillEmail | BillEmailCc | BillEmailBcc | Currency | ExchangeRate | Deposit | ToBePrinted | ToBeEmailed | AllowIPNPayment | AllowOnlineCreditCardPayment | AllowOnlineACHPayment | ShipAmt | ShipItem | DiscountAmt | DiscountRate | TaxRate | TaxAmt | DiscountTaxable | LineServiceDate | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineClass | LineTaxable |
101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | MP3 Player | Blue MP3 Player | 2 | 55 | TAX | |||||||||||||||||||||
101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | Leather Case | Leather Case | 2 | 10 | TAX | |||||||||||||||||||||
101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | Gift Cards | Gift Cards | 2 | 5 | TAX | |||||||||||||||||||||
102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Handhelds | Portable Game Player | 1 | 100 | TAX | |||||||||||||||||||||||||||||
102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Software | 1 Year Warranty | 1 | 25 | TAX | |||||||||||||||||||||||||||||
102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Extended Warranty | 1 Year Extended Warranty | 1 | 5 | TAX | |||||||||||||||||||||||||||||
103 | Lisa Smith | 01/10/2020 | Net 30 | 19 Jerico Drive | Bensalem | PA | 84256 | 19 Jerico Drive | Bensalem | PA | 84256 | We appreciate your business! | 0 | N | Y | N | N | Y | Gift Certificate | $50 Gift Certificate | 1 | 50 | NON |
5. Re-import transactions to your QBO account.
Hope it helps.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here