Solved

Matching 3 payroll transactions in QB to ONE bank entry.

Forum|Forum|5 years ago
June 4, 2021
1 reply
10 views

In QB Desktop Pro 2021 I paid 3 employees, three different amounts (cheques)

Using my banking I made payments to those 3 employees. When the bank transaction imported into QB it imported as ONE transaction and not 3. Now QB will not match that ONE amount to the THREE separate cheques.

How do I tell QB to match the 3 transactions to the one bank transaction?

QuickBooks Desktop

Best answer by Angelyn_T

Thanks again for trying to assist.

Your step by step instructions works up to #3.

There is no drop down menu with an Ignore option or Action menu that I can see....or am I looking in the wrong location?

I find it very difficult to comprehend that matching 3 transactions in QB to one bank transaction is this difficult??

Thank you for performing the troubleshooting steps provided above, @sbolohan.

It's my priority to help you with handling your downloaded transactions in QuickBooks Desktop.

The Ignore button is available if the transaction is not yet added to QuickBooks. If it is, you can follow the suggested steps I've laid out above on how to delete or exclude your bank entry. In case you're getting the same issue, I would recommend reaching out to our Support Team for further assistance. A live representative can access your account securely and may perform a screen-sharing session to review your bank entry.

To contact support:

Sign in to your QuickBooks account.
Select the Help (?) icon.
Scroll down to select the Contact Us button and follow the prompts.
You will be able to request a callback or start a live chat with an expert.

You can also check this article for more details: How to get help with QuickBooks.

For additional resources about the banking feature in QuickBooks Desktop, you can check out the topics from this link: Find help with bank feeds and reconciling accounts.

Please feel free to get back to me here for any additional questions. I always have your back. Wishing you a good one!

M

Maybelle_S

QuickBooks Team

Hello there, @sbolohan.

To match the transactions, you'll have to create a Bank Deposit with a negative amount for the fees. I'll walk you through the instructions below:

1. On the Homepage, select Record Deposits / Make Deposits.

2. In the Payments to Deposit window, select the payments you want to combine, and then click OK.

3. From the Make Deposits window, select the account you want to put the deposit into from the Deposit to drop-down.

4. Check the deposit total. Make sure the account and selected payments match the deposit slip from your bank. Use your deposit slip as a reference.

5. Enter the date you deposited at your bank.

6. Add a memo as needed.

7. Select Save & Close.

Check out this guide for additional insight on how to match transactions in QBDT: Add and match Bank Feed transactions in QuickBooks Desktop.

Be sure to drop me a reply if you have additional questions. I'd be more than happy to help. Stay safe and have a good one.

S

sbolohanAuthor

This is not working out for me. There are no payments in the window you suggest.

I imported the 1 QB Transaction (for $3000 for instance) from my bank. In QB I made 3 payroll transactions that show up in my bank register as unmatched. The transactions are for 3 separate individuals. The amounts are $900, $1500, and $600. The bank recorded the deposits to the 3 employees as one transaction of $3000. That transaction is sitting in the bank feeds waiting to be matched to the 3 amounts in the register.

When I look under Record/Make Deposits there is nothing in the below window.

There must be an easy way to match this one bank transaction to the 3 QB made.??

Angelyn_T

Moderator

Hi, @sbolohan.

I appreciate you for getting back to us here in the Community forum. I'm here to help you with matching your transactions in QuickBooks Desktop.

There are cases in that QuickBooks can't find match transactions for one downloaded entry on the Banking page. Some of these reasons are the following:

The transaction that exists in QuickBooks could have a different transaction number, amount, date, or payee from the downloaded one.
If the downloaded entry matches an already reconciled transaction.
Occasions when QuickBooks downloads duplicate statements or transactions.

To avoid this from happening, you can:

Verify that the transactions have not been reconciled.
Check if the transactions were entered using the same bank account.
Make sure the Quickbooks transaction has not been previously matched to another bank downloaded transaction.

Once done, you can match your transactions again. For your reference, you can open this link:

Managing Bank Feed entries in QuickBooks Desktop.

Alternatively, you may exclude the downloaded bank transaction, then reconcile the three separate payroll transactions from the register manually.

Here's how you can delete or exclude your bank entry:

Go to the Banking tab, Bank Feeds then Bank Feeds Center.
In the Items Reviewed section, select the name of the account with the transactions you wish to remove.
Choose the Select Items to Delete button.
Select the transaction(s) you wish to delete.
Click on the Delete Selected button.
Confirm deleting the transaction(s) by selecting Yes.

And, here's how you can learn more about reconciliation in QuickBooks Desktop.

If you have any other questions about managing your bank transactions, let me know by leaving a comment below. I'm just a few clicks away to help. Keep safe!

Sign up

Login with SSO

Let's get you signed in

Login with SSO