cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
bechepar
Level 1

Can I match different transactions with one expense?

 
6 Comments 6
MaryLandT
Moderator

Can I match different transactions with one expense?

Yes, you can match multiple transactions with one expense, bechepar.

 

If the expense is downloaded from your bank, you can click Find match to locate those two entries. You'll be able to match with different vendors as well. Just make sure the sum of these transactions is equal to the expense.

 

Let me show you how:

 

  1. Go to the Banking page and select the account where the expense is downloaded.
  2. Click the entry to expand it, then choose Find match.
    matchdifferenttransactionswithoneexpense.PNG
  3. From the Match transactions page, mark those expenses you've entered in QuickBooks.
    matchdifferenttransactionswithoneexpense1.PNG
  4. You can also select Show to open other transactions.
  5. Click Save.

If you use the Expense feature in QuickBooks to record the transaction, you can only match it to one vendor. Here's how to apply the payment:

 

  1. Go to Expenses from the left menu.
  2. Locate the expense you've entered and it.
  3. Open transactions will automatically appear on the right side.
    matchdifferenttransactionswithoneexpense2.PNG
  4. Add them to the expense.
    matchdifferenttransactionswithoneexpense3.PNG
  5. Click Save to record the payment.

Feel free to read through the Categorise and match online bank transactions to learn more about reviewing transactions after you download them.

 

Don't hesitate to leave a comment below if have follow-up questions about the steps provided above. I'm always right here to help.

bechepar
Level 1

Can I match different transactions with one expense?

Thanks.

I am not quite sure about your explanation. I understand how to match different expenses with one bank transaction (following your instructions), but my question is about one expense with several bank transactions. The problem is that I have one invoice (google i.e.) that has been paid with four transactions in the bank. How can I match the invoice (expense) with the payments in the bank account?
Thanks. Regards
IamjuViel
QuickBooks Team

Can I match different transactions with one expense?

Let me share additional to elaborate on the process, @bechepar.

 

Matching your expense transactions to your actual bank payments depends on how you record it. 

 

If you have created a bill to record the Google invoice then made 4 separate bank payments, you'd want to make sure to pay the bill 4 times in QuickBooks too.  Here's how to create a bill:

  1. Go to the Plus icon (+).
  2. Choose Bills.
  3. Enter the bill details (i.e Google invoice information).
  4. Click the Save and Close button.

Once completed, let's pay the bill 4 times. You can follow these steps:

  1. Choose the Expenses menu.
  2. Select the Vendor details.
  3. Locate the name of the vendor.
  4. From the Actions column, click the Make Payment link.
  5. Scroll down to the Outstanding Transactions section.
  6. Make sure to mark the Bill you want to pay.
  7. Enter the actual amount you paid in the Payment column. 
  8. Click the Save and Close button.

You can repeat the same process until you zero out the bill's balance. 

 

The other way is to directly create 4 individual expense transactions or checks to record the separate payments you've made. Once completed, QuickBooks will be able to automatically detect the transactions. You can see a prompt in the For Review tab that record is found. Just double-click on each transaction to review its details. 

 

Feel free to get back to us here if you have other questions about managing your expense-related transactions. I'm just a few clicks away.

JonSWR
Level 2

Can I match different transactions with one expense?

This sounds to me like what the OP was asking for is not possible...

 

I have a similar situation, where I have multiple transactions on a credit card.  At the end of the month, I get a monthly summary.  I would like to enter this one monthly summary as a bill, and then to be able to individually select the transactions on my credit card feed to zero out the value of the bill.  But I can't do that, unless there has been some update to QBO that I'm not aware of.

 

Right now, I do create individual expense entries for each transaction and it matches with my credit card feed just fine.  But I was hoping to be able to do what I described above to save some effort.  Creating a bill and manually "making payment" for the value of each individual transaction does not save any effort compared to what I do now.  It would be nice if this were possible.

jamespaul
Moderator

Can I match different transactions with one expense?

Hello, Jon.

 

I appreciate adding all the details about your situation. I'll clarify and elaborate on handling multiple bank feed transactions with a single expense entry. 

 

You're right about this. To clarify, the Online Banking feature will only let you match a single bank transaction with multiple expenses, not the other way around. 

 

You can continue doing creating individual expenses for each transaction in the meantime. I'd also suggest excluding those individual credit card transactions from the feed. Then, 

 

Excluding the credit card transactions: 

 

  1. Go to the Banking page, then select your credit card account. 
  2. Check the credit card or bank transactions.
  3. Click the Exclude button. 

 

Manually clearing the expense transactions: 

 

  1. Go to your Chart of Accounts.
  2. Find the credit card or bank account, then click Account history.
  3. Locate and select the expense.
  4. Click the "Check mark" column until a "C" appears.
  5. Once done, click Save

 

manualclear1.PNG

 

I'd also suggest sending feedback to our developers. They might consider adding an option to let you match multiple bank transactions with a single expense. Simply go to to the Gear icon, then select Feedback

 

If you need help reconciling your bank or your credit card statements, feel free to use this article as a reference: Reconcile an account in QuickBooks Online.

 

You're more than welcome to share other concerns you might have regarding the Online Banking feature. I'm also willing to answer any other questions you might have in QuickBooks Online. I'm always here to help. 

DanaBinAZ
Level 1

Can I match different transactions with one expense?

This does not seem to work anymore! How frustrating :(.