Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > QuickBooks > How to Download Bank Transactions to QuickBooks 2019

How to Download Bank Transactions to QuickBooks 2019

Watch the QuickBooks 2019 video tutorial. We will discuss how to download bank transactions. And, find out the pitfalls of doing such operation in QuickBooks.

Facebook Linkedin Twitter

We are working in module seven right now where we’re talking about the different banking activities that QuickBooks has available.

We’ve talked about working with the registers a little bit. I want to talk to you now a little bit about downloading your transactions from your bank’s website.

This may or may not be a good idea. Depending on how many options in QuickBooks you’re actually using. Let me take a few minutes and tell you why I say that. And then, I’ll show you how to download transactions (if that’s what you choose to do for your business).

Before I show you how to go in and actually download your transactions. Let’s talk about why I said it may or may not be a good idea. I want you to think about something. When you download from the bank, all you’re doing is downloading the checks or the deposits into your actual checkbook register. Right here!

That means that the register would be correct. But think about this! Let’s say you have invoiced a customer, and you receive a payment. If you’ve already made that deposit, (which you should have if you’re following the flowchart), then, you don’t want to download that deposit a second time! Why? Because, then, it would be in there twice.

That’s scenario number one!

Here’s scenario number two. Let’s say, you did create an invoice and you did receive payment. And, you stopped there! You never put that deposit in your checkbook. What would happen is your checkbook would be correct (when you download it). But, you would never take that money out of undeposited funds, because you didn’t complete the whole cycle here.

How about bills? Let’s say, you’ve entered a bill. And then, let’s say that you paid it. That means that the check is already in the register. Why do you want to put it in twice? So, you have to be very careful when you’re downloading from the bank because you don’t want to download everything.

And then, also, you’re going to see that sometimes it doesn’t have the right accounts. Then, you have to figure things out. So, it could be more trouble than it’s worth, but that’s up to you!

I usually say go ahead and do about a weeks’ worth or maybe a couple days if you had a lot of transactions, but don’t try to do a whole years’ worth at once because if it’s screwed up then the whole thing is screwed up and you’re going to have a really hard time fixing it.

But let me show you where to go if you’d like to download your transactions.

There’s a couple of ways you can do this. Number one, if you’re in the check register, you’re going to be able to download from there.

You’ll actually see a button here that says: “Download Transactions”. The other thing is that, if you go to your bank’s website, you can download into QuickBooks.

It’s probably suggested that you do it from within QuickBooks because you’re going to see there’s going to be a little holding window and you’ll be able to pick and choose what you’d like to pull over if you do it this way.

I’m going to click on Download Transactions.

When you download transactions, you’re going to see on the left all of the bank accounts that you’ve initially hooked up to work with the download feature.

There is an initial process, you’ll have to go through where you log in to that particular bank account. The QuickBooks recognizes it for future reference.

You do have the ability to download your credit cards as well. Not just checking accounts. This could be checking, savings, and credit cards.

You’ll want to click on the account that you’re trying to download from. It will give you the current balance that’s in the bank and it will give you your current balance in QuickBooks. You’re going to come over here and click Transaction List. And then, it’s going to download anything since your last download.

So, if you’ve already downloaded something you can’t download it again.

What you’re going to see here are all the transactions that have not yet been pulled into QuickBooks. You can go down the list and check off the ones you’d like to pull over.

Notice, that you will have to check things like the payee’s name. There’s not going to be one for most of your transactions. So, you’ll have to go figure out what this check was for and put in the payee.

You’ll have to put in the account (which account this would go to). You’ll have to put in the class. And then, you do have some actions over on the right. You can quickly add this particular one (once you get all that information in).

You might have some bills that you want to mark as paid. There’s just several different things you can do here.

Let me mention the Match to existing. What that means is that if it recognizes you already have a transaction in the register for the exact same amount it will allow you to match to an existing transaction in this window.

It may not always be the correct one, so you’ll always want to investigate just to make sure. But once you check those off, then, you have the ability down at the bottom where you see Batch Actions to go ahead and add or approve all the checked ones and that will put it over in QuickBooks.

You would choose to ignore ones that might already be in QuickBooks or ones you don’t want to pull over. And, that’s how the whole download process works.

You can always get out of this and finish it later if you want. Anything you’d already pulled into this window would stay here so you wouldn’t have to download it again, but that’s how that would work.

All you need to do when you’re finished is close the bank feeds and then you’ll be good to go until the next time.

So just pay attention to those things I said. Make sure you only download a couple days at a time just to make sure it’s going to work for you. And if it doesn’t then you’ll know that you need to enter these by hand.

Well, that’s how downloading is going to work. I’m going to have you go over now to section three where we’re going to talk about creating entries and writing manual checks in QuickBooks.

Cindy McGuckin

Cindy McGuckin is an IT trainer with over 20 years of experience. Cindy currently manages the IT Training Department at Trident Technical College, she's a Member of the Association of IT Professionals, Charleston, SC chapter and the Treasurer of the South Carolina Association of Continuing Higher Education. Cindy is a Microsoft Office and QuickBooks expert and her online courses have received hundreds of 5-star reviews. Her no-nonsense approach to teaching complicated topics makes her classes engaging and interesting.

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How To Use The Quick Access Toolbar in Excel 2013

How to Delete Boards in JIRA? A Simple & Effective Step in 2022

How to Make a Box Plot Excel Chart? 2 Easy Ways

How to Convert Word to Excel? 3 Easy Ways

QuickBooks Training – A Small Business Beginner’s Guide [2022]

The Most Used Excel Shortcuts

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)