cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
kdean-dolphin
Level 3

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

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.

2 Comments 2
glassr
Level 2

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

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-aft... 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

Trish_T
QuickBooks Team

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

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!

Need to get in touch?

Contact us