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.
It has some details about the Account and the most important part is transactions. There are Date, Description, Withdrawals, Deposits for each transaction.
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.
Click the 'Convert' to create a QBO file.
Then switch to Quickbooks and click 'File' - 'Utilities' - 'Import' - 'Web Connect Files', select saved QBO file and click 'Open'.
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.
Data is successfully imported. Click 'OK'.
Quickbooks open the Bank Feeds Centre for us. It's available to 'Banking' - 'Bank Feeds' - 'Bank Feeds Cente'.
Click on the '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).
Then we select 'Add/Approve' to register once this selected.