IS it possible to batch process transactions?

We're happy to see you here, @TUSSU. I'm here to outline the steps to rectify an incorrectly entered transaction type in QuickBooks Online (QBO) that is already reconciled. 

I understand the convenience of batch modifying the type of transactions. However, this option is currently unavailable in QBO. 

To correct this, you'll need to delete the expense transactions. Then, utilize the audit log so you can recreate them as transfers. Once done, manually mark the individual entries as reconciled. To do that:

1. Go to the Gear icon and select Chart of Accounts.
2. Find the account and click Account History.
3. Search the transactions you re-entered and select it to expand the view.
4. Click the empty field multiple times under the check (✔) icon column until the letter R appears. It indicates the transaction is reconciled.
5. Select Save and close the register.
   

Moreover, I'm sharing this article to help regularly review your accounts in QBO to ensure they align with your bank statements: Learn the reconcile workflow in QuickBooks. It also contains troubleshooting options if ever you encounter issues when reconciling.

Let me know in the comments below if you have any clarifications about batch-changing the type of transactions. We're always here to help. Take care and have a good one.

Thank you for your quick reply, it is night time in Ireland so I will do this first thing in the morning and report back here on my progress

Best Regards,

Noel

HI,

I have followed your instructions and deleted the expenses, entered them again as Transfers and then set all of the transfers to R in the chart of accounts. However, when I go to reconcile I am now getting this message:

my account is not ready to be reconciled my beginning balance balance is off by -€1300.

Everything is copied from the expenses to the Transfers exactly as they were in the expenses.

Please see attachment

Best Regards,

Noel

Hello TUSSU, If those deleted transactions were already marked as reconciled then deleting the transactions and re-creating them and marking as R shouldnt create discrepancies. If you remove the R mark on the transactions you re-created does that decreases the discrepancy amount? 

Hi,

thank you for the quick reply, I checked everything again some of the items that I had deleted were still there even though Quickbooks tells me they were deleted I had the click delete on some entries three times to finally get them to disappear, All the expense entries are now gone and have been replaced by Transfer entries. The next problem is that they are appearing in the balance sheet. Should they be there? if not, how to stop them from appearing there?

Best Regards,

Noel

Hi Noel, thanks for coming back to us and letting us know how you got on, so yes if the transactions were fully deleted those shouldn't show on the balance sheet. Are you able to check the audit log and see that the expenses were really deleted? Once you can confirm that the expenses are showing as deleted on the audit log, can you please clear your cache and cookies to all time, close the browser down, reload it and log back in and see if that then shows them removed off the balance sheet. 

Hi, I have checked the audit log and the Expense entries are fully deleted however, when I check the bank they have arrived in the bank queue to be processed!!

When I run the report "ATM Withdrawals" is still in the balance sheet but all of the entries in it are "Transfer"

I even open QuickBooks in incognito mode and the results are the same.

Best regards,

Noel

Hi Noel, thanks for getting back to us here. When a transaction that has been added or matched from the bank feed is deleted, the entry will return to the for review screen. From here, the transaction can be re-reviewed or removed (tick the check-box to the left > scroll to the top of the page and click exclude). 

Your balance sheet will show asset accounts which includes bank accounts; is your 'ATM Withdrawals' account listed with the account type 'Cash at bank and in hand' in your Chart of accounts? 

Hi,

no, it is listed as cash and cash equivalents. I don't see "Cash at bank and in hand" in the drop-down list. 

Is there a course or anywhere that I can learn how to do all of this in Quickbooks? I have taken the official training but that does not teach you what to do if you have a problem like this one. The exclude option is new to me is there somewhere to learn about all of the functionality?

Regards,

Noel

Thats brilliant, thank you very much for taking so much time with me and your great explanations

Best Regards,

Noel

Hi there, Noel. 

We're glad to know that we are able to provide additional guidance when working with your banking transactions.  Please know that you can always reach out to us again anytime you need more help with QBO.