Skip to main content
S
sigma-utilitiesl
July 9, 2021
Solved

Journal Entries not showing up to match to transactions

  • July 9, 2021
  • 1 reply
  • 0 views

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

    Best answer by MaryLandT

    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.


    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:

     

    1. Go to the Gear icon on the top right and select Accounts and Settings.
    2. Select Payroll on the left menu.
    3. 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.

    1 reply

    G
    GeorgiaC
    July 9, 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. 🙂

      S
      sigma-utilitieslAuthor
      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

      A
      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:

       

      1. Click the Help menu in the upper-right hand corner of your QBO account.
      2. Type in "Talk to a human" in the chatbox, then press Enter.
      3. Select Get help from a human.
      4. 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!

      Terms & ConditionsAccessibility statement