Match a manual transaction (2024)

United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Search instead for

Did you mean:

Connect with and learn from others in the QuickBooks Community.

Join now

  • US QuickBooks Community
  • :
  • :
  • Banking
  • :
  • Match a manual transaction
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Printer Friendly Page

Match a manual transaction (2)

ChristineD65

Level 3

posted

‎December 20, 202007:47 PM

last updated‎December 20, 20207:47 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

The upload from the bank filtered out a transaction as a duplicate. It's not, we actually did have a payment for the exact amount, to the same vendor, on the same date (third party contractor payments)
There are journal entries for both transactions, but I can only match one, because the bank feed only lists one.
I tried manually creating the deposit, but cannot figure out how to then match the transaction to the journal entry.

Please help

Labels:

  • QuickBooks Online

Cheer

Reply

Join the conversation

9 Comments 9

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

I can help you get this sorted out,ChristineD65.

We can only match a downloaded transaction to a single one in QuickBooks Online. If a payment was created, you may not need to create a Journal Entry. This is to avoid doubling your expenses and match the bank transaction to it.

Please double-check the both the payment and the journal entry, and remove the one that 's notneeded. Here's how:

  1. Go to the Banking menu andselect Banking.
  2. In the For Review tab, put a checkmark on the boxes for those duplicates.
  3. Click on Exclude.

Transactions will then be moved to the Excluded tab.

That's it! If you have any other concerns or questions about banking,I'll be right here to keep helping.

Cheer

Reply

Join the conversation

Match a manual transaction (5)

ChristineD65

Level 3

‎December 22, 202012:21 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

No, I think you got this backwards.
There is only one downloaded bank transaction, but it is supposed to be two. I think QBO only accepted one because they look like duplicates. They actually aren't, there were two payment made on the same day for the same amount, to the same vendor.
There are two existing journal entries in QBO, one for each payment. This is correct.

The problem is that I can't match both of the journal entries because one of the bank transactions is missing in QBO. I've tried manually creating the missing transaction, but that will not allow me to connect it to the journal entry.

Cheer

Reply

Join the conversation

Match a manual transaction (6)

Match a manual transaction (7)MJoy_D

Moderator

‎December 22, 202001:12 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

Thank you for getting back and providing us with more information about this transaction that you're trying to match, @ChristineD65.

Here are the possible reasons why the journal entry won't match:

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

Try to check again the date, amount, and category that you set for this manually added transaction to match it successfully.

For more information about matching your transactions QuickBooks, refer to these articles:

  • Tips for Working in QuickBooks Online’s Bank Feed: Matching Transactions
  • What to do if QuickBooks matches the wrong transaction.

See this guide on how tomanually upload transactions into QuickBooks Online. From here, you can nowcategorizeand thenreconcilethe transactions.

Let me know if there’s anything else that I can assist about your bank transactions by leaving a comment below. I’m always here to assist. Have a wonderful day!

Cheer

Reply

Join the conversation

Match a manual transaction (8)

ChristineD65

Level 3

‎December 22, 202001:16 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

Thank you, but no.

The journal entries are correct, in the correct account, on the correct date, for the correct amount, etc. They are completely correct.

The problem is that QBO *did not download both transactions*. QBO only downloaded one transaction, and there are supposed to be two transactions.

Since there is only one bank transaction, I cannot match both journal entries. I need to ADD a bank transaction that can be matched to the second journal entry.

I do not have too many total transactions, I am missing one.

Cheer

Reply

Join the conversation

Match a manual transaction (9)

MariaSoledadGMatch a manual transaction (10)

QuickBooks Team

‎December 22, 202002:25 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

You can manually add transactions to the account register so you can match the second journal entry,ChristineD65.

Follow the steps below on how to do it.

  1. At the very top of the list, select theAdd journal entry, Add deposit or Add check▼ dropdown.Tip: The menu can be hard to see - it's at just above the most recent transaction. You can also pressCtrl+Alt+N.
  2. Select the transaction you want to add.
  3. Fill out the fields to complete the transaction.
  4. When you're done, clickSave.

Once done you'll already have the option to match the transactions. To give you complete information, read this article for more information: Manually Add Transactions To Account Registers In QuickBooks Online.

You'll want to run reports for a specific account to know the total amount of each account.

Reply to this thread if you need help from us about adding transactions in QuickBooks. I'll always be right here to help you anytime you need us. Just let us know.

Cheer

Reply

Join the conversation

Match a manual transaction (11)

ChristineD65

Level 3

‎December 22, 202002:50 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

Yes, thank you, I *did* add a manual deposit.
Which brings me back to my original post. How do you then match a manually created deposit to an existing journal entry? This is what I cannot figure out how to do.

1

Cheer

Reply

Join the conversation

Match a manual transaction (12)

Match a manual transaction (13)MonicaM3

Moderator

‎December 22, 202004:50 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

Welcome back@ChristineD65,

Matching a manually added transaction to a journal entry be the same process as matching a bank feed transaction. The first thing to double-check is the journal entry. I do see that you were able to match the downloaded transaction to a journal entry. Are both journal entries identical? To match follow these steps:

Go toBankingorTransactionson the left panel.

  1. Click theBankingtab.
  2. In the For Review section, select the transaction you want to match and click theFind matchradio button.
  3. In theMatch Transactionswindow, select the Date and if you see any possible matches,put a checkmark on the transactions.
  4. ClickSave.

If the journal entry is correct and you are not seeing it listed to match, can you send me a screenshot? I’ll look for your response. I’m dedicated to helping you get this done!

Cheer

Reply

Join the conversation

Match a manual transaction (14)

Lookingforanswers1978

Level 1

‎August 28, 202312:38 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

This makes sense but what if I have to split a portion of a bank transaction and match said portion to a journal entry? How would I do that?

Cheer

Reply

Join the conversation

Match a manual transaction (15)

Maybelle_SMatch a manual transaction (16)

QuickBooks Team

‎August 28, 202302:46 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

Match a manual transaction

Let's work together to match your transactions in QuickBooks Online (QBO),Lookingforanswers1978.

In QBO, we can log all of your transactions that require alignment with the bank transactions. Afterward, you can utilize the "Find match" function to incorporate the corresponding journal entry.

Here's how:

  1. Go to the+Newbutton.
  2. Choose the transaction types you want to record.
  3. Enter the necessary information.
  4. HitSave and close.
    Match a manual transaction (17)

Once done, match the transactions. I'll guide you on how to do it.

  1. Go to theBankingmenu.
  2. Select the transaction.
  3. Click Find match.
    Match a manual transaction (18)

Additionally, I've attached an article you can utilize to help locate transactions in your account registers so you can examine or modify them:Find, review, and edit transactions in account registers in QuickBooks Online.

Fill me in if you have further questions about matching transactions in QuickBooks. I'm always around to help you out. Have a good day!

Cheer

Reply

Join the conversation

Featured

Match a manual transaction (20)

Community Chatter Series: Episode 8 (Invoicing)

(view in My Videos) For topics mentioned in this episode, check out thefol...

Read more

Match a manual transaction (21)

Top 5- Payments

Hello Community! We are back with another Top 5, but this time around wewi...

Read more

Match a manual transaction (22)

The Answer Room: Spring Hashtag Holidays

Hello Community! Spring is upon us, and that means The Answer Room isbring...

Read more

Need to get in touch?

Contact us

Match a manual transaction (2024)
Top Articles
Latest Posts
Article information

Author: Fredrick Kertzmann

Last Updated:

Views: 5314

Rating: 4.6 / 5 (66 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Fredrick Kertzmann

Birthday: 2000-04-29

Address: Apt. 203 613 Huels Gateway, Ralphtown, LA 40204

Phone: +2135150832870

Job: Regional Design Producer

Hobby: Nordic skating, Lacemaking, Mountain biking, Rowing, Gardening, Water sports, role-playing games

Introduction: My name is Fredrick Kertzmann, I am a gleaming, encouraging, inexpensive, thankful, tender, quaint, precious person who loves writing and wants to share my knowledge and understanding with you.