cancel
Showing results for 
Search instead for 
Did you mean: 
LockerRoom
Level 1

Where are bank statements for reconciling?

Bank and Credit Card Accounts are linked and transactions/deposits are automatically added in QB Online but when I attempt to reconcile a message appears "your statements haven't come in yet". Refresh now doesn't provide any results. Account has been active for over a year but hasn't been reconciled. Summary and History by account are both blank. Any advice would be much appreciated.
9 Comments 9
Kevin_C
QuickBooks Team

Where are bank statements for reconciling?

Great to have you in the Community, @LockerRoom. I'm here to ensure you can get your bank statements so that you can reconcile your bank transactions in QuickBooks Online (QBO).

 

Let's do some troubleshooting solutions to isolate this issue. I suggest logging out of your account and logging back in. It will help refresh the data in your account.


If the issue persists, you can reach out to your bank provider and verify if this is on their end or not.

 

Also, may I know the name of your bank? This way, we can better isolate if there's an ongoing issue with it. 

 

Moreover, you can read this article to learn more about how to import bank statements to help you reconcile an account. This is available for QBO Plus, Advanced, Accountant, and QuickBooks Live users.

 

Additionally, if your bank statements are all good now, then you can proceed to reconcile an account in QuickBooks Online.

 

Kindly update me on the results in the comment. I'm always here if you need additional assistance in getting your bank statements in QBO. Stay safe always!

LockerRoom
Level 1

Where are bank statements for reconciling?

Thanks for the response! I have logged out and logged back in without success. 

 

We are using most basic QBO plan...not sure if that may have something to do with this issue?

 

Our bank is LCNB. If you don't know of any on-going issues importing bank statements, I will contact them directly. 

GebelAlainaM
QuickBooks Team

Where are bank statements for reconciling?

Thanks for getting back to the thread, @LockerRoom. I can help you import your bank transactions.

To answer your question, when we check here on our end, there are no ongoing issues importing bank statements from LCNB bank.

In order to reconcile your account in QuickBooks Online, you can manually import bank transactions using a CSV file format.

Here's how to manually add transaction using a CSV file:

  1. Go to the Banking or Transactions menu and choose Banking.
  2. Click the blue tile for the account you want to upload the transactions into.
  3. Click the Link account dropdown and then Upload from file.
  4. Select Browse and then select the file you downloaded from your bank.
  5. In the QuickBooks account dropdown, select the account you want to upload the transactions into.
  6. To match the columns in the file with the correct fields in QuickBooks, follow the onscreen instructions.
  7. Select the transactions you would like to import.
  8. Click Yes and when you're good to go, select Let's go.

You can also check out this article for a detailed step-by-step guide: Manually upload transactions into QuickBooks Online.

Once your transactions are already in QuickBooks, you can now match and categorize them. Then, finally proceed to reconciling you bank.

Here's how:
 

  1. Go to the Gear icon and select Reconcile. If you're reconciling for the very first time, select Get started to continue.
  2. From the Account dropdown, select the account you want to reconcile. Make sure it's the same one on your statement.
  3. Review the Beginning balance also make sure it same on your statement.
  4. Enter the Ending balance and Ending date on your statement.
  5. Review the Last statement ending date.
  6. Then select Start reconciling.

I've also added this article in case you encounter error in reconciling your bank: Fix issues the first time you reconcile an account in QuickBooks Online.

Feel free to get back to me if you need any clarification on the reconciliation process. I'll be here. Have a good one!
 

LockerRoom
Level 1

Where are bank statements for reconciling?

Thanks for your response.

 

The account is linked and banking transactions appear for this account, just no statements for reconciling. If I import the bank statement, will that create duplicate transactions? 

Carneil_C
QuickBooks Team

Where are bank statements for reconciling?

Thanks for getting back to us in Community, @LockerRoom. Let me further assist you in managing your bank transactions in QuickBooks Online.

 

Importing a CSV file won't create duplicate transactions. Review them and make sure everything is categorized correctly.

 

Here’s how:

  1. Click Banking.
  2. Go to the For review tab.
  3. Select the transaction, then click the Categorize.
  4. Click Add or Match.

 
From there, you can now exclude the transactions that aren’t needed in the register to keep the account accurate.

 

Here’s how:

  1. Go to the Banking page.
  2. Click the transactions you want to exclude.
  3. Select Exclude.

 
You can check this article for more details about categorizing bank transactions.

 

In addition, here are a few extra articles that can help you along the way: 

If you have any further questions with any transactions in QBO, please let me know and I’ll do everything I can to help here in the Community! 

LockerRoom
Level 1

Where are bank statements for reconciling?

I have two checking accounts (both from LCNB) linked to our QB account. One account downloads transactions for reconciling and one doesn't. I would prefer not to import a CSV file if I can avoid it. I can see the bank register for the account in question but this message appears when attempting to reconcile. 

 

"Your statements haven't come in yet, but we're working on it. Check back in a few days."

 

I've been working on this for over a week. Wondering if it's a setting in my account? 

Ethel_A
QuickBooks Team

Where are bank statements for reconciling?

Hello there, @LockerRoom. Allow me to share some insights about updating bank transactions.

 

The system automatically downloads your most recent transactions. We can update the connection between your bank and QuickBooks to refresh its settings if it brings up the items.

 

Here's how:

 

  1. From the left menu, go to Banking.
  2. Select Banking.
  3. Click the Update button.

 

If this happens again, I recommend contacting our Phone Support team. This way, they can look into the root of the problem.

 

Can you also tell me the name of your banking institution for me to check any active investigations on my end?

 

You can categorize the transactions once everything is in order. As a starting point, consider the following article:  Categorize and match online bank transactions in QuickBooks Online.

 

Reply below if you have additional questions about updating bank transactions. I want to ensure everything is working well for you, and I'm here to provide assistance and insights.

LockerRoom
Level 1

Where are bank statements for reconciling?

We have TWO checking accounts (both with LCNB). The recent transactions are displayed in the bank register window.

 
One of the checking accounts has no issues with the bank register or reconciliation. The second LCNB account
displays the recent transactions in the bank register but will not import the statements for reconciliation. 
 
I have updated and refreshed and neither have resolved the issue. 

 

GebelAlainaM
QuickBooks Team

Where are bank statements for reconciling?

I appreciate you getting back to the thread, @LockerRoom. I'll provide you with some information that'll help you resolve your concern.

You can perform the basic browser troubleshooting to help you isolate the issue and to make your browser load faster. This helps refresh the website and clear the cache that is blocking you from reconciling your account ang processing the bank statement.

Here's how:
 

  1. Restart your browser.
  2. Log in to your account and try to import bank statements and reconcile your account in an incognito or private browser. You can use these keyboard shortcuts to launch a new private window:

    Google Chrome: press Ctrl Shift N
    Mozilla Firefox: press Ctrl Shift P
    Safari: press Command Shift N
     
  3. If it works on the private browser, you can go back to the regular browser and clear your browser's cache. From there, try to import bank statements and reconcile again your account.

Also, make sure you're using the updated/supported browsers.

You may refer to this article for the error message prompted to your screen: What to do if you get a bank error or can't download transactions in QuickBooks Online.

Let me know if you're still unable to proceed with the reconciliation and import the bank statements. I'll get back to you as soon as possible. Have a prosperous business!

Need to get in touch?

Contact us