cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Need to update your account details or payment information for QuickBooks Desktop? Click here for our step-by-step guide.
Created with Sketch. Need help running payroll? Watch our video or read the guide in our Product Tutorial.
Created with Sketch. Learn how to create and match bank rules in our video guide.
Created with Sketch. Get help with your T4A and T5018 forms.
Level 1

How do you add a bank account manually? My bank does not allow Quickbooks downloads.

 
2 Comments
Level 15

How do you add a bank account manually? My bank does not allow Quickbooks downloads.

If your bank supports SlickConnect, utilize the trial period of it.

https://www.moneythumb.com/?ref=110

 

QuickBooks Team

How do you add a bank account manually? My bank does not allow Quickbooks downloads.

Hi there stephanie-thevic,

 

Taking advantage of the banking feeds feature in QuickBooks Online is a smart move. It makes adding your transactions into your books a much more streamlined process. I'm aware that not all financial institutions allow for a direct connection with QuickBooks, so I love that you're looking to explore other options. Let me give you a hand with manually uploading your transactions.

 

The first step is to decide how far back you'll need to go to download your transactions. If you've already entered some into QuickBooks and want to match them to your bank, you can go back as far as your oldest transaction. Typically the oldest transaction you pull will be your opening balance, so refer to the corresponding account in your Chart of Accounts to review this.

 

The next step is to download the transactions from your financial institution's online banking portal as a .CSV file. The steps should be available to you on your bank's website. You'll want to ensure that you specify the date you decided on for your oldest transaction in the first step. Ensure that you save the file somewhere you'll be able to find easily. The file should be no bigger than 350KB. If it's too large, just shorten the date range and download multiple smaller files instead.

 

Now you'll want to upload the transactions. Here's how:

 

  1. Navigate to the Banking or Transactions tab from the left menu.
  2. Choose Upload transactions.
  3. Hit Browse to select the file you downloaded from your bank, then hit Next.
  4. Choose the QuickBooks account that corresponds to this bank account from the dropdown, or hit Add New if you haven't created one yet.
  5. Follow the prompts to match the columns in your file with the fields that are available within the program. Hit Next.
  6. Once complete, select Let's Go.

 

Now you're ready to categorize and match your transactions, and set up banking rules if you want to make your life a little easier. For more indepth instructions on this entire process, and for more handy tips, you can refer to our article on how to Manually upload transactions into QuickBooks Online.

 

It's as simple as that! Let me know if you run into any issues because I'd be happy to troubleshoot with you. Have a great day.