cancel
Showing results for 
Search instead for 
Did you mean: 
villagewines
Level 1

Matching downloaded transaction to a journal entry

I am hoping you can help me.  My payroll service (Gusto) has QBO integration so a JE is entered for each payroll with lines for each item (taxes, wages, etc.), as well as employee checks.  I am struggling with how to match the downloaded check details to the journal entries.  Any ideas?  Please see the picture below which shows what the journal entry line for the check and the downloaded check in my transaction list.  I could really use some help as we write a lot of checks to employees.  

Thanks,

TimJournal Entry Gusto.jpgDownloaded transaction from online banking.jpg

Solved
Best answer April 26, 2020

Best Answers
MaryLandT
Moderator

Matching downloaded transaction to a journal entry

Thanks for the update and screenshot, villagewines.

 

Let's match the check with the journal entry you've already added in QuickBooks Online.

 

Before proceeding, here are a few reasons the match may not have been recognized:

  • The JE was recorded in a different bank account.
  • The JE has been reconciled. 
  • The JE has been previously matched to another bank downloaded transaction.

You may want to double-check again the date, amount, category, and check numbers of the entries are aligned. This is to make sure those checks will match.

 

For more in-depth information about finding a match in QuickBooks, refer to these articles: 

Stay in touch on how this goes by clicking the Reply button. I'm always around whenever you need help.

View solution in original post

8 Comments 8
KlentB
Moderator

Matching downloaded transaction to a journal entry

I'm here to help you with matching them, Tim.

 

We can match the downloaded transaction with the journal entries you've already entered the Banking page. We'll have to click the Match radio button so that will program will automatically locate the journal entry associated with it. Let me show you how:

 

  1. Select Banking from the sidebar menu, then go to the Banking tab.
  2. Choose the appropriate bank account then click the For Review tab.
  3. Locate then click downloaded check to expand the view. 
  4. Tick the Match radio button.
  5. Review the Records found, then select the link next to each record to get more details.
  6. Check the Deposit to field on the forms.
  7. When you’re done, select Match.

Take a look at my screenshot below:

 

Capture.PNG

 

I've also included an article that will help you in categorizing and editing your downloaded banking transactions.

If you're about to reconcile your account, I recommend reading our reconciliation guide to ensure that your QuickBooks accounts accurate.

 

I want to ensure that you're able to match these transactions, so please let me know how it goes by posting a comment below. Have a great rest of the weekend.

villagewines
Level 1

Matching downloaded transaction to a journal entry

Hello.  

I do use the match function a lot for other things like transfers.  However, when i am under 'for review'  and i select any of the checks that match the payroll JE entries (imported from payroll company), there are no matches found.  

See attached image.

 

Screen Shot 2020-04-26 at 1.50.40 PM.png

MaryLandT
Moderator

Matching downloaded transaction to a journal entry

Thanks for the update and screenshot, villagewines.

 

Let's match the check with the journal entry you've already added in QuickBooks Online.

 

Before proceeding, here are a few reasons the match may not have been recognized:

  • The JE was recorded in a different bank account.
  • The JE has been reconciled. 
  • The JE has been previously matched to another bank downloaded transaction.

You may want to double-check again the date, amount, category, and check numbers of the entries are aligned. This is to make sure those checks will match.

 

For more in-depth information about finding a match in QuickBooks, refer to these articles: 

Stay in touch on how this goes by clicking the Reply button. I'm always around whenever you need help.

Sandhya9
Level 1

Matching downloaded transaction to a journal entry

I have passed a journal entry like this sale value say 698

 

received in bank   650

Pay u money             30

Tax                               18

 

they are 2 parties   1 party amount is Rs. 400

                                    2 party amount is Rs. 298

 

while passing journal shown as sales 400 + 298 seperately.

 

My invoices are not matching individually how to go on

RCV
QuickBooks Team
QuickBooks Team

Matching downloaded transaction to a journal entry

Let me help you match the bank feed transaction to a journal entry in your account, Sandhya9. 

 

You mentioned they are two parties for the transactions. The system only lets you match a single bank feed entry with multiple journal entries. Let me show you how: 

  1. Go to the Banking page.
  2. In the For review, tab, find the Transfer record. 
  3. QuickBooks will automatically find the match for the record. Simply select it, then click on Match
  4. If not, select it then tick the Find match button. 

If you have multiple bank feed transactions but a single journal entry, then you'll want to skip the matching part. What we can do is to exclude those transactions and manually clear the journal entries in the register. To exclude the transactions, just follow the steps below:

  1. Go to the Banking page again, then click the For review tab. 
  2. Find the bank feed transaction and check it. 
  3. Click the Exclude button.

Then, clear the journal entries by following the instructions below: 

  1. Go to your Chart of Accounts.
  2. Find the bank, and click View register.
  3. Locate the Journal transaction, and click the "checkmark" column until a "C" appears.
  4. Click Save

Do the steps until all of the transactions and records are accounted for in all bank accounts. Feel free to visit our Reconciliation page for more insights about reconciling your bank account with QuickBooks.

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. Take care always.

MinnieS
Level 1

Matching downloaded transaction to a journal entry


Hi @MaryLandT !

I was reading through your solution for the OP, and I'm hoping you can help me resolve my version of this issue!

You said "Before proceeding, here are a few reasons the match may not have been recognized:

  • The JE was recorded in a different bank account.
  • The JE has been reconciled. 
  • The JE has been previously matched to another bank downloaded transaction."

Of the three reasons you listed, I can eliminate two, which leaves me with 

"The JE was recorded in a different bank account."

I'm dealing with TXs imported from an app that we enter our vehicles, and any vehicle-specific income and expenses into.  The app then syncs the transactions to QBO as Journal Entries into the mapped accounts.  When I try to match my TX from the Bank account with the JE from the app, it doesn't appear in the "Match Transactions" search screen at all. 

If the issue is that the JE was recorded in the wrong bank account, which line in the JE do I change?  I tried changing lines 1 and 2, one at a time, to the Checking account, then testing to see if the TX would show up in the "Match Transactions" search screen, but it still didn't appear in the available TXs.

Please help!

(Also, I wanted to include a few screenshots, but I don't see a way to do this in this reply window, so I just attached an image of the JE in question...)

N0236
Level 1

Matching downloaded transaction to a journal entry

What do I do when I get 'No Matches found'

Example: I owe someone £500 but I have to deduct £100 for a loan for which I create a Journal Entry.

Then when I go to do my Bank Matching there is a payment of £400 there but I cannot find a match for it. 

I have already created an Expense for £500 and a Journal entry for £100 deducted for repayment. How do I match the the Journal Entry with the Bank £400 to clear the Bank

 

Mark_R
QuickBooks Team

Matching downloaded transaction to a journal entry

Thanks for dropping by, @N0236.

 

I'm here to help match the created journal entry to your bank transaction.

 

There are times when some of the transactions can’t find their match from existing records. Details from the downloaded data and the journal should match to ensure it shows up. Here are the possible reasons:

 

  • The payees don’t match
  • The amounts don't match
  • The dates don't match or are not close
  • The bank account on the payment is not the same as the bank where the match is located
  • The payment has been reconciled

 

You'll want to ensure you choose the correct date range for the transactions. It'll help the system find the journal entry from the register. Here's how:

 

  1. Click Banking from the left menu and select the transaction. Then, select Find a match.
  2. From the Match transactions page, select Journal Entries under Show drop-down.
  3. Make sure the From and To date are correct.
  4. Locate the journal entry, then Save.

 

You can also use this article to review added transactions or unmatch them in QuickBooks: Categorize and match online bank transactions in QuickBooks Online.

 

Don't hesitate to leave a comment below if you need further assistance matching your journal entry. The Community team and I are always here to help.

Need to get in touch?

Contact us