Question

How do you fix missing transactions when trying to reconcile an account?

Forum|Forum|5 years ago
July 13, 2021
1 reply
192 views

No text available

QuickBooks Online

RenjolynC

Level 9

Glad to see you in the Community, usersbrewer.

I'll give details why this happened and help you reconcile the account.

There are a few possible reasons why transactions are missing in your Reconcile page. Here are the following:

Some banks and credit card companies don't post transactions for download until later in the day or the next morning.
Some banks will show a transaction on their website but won't download the transaction until it posts.
If the missing transactions are the most recent ones, wait at least 24 hours in case your bank doesn't make them available immediately.
Transactions are showing up in the For Review page but were not categorized or matched.
Transactions were manually reconciled in the register.

We can try to update your bank in QuickBooks to download the latest data.

Here's how:

Go to Transactions or Banking on the left navigation menu.
In the Banking page, select Update.

If you see the missing transactions, let's make sure to review and categorize them, so it shows up in the Reconcile page.

To check if the missing transactions were manually reconciled, you can follow these steps:

Go to Accounting > Chart of Accounts.
Click the View register link of the bank account.
Select the funnel icon and filter it by Reconcile Status, Transaction Type, Payee, and Date.
Hit Apply.
Find the transaction and check if you see the letter R under the Reconcile Status (indicated by a check mark) column. This means Reconciled.
Edit the transaction if necessary and click Save.

Here's a sample screenshot for a visual reference:

I'm also adding these articles for reference:

Fix issues at the end of a reconciliation in QuickBooks Online. Go to the Step 5 section.
What to do if you can’t find downloaded transactions in QuickBooks Online. Follow Step 2 if you still can’t find the transaction.

Once you have all the transactions, try to reconcile the account again. You can watch a video tutorial in this link: Reconcile an account in QuickBooks Online.

Please keep me posted on how it goes. I'd like to make sure you're able to reconcile the account. Thanks.

H

Hillary12

My bank changed system last year and now all of my transactions are just listed as Debit or check No vendors are showing ! Is this a bank issue sad they are telling me it is Quickbooks issue Will I now have to manually enter every transaction? Are other customers having an issue with Wesbanco program?

C

ChristineJoieR

QuickBooks Team

Hello there, @Hillary12. I can provide you with a solution for the bank transaction you're having trouble with.

I recommend importing transactions manually in QuickBooks Online. Importing transactions from a CSV file is an easy-peasy steps in QuickBooks. Let me guide you how:

From the Transactions tab, select Banking.
In the Link account drop-down, select Upload from file.
Click the Drag and drop or select files button.
Select the CSV file and then Open.
In the QuickBooks account dropdown, select the account you want to upload the transactions into.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks.
Select the transactions
Select Yes.
Click Let's go.

You can utilize this link for manually importing transactions and mapping CSV file format into QuickBooks.

After that, you can categorize them in order to allocate them to the appropriate account. As a starting point, consider the following article: Categorize and match online bank transactions in QuickBooks Online.

In addition, I added this article to guide you how to reconcile an account in QuickBooks Online.

If you have any queries about the classification process, please don't hesitate to contact me. Have a nice day!

Sign up

Login with SSO

Let's get you signed in

Login with SSO