Bank Reconciliation - Deleted Transaction

Hi AESTexas,

I'll assist you in breaking down your single transaction so that the amounts are spread across different expense categories. However, You don't have to undo and split the charge because it's already reconciled, which means it shows in your bank statement as one big amount.

What you can do is Just open the transaction from the register and break the amounts into different categories. Just make sure the total amount stays the same.

To open the transaction from the bank register:

1. Click the Gear icon and choose Chart of accounts.
2. Choose View register on the register in concern.
3. Click the transaction and choose Edit.
4. In the Category detail section, select the different categories where the portions should be reported and enter the amount of each of them.
5. Click Save and close.

Your reconciliation report will not be affected in this process because the amount hasn't changed.

Let me know if you have more questions about correcting your reconciled transaction. Take care and have a good one!

Thank you JessT

So the $4k I'm trying to break out is multiple vendors with different categories. I think I need to delete this transaction all together instead so I input each transaction for each vendor and the appropriate category. Is this possible after the bank account has been reconciled for the month?

Hi JessT,

Unfortunately I think this won't work for me. I just tried and it's multiple payees vs. categories. I need to break out the $4k out into about 20 transactions instead. How can I delete the $4k entry after the bank account has been reconciled without affecting the reconciliation? 

Thanks for getting back to us, @AESTexas. 

Allow me to step in and share some details on how you can break out the $4k Journal Entry (JE) into 20 transactions in QuickBooks Online (QBO).

We can delete the created JE, recreate them, and link it to the corresponding vendors, and ensure to enter the same date. This way, it'll not affect your reconciliation.

Here's how:
 

1. Select Settings and then Chart of Accounts.
2. Find the account you created the journal entry for. Then click Account History.
3. Find the journal entry in the account register. The word "Journal" should be in the Ref No. or Type column.
4. Tap the journal entry to expand the view.
5. Hit Delete.
6. Click Yes to confirm.
    

Once done, you can recreate the JE and link them to the vendors. 

When everything is done, you'll need to manually reconcile them. You can follow the instructions I provided above and click the box until "R" appears. With this, I would encourage you to consult with your accountant to keep your financial data accurate.

I've added here an article that will help you in case you encounter reconciliation issues: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online. 

Please let me know in the comment section below if there is anything else I can do to assist you with bank reconciliations. I'll always be nearby and ready to assist you, @AESTexas.