cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Moderator

Connecting to your bank account in QuickBooks

Connecting to your bank account and downloading your transactions into QuickBooks makes it easy for you to track your income and expenses. You can connect using any one of these methods:

  • Standard feeds
  • Upload CSV file

 

Below we recommend which method to use.

 

Scenario 1: Standard Feed

We recommend connecting via standard feeds which is quick and immediate.

 

 

  1. Select Banking from the left menu. This will open the Bank and Cards page.
  2. If you already have an account connected click Add account in the upper right.
  3. Enter the name of you bank in the Search bar or select it from the tiles below.
  4. Enter your login details that you use for online banking and select Continue.
  5. Click Agree. You may be asked to enter additional sign-in information by your bank at this stage. Simply follow the onscreen instructions as required.
  6. QuickBooks allows you to connect multiple accounts linked to the same account or credit card. Select the bank accounts you want to connect.
  7. Select Connect.

The number of transactions that can be downloaded depends on the bank. If you need more transactions, refer to scenario 2.

 

Scenario 2: Importing CSV file

If you are setting up your QuickBooks account half way through your financial year, you’ll need to download all your transactions from the start of the financial year and import them into QuickBooks.

 

 

It’s really important to prepare your spreadsheet before you begin your import. Here are some tips:

  1. QuickBooks requires 3 fields: Date, Description and Amount in order to successfully import bank transactions. Some banks in UK provides CSV transactions in 3 columns, and others in 4 columns (separating Amount into Debit and Credit fields). Both formats work for QuickBooks, as long as the fields are mapped correctly.
  2. All mandatory fields should be filled in. For Amount fields that doesn't have a value (normally happens to 4-column .CSV files), enter a 0.
  3. Remove all symbols in the Amount field. For example, currency sign £ or comma ,.
  4. If your Amount field is in one column, use minus sign - to depict money out rather than brackets ().
  5. Remove any non-transactional information in the file, such as account numbers, opening and closing balance.
  6. Save your changes.

Here's how your file looks like when it's ready.

 

3 columns

48500_03.png

 

 

 

 

 

 

 

4 columns

48500_04.png

 

 

 

     

 

 

Now that you've prepared your .CSV file, you are ready to import bank transactions from CSV file to QuickBooks

  1. In the left nav, select Banking, then File Upload. If you have connected to a bank account in the past, click on the drop-down arrow to find your File Upload option.
  2. On the File Upload page, click Browse and choose the appropriate .CSV file then click Next.
  3. From the QuickBooks Account drop-down, select the appropriate bank account you want to import your transactions to then click Next.
  4. Map the statement fields according to your .CSV file's format. Check to make sure that the date format is same as the one in your .CSV file. Most of the time it is dd/MM/yyyy for UK banks. If your CSV file separates out Amount into 2 columns, choose the 2 column option. Then, map the Debit and Credit fields. Debit field in QuickBooks mean money out and Credit for money in. When you are ready, click Next.
  5. On the next page, all transactions in your .CSV file will be displayed. If you'd like to exclude any transactions, untick the checkbox next to those transactions then click Next.
  6. Then, select Yes on the notification asking if you want to import now.

 

5 REPLIES 5
Level 1

Re: Connecting to your bank account in QuickBooks

There is no question to reply here.

The message gives clear instructions to connect bank account in Quickbooks.

 

Level 1

Re: Connecting to your bank account in QuickBooks

Quick question: If I do a manual upload once to introduce the bank account to the banking section it works very well. However, the bank balance shows as zero each time while the Quickbooks balance below it shows correctly. Any fix? See attached yellow highlight from banking section.

Capture.PNG

S Ansari

QuickBooks Team

Re: Connecting to your bank account in QuickBooks

Hello alithiahealth,

 

 

Thanks for your post! The bank balance will only show here if there is a live connection to your bank, otherwise this will show as 0.00 if there is no feed connected and you are using manual uploads instead :)

Level 1

Re: Connecting to your bank account in QuickBooks

Hi, I have connected on bank account to a bank - it was earlier manual.  My other bank account, which is still manual because there is not connection has now disappeared from my dashboard so I can no longer upload transactions to it. It is set up as a bank and all the uploaded transactions are there, but the only way I can enter transactions is by manually typing them in, not by a csv upload any longer. 

Help! 

Thanks

michael

 

 

Moderator

Re: Connecting to your bank account in QuickBooks

Thanks for reaching out to us here in the Community, Michael_Vowles.

 

If a bank account doesn't show up on the Banking page, it's possible that it was disconnected. However, you can still manually upload transactions to it. Please follow the steps below:

 

  1. Go to Banking on the left pane.
  2. Choose Banking at the top then click File Upload. If you’ve never connected an account, select Upload transactions manually at the bottom of the screen.
  3. Click Browse and choose the file you saved in Step 1.
  4. Hit Next.
  5. From the QuickBooks account drop-down, select the account you want to upload the bank data and then click Next.
  6. If you're uploading a CSV file, you're prompted to select columns from the CSV file that match QuickBooks Online banking fields. Then, tick Next when you're done.
  7. Select Let's go! or Finish depending on what you see.

Once done, it’s time to go to the Banking menu to match and categorize the transactions.

 

I'll be here if you need additional support about bank connection in QuickBooks Online or if you need anything else. Have a great day.