Importing bank statements into Quicken is a great way to keep track of your income and expenses without having to enter all the information manually. Most banks now deal with online financial management, making it easy for their clients to view statements electronically. If you are already a Quicken user, choosing to import your bank statements makes sense.
- Skill level:
- Moderately Easy
Things you need
- An account with an approved bank
- Quicken software (new version)
Check with your bank to make sure it offers statement downloading and support for Quicken. You need to know this in advance of installing the program.
Ask what version of Quicken your bank requires. Most banks will only work with either the current year or the last 2 years of the software.
Log on to your Quicken account and open the summary page for your bank. You should have the data for your bank already saved in your Quicken account. If you don't, you will have to save it before you can proceed to importing statements.
Make sure you are connected to the Internet, and then choose the "Download" option to get the last statement from your bank to your computer. If you want previous statements as well, you can select a different date. Keep in mind, however, that most banks will only allow you to download a period at a time, so you may have to repeat the procedure until you get all the information you need.
Open the "Account Detail" file, and a window should pop up after the download finishes in Quicken versions 2007 or later.
Go to "File," and then "Import" to get the downloaded statements into Quicken. If you don't do this, the bank statements will remain in your hard drive, but won't show up when you open Quicken to work on them.
Check that you have the right information. The file should be complete, with no missing text. It should include the total monthly balance.
Choose the name of the file you want to upload into Quicken, and then click "Save."
Import Bank Statements Into Quicken
Tips and warnings
- Check your software version. You can only import bank statements into the full versions of the program (QuickBooks Pro, Premier and Enterprise). QuickBooks Simple Start software does not support this feature. Likewise, trial versions and some of the older versions (prior to 2003) are not capable of importing bank statements.