Convert a PDF file to QBO format and import into Quickbooks (PDF2QBO)
Access ProperSoft at https://www.propersoft.net/
Use ProperSoft PDF2QBO to convert PDF to QBO (Web Connect) format and import into Quickbooks (Windows/Mac/Online).
00:00 - Start PDF2QBO and read the welcome message
00:45 - Select a file with transactions
01:06 - How does the PDF file look like?
01:20 - Examine the transactions
02:36 - 'Pages' option
02:47 - 'PDF Password' option
03:05 - 'Input Dates' option
03:15 - 'OCR' option
03:44 - 'Resolution' option
04:32 - Click the 'Apply' button
04:41 - The bottom part: 'Change +/- for all', 'Set year', 'Use post date' options
05:16 - The central part: 'Check', 'Uncheck' transactions
05:51 - How to adjust the year?
06:21 - How to edit the transactions?
06:59 - The Renamings Tab
07:44 - The right panel
08:07 - Set the Account ID
08:30 - Set the Account Type
08:46 - Set the Currency
08:59 - Set Bank ID and Branch ID
09:14 - Set the Bank INTU.BID
09:57 - Set the Balance
10:02 - Advance settings
10:11 - 'Open after save' setting
11:26 - Convert to QBO file
11:52 - The conclusion and about other tutorials
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. 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.
When you start a PDF2QBO converter it offers you to select a PDF file. We will select a sample-bank-statement.pdf file. Once the PDF file is loaded, examine the transactions.
Let's look first at the bar on the top. The Parse allows you to specify the 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 it 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.
And you can specify how dates look like in your PDF file. Usually, it's not required, but you can specify it.
If you have a scan or image page file, you can click the OCR checkbox, which means optical character recognition.
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 if you change any of these settings - click the 'Apply' button to restart the parsing process.
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'.
The central part - you can uncheck or deselect any transaction, increase year or decrease year for those specific transactions only, you can edit any of those transactions, you can adjust Amount, Date. And you may also enter any other details you would like to enter.
And if you need to rename certain names - use the Renaming Tab - 'Name' and 'New name'.
Each QBO file has several properties, that you can set on the right 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.
The Currency must be US dollars for QuickBooks US Edition.
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 the allowed value, you can click the 'Lookup' button and locate your bank.
You can set a Balance if you need to. In this case, this tutorial focuses on just using PDF2QBO, so, we will not click the 'Open after save' checkbox.
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.
This tutorial was about opening a PDF file, setting options, and creating a QBO file. Look for other tutorials, that show how to import a QBO file in QuickBooks in the description to this video.