Online Banking with QuickBooks - Unmatched Transactions Defined

Using online banking with QuickBooks is a huge time saver, but not if there are problems with it. One common source of problems is downloaded transactions that cannot be matched.

When transactions are downloaded from the bank or credit card company, QuickBooks assigns each a “Matched” or an “Unmatched” status, then places all of them into the Online Banking Center’s QuickStatement. The “Matched” status means only one thing: you previously entered the transaction into QuickBooks, then when the transaction cleared the bank and was downloaded, QuickBooks “Matched” the downloaded transaction with the transaction already entered.

The “Unmatched” status is where problems occur. The “Unmatched” status actually means one of four things:

1. It’s brand new. The transaction was not previously entered into QuickBooks. If this is the case, enter the transaction now. QuickBooks will assign it the “Matched” status.

2. It’s different. The transaction was previously entered into QuickBooks, but in a different amount than how it cleared the bank. If you are sure you already entered the transaction into QuickBooks, scroll through the bank register to find it. Once you do, change the amount to the downloaded amount. QuickBooks will automatically match it.

3. It’s already downloaded. Sometimes clients accidentally overlap download dates, meaning that they download the same transaction more than once. If there are entries in the register that have a small lightening bolt in the Cleared column, these have been downloaded already. QuickBooks will not match them to transactions in the QuickStatement, even if they are the same transaction.

4. It’s reconciled. This is similiar to #3, but instead of being previously downloaded, the transaction is reconciled. To verify if this is the case, scroll through the register and look for transactions with a checkmark in the Cleared column. Again, QuickBooks will not match them to entries in the QuickStatement, even if they are the same transaction.

Notice that once the first two situations are resolved, QuickBooks automatically matches them. But in the last two situations, QuickBooks will not match the transactions; they are unmatchable. If you determine that some downloaded transactions are unmatchable:

* Make sure that all matchable transactions are matched. You are going to delete the QuickStatement, and if you accidentally delete matchable transactions, you may later have to enter them manually.

* Once all matchable transactions are matched, click Done.

* QuickBooks will ask if you are sure you want to finish. Click Yes. You are now at the Online Banking Center main page.

* Delete the QuickStatement by clicking the Delete button located near the lower right corner.

That’s it. Your unmatched problems are over, and you now understand the process better. This will help you circumvent future problems when using online banking with QuickBooks.
Jennifer A. Thieme - EzineArticles Expert Author

Article Source: http://www.accountingsoftwarearticles.com

About the Author: Do you have a specific accounting or QuickBooks problem? Would you like to see an article written about it? Jennifer A. Thieme invites you to contact her today with your accounting or QuickBooks article suggestion. Resolving accounting or QuickBooks issues is her specialty. Email her today to receive a free initial consultation, free QuickBooks software trial, and a free payroll processing quote. She’s the owner of Solid Rock Accounting Services and has been in the bookkeeping, income tax, and payroll business for nine years. She’s a Certified QuickBooks Pro Advisor, and a Registered Tax Preparer. Her clients receive QuickBooks training, general bookkeeping, income tax, and/or payroll processing services. Visit www.jenniferthieme.com today for contact information. Article Source: EzineArticles.com/?expert=Jennifer_A._Thieme

Please Rate this Article

5 out of 54 out of 53 out of 52 out of 51 out of 5 

Not yet Rated