cancel
Showing results for 
Search instead for 
Did you mean: 
comet52
Level 1

Split previous transaction

Our business has a monthly lease payment that includes electrical.  We decided this should be split going forward.   I need to fix the last several payments that weren't split.  

 

I went to the first one, unmatched it, re-entered it as a split and saved.  However in the bank register, there is now the split transaction and another transaction for the same amount that is not split.  I thought unmatching would remove the old transaction.   I'm attaching a screen shot--I wiped the $ amounts for privacy but they are the same.   Do I just delete the second transaction?  Not sure what to do here.

 

The other question I have is, to fix the last several months will involve doing this with reconciled transactions so what other issues are going to arise?  Thanks.

3 Comments 3
Mich_S
QuickBooks Team

Split previous transaction

Hello there, @comet52.

 

I've got some insights to share with you about handling split transactions in QuickBooks Online.

 

To avoid a transaction from being duplicated if you un-match then split it, you'll have to re-match it after saving it. I can show you how:

 

To undo transaction:

 

  1. Open the Baking menu, then select the Banking tab.
  2. Choose the bank account you want to work with.
  3. Go to the Categorized tab.
  4. Locate the transaction and click on UNDO.

After that, stay on the Banking page and follow these steps to re-match it:

 

  1. Go to the For Review tab.
  2. Locate the transaction to match then click it,
  3. Match it to the split transaction then click on Match.

 

In case you'll have further questions specific to accounting or your register especially reconciled transactions, I suggest getting in touch with your accountant. They'll be able to look into this further and give you the best resolution to your issue.

 

 

For future use, read these articles about managing transactions in QBO:

 

I'm always here to back you up if you need other concerns with banking or QuickBooks. Take care!

 

comet52
Level 1

Split previous transaction

That just rematches it as a rent check and the electric is no longer categorized.  The split got lost.

MariaSoledadG
QuickBooks Team

Split previous transaction

Let me guide you on what you can do with your split transaction, comet52.

 

Any changes made to your reconciled transaction such as editing or deleting may affect your books. You'll want to make the changes directly from those transactions that were already reconciled. You can undo the reconciliation and edit the transaction that wasn't split yet. 

  1. Go to the Gear menu and choose Chart of Accounts.
  2. Look for the bank where you're reconciled transactions belong.
  3. Click View register.
  4. From there, you'll see reconciled transactions marked as under the Check column. 
  5. To undo them, you have to repeatedly click the box to change the status to Blank (unreconciled). 
  6. Once done, select Save

 

Then, you can reconcile those transactions after editing them. In connection to this, you can delete those transactions that you no longer need and weren't reconciled yet. You can click the Delete button to remove duplicates. I've attached a screenshot for your guide.

 

Additionally, learn how to view and export reconciliation reports in QuickBooks. I've added this article for your reference: How Do I View, Print, or Export A Reconciliation Report?

 

Please get back to us if you have any questions about your bank transactions. We'll always be right here to help you.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us