Solved

QB not finding transactions to match with banking when they are in QB

Forum|Forum|7 years ago
January 17, 2019
1 reply
1 view

No text available

QuickBooks Online

Best answer by David-212915

A warm aloha back to you, Anny. You're most welcome, as well.

So that I'm on the same page, when you refer to these transactions being in the Bank feed, do you mean that you're seeing them in For Review? If so, you may want to consider excluding them since you've already reconciled. I'm including an article that provides the steps and includess a section on how it affects a reconcile: How To Exclude Expenses From Downloaded Bank Transactions. This would result in them no longer showing up there.

Should you have questions about this, I'm just a few clicks away. Cheering you to continued success.

D

David-212915

Level 5

Hello @Anny,

Thanks for joining the Community. I'd be happy to lend a hand with matching transactions.

Just to clarify, if you select the transaction in the Bank feed and choose Find match, are the transactions missing? The following is a couple of screenshots to serve as an example:

If they're missing, there are some things that I'd recommend checking. First, it would be good to confirm that they're in the account by selecting Go to Register on the Banking page.

Should you locate them in the register, the next step would be to verify that they're not matched to another downloaded transaction or have been reconciled. There will be two Green squares in the Reconcile status column if they've been matched. Additionally, an R will signify that it's reconciled. Both of these will prevent a transaction from being able to be matched. I've included a screenshot as a reference:

For information on this, please see the following article: How To Add And Match Downloaded Banking Transactions.

In case these transactions are in the register and don't have anything preventing them from being matched, I suggest clearing the cache of your browser. This is stored in order speed up loading times, but can impede processes and cause unexpected behavior. I'm attaching an article that goes over this and includes the steps to perform this action: Delete Or Disable Cache And Temporary Internet Files In Your Web Browser.

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. Hoping this response finds you with a smile.

A

AnnyAuthor

Aloha David,

So thankful for your response. It turns out that many of these have been reconciled, but they keep appearing in the bank feed. Is there a way to get them to not show up there anymore? They seem to be reappearing after being reconciled. Your help would be most appreciated.

N

naguilar

Yes, there's a way to get a match for your receipts in QuickBooks Online (QBO), @KaylasCraftyKreations. I'm here to walk you through the steps.

Since the receipts weren't purchased from your bank, you can match them if the transactions are properly recorded in the program. First, you'll want to record the business items that were bought off from your husband's card by creating a journal entry. I'd suggest consulting your accountant to determine the specific expense account you'll need to use. Please make sure to switch from Business view to Accountant view. Once verified, proceed with the steps below.

Go to the + New button from the left menu.
Select Journal entry under Other.
Set the Journal date.
On the first line, choose the expense account for the purchase.
In the Debits column, enter the purchase amount.
Select Partner's equity or Owner's equity on the second line.
Enter the same purchase amount in the Credits column.
Click Save and close.

The screenshot below shows you the last six steps.

Second, you can record the reimbursements as checks or expenses. Just make sure to select your bank account to reimburse the personal funds. For detailed instructions, see the Step 2: Decide how you want to reimburse the money section through this article: Pay For Business Expenses With Personal Funds.

Third, let's go to the For Review tab so you can match the receipts. I'll guide you how.

Go to Banking from the left menu.
Select For Review.
Review the Record found.
Select the link beside the date to get more details.
If the match is correct, click Match.
You can click Find other records if the match isn't correct.

For your reference, view the Match an existing transaction section through this article: Matching and Categorizing Bank Transactions.

Once done, it's a great idea to reconcile your account monthly. This ensures your account in QBO matches your bank statement. To learn more about this process, visit this article: Reconciling An Account.

I'll be right here to help if you need further assistance. Have a great rest of your day, @KaylasCraftyKreations.

Hi, I was wondering if you can expand on this idea to me. I'm having a similar problem where I can't match two transactions to one record, my issue is due to payroll tax and are unable to modify the transaction QB has recorded for me.

I was having issues with the e-file/e-payment so I manually had to make the payment through the EFTPS website, but realized shortly after that I didn't add up the numbers correctly and had to make a second payment to cover the difference. The next day the e-file was finally fixed and I was able to record the transaction (Payment 1 + Payment 2 = QB Payment). Normally the find match function will let you add the transaction and resolve the difference, but only if the transaction on the banking side is larger than the recorded amount (opposite problem I have). Any suggestions? I need them to match so I can reconcile later, but since they are a tax payment I don't want to make a journal entry that will get me out of balance.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded