Downloading your data is the most convenient way to get your transactions and other account information from your bank, credit card company, and other financial institutions into Quicken. Instead of entering each transaction manually, you can set up your accounts for automatic download directly into Quicken. To set up your online accounts, seeSetting up accounts.
Download transactions for all accounts at once (Update Accounts)
- Update Online Accounts: Click the Update Accounts icon at the top of the sidebar. You can see when the accounts were last updated immediately below the update button.
- You can also choose Accounts > Update All Online Accounts from the Quicken menu.
When your update completes you will see a Connectivity Status window. That window will let you know what accounts connected successfully. You may also see a Needs Attention panel that will inform you of any connectivity issues and suggest a resolution, such as Re-Enter Credentials. You can recall the Connectivity Status window by going to the menu bar at the top of the screen and selecting Window > Connectivity Status.
You can copy the Update Summary information. This can be helpful if you're experiencing an issue and want to preserve the update text.
Identify New or Unreviewed Transaction
The Status column in the register allows you to identify recently entered and Bill Pay transactions.
- Set the Status filter in your register's filter bar to Last Downloaded to see only transactions that were downloaded during the last update.
- Set the Status filter in your register's filter bar to Not Reviewed to see downloaded transactions that you have not yet reviewed. Reviewing a transaction is optional.
Learn more about the transaction download status icons displayed in your account register.
Match downloaded transactions
Automatic Matching of Manually Entered Transactions
You can manually enter transactions even in your accounts that are set up for automatic download. When Quicken downloads from your bank account a transaction that matches the date and amount of a manually entered transaction, the downloaded transaction will match the manual transaction, resulting in only one transaction in your account register. Any manually entered payee name, category, memos, or tags will be retained. Matched transactions are represented by the icon .
If Quicken fails to recognize that a downloaded transaction matches a manually entered transaction, you can match them manually by dragging and dropping one onto the other.
Automatic Matching of Scheduled Transactions
Scheduled Transactions are marked as paid automatically when you download a transaction from your bank that matches a scheduled transaction in your register.
For example, suppose you have a scheduled transaction for your electricity bill. You scheduled it to be paid on the first Friday of every month. Then later you pay that bill at your bank's website. When Quicken downloads a transaction from your bank account that consists of a payment to your electricity company that took place around the beginning of the month with the same amount as the scheduled transaction, it automatically marks the scheduled transaction for your electricity bill for that month as paid.
If Quicken fails to recognize that a downloaded transaction matches a scheduled transaction, you can match them manually by dragging and dropping one onto the other. Matched transactions are represented by the icon .
When you set up an online account and download transactions, you will only see a limited number of transactions, usually the last 90 days of transactions. This is a limit set by banks. This is one reason why you should regularly download transactions from your bank. You do not want to update so rarely that there are gaps in your transactions.
It is possible to import transactions from further back than 90 days, but you will have to export those transactions from your financial account's website.
Skip to end of metadataGo to start of metadata
What is QFX?
QFXstands forQuicken File eXchange. It is used by many financial institution websites to transfer information from their website to Quicken.QFXfiles provide information about transactions, balances, and other key data that needs to be passed from the financial institution to Quicken. Using QFX files to transfer information is often referred to by Quicken asWeb ConnectorQuicken WebConnect.
QXF(Web Connect) is primarily used to transfer financial information whenDirect ConnectandExpress Web Connectare unsupported by the financial institution. If you have the option to useDirect ConnectorExpress Web Connect, we recommend that you chose one of those options instead.
QXF(Web Connect) is also sometimes used to download older transactions from a financial institution when you want to view those transactions in your Quicken file.
Downloading a QFX file from your financial institution's website
One of the reasons QFX is not the preferred option for most users is that you must download the file directly from your financial institution's website. While we can provide general instructions, websites vary.
- Log in to your financial institution's website.
- Select the account you wish to download transactions for. The download option is usually on the transactions page for an account.
- Select the download link. This is usually represented by a download symbol using a down arrow such as.
- You may need to select the download format. Look for the formatQFXorWeb Connect.
You will have to specify theDate Range(Start Date/End Date). You may also need to select the account or accounts you wish to download.
If you have existing transactions in Quicken for your financial account, make sure that you do not duplicate those dates, otherwise you will have duplicate transaction. You can always delete duplicate transactions, but it it much easier to just avoid duplicating dates.
- Once you have filled out all of your information there should be a button to select such asDownloadorExportorStartto start downloading the transaction.
The transaction will download into the default directory/folder for your browser. This is usually theDownloadsdirectory.
Importing a QFX file into Quicken
Once you have downloaded your QFX file, you'll need to import that file into Quicken. If this file was requested as part of a process, such as theDownload Transactionsscreen, follow the instructions there. Otherwise follow the instructions below:
- Back up your Quicken Data File.
- Go to the File menu and selectFile Import→Bank or Brokerage File (OFX, QFX).
The file selection screen will appear. - Use theBrowsebutton to find and select the file you want to import.
- ClickOpenor double-click the file to import.
- The Choose Your Accounts screen will appear. Select the account you want to import transactions to.
- Review the account register to verify the transactions have been added,
For more information about downloading transactions, including troubleshooting information, see the support article How do I import/export a Quicken Transfer Format (.QXF) file?.
FAQs
When you set up an online account and download transactions, you will only see a limited number of transactions, usually the last 90 days of transactions.
Why is my Quicken not downloading transactions? ›
If this issue occurs frequently
Go to Edit > Preferences > Downloaded Transactions. The option Automatically add to banking registers needs to be unchecked. Refresh your online account information by clicking the Actions Gear Icon on the upper right of the register, and select Update Now.
How do I get a PDF of a transaction? ›
Open the Transactions page. Click Export. Select Export PDF Statement. Your PDF file will automatically download.
Can I print my bank transaction history? ›
If your bank doesn't have an option to request a paper statement, you can print out a downloaded PDF for a physical copy of your statement. This printed version will look exactly like the mailed version of your statement and is considered an official document.
Why doesn t Quicken show all transactions? ›
The missing transaction hasn't cleared your bank yet
Sometimes it takes a few days between when you initiate a transaction and when it clears your bank. It won't download into Quicken until it clears. If your missing transaction is one that is dated recently, it might not have cleared your bank yet.
Can I export transactions from Quicken? ›
You can export and copy your Quicken data to other programs. For example, from one Quicken account (or file) to another, or to Microsoft Word or Excel.
How do I copy all transactions in Quicken? ›
Click the transaction to select it. Click the Edit gear icon in the transaction (on the right side of the entry), and then choose Copy Transaction(s). If you need to select multiple transactions, hold the Shift key as you select them.
How many transactions can Quicken hold? ›
Accounts - Up to 512 accounts of each Account Type (spending, credit, investment, etc.);
Where is the downloaded transactions tab in Quicken? ›
The Downloaded Transactions tab normally appears just below your Quicken register.
Can I download more than 90 days in Quicken? ›
Your FI or bank controls how far back you can download. Most only go back 90 days. The rest you will have to enter manually. You might get a greater range of transactions if you go to your financial institution's website and download a different range of dates in a Web Connect .
Open Google Pay . From the bottom of the screen, slide your finger up to show your contacts. To see all transactions: At the bottom of the screen, tap All transactions.
Can I download transactions from Bank of America to Quicken? ›
Log into privatebank.bankofamerica.com/AccountAccess. To get to the Quicken download page, click on Accounts, then Download Account Data. Select the account(s), date range and click Download. multiple accounts or groups, select the checkbox beside each account or group to include.
Can I download from Bank of America to Quicken? ›
All you need to do is sign in with your Bank of America credentials when prompted to establish a connection. After you sign in, select the accounts you want to connect in Quicken. Note: Make sure all of your accounts are checked, even if they're already added to Quicken or if they're in a different file.
How do I export bank Transactions to PDF? ›
Log in to your online banking. Select Statements from the left menu and the required account. Select a statement number, followed by 'Print' at the top. Now, right-click your statement and choose to save as a PDF.
What does PDF mean in banking? ›
What software do I need to view my Online Statements and account notices? PDF stands for “portable document file” and is a standard way to deliver electronic documents on the Internet. Your Online Statements are available in Online Banking as PDFs, which require a document reader to view.
How long do banks keep transaction records? ›
Banks are required by federal law to keep most records on file for at least five years, and many keep members' account statements available for up to seven.
How do you show proof of a bank transaction? ›
A receipt or bank statement is the most common way to provide proof of payment. Receipt copies can be obtained from the seller either online or in person. If you need to use a bank statement, access it through your online bank account.
How far back can you print bank statements? ›
If you have an online bank account and don't get paper statements, you'll be able to review or print your statements for a number of years when needed. The banks keep these documents accessible for more than a year (and up to 3 years, depending on the bank).
How do I view all transactions in Quicken? ›
Just click the Calendars tab at the top of your Quicken screen. The Quicken calendar displays all the past, present, and scheduled transactions created in your register. Click on a calendar day to view all the transactions created for that day. For more information about Quicken calendars, see Your financial calendar.
How do I download Quicken files? ›
Step 1: Download the Quicken subscription product
If you're using Google Chrome, click the download progress button at the bottom left corner of the window after the download is complete. If you're using Firefox, click Save File. Click the download icon in the upper right corner then select the Quicken EXE file.
QuickBooks is a full-featured business and management suite with all the tools that a small business would need, but it's also costlier. Quicken helps families and individuals track account balances, investments, budgeting, and other expenses.
Why is Quicken downloading transactions twice? ›
Transfers are appearing twice.
This occurs when a transfer is downloaded for one account then downloads again for the other account and the transfer transactions do not get matched to each other.
Does Quicken have memorized transactions? ›
The Memorized Payee List allows you to save frequently used information so you don't need to reenter it each time you enter a transaction. The Memorized Payee List saves all information about payees such as categories, amounts, and memos.
How can I get my transaction history? ›
Open Google Pay . From the bottom of the screen, slide your finger up to show your contacts. To see all transactions: At the bottom of the screen, tap All transactions.
Which app is used to download bank statement? ›
Docparser is your go-to PDF bank statement parser helping you to parse data which is trapped in PDF bank and credit card statements and physical images.
How do I convert bank statements to PDF? ›
Log in to your online banking. Select Statements from the left menu and the required account. Select a statement number, followed by 'Print' at the top. Now, right-click your statement and choose to save as a PDF.
How do I automatically import bank transactions into Excel? ›
Import CSV
First, you download the bank activity from the bank website as a CSV file. Then, in a new blank Excel workbook, you click the Data > From Text/CSV command in the Get & Transform ribbon group. In the resulting Import Data dialog, browse to the CSV file. Excel provides a preview of the data, as shown below.
Can I convert PDF bank statement to CSV? ›
Select the Start button to begin converting your PDF to Excel first. Open the Excel file in the MS Excel app and go to File > Save as. Choose CSV as the output format.
What is CSV for download? ›
What are CSV files? CSV files are text files with information separated by commas, saved with the extension .csv.
What software converts bank statements to CSV? ›
Nanonets is particularly useful for converting bank statements into machine-readable structured data formats such as Excel, CSV, XML, or JSON.
If you need a paper copy of a bank statement, or a copy of an older statement that's not available online, you may need to visit a bank branch or request the statement by mail. Visiting a local bank branch could be the fastest option as you won't need to wait for the mail.
How do you keep track of bank transactions? ›
Keep a checkbook to track deposits and transactions. It may seem old-fashioned, but recording your transactions in a checkbook is still a simple and reliable way of tracking your finances. Plus, it can help you catch banking mistakes and fraudulent charges.
Can a bank statement be downloaded by anyone? ›
No. Unless you give out your account number, banks do not release information regarding your bank statement to unknown third parties without your consent.
What is a PDF version of a bank statement? ›
PDF stands for “portable document file” and is a standard way to deliver electronic documents on the Internet. Your Online Statements are available in Online Banking as PDFs, which require a document reader to view. This is a standard feature of most Web browsers.
Do I need to download bank statements? ›
Why You Should Keep the Statements. Access to a record of your recent purchases, bill payments, and payroll deposits is necessary for a number of reasons, not least as a proof of payment in case of a dispute. You should review your bank account activity regularly for evidence of identity theft and debit card fraud.
.
