Skip to main content
December 3, 2019
Question

Re: Is there a way to attach a copy of the bank statements to the bank reconciliation? The CPA's like to see this.

  • December 3, 2019
  • 1 reply
  • 0 views

That feature now appears to be available, but it's incredibly buggy. I have attached what I see when I click on "View statements" in the "Reconcile" tab. It looks like statements are being downloaded directly from my bank, but there are several problems.

 

  1. Although the top of the screen shows that I'm working in my "Chequing - CAD" account, absolutely all of the statements are for my "Chequing - USD" account. If I switch to any account that has statements, only "Chequing - USD" statements are shown in the "Reconciled" tab and none in the "Unreconciled" tab.
  2. If I switch to an account that doesn't support statement download, I get a message saying so, but the "Unreconciled" tab shows statements for my "MasterCard" account and the "Reconciled" tab shows nothing.
  3. As you can see from the list, many statements have been downloaded twice.
  4. Furthermore, all these statements were downloaded on December 2. At that time, my November statement was available online, but it's not in the list.
  5. When I select "History by account", I can see the statements for the right accounts, but the "duplicates" problem still exists and the end of November statements are missing.
  6. The statements that have been downloaded don't show up in the global "Attachments" list.
  7. The statement files are named according to the name the bank gives them. I have a naming convention I use and I'm unable to rename the files to something more sensible.
  8. Although there's an "Attach" option for older reconciliation reports, because there's no connection to the global "Attachments" list, I can't link to the statements that I have stored there. If I want to attach older statements, I would have to download them from the global list and re-upload them here.
  9. Although the history is supposed to show "Attachments" for reconciliations that have attachments and "Attach" for reconciliations that don't, I can in fact click on quite a few with "Attach" and find that they in fact do have attachments.

The whole thing is a dog's breakfast.

    1 reply

    February 3, 2022

    QBO Accountant logged in >  Opened a company file > Accounting > Reconcile > History by account > There is no link or icon to upload bank statement , attach it to a reconciliation and yet this article indicates it is possible to do so when logged into QBO acountant following those steps.  What am I doing wrong or what is wrong with my QBO Accountant access? https://quickbooks.intuit.com/learn-support/en-ca/banking-currency/how-to-attach-bank-statements-after-reconciling/00/422044 this is a highly valued time saving feature.  I want it now!

     

    attached screen shot 

    qbo_accountant_upload_attach_bank_statement_to_bank_reconciliation_function_not_apparently_available.png

    February 3, 2022

    Hi glassr,

     

    Thanks for reaching out here.  QuickBooks Online is a superb accounting software allowing you to complete your dally tasks seamlessly.  One of the great features available is having the ability to download your bank statement when reconciling your accounts.  I'll be happy to provide more information so you can get back to what you love!


    As mentioned by others in this thread, bank statements are only available in QuickBooks Online Plus and Accountant.  If you're reconciling an account in your client's books, the option won't be available unless the subscription is upgraded.  When you're reconciling accounts in your Accounting Firm, you'll also have the option to import statements.  However, not all financial institutions support this feature at this time.

     

    For more details on this feature and the banks that currently support it, click here.

     

    I hope you find this helpful.  Let us know if you have other questions.  We'd be glad to help!