Can you match two bank transactions to a single QuickBooks expense transaction? The bank posted a $508.16 payroll check as $8.16, sent correction weeks later.

Hi @cathy30,

A single downloaded transaction can only be matched to multiple existing entries. Let’s exclude the incorrect transactions by following the steps below. 

The Exclude Selected option can be found under Batch actions from your Banking tab. 

Here’s how:

1. Go to the Banking menu on the left panel.
2. Choose the Banking tab.
3. Check the box for beside the transactions you want to exclude.
4. Click the Batch actions drop-down and choose to Exclude Selected.
5. The items will be moved to the Excluded section.
6. From the Excluded tab, put a check in the box for the transaction you'd like to permanently delete.
7. Choose Batch actions, then Delete.
8. You'll be asked if you're sure. Click Yes to confirm.

Once done, these items are no longer reported as part of your business finances and will not appear in any associated account registers or reports.

You can wait for the corrected transactions then match it in your For Review tab. I've got a great article for you that provides additional details on excluding transactions. You can view it by clicking this link: How to exclude expenses from downloaded bank transactions?

For more details about adding and matching downloaded transactions, please refer to this article: Match and categorize bank transactions in QuickBooks Online.

If you have any more questions with your online banking transactions in QuickBooks. I'm just a post away if you need a helping hand. Take care.

Hi Cathy, 

In my own case, I have 2 bank transactions to be matched with 2 different expense transactions e.g. 2 bank transactions of N15,000 and N2,500 to be matched with expense transactions of N16,892 and N608. However, I can't seem to match it. Quickbooks not giving me the option of batching the 2 bank transactions so it can easily be matched to the expense transactions. Please help. 

Hello, @LB01.

We aren't able to match 2 or multiple downloaded transactions at the same time. We can only match a single downloaded transaction to multiple existing entries. At this time, you can exclude the downloaded transactions from the Banking page as suggested from the steps provided by MaryAnn_E above. Then, manually clear the expenses from the register.

Here's how:

1. Click on Accounting at the left pane, then select Chart of Accounts.
2. Look for your account from the list, then click on View register under Action.
3. Locate the expenses, then go to the ✓ column and mark the transaction as Cleared (C).
4. Tap on Save to record the action.

For additional reference about matching transactions in QuickBooks Online, check out these articles:

• Assign, categorize, edit, and add your downloaded banking transactions
• Categorize and match online bank transactions in QuickBooks Online

Let me know if you have any other questions. I'm more than happy to help. Have a good day!