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

Transaction Matching

Hello,


I am trying to match my banking transactions on Quickbooks Online and have run into an issue.  My daughter took our checks to the bank to be deposited and put the wrong dollar amount on the deposit slip.  The bank made the deposit and realized overnight that the total deposit amount was wrong and they made an additional entry to my account to cover the difference. (i.e. total deposits S/B $15,000.00, but the deposit slip read $14,490.00.  So the deposit into my account reads $14,490.00 with an additional entry of $10.00 as a back office adjustment.)

 

With all of that being said, I am squared away technically, but I am unable to match the checks in QB to the deposit from my banking info because the dollar amount is off.  Is there a way that I can combine two transactions to match with the checks that they coincide with? (i.e. is there a way I can combine the two transactions of $14,490.00 and $10.00 to match with the checks totaling $15,000.00?)

 

Any assistance on this would be very helpful.  I called the helpline, and no one seemed to know how to help me.

1 Comment 1
RenjolynC
QuickBooks Team

Transaction Matching

I have some steps that can help you, AmyF4.

 

When there are multiple transactions downloaded from the Banking page, you will be unable to match it to a single transaction recorded in QuickBooks Online. Instead, you can exclude the downloaded transactions ($14,490.00 and  $10.00) and manually clear the check ($15,000.00) in the register. 

 

To exclude, here's how:

 

  1. Go to the Banking > For Review tab.
  2. Select the transactions by putting a check mark on the boxes and click the Batch actions drop-down menu.
  3. Choose Exclude Selected.

Please see this sample screenshot:

 

 

Once done, the transactions will be added to the Excluded tab were you can undo or delete them. Here's an article for reference: Exclude expenses from downloaded bank transactions.

 

For clearing the checking, you can follow these steps:

 

  1. On the left panel, select Accounting > Chart of Accounts.
  2. Click the View register link of the bank account where the check was added.
  3. Find and select the check to show the options. Under the Reconcile (indicated by a check mark) column, click the blank field until you see the letter C. This letter means cleared and the letter R is for Reconciled.
  4. Press the Save button after.

 

Here's a sample screenshot:

 

 

 

You can also bookmark these article to use as a guide in the future: 

 

 

Please let me know if you have additional questions by leaving a comment on this thread. The Community is available 24/7 to help you some more. Take care. 

Need to get in touch?

Contact us