Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
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.jpg Downloaded transaction from online banking.jpg

Solved
Best answer April 26, 2020

Best Answers
QuickBooks Team

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

6 Comments
QuickBooks Team

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.

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

QuickBooks Team

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

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

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.

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...)

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us