I've paid and employee in 2 transactions and now when reviewing the bank transactions it doesn't automatically match to the payroll postings, how do i match them?

info1403 · ‎November 30, 2020

KlentB · ‎November 30, 2020

Thanks for adding some details of your concern, info1403.

Unfortunately, we're unable to match the two payments to a single transaction since their amounts aren't the same. Please take note that we can only match transactions with the same amounts in QuickBooks Online.

To ensure that your payroll records are accurate, you'll have to exclude those two downloaded transactions on the Banking page. Once done, you'll have to manually clear them in the register so you can easily reconcile the transactions. I'll show you how:

Select Accounting from the sidebar menu.
Go to Chart of Accounts.
Find the account holding the transaction, then click View register from the Action column.
Locate the payments, then review the check column.
Select the transaction and then keep clicking the box from the Check column the box until it shows C. This process will mark the transaction as cleared.
Click the Save button to save the changes, then close the account register.

I also encourage reading these articles to help manage your downloaded bank transactions in QuickBooks Online:

I'm just a few clicks away if you have any other concerns or questions about bank transactions and reconciliation. I'll always have your back.

View solution in original post

EmmaM · ‎November 30, 2020

Are you trying to match the payroll journals to the employee payments? Do the amounts match? If you click on the payment in banking and go to find a match are they there?

info1403 · ‎November 30, 2020

Yes that’s what I usually do to match them. The issue is I’ve paid them in 2 transactions, for example total payment should have been £500 and I’ve paid £200 and £300 so it doesn’t let me allocate them unless I resolve the reconciling difference and I don’t know where to put the difference if that makes sense? Looking at it now I think I should have put it as an advance payment before running payroll so I will remember that for next time!

KlentB · ‎November 30, 2020

Thanks for adding some details of your concern, info1403.

Unfortunately, we're unable to match the two payments to a single transaction since their amounts aren't the same. Please take note that we can only match transactions with the same amounts in QuickBooks Online.

To ensure that your payroll records are accurate, you'll have to exclude those two downloaded transactions on the Banking page. Once done, you'll have to manually clear them in the register so you can easily reconcile the transactions. I'll show you how:

Select Accounting from the sidebar menu.
Go to Chart of Accounts.
Find the account holding the transaction, then click View register from the Action column.
Locate the payments, then review the check column.
Select the transaction and then keep clicking the box from the Check column the box until it shows C. This process will mark the transaction as cleared.
Click the Save button to save the changes, then close the account register.

I also encourage reading these articles to help manage your downloaded bank transactions in QuickBooks Online:

I'm just a few clicks away if you have any other concerns or questions about bank transactions and reconciliation. I'll always have your back.

superior123 · ‎February 01, 2022

Hi, I have the same issue, I have excluded the transactions but I am struggling with the chart of accounts part as I cant see the transaction?

Charies_M · ‎February 02, 2022

Thanks for joining us today, superior123.

I'm here to help you find the transaction in your Chart of Accounts. Let's try reviewing the Account history and look for the transaction.

Here's how:

Go to the Accounting menu.
Select the Chart of Accounts tab.
Look for the bank account and select Account history.
Look for the transaction. Select it to get more details.

If it's still not there, try performing some basic browser troubleshooting. Let's begin by using your browser's private window.

Here's how:

Google Chrome: press Ctrl + Shift + N.
Mozilla Firefox: press Ctrl + Shift + P.
Internet Explorer: press Ctrl + Shift + P.
Safari: press Command + Shift + N

If it works, close out the private window and clear the cache on the regular browser. This will remove previously-stored browsing data that might have caused the issue. Otherwise, you can try other supported browsers to help narrow down the cause of this behavior.

For additional reference, you can check these articles to learn more on how to add, match, and reconcile in QBO:

Please know that you're always welcome to post if you have any other questions managing your transactions in QBO. I'd be happy to answer them for you. Wishing you and your business continued success.

Topics

Training

Community

Resources

I've paid and employee in 2 transactions and now when reviewing the bank transactions it doesn't automatically match to the payroll postings, how do i match them?