Convert PDF to QBO and upload into Quickbooks




Access ProperSoft at
ProperSoft PDF2QBO converts PDF to QBO. PDF statement is downloaded from your bank or credit card company and converted to QBO (Web Connect) format that QuickBooks for desktop (PC or Mac) or Quickbooks online imports.

00:00 – A sample PDF file
00:35 – Download and start PDF2QBO, select a file with transactions
00:45 – Review the transactions before converting
01:01 – Convert to QBO file
01:09 – Switch to Quickbooks and import a QBO file
01:29 – Select the account to import data into
01:44 – Bank Feed Center
02:02 – Review and assign Vendor Records to transactions
02:14 – ‘Downloaded as’ column
02:19 – ‘Payee’ and ‘Account’ columns
02:34 – Add transactions to register

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 it, 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….(read more)


Convert Word 2 PDF: Word to PDF Converter

Convert PowerPoint 2 PDF: PPT to PDF Converter

Convert Excel 2 PDF: Excel to PDF Converter

Convert an Image 2 PDF: Image to PDF Converter

Convert HTML 2 PDF: HTML to PDF Converter

More Tools: PDF Converter