Skip to main content
A
APPLEPIE54
December 6, 2020
Question

Attaching Bank Statements to Bank Reconcilation

  • December 6, 2020
  • 3 replies
  • 0 views

Let us talk about this mythical attaching Bank Statements to Bank Reconciliations. Before I start I am going to put a in guidelines of what I want to figure out.

 

I want to be able to at minimum attach bank statements to bank reconciliations. I do not care about how some supported bank can automatically download bank statements to quick books for you. I want to be able to long in and click and drag over a PDF of the bank statement and attach it to the bank reconciliation like I can attach any image to any other transaction in QBO.

 

I am figuring this out on QBOA at first so I would have a version that supports this. I have Clients at Plus who would like to use this as well. As I understand Plus and above can get this function. However I am honestly baffled as to why such a basic function would be pay walled. One of the main benefits of QBO is that it acts as a cloud storage for supporting documentation. Having a pay wall for the cloud storage of one of the more important and constant forms of bookkeeping documentation seems silly to me. So please don't ask me If I have the correct subscription. But please tell me if QBOA is somehow excluded from support for this function for some silly reason.

 

My bank is not supporting of the auto download but I don't care about the auto download I just want the manual attachment function. If I hear that you are adding more bank support all the time for the auto download one more time I might scream. Also if this article gets linked to me again  I might scream :https://quickbooks.intuit.com/learn-support/en-us/statement-reconciliation/get-bank-statements-directly-from-your-bank-when-you-reconcile/00/570423

 

Finally from support I was told that if I don't have a bank account at a supported bank the feature of being able to manually attach bank statements to bank reconciliations would not be active on my account. Period. Please confirm if that is the case. If you do confirm if that is the case please put in a ticket as well to ask for that to be changed. I see no reason why the ability to manually attach a document should be dependent of being able to automatically attach a document. It should be the other way around.

 

Finally just to prove that I do not have this function Here is a screenshot of the missing buttons.

    3 replies

    MJoy_D
    MJoy_D
    December 6, 2020

    Thank you for posting here in the Community, @APPLEPIE54.

     

    I can provide some information about the feature to attach bank statements to a bank reconciliation.

     

    The feature to attach your bank statements to your reconciliations is available in QuickBooks Online Plus, Advanced, Accountant, and QuickBooks Live users. You can simply click on Attach statement when you’re prompted with a pop-up message after completing the reconciliation. However, your bank must be connected, so you'll get bank statements automatically.

     

    I can see the importance of being able to attach statements like how you can do it to any other transaction in QBO. That would be a great addition to the current features that we have, so I’ll be sure to take note of it. For now, you can visit the QuickBooks Blog to check for new updates and features that we have. 

     

    Here's a guide on how to reconcile an account in QuickBooks Online and what to do when you encounter issues when reconciling: Fix issues at the end of a reconciliation in QuickBooks Online.

     

    That's it! Let me know if you have any other concerns or follow-up questions when reconciling your accounts. Take care and have a wonderful day!

    A
    akfailla1
    January 4, 2021

    I am using QBO Accountant. When I do bank reconciliations I do not get the request to attach a statement, nor do I have the option to attach after by going thru the History by Account screen. Why is this? He has a Plus subscription.

      JasroV
      JasroV
      January 4, 2021

       I’m here to help and share some insights on how to get around this issue, @akfailla1.

       

      There are times that the browser is full of frequently access web page. When this gets outdated, it can cause an issue with your QuickBooks performance. To verify this, let access your account via a private window (incognito).

       

      Incognito window doesn’t save any data file, thus, it’s the best tool to verify a browser’s cache issue. To begin, here are the keyboard shortcuts that you can use to in opening a private window:

       

      • For Google Chrome browser, press keys: Ctrl + Shift + N
      • For Mozilla Firefox browser, press keys: Ctrl + Shift + P
      • For Safari browse, press keys: Command + Shift + N 

      Once logged in, attach the statement again to double-check. If you’re able to, go back to your regular browser and clear its cache. If you’re unable to, try using other supported browsers and check if this is a browser-integrated issue.

       

      In case you need to make some adjustment to your clients' reconciliation, check out this link for your reference: Undo a client’s reconciliation in QuickBooks Online Accountant.

       

      You’re always welcome to post a reply in this thread if there’s anything else you need help with. We’re always open 24/7 ready to help you. Have a good one and keep safe!

      C
      cookingclo
      May 3, 2021

      how do I download my bank statements to my computer 

      Angelyn_T
      Angelyn_T
      May 3, 2021

      Hi, @cookingclo.

       

      I'll help you with downloading your bank statement to your computer.

       

      If you're trying to upload your bank transactions to QuickBooks manually, you can download your bank statements through your bank's website. I'll guide you how.

       

      1. Sign in to your bank's website.
      2. Follow your bank's instructions for how to download CSV files of your transactions to your computer. 
      3. Check the date range for the download. It should be at least one day before the date of your oldest transaction.
      4. Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.

       

      After that, you're now ready to upload them to QuickBooks Online.

       

      Once your bank transactions are available on the Banking page, you need to review them and put them in the correct accounts. You can check out this link as your guide: Categorize and match online bank transactions in QuickBooks Online.

       

      If you have any other questions about downloading your bank statements, please notify me by adding a comment below. I'm always here to help. Keep safe!

      D
      Danewell
      December 21, 2023

      How can you attach it after its been filed?

      Like I already did the reconciliation for a whole year and then the cpa decides he wants the bank statements atached.

      J
      JanbonN
      December 21, 2023

      Welcome to the Community space, @Danewell. 

       

      I'll be happy to guide you through the process of attaching your bank statements to an already reconciled account. Here are the steps you need to follow:

       

      1. Go to Transactions, then select Reconcile.
      2. Click the History by account.
      3. Choose the Account and the Report period in the dropdowns.
      4. Under STATEMENTS, click Attach.
      5. Drag and drop the bank statements in the field. Just be mindful of the support file types.
      6. Click Done.

       

      Once you have attached your statements, you can run a reconciliation report to get a summary of your actions.

       

      If you need further assistance with your attachments, feel free to reach out to me. I'll be around to help you out. Stay safe.

      Terms & ConditionsAccessibility statement