Skip to main content
T
TUSSU
October 26, 2023
Solved

IS it possible to batch process transactions?

  • October 26, 2023
  • 1 reply
  • 0 views

Hi,

I have about 12 ATM Withdrawal transactions that are incorrectly entered as "expense" and should be "transfer" one of them has been entered as bank deposit and most have been reconciled. Is it possible to batch change them from expense to transfer or do I need to delete them individually and re-enter as transfer and then reconcile them again or what is the best solution?

Best Regards,

Noel 

Best answer by JessT

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


Certainly, Noel!

 

While the official training for QuickBooks offers a strong foundation, it may not cover every specific issue or feature in great detail. However, there are additional resources available to help you expand your knowledge and comprehension of QuickBooks. I'd like to share insights about the Exclude option on the Banking page.

 

The Exclude feature allows you to remove specific bank transactions and prevents from adding them to your financial records. This feature is useful when you encounter transactions that are not relevant to your business or need further review before being included in your books.

 

To exclude a transaction, simply navigate to the Banking page in QBO, locate the transaction you want to exclude, and select the Exclude option. The transaction will be moved to the Excluded tab, ensuring it doesn't impact your financial records.

 

Remember, excluded transactions can be reviewed and re-included if necessary. This feature provides flexibility and control over your financial data, allowing you to maintain accurate and relevant records in QuickBooks Online.

 

Here's an article for your reference: Exclude a bank transaction you downloaded into QuickBooks Online.

 

I'm just a comment away if you need further assistance about the online banking feature in QBO. Take care and have a good one!

1 reply

JaeAnnC
JaeAnnC
October 26, 2023

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.

T
TUSSUAuthor
October 26, 2023

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

T
TUSSUAuthor
October 31, 2023

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

 

Terms & ConditionsAccessibility statement