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

Adding Bank Account

Hi all,

A complete newbie and novice here on QuickBooks so please be gentle. I'm trying to add my HSBC account to my QB and all it wants to do is download the whole of the last years transactions. I only started as self employed yesterday and want my QB bank transactions to show from then only, otherwise I have nearly 700 transactions to categorise and that's not what I want to do. 

 

Any idea if what I am trying to achieve is possible?

Many Thanks.

Matt.

1 REPLY 1
Maybelle_S
QuickBooks Team

Adding Bank Account

Glad to know that you're using QuickBooks to manage your account, @Matt Butler1.

 

Let me share some information about connecting accounts in QuickBooks Self-Employed (QBSE).

 

When connecting a bank account for the first time, QuickBooks automatically downloads the 30 to 90 days worth of transactions. To add the older transactions, we need to export them from your bank first. Then, import them into QuickBooks. Before doing so, check the transactions that are already in QuickBooks so you don't have duplicates.

 

To check, here's how:

  1. Go to the Transactions menu.
  2. From the Account: All drop-down arrow, select the account you want to upload the transactions into.
  3. Click the Date drop-down arrow, and then select All.
  4. Select the Date column header to sort the list by date.
  5. Take note of the oldest transaction date in the account.

Once done, export the transactions from your bank. I'll guide you how:

  1. Sign in to your bank’s website.
  2. Follow the steps to download your transactions as a CSV file.
  3. Set the date range for at least one day before the oldest transaction in the account in QuickBooks.
  4. Follow the on-screen instructions to finish the download.

To import the transactions, you can follow the steps under step 3 from this article: Import transactions.

 

I've also added this link about categorizing transactions in QBSE: Categorise transactions.

 

Don't hold your back to drop a comment below if you need assistance with the process. I'm always here to help. Have a great day!

Need to get in touch?

Contact us