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, propersoft.net. 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.

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.

• Account ID (actual account number or any other number)
• Account Type (Checking or credit card the most common)
• File Type (Quickbooks US)
• INTU.BID value

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.

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.

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.

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.

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

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.

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

• Convert QFX to QBO and import into Quickbooks
• Import a QFX file into Quickbooks Online
• How to import a QBO file under an existing account in QuickBooks
• Convert to Quickbooks compatible formats (QBO, IIF, QBJ)
• Import a QBO file into Quickbooks Desktop for Mac
• Download bank transactions into QuickBooks
• What do Quickbooks import errors mean and how to fix them