Skip to main content
December 6, 2023
Question

Is there a way to have bank statements automatically import to QBO?

  • December 6, 2023
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

December 6, 2023

You can get your bank statements into QuickBooks Online and automate the process, I'd be glad to walk you through the steps, @cmb3.

 

If you're using QuickBooks Online Plus, Advanced, Accountant, and QuickBooks Live, you can get bank statements directly from your bank when you reconcile.

 

If you're using QuickBooks Online Simple Start and Essentials, you'll want to manually upload your bank entries into QBO.

 

Here's how:

  1. Click Banking from the left navigation panel.
  2. Pick File Upload from the Update drop-down menu or Upload transactions manually if there isn’t any bank connected to QBO.
  3. Select Browse and choose the file you downloaded.
  4. Choose an account from the list, then Next.
  5. Follow the on-screen instructions to map the fields.
  6. Select the transactions to import.
  7. Click Yes.
  8. Hit Let’s go.

 

Here's an article for more information and steps on importing these files, see this article: Manually upload transactions into QuickBooks Online.

 

Once everything is good, you can begin categorizing and matching your online bank transactions to post them into the appropriate accounts.

 

You might want to keep these links handy for reference about the process of reconciliation:

 

I am also adding these tips to know what to do if you get a bank error or can't download transactions in QuickBooks Online.

 

Let me know if you need further assistance or have other concerns while importing your bank statements.. I'm always available here to help. I'll keep an eye out for your response. Take care.