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.

      Join Our Team

      Join us to collaborate with talented teammates in an environment that values your work and your life outside of work.

  • Login
Search
Close this search box.

PayPal to Quicken


Do Any of These Apply to You?

  • Do you use PayPal for your business and need to load your PayPal transactions into Quicken?
  • Do you need more than 90 days worth of transactions?
  • Do you need email addresses or other info from your PayPal transactions loaded into your Quicken register?
  • Would you like to automatically split the PayPal transaction into income and expense categories?


MoneyThumb offers two alternatives for improved PayPal import

CSV2QIF – If you are importing PayPal transactions only once, then CSV2QIF is slightly simpler.  It can perform the automatic generation of split transactions.  QFX does not support splits or categories.

CSV2QFX – If you are merging with an existing Quicken account or intend to import PayPal transactions into Quicken on a regular basis and want to avoid duplicate transactions, then you should use CSV2QFX.

You can import an unlimited history of PayPal transactions into Quicken quickly and easily using either CSV2QIF or CSV2QFX.  And you can control which information is loaded into the Quicken Payee and Memo fields.  Additionally, CSV2QIF can automatically generate Quicken split transactions from the PayPal downloaded file.

PayPal to Quicken Tutorial

  • CSV2QIF
  • CSV2QFX
  • PayPal Split Transactions
CSV2QIF

How to import PayPal into Quicken with CSV2QIF

1. Download your PayPal transactions to a CSV file on your computer,

If you are not familiar with that, the procedure for doing so is at the end of this page. Give the file a name such as paypal.csv.

2. Install and run CSV2QIF

3. Select the Convert menu, and browse to the downloaded PayPal file from the previous step.

4. Select the file, and then Select Open.  This will run the CSV2QIF Convert, and create a QIF file, in this example called paypal.qif

5. Run the Quicken program.

6. Select File, then from the pull-down menu select File Import, and then QIF File…  This will bring up a dialog window.

Import QIF PayPal

7. Select the following options in the dialog:

In the box for Location of QIF file, select Browse and browse to the QIF just created i.e. paypal.qif.

In the box for Quicken Account to import into, select the pull-down and select <All Accounts>. Selecting an individual account will not work. Ignore the warning about not being able to import checking, savings, or credit cards etc. The QIF files created by CSV2QIF contain the account name in a format that Quicken does read.

At the bottom of the dialog, select the Transactions check box, and unselect all the other check boxes.

8. Select Import to import the transactions into Quicken.

You will get various prompts from Quicken depending on whether the account already exists, and whether it is currently the active account.  You may also be prompted to allow Quicken to create new categories. Confirm that you want to import the transactions

9.  From the Quicken account list, select the account, i.e. paypal.  The transactions imported from PayPal will be in a temporary register at the bottom of the screen.

10.  Select Accept All (at the lower right) to accept all the imported transactions.  Or select individual transaction to accept or delete.


Procedure to Create a PayPal CSV file

  1. Login into your PayPal account. Note that this procedure is written for the ‘new PayPal experience’ user interface on the PayPal web site, not the ‘classic’.
  2. Select Reports from the top menu bar
  3. Select Activity Download from the left menu, as seen below:

Download Payment CSV File

  1. Choose the Transaction type download type as either Balance affecting or Completed payments . Balance Affecting Payments will include refunds and disputed payments in addition to Completed Payments.
  2. Select Create Report on the right side. When the report is reading, save the file on your computer, for example as paypal download.csv.

In our example the downloaded .csv file looks like this when viewed in Excel (there are many more columns to the right, which are not visible here)PayPal Transactions CSV file

 

CSV2QFX

How to import PayPal into Quicken with CSV2QFX

1. Download your PayPal transactions to a CSV file on your computer,

If you are not familiar with that, the procedure for doing so is at the end of this page. Give the file a name such as paypal.csv.

2. Install and run CSV2QFX

3. Select the Settings button.  This brings up a dialog window with Quicken information.

Quicken info dialog paypal

 

4. Select Lookup (to the right of the FID input box), and this will bring up the Quicken list of financial institutions.

5. Type payapl into the Search String box.  The only line remaining should be PayPal, so select that line.

6. Select OK twice to return to the main CSV2QFX screen. (You can leave the routing number blank; the account number is useful if you have more than one PayPal account and would be your PayPal login email.)

7, Select the File menu, then Open CSV File, and browse to the downloaded PayPal file, i.e.  paypal.csv,

8. Select the file, and then select Open.  This will run the CSV2QFX converter, and create a QFX file, in this example called paypal.qfx.

9. Run the Quicken program.

10. Select File, then from the pull-down menu select File Import, and then Web Connect File…

11. Browse to the QFX file just created (i.e. paypal.qfx) , select it, and select Open

OR you can combine steps 9-11 by using Windows Explorer, and simply double-clicking the QFX file.

Either method will bring up a Import Downloaded Transactions dialog:

Import QFX PayPal

12.  Select the correct option – to create a new account called PayPal, or to link to an existing account.

If creating a new account, the account type should be Savings, although it does not make much difference.

13. Select Import, and the PayPal transactions will be read.

14.  If your Quicken preference type for Downloaded Transactions is not set to Automatically add to registers  then the transactions imported from PayPal will be in a temporary register at the bottom of the screen.  In this case, select Accept All (at the lower right) to accept all the imported transactions.  Or select individual transaction to accept or delete.


Procedure to Create a PayPal CSV file

  1. Login into your PayPal account. Note that this procedure is written for the ‘new PayPal experience’ user interface on the PayPal web site, not the ‘classic’.
  2. Select Reports from the top menu bar
  3. Select Activity Download from the left menu, as seen below:

Download Payment CSV File

  1. Choose the Transaction type download type as either Balance affecting or Completed payments . Balance Affecting Payments will include refunds and disputed payments in addition to Completed Payments.
  2. Select Create Report on the right side. When the report is reading, save the file on your computer, for example as paypal download.csv.

In our example the downloaded .csv file looks like this when viewed in Excel (there are many more columns to the right, which are not visible here)PayPal Transactions CSV file

PayPal Split Transactions

Automatically create splits for PayPal transactions

This feature in only available in CSV2QIF. QFX format does not support the ability to create categories.

1. Open the paypal.csv file with Excel or a text editor.

2. Change any column headers that should be split to “Split<QuickenCategory>”.

For example, to automatically split PayPal transactions so that they contain Gross as an Income Category, and Fee as an Expense Category, edit the column header from Gross to Split<Sales (Business)> and from Fee to Split<Discounts (Business)>.

3. Run CSV2QIF and it will generate transactions that are imported as splits by Quicken.  Then follow the same procedure as above for CSV2QIF.

For more details see the CSV2QIF | help.


Fine-tuning PayPal field input

If you view the downloaded PayPal file in Excel, you can see that there are over 30 columns, some of which have pretty detailed information.  The default for both CSV2QIF and CSV2QFX is to use the Name column for the Quicken Payee, and the From Email Address as the Quicken Memo (This default is because Name is an alternative for Payee, and Address is an alternative for Memo).

If you wish to have some other fields used for the conversion, then edit the paypal.csv file to rename the headers so the that first Payee or Name column is what you want to import for the Payee and the first Memo or Address column is what you want to import into the Quicken Memo.

See the appendix in the appropriate converter help file for more details on the column headers and  fields.


Procedure to Download PayPal Transactions to a CSV file

1. Log into your PayPal account at www.paypal.com from your web browser.

2. Select “My Account” from the top menu.  This will bring up list of recent transactions.

3. Select “View all of my transactions” (this is just above the recent transactions, on the right hand side)

4. Select a date range for the transactions you want to import at the top of the screen.

PayPal has a limit of two years for a single download.  If you need more than two years you will have to do multiple downloads.  You can either combine them in Excel, or import them individually.

5. Select “Download CSV”, (which is above the transactions on the right hand side).

6. Your browser will open a popup window prompting you to save or open the file – save the file to a folder or your desktop and give it a useful name such as paypal.csv.

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