How to use PDF2QBO converter - ProperSoft

How to use PDF2QBO converter

This tutorial shows how to use a PDF2QBO converter.

The tutorial starts from the point, that the PDF2QBO converter is already installed on your computer. And this tutorial is good for both - macOS and Windows versions. This video is done, using the Windows version. When you start a PDF2QBO converter for the first time, you will see the welcome screen - please read it - it shows some important details about the conversion process.

PDF2QBO Step 1: Welcome Screen

When you start a PDF2QBO converter it offers you to select a PDF file. We will select a sample-bank-statement.pdf file.

PDF2QBO Step 2: Select a pdf file

These are the parsing transactions from the PDF file.

PDF2QBO Step 3: Parsing transactions from the pdf file

And this is like the PDF file looks like. This is the bank statement. It has the Deposits.

PDF2QBO Step 4: How a pdf file looks like - bank statement

It has the Checks.

PDF2QBO Step 5: How a pdf file looks like - checks

And it has the Withdrawals.

PDF2QBO Step 6: How a pdf file looks like - withdrawals

Once the PDF file is loaded, examine the transactions: check the dates are correct: year, month, the day on the dates are correct. Sometimes some dates could be confusing.

PDF2QBO Step 7: Examine the transactions

In this case, we show dates as month/day/year. It is all July's statement for 2016.

PDF2QBO Step 8: Date Format - Month, Day, Year

Make sure, that Deposits are positive, Withdrawals are negative. It is for bank or credit card statements, expenses always must be negative and payments to the account must be positive. This part of the converter is about working with the statement, parsing the statement, parsing the statement.

PDF2QBO Step 9: Deposits

This part is about converting to the output file, output file settings. Here you are creating a QBO file, creating a CSV file.

PDF2QBO Step 10: Output file settings

So let's look first at the bar on the top. What does it mean? The Parse allows you to specify page range. If you want to convert only specific pages you can specify it here from one page to another page. If the PDF file has the password, you can enter here, let's say to use it for several statements. And the Parser will ask the password if there is any password for the first time.

PDF2QBO Step 11: Pages

And you can specify how dates look like in your PDF file. Usually, it's not required, but you can specify it.

PDF2QBO Step 12: Dates

If you have a scan or image page file, you can click the OCR checkbox, which means optical character recognition. So, some PDF files do not have text in them or may be created in a specific way, that the Parser cannot parse them correctly. So, the OCR is a good option to use in such situations.

PDF2QBO Step 13: OCR

And the next option is Resolution. So when it does OCR it needs to render the image of your PDF file and you can select the Resolution for this image. And it is important for certain forms, for certain text, how the text looks, how it composed on your PDF file. The resolution is important in the OCR process. Some PDF files are better parsed with 300 dpi, some better parsed with lower Resolution, like 150. Once you start working with your PDF files you will see quickly which resolution works better for you.

PDF2QBO Step 14: Resolution

And if you change any of these settings - click the 'Apply' button to restart the parsing process.

PDF2QBO Step 15: Apply

The bottom part of this form is for quickly changing some transaction properties. So, let's say if you see that those are Withdrawals, but the Parser shows them as Deposit, you can quickly adjust it. And if you want to adjust the year - you can quickly adjust for all transactions. If it's present on a PDF file, you can do this with this checkbox 'Use Post date'.

PDF2QBO Step 16: Use Post date

And now let's discuss this central part. You can uncheck or deselect any transaction. You can select a group of transactions - click the first one, hold shift and click the last one and then right-click. You can do several things: we can 'Check', 'Uncheck', 'Change +/-', 'Add payee(s) to payee mapping', increase year or decrease year for those specific transactions only. Sometimes if you have a statement over year, coming and starting December and ending in January, the Parser usually should pick up the year correctly for both parts before the year and after year. And if it doesn't, you can quickly adjust it, select transactions for the previous year for December you will see the December dates and then January dates, then select them and click right-click and click 'Year -' to adjust year quicker.

PDF2QBO Step 17: Central part, select

You can edit any of those transactions, you can change, you can adjust Amount, you can adjust Date, you can change the Amount to become Deposit instead of Withdrawal or Withdrawal instead of Deposit. And you may also enter any other details you would like to enter.

PDF2QBO Step 18: Edit any transaction

And if you need to rename certain names, let's say, clean up or do some other changes, let's say, you have Shell 1,2,3 or Shell corporation, something like that, where too many names in QuickBooks, then you can do that, using the renaming Tab - 'Name' and 'New name' - you can specify here, you can have several lines added and once you enter the first line, the second line will appear and so on. Now we finished with working with our actual transactions and we are ready to create a QBO file.

PDF2QBO Step 19: New Name

Each QBO file has several properties, that you can set on this part of the screen. The first one is Account ID, which is important to set and must be digits only. Account ID must be different for different accounts. Let's say if you have few statements for one account, you converting them, make sure to use the same Account ID, once you switch to another account, make sure to change the Account ID.

PDF2QBO Step 20: Account ID

Then you have the Account Type and in this case, is Checking account. You can set CreditCard, let's say if you're working with a bank account and then you switch into CreditCard, make sure to change the Account ID, as well.

PDF2QBO Step 21: Account Type

The Currency must be US dollars for QuickBooks US Edition. If your accounting software allows to import QBO files and allows different currency, then you can set the Currency here.

PDF2QBO Step 22: Currency

Bank ID and Branch ID - you can set them as well, QuickBooks does not show them and the Parser will use some good default values. Bank INTU.BID value - it has to be from the allowed bank for the Account Type you convert. It is important to set allowed value, you can click the 'Lookup' button and locate your bank. And if your bank is Capital One, for example, which has several INTU.BID values. 'Capital One Comm Card Connect' (number 54696) is good for CreditCard and 'Capital One Intellix Services' (number 15496) is good for Checking account. So, make sure, that the value/number you choose is allowed number for QuickBooks.

PDF2QBO Step 23: Lookup

You can set Balance if you need to. 'Deterministic references', 'Allow non-numeric checks', 'Allow empty name' settings are not going in this tutorial. They are Advanced Settings and usually included for specific advanced cases. And the last thing to pay attention to is the 'Open after save'. So, what happens, if you click it and then click the 'Convert': the QBO file will be created and the QBO file will be passed to the application that is responsible for the QBO files on your computer. And if you have QuickBooks installed on your computer the application responsible for QBO files will be Quickbooks, so, in this case, the Parser will create a QBO file and we'll start QuickBooks and will ask it to load a QBO file. Some users prefer this a streamlined workflow, that you open a PDF file in converter, then you click 'Open after save', then you click 'Convert', and then QBO file is created, and QuickBooks started right away, and QuickBooks loading that QBO file right away without asking any questions. In this case, this tutorial focuses on just using PDF2QBO, so, we will not click that checkbox.

PDF2QBO Step 24: Open after Save

And, finally, to create a QBO file, make sure, to click the 'Convert' button. You will be asked to confirm the file name and the file location, you can change either of those and then you click 'Save' to create a QBO file. And if you have already some QBO file with the same name created, you have to confirm that you want to resave.

PDF2QBO Step 25: Confirm

This tutorial was about opening a PDF file, setting options, and creating a QBO file.

PDF2QBO Step 26: Done

Related articles