Convert PDF to QBO and upload into Quickbooks - ProperSoft

Convert PDF to QBO and upload into Quickbooks

This tutorial shows how to convert PDF file from your Bank or Credit Card Company to QBO format and import into Quickbooks. We will use PDF2QBO utility.

In this example, we will use a sample.pdf file from the Royal Bank of Canada.

Convert PDF to QBO and upload into Quickbooks Step 1: sample pdf file

It has some details about the Account and the most important part is transactions. There are Date, Description, Withdrawals, Deposits for each transaction.

Convert PDF to QBO and upload into Quickbooks Step 2: sample pdf file, details

We will use PDF2QBO to parse this PDF file. And PDF2QBO loads the PDF file, parses and shows the Date, Amount of transactions, Deposit, Withdrawal, transactions Memo and Cheque # from Memo, if available.

Convert PDF to QBO and upload into Quickbooks Step 3: review pdf2qbo

Click the 'Convert' to create a QBO file.

Convert PDF to QBO and upload into Quickbooks Step 4: convert

Then switch to Quickbooks and click 'File' - 'Utilities' - 'Import' - 'Web Connect Files', select saved QBO file and click 'Open'.

Convert PDF to QBO and upload into Quickbooks Step 5: file, import

Quickbooks offers us to 'Use an existing account' or 'Create a new account'. For this case, we select - 'Create a new account', click the 'Continue' button.

Convert PDF to QBO and upload into Quickbooks Step 6: create new account

Data is successfully imported. Click 'OK'.

Convert PDF to QBO and upload into Quickbooks Step 7: data imported

Quickbooks open the Bank Feeds Centre for us. It's available to 'Banking' - 'Bank Feeds' - 'Bank Feeds Cente'.

Convert PDF to QBO and upload into Quickbooks Step 8: bank feeds

Click on the 'Transaction List'.

Convert PDF to QBO and upload into Quickbooks Step 9: transaction list

Here we can review transactions, that were imported, match Vendor records and assign accounts. Payee or Description, shown as 'Downloaded As'. Now we can select Payee or Vendor records you have in Quickbooks, and Account (expense or income account).

Convert PDF to QBO and upload into Quickbooks Step 10: review after import

Then we select 'Add/Approve' to register once this selected.

Convert PDF to QBO and upload into Quickbooks Step 11: add to register

Related articles