Journal Entries not showing up to match to transactions

sigma-utilitiesl · ‎July 09, 2021

Afternoon,

I am having a problem with a couple of payroll entries. I run my standard payroll through quickbooks and that creates a journal entry for each of my employees each week. When the employee wages shows up in the banking transactions (the bank account is linked to quickbooks) I normally just match the transaction to the journal entry.

Due to previous overpayments of NI for a few employees, I have made some slight deductions off the employee wages after payroll. Now because the figures are not the same they are not matching and when I go to find match- it doesn't even bring them up. I was hoping if it brought it up I could just match it and resolve the payment.

Can you please advise how I can match the payment to the journal entry when it is not bringing it up with the 'find match' option.

Thank you

MaryLandT · ‎April 26, 2022

Thanks for joining this thread, Alys G.

Let me provide some troubleshooting steps to get the journal entries to show up when matching transactions.

You can start by checking your payroll preferences and ensure that the accounts for journal mapping are correct. Here's how:

Go to the Gear icon on the top right and select Accounts and Settings.
Select Payroll on the left menu.
From the Journal Mapping section, click on the Pencil icon to make your change and Save.

Once done, you can log out and back into QuickBooks to refresh and the journal to be put back in the queue for processing.

I recommend getting back in touch with our Live Support Team if the same issue persists. That way, they can pull up your account and review again your payroll settings.

You may also manually download the transactions from the bank, then upload the file to your QuickBooks account. Check this article for more information: Manually upload transactions into QuickBooks Online. From here, you can now categorise and match transactions

Let me know if there's anything else that I can help with. I'm always here to assist you.

View solution in original post

GeorgiaC · ‎July 09, 2021

Hi sigma-utilitiesl

The banking mechanism works by scanning for transactions within a certain range of the transaction date and amount, if the transaction falls outside of this range it won't suggest these as a potential match, however, it's worth checking that the bank payments posting from the journal haven't already been reconciled and that when clicking 'find match' the date range on the following screen captures the journal date. :)

sigma-utilitiesl · ‎July 12, 2021

Thanks for your response Georgia! I thought that may be the case with the transaction being out of a certain range to tie it that journal entry.

I have checked in banking and the transaction remains unreconciled. When I click 'find match' I make sure the correct date range is covered but it doesn't bring anything up at all. There should be a few journal entries that are unallocated so its strange its not bringing any of them up.

I don't know how I can categorise these payments without being able to allocate them to the wages.

Thanks

AileneA · ‎July 12, 2021

Hello, sigma-utilitiesl.

In this case, I would recommend reaching out to our chat and phone support teams. They can take a closer look at your statement and check why it's not showing match transactions.

Here's how to reach out to them:

Click the Help menu in the upper-right hand corner of your QBO account.
Type in "Talk to a human" in the chatbox, then press Enter.
Select Get help from a human.
Click Chat with us or Have us call you.

More details about their contact details are discussed here: QuickBooks Online Support.

For detailed instructions on how to match a transaction, check out this article: Add and match downloaded banking transactions.

You can mention my name if you have additional questions. I'll get back to assist you further. Have a good one and stay safe!

RuthM13 · ‎March 28, 2022

Hi,

I just wondered if you managed to get a solution to this, I have exactly the same issue.

Thanks,

Ruth

GeorgiaC · ‎March 28, 2022

Hi Ruth, thanks for joining this thread - are the journals a different amount to the payment(s) in the banking screen?

Alys G · ‎April 26, 2022

I'm having the same issue as this. The payroll was paid in two instalments - as there was a bonus and I can now not match up the journal as doesn't appear. I've spent over an hour on a help call and got nowhere.

Would love to know how to sort it out.

MaryLandT · ‎April 26, 2022

Thanks for joining this thread, Alys G.

Let me provide some troubleshooting steps to get the journal entries to show up when matching transactions.

You can start by checking your payroll preferences and ensure that the accounts for journal mapping are correct. Here's how:

Go to the Gear icon on the top right and select Accounts and Settings.
Select Payroll on the left menu.
From the Journal Mapping section, click on the Pencil icon to make your change and Save.

Once done, you can log out and back into QuickBooks to refresh and the journal to be put back in the queue for processing.

I recommend getting back in touch with our Live Support Team if the same issue persists. That way, they can pull up your account and review again your payroll settings.

You may also manually download the transactions from the bank, then upload the file to your QuickBooks account. Check this article for more information: Manually upload transactions into QuickBooks Online. From here, you can now categorise and match transactions

Let me know if there's anything else that I can help with. I'm always here to assist you.

Topics

Training

Community

Resources

Journal Entries not showing up to match to transactions