cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
JackS
Moderator

Downloading Your Bank Transactions and What To Do Next

Our banking feature enables our customers to connect to their bank accounts to QuickBooks, making it easy to keep track of your business income and expense.

 

First, download your transactions to QuickBooks using one of the three ways that are available to you. Once the transactions are available in QuickBooks, you'll need to accept them into your books or match them to the ones you have already created in QuickBooks. Lastly, reconcile the transactions in QuickBooks against the transactions in your bank account. We recommend doing this at least once a month to avoid lengthy reconciliation process at the end of the year.

 

Downloading transactions

There are three ways of downloading your bank transactions. Both direct and standard bank feeds allow your transactions to flow into QuickBooks but if you prefer to import your transactions into QuickBooks manually, you can do that too. This video gives you a quick overview on the options available to you.

 

 

Using direct feed connection

Direct feed provide a direct connection to your bank account. You'll need to apply in QuickBooks and submit a Customer Authority Form. Some banks require you to print, sign and post the form to them, whilst others let you complete the process online.

 

The approval process takes up to 10 business days once you've posted your form. After your application is approved by the bank, transactions will start flowing into QuickBooks automatically, you'll no longer need to download or import your transactions manually.   

 

This article details which banks have direct feed available. Watch the short video below for steps to complete the process.

 

 

Using standard feed connection

QuickBooks connects to most major UK banks through standard feed. Standard feed connection requires you to enter your online banking username and password details. If your bank requires a one-time passcode (additional verification that could be a security question or security token), you'll need to provide it to update the connection in QuickBooks to download the most recent transactions. 

 

Watch the short video below on how to complete this process.

 

 

When connecting via standard feed, you may occasionally receive an error when you try to update your connection. This article details steps you can try to resolve the issue, most of the time, the issue can be fixed by following these steps.

 

Using CSV import

If you have connected via direct or standard feed, and need transactions going back longer than what your bank provides, you can import them into QuickBooks using our CSV import functionality. 

 

Watch this short video for steps to prepare your CSV and to complete the import process.

 

 

Add or match your transactions in QuickBooks

After downloading your bank transactions to QuickBooks, you need to add them to your books or match them to transactions you have already created.

 

If your transaction does not yet exist in QuickBooks, you need to add them to QuickBooks. The video below details.

 

 

If your transaction already exist in QuickBooks, you need to match them to create a link between your bank transaction and QuickBooks transaction. Watch the video below for more details.

 

 

Reconcile your bank account

This is the process of comparing your QuickBooks transactions against your bank statement to ensure that all your transactions are correct and accurate in QuickBooks.

 

4 REPLIES 4
Karen SCR
Level 3

Downloading Your Bank Transactions and What To Do Next

I have a question. I just migrated to online from desktop. My bank downloaded 90 days worth of transactions. I matched the ones that were labeled match (they were all current transactions). 

I have 60 days or so worth of transactions that QB is labeling add, but they are transactions that are already in my QB record and have been reconciled. How do I review this list and get them removed, without adding them to my records? I do not want to end up with duplicates of the last 60 days worth of bank transactions! 

Thank you, Karen SCR:)

Aphylis
Moderator

Downloading Your Bank Transactions and What To Do Next

Hi Karen SCR

 

You’ll be glad to know that in QuickBooks Online, you’ll have an option to exclude transactions that you wish not to Add or Match.

 

Here’s how:

  1. From the left menu, select Banking.
  2. On the Banking page, select the For Review tab.
  3. Select the checkboxes of the transactions to exclude.
  4. From the Batch actions drop-dow, choose Exclude Selected.

Excluded transactions are listed on the Excluded tab for reference or review, but are not tracked or reported as part of your business finances and don't appear in any associated account registers or reports.

 

To avoid duplicate transactions, run a report with your Bank account from Chart of Accounts and compare to your Bank Statement record. If the transaction is correct, you can tag transaction as Clear ( C ).

 

Migration from QuickBooks Desktop to QuickBooks Online will need to reconcile the accounts again.

 

For detailed information for reconciliation of accounts, see links below.

How to reconcile accounts

Reconciliation errors in QuickBooks Online

Karen SCR
Level 3

Downloading Your Bank Transactions and What To Do Next

Thank you so much!! That was very helpful and solved my concern! 

 

Thank you also for the tips about reconciling. :)

aphylis2
Level 1

Downloading Your Bank Transactions and What To Do Next

Very much welcome @Karen SCR. I'm glad it solved your concern.

 

Just drop a comment if you have further query, we are happy to help.

Need to get in touch?

Contact us