Skip to main content
March 22, 2023
Question

Match multiple bank transactions to a single receipt/expense

  • March 22, 2023
  • 1 reply
  • 0 views

Hi Community,

 

I have found several "answers" to the question above but none of them appear to be what I am looking for.  So, I have purchase an item form a person for £750.00 cash.  I paid cash and withdrew three seperate ammounts of £250.00 from an ATM (maximum daily ammount).  I have a repiept from that person for £750.00 which I scanned into QBO and created an expense from that.

 

I have, of course, three seperate transactions in QBO that I want to match to that expense, what is the correct way to match those transactions with that expense?

 

Thank you in advance for your help.

 

 

1 reply

March 22, 2023

Matching multiple transactions to a single receipt is a great functionality, Campersteve.

 

As of now, we're unable to match a single expense in QuickBooks to multiple withdrawals. QuickBooks Online only suggest matches that have the exact amount. 

 

In the meantime, we can manually clear the expense you recorded within QuickBooks and exclude the withdrawals to avoid duplicates. 

 

Here's how to exclude the downloaded transactions: 

 

  1. Go to Bookkeeping, then select Transactions.
  2. Select Bank transactions 
  3. Click the bank account.
  4. From the For Review tab, select the expense transactions.
  5. Click Exclude.

 

Once done, we can now manually clear the expense:

 

  1. Go to the Gear icon and then click Chart of Accounts.
  2. Look for the checking account and click View register under the Action column.
  3. Select the Expense and under the reconciliation status column indicated with a checkmark.
  4. Then, repeatedly click the box until it displays the cleared ( ) status.
  5. Click Save.

 

I can see how this feature would be beneficial to your business. I encourage sending feedback directly to our Product Development team. This helps us improve the program. I'll show you how:

 

  1. Go to the Gear menu and then select Feedback.
  2. Type in your feature request in the description box.
  3. Once done, click on Next.

 

Additionally, I've added this article that'll help you review your accounts in QuickBooks to make sure they match your bank and credit card statements: Reconcile an Account.

 

You're always welcome to share other concerns or questions you might have in QuickBooks Online. I'm ready to help you out.