MoneyThumb
Main Menu
Navigation
  • Who We Serve

      MCAs

      Analyze bank statements and other financial documents into an instant scorecard to determine an applicant’s credit worthiness and get to an approval in minutes, not days.

      Small Business Lenders

      Evaluate financial documents and get an underwriting scorecard instantly with our automated document processing and fraud analysis tool. Get to Yes or No faster than your competition.

      Mortgage Lenders

      Ideal for bank statement and asset-based loans and other non-QM loans, PDF Insights and Thumbprint can save time and money while mitigating risk.

      Accounting Professionals

      Convert PDF bank and credit card statements or other accounting file formats into QBO, OFX, CSV for import into accounting systems or other assessment.

      Small Business Owners

      Get your financials up to date by effortlessly and accurately extracting transactions from bank and credit card PDF statements into suitable formats (QBO, QFX, QFX, QIF, CSV) for import into your accounting software.

      Individuals

      Convert or migrate financial transaction data to or from personal finance apps. Reads PDF bank and credit card statements, Mint, Quicken Export File, QIF and CSV files.
  • Products

      PDF Insights

      Enables banks and fintechs to read and analyze financial documents in seconds to determine a loan applicant’s credit worthiness.

      Thumbprint®

      Instantly evaluates and scores the authenticity of PDF financial documents giving you a fraud score so you can make more confident lending decisions.

      Server API

      Provides access to PDF Insights and Thumbprint through a REST API for seamless integration with your CRM.

      QuickBooks Converters

      Convert virtually any file type into the QBO format for quick and easy import into QuickBooks Desktop or QuickBooks Online.

      Other Accounting Converters

      Convert financial transactions into leading accounting systems such as Xero, FreshBooks, Sage, Wave, Zoho, YNAB, and others.

      Converters for Spreadsheets

      Our converters bring transactional data into spreadsheets from PDF, OFX, QBO, QFX, or QIF.
  • Help Center

      Learning Center

      Everything you need to know to make the most of your MoneyThumb products – from tutorials to a glossary of terms and other resources – all at your fingertips.

      Tutorials and Guides

      Get access to clear step-by-step instructions with screenshots for each of the products that we offer. Leverage the power of your MoneyThumb product.

      FAQs

      Have a question on one of our products? Check out our comprehensive FAQs page and find the answers you need to make the most of your MoneyThumb tool.

      My Account

      Once you become a MoneyThumb customer, you can access and manage your products using your unique username and password.

      Resend My License

      If you need your license code resent, no problem! Send us a request using our request form and we’ll resend it to you.

      Contact Support

      Can’t find the answers you need on our website? You can reach out to our expert support team and get fast answers to your product questions.
  • Company

      About MoneyThumb

      MoneyThumb has been a leader in financial document conversion services since 2015. Learn about our journey and what makes us tick.

      Our Leadership Team

      We’re a hard-working and fun-loving group, and we’re passionate about helping our clients become more efficient and productive. Meet the people behind MoneyThumb.

      Affiliate Program

      Become a MoneyThumb affiliate partner and get access to one of the industry’s best affiliate programs. Earn commission while introducing your clients to a great product.

      Blog

      Your resource for a curated collection of informative articles for accounting and bookkeeping professionals, lenders, and small businesses.

      Contact Us

      Need to get in touch? Fill out our form and our sales or support team will reach out.

      Submit a Review

      We love hearing from our customers. If you’ve had a positive experience with a MoneyThumb product or with our customer service team, please write us a review.
  • Login
Search
Close this search box.

PDF to Quicken® Tutorial

Often times, bank statements are issued electronically in the PDF format, as statements available to download from the bank’s website. Alternatively paper statements may be scanned and be saved in PDF format. Manually entering transactions from a statement into Quicken® can be extremely time-consuming, especially with business accounts that handle a large volume of transactions, incoming and outgoing.

PDF to Quicken

pdf2qfx Convert allows you to take a PDF bank statement and import the transactions automatically into a Quicken®-ready QFX file. Not only can this save many hours of drudgery, but also reduce the chance of error associated with manual entry.


Getting Started

MoneyThumb converters work with both scanned and downloaded statements. pdf2qfx Convert will convert most downloaded statements, as downloaded statements are generally text-based PDF. For scanned, image-based, or encrypted documents, you will need PDF+, which comes bundled with pdf2qfx Convert+. If you’re not sure which type of PDF you need to convert, see https://www.moneythumb.com/pdf-types/.

This tutorial is based on a short bank statement containing 1 check, 4 withdrawals, and 2 deposits. The converter will work equally well on statements with hundreds of transactions.

PDF to Quicken statement


Step I - PDF Converter Setup

Run either pdf2qfx Convert or pdf2qfx Convert+

  1. Select the Settings button to bring up the Settings dialog PDF2QFX Settings
  2. The Settings menu is divided into three columns. In the left column you should specify the Quicken account type, lookup the FID of the bank to import into, and specify the account number. If your bank is not listed, then Quicken will not import transactions using that bank name, and you have to select a different bank. But you can still name the account anything you want. For our example we will just use the name 'National Bank' which is the name of a bank in Texas.PDF 2 Quicken lookup
  3. In the middle column, if you have a scanned image, it is good idea to select the option for Always run PDF+ text recognition (OCR). The converter will automatically run PDF+ when the file only has scanned images, but some scanners will automatically run a built-in OCR, and the scanned file will then have both text and images (a searchable PDF). In that case you need to specify that PDF+ should run regardless of whether there is text in the PDF. The other options can generally be left as defaults.
  4. On the right column you should select the correct date type (month-day vs. day-month). The option to switch signs is generally set correctly based on your account type (bank vs credit card), you can also review that later. The checkbox to Use column names should be unchecked the first time you run a conversion with a new bank, and then will automatically be checked on subsequent conversions.


Step II - Extract Transactions and Create the QFX file

  1. Run the conversion by selecting the big Convert button, which will bring a file chooser. Select the PDF statement to be converted. The first time you run the converter you should select the Preview button in the file chooser to make sure the data is correctly identified. Subsequent conversions with statements from the same bank can be converted in a single step by selecting the Convert to qfx button. PDF to Quicken file open
    The converter will extract financial transactions from the statement, automatically discarding extra headers, footers, summaries, ads, and other extraneous information in the statement. The converter will display a log with setting information, a summary of each transaction that was extracted, and a reconciliation report.

PDF to Quicken log

  1. Preview mode will bring up a spreadsheet-like dialog for confirming the transaction information extracted from the PDF Statement. At the top right is a summary of the information found in the statement; this is automatically updated as you make changes. PDF to Quicken Preview
  2. Verify the account type as a bank or credit card. You can also change the Quicken account information from this screen.
  3. Verify the names of each column, using the pull down menus at the bottom of each column to specify the type of data in that column. This is the most important aspect of preview mode. Most of the columns will automatically be correctly identified, but sometimes the names need to be modified.
    • There should be one Date column
    • Amounts can either be in one column, or two columns with one for Credits and one for Debits. If there is one column with both credits and debits and all the amounts are positive then there should be another column that contains the transaction Type i.e. credit/debit or cr/db.
    • The Payee name is taken from the left most description column and/or the first line of each transaction. Some banks have very long payee names, prefaced by things such as “Check card payment on …” Because QFX format limits the payee to 32 characters, useful information can be lost. One solution for that is to put the payee in both the payee field and the start of the memo field. We will use the Payee & Memo column name to put information in both fields – the Quicken Payee will have the first 32 characters and the Quicken Memo will have the entire string. Other banks use that first column more like a transaction type (Deposit, Credit etc.) and you will need to select a different column as the Payee name.
    • The Memo field contains text from additional lines in the transaction, or additional description columns. Sometimes there are two such columns and you can use Memo Add-on to specify that a second field be concatenated to the Memo field. You can combine Payee & Memo, Memo, and Memo Add-on to merge the contents of 3 columns; the QFX memo field can contain up to 256 characters.
    • The rightmost column labeled Use determines whether a transaction will be output to the .qfx file or skipped. You can select or unselect all the transactions by selecting the selecting the Use box in the footer.
    • Each column name can only be used once - if you need to make many changes, use the Clear button at the bottom to clear out all the column names and start over.
    • In our example the only change we will make is to identify the column with the description as Payee & Memo. Since some descriptions are longer than 32 characters this will ensure that we get the full description into Quicken.
  4. Verify that the signs of amounts are correct. Checking accounts normally have charges as negative numbers and credit card statements have charges as positive numbers. Quicken wants all charges as negative numbers. Use the checkbox for Switch signs of amounts if necessary.
  5. If you have PDF+ installed you can also edit individual transactions. Select and edit each field as you would in a spreadsheet. Transactions shown in yellow by PDF+ should be corrected, or possibly ignored. You can also create new translations using the Add Transaction button.
  6. When everything looks correct select the Create qfx button to create a .qfx file containing all the transactions for input into Quicken®. The log will be updated to show the number of transactions written to the .qfx file. The .qfx file will be created in the same folder as the PDF file you converted. PDF to Quicken logNote that if you view that folder in Windows the file will have a .qfx extension but the file type will be listed as 'Quicken OFX Data'


Step III - Import the QFX file into Quicken

  1. Open the .qfx file in Quicken.
    With a default Quicken installation you can simply click the big Import button and the .qfx file will be opened in Quicken. You can also double-click the .qfx file in a folder listing, or from within Quicken, select the File menu, File Import, and Web Connect File... Do not try to import it as a Quicken Transfer File (.QXF) file, that is something entirely different.
  2. The first time you import a .qfx file from a new bank, Quicken will offer to create new account. Quicken will identify the bank name from the FID you selected in the converter. However, you can still name the account with whatever bank name you want. Enter a name for the account and create the account, and import the transactions. In this example we used the FID from National Bank, which is a bank in Texas.PDF to QuickBooks Online new account
  3. After importing, depending on your setup, Quicken will display the new transactions at the bottom of the account register, ready to be accepted. Note that because we included the Memo information, Quicken has used the Memo information to create a longer Payee name. You can either accept all the transactions at once or accept the transactions one by one and modify the Payee names and category names to be exactly what you want. Quicken will also simplify the Payee names and change capitalization. You can edit any of that information as you accept transactions, or in the account register.QuickBooks BankFeeds
  4. After all the transactions have been accepted you can view them in the account register. You can also verify that account balance matches the account balance from the original PDF bank statement.PDF to Quicken Register

Products
  • Converters for QuickBooks
  • Converters for Accounting
  • Converters for Spreadsheets
  • Converters for Quicken
  • Trial Version Downloads
  • PDF+ AddOn
Solutions
  • For Lenders
  • For Accounting Professionals, Small Business and
    Home Users
Support
  • FAQ
  • Support Portal
  • Tutorials & Guides
  • Installation Tips
  • Resend My License
Company
  • Contact Us
  • Jobs
  • Affiliate Benefits Program
  • Blog
  • Legal Policies
Facebook Twitter Linkedin Youtube

© Copyright 2023 MoneyThumb | All Rights Reserved

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsRead Our Privacy PolicyAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT
Multi-User Licenses

Do you have more than one person in your office who needs a license?

MoneyThumb converters are licensed to individual users.  Multiple users will need a multi-user license.

Take advantage of our volume pricing for multiple users.  Select your quantity and the discount will automatically be applied at checkout.

# of Licenses Discount
2 20%
(That’s 40% off the second seat!)
5 25%
10 30%
50 35%
100+ Contact Us
License Options

2qfx Convert Pro+ license options:

  • Pro+ – Lifetime license with 1 year of PDF+
    (Currently Windows only)
  • Pro – Lifetime license, without PDF+
  • Express – 50-day Express License, including PDF+
    (Currently Windows only)

See Compare PDF Convert Editions for details