Hello All,
I have posted a lot of transactions in the wrong P&L accounts. It will take me several weeks to take them into their correct accounts. Is there an easier alternative of correcting these transactions In bulk to the desired accounts?
Many thanks in advance,
Kind regards,
I got the options to help you re-categorize your transactions, nyagafc.
If they are from the Banking screen, just undo them. Then, re-categorize and add them back to your bank account. Here’s how:
For expenses, you can categorize them in the Expenses section.
If you use product items, you change the account of the item. Then, select the option that says Also update this account in historical transactions. Please see the screenshot.
If you have other questions, feel free to comment down below.
Hi!
This is very helpful! I'm not sure how I never noticed this before... :D
Question though... what if one of the transactions in the list is Split? Will it change the entire transaction or only the Split line? I guess I could try this with one transaction, but if it changes the entire transaction, then I would think others viewing this thread might need to realize that before starting.
Good day, sharks17.
Re-categorizing the split transactions will not affect the entire split line. This will only change the
modified one.
You can learn more about split transactions in the following article below:
If you have other questions or need help with anything about QuickBooks, please leave them in the comment below. I'll be glad to get back and provide further assistance.
Does anyone know how to do this for the desktop version?
Hello there, @philipjacobs,
Currently, there isn't an option to re-categorize your transactions by batch. As an alternative, you'll have to manually change the accounts and payees of each transaction before adding them to the register. See the screenshot below for your visual reference. To learn more about this process, go through this article: Add and Match Bank Feed Transactions.
If you're using the 2019 version, I'd suggest visiting this website: What's New. This link contains more information about our product improvements that can benefit you and your business.
You can count me in if there's anything else you need. Have a great day, @philipjacobs.
Thank you for that info, it would be greatly helpful but (unless I'm missing it), there is no UNDO button - Item 3 - that I can find. Can you direct me. Everything else in your description makes perfect sense.
Hi @InfoPrincess,
I'm here to direct you to the right page so you can undo your added or matched transactions. This can be done by selecting the correct sub-tab in the Banking menu.
There are 3 sub-tabs under the Banking menu. These are For Review, Reviewed, and Excluded. You'll have to ensure that you've clicked on the Reviewed sub-tab to achieve your goal. Refer to a sample screenshot below.
You can follow the same steps provided by my peer JessT above, and you'll be good to go.
As for the steps on how you can categorize your bank feeds, view this article: Download, match, and categorize your bank transactions in QuickBooks Online.
I'll be around in case you need further assistance. Feel free to drop a comment below, and I'll get back to you.
Almost got it! What if the Batch Actions > Categorized Selected is not selectable? It is showing up but I cannot use it to re-categorize.
Thank you for joining the thread, @tina13vb.
Let me provide some information about categorizing transactions on the Expense Transactions window.
At this time, we aren't able to include the split transactions when categorizing expenses in batch. If you've selected a split expense/s that would be the reason why the Categorize selected button is grayed out. So you can proceed with the process, I recommend excluding the split entries from the selected transactions and just manually categorize them.
I've added these screenshots for your visual reference.
Get back to me if you have any other questions. I'm always here to help. Have a good day!
Thank you for that clarification. However, I did NOT select a "Split" transaction, and the Categorize Selected is still not available. See attached.
Thank you for getting back here, @tina13vb.
Initially, when you select the unsplit transaction, you must be able to categorize them. Let me help you fix this.
You can perform some troubleshooting by opening an incognito/private browser to check if this is caused by some browsing issues.
You can use these keyboard shortcuts in opening an incognito/private browser:
If you’re unable to categorize expense transactions, you need to offload some data from your default browser by clearing its cache. This way, your browser can process data faster and improve its performance.
You can check this article for future reference: Reclassify or move multiple transactions at once.
Please let me know how it goes. I'd be glad to help you as soon as I can. Take care.
If you would like to reclassify multiple transactions in QuickBooks Online, click on the Accountant Tools next to the handbag icon. Then select reclassify transactions.
This is an easy way to move transactions from one account to the next.
Hello there, Vventures,
The Accountant Tools is located at the top of your QuickBooks account. If you're using QuickBooks Online Accountant, you can see this:
Please let me know if you need further assistance.
Hey,
What if i entered all the expenses manually and made payment from an "X" account but now i have to change only the payment account for all the transaction from "X" bank a/c to "Y" bank a/c?
is this possible if we have entered all the expense transaction manually?
You can manually edit your expense transaction to change your payment account, Shona7689.
Entering expenses can be done under the Vendors' menu or Register if this is for a large number of expenses to create. Then, you'll have to open each transaction and do the changes from there.
Here's how:
For paid bill:
For expenses, you can open the transaction and manually change the account.
Please check this article for more information if you're billing this expense to a specific customer: Enter, Edit, or Delete Expenses in QuickBooks Online.
To track the total expenses entered in QuickBooks, you'll want to run an expense report to show the total amount: Run Reports.
Please touch base with us if you have any other concerns. I'll always be here to help you.
Hi, can you re-categorize the transactions using Quickbooks Desktop.
I have 1,000 of transactions which were entered for the same vendor but as an expense. I need to change it from expense into item, when I enter bill for this vendor.
Is there a way to change the bills at once or do I have to click on each individual bill, delete all fields in "expense" and re-enter it as "item"
Thank you
Yana
I forgot to mention that I am using Quickbook Desktop Pro 2020.
Thanks for following this thread, @YanaSletten.
While we're unable to edit transactions at once, we'll have to open each transaction and delete the information entered on the Expense tab and enter the items on the Items tab. Let me show you how:
To delete an expense
To re-create a bill and enter it as an item
For future reference, read through this article: Add, edit, and delete items. It includes answers to commonly asked questions about items in QuickBooks Desktop.
Let me know if you have additional questions. We're always delighted to help.
You may need a 3rd party app to speed up your works.
Hi there, @LadyAnna.
I'd be glad to help you re-categorize your transactions by batch in QuickBooks Desktop and QuickBooks Online.
If you're referring to QuickBooks Online version about re-categorizing your transactions. I'll show you the steps below.
Here's how to do that for the transactions found in the Banking page:
I've added some screenshots below for your additional reference.
Here are the steps if you're referring to the Expenses in QuickBooks Online:
For more information about editing expense transactions, you can review this article: Enter, edit, or delete expenses in QuickBooks Online.
However, if you're referring to the QuickBooks Desktop, the option to re-categorize the transactions by batch is unavailable. As a workaround, you can change the payees and accounts manually before adding them to the register. To learn more about this process, you can check out this article: Add and match Bank Feed transactions in QuickBooks Desktop.
I've also added these articles you can refer when you're ready to reconcile:
You can always tag my name in the comment section below if you need further assistance with QuickBooks. I'd be happy to help. Take care and have a wonderful day.
Is there a way to change the payment account on multiple expenses at once? I am working on my profit and loss detail report and noticed that the expenses are categorized incorrectly with Amex or cash on hand instead of how I want them categorized. Is there a way to change multiple expenses by vendor without having to manually change each expense?
Thanks for joining this thread, dianeito.
Yes, you can directly change multiple expenses by Vendor through the Expenses tab. Please follow the steps I outlined below:
These steps will pull up the transactions you want to change the account, then click the Batch action menu and select Categorise selected.
Keep on posting if you need more help.