Convert a PDF File to QBO format and import into Quickbooks Desktop

This tutorial shows you how to convert a PDF file with transactions to QBO (Web Connect format) and import it into QuickBooks Desktop. PDF statement files have transaction data you need to enter in Quickbooks and extracting this data should help you save time and data entry effort.

To begin, you will need to download and install the ProperConvert app from our website, Simply visit our website, click on the download button, and follow the installation instructions. Once the app is installed, you can start using it to convert your PDF files.

Converting the PDF File

In this tutorial, we have a PDF file containing transactions from Chase Bank from 2016. Our goal is to convert this file into QBO Web Connect format, which can be easily imported into QuickBooks Desktop.

First, open the Proper Convert app on your computer. Once the app is open, you will see a file selection screen. Locate and select the PDF file you want to convert.

Step 1: Open a PDF file in the ProperConvert app

Setting the QBO File Attributes

Now, we need to provide some additional information to ensure proper conversion. Set the Account ID and Account Type according to your requirements. In our case, we are converting transactions from a Chase Bank account, so we will select the appropriate values for Chase Bank.

Step 2: Set QBO file attributes

To find the correct bank label INTU.BID, enter "Chase" in the search field. Look for the value that contains "CH" and "CC" marks, as this indicates support for checking accounts and credit card accounts. Select this value to proceed with the conversion.

Step 3: Select INTU.BID value

If you prefer more control over the conversion process, you can uncheck the "Open After Save" option. This allows you to create the QBO file first and then manually import it into QuickBooks Desktop. If you want a more automated approach, leave this checkbox checked. The QBO file will be created and QuickBooks Desktop will be called automatically to import the file.

Step 4: Open after save option and the Convert button

Once you have made your selection, click on the "Convert" button to initiate the conversion process.

Importing the QBO File into QuickBooks Desktop

After the QBO file is created, open QuickBooks Desktop and navigate to "File Utilities" > "Import" > "Web Connect Files". Select the QBO file you just created.

Step 5: Import a QBO file in Quickbooks Desktop

Now, you have two options. You can either use an existing QuickBooks account or create a new one specifically for the imported transactions. For this tutorial, let's select "New Account" to create a separate account for the transactions.

Step 6: Import into a new account or select an existing account

There is should a message after the QBO file is successfully imported.

Step 7: Open a PDF file in the ProperConvert app

Once the import is complete, you will need to review the imported transactions. This involves matching vendor records, selecting expense and income accounts, and adding the transactions to the register. The process is similar to reviewing transactions downloaded directly from your bank.

Step 8: Open a PDF file in the ProperConvert app

By following these steps, you can convert a PDF file with transactions into QBO Web Connect format and import it into QuickBooks Desktop.

Related articles