Convert PDF bank or credit card statement files to OFX format and import into Quickbooks Online, Xero, Sage, MS Money, and other accounting software

This tutorial shows how to convert a PDF file from your bank or credit card statement to OFX format and import into Quickbooks Online. We will use the PDF2OFX utility. IMPORTANT: PDF2OFX is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Step by step instructions for Windows

Follow the steps below for the Windows version, followed by the Mac version.

Make sure you are using the latest version of PDF2OFX. Download it from the PDF2OFX download page. Start PDF2OFX and select a PDF file. Review transactions before converting. Check that dates are correct, have the correct year (Date), amount, withdrawals and deposits are shown in corresponding columns, check number (Doc/Check#) is assigned. 

Set the OFX target to match your accounting software. You can select "Regular OFX" as a default setting or you can select a specific list, like Quickbooks Online.  Choose the OFX Target: Regular OFX, Quickbooks Online, YNAB, iBank, Ariett, Microsoft Money 99, GoDaddy Outright, PeachTree, Dominio Contabil, Xero. 

Set the Account ID (number) and the Account Type. Account ID must be all digits for Quickbooks. For multiple accounts, use a different Account ID for each account. 

Currency should be USD even for non-USD accounts for Quickbooks US edition. For the Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set. 

Click the 'Convert' button to create an OFX file.  

Confirm the file name and location. 

Import created OFX file into Quickbooks Online 

Now the OFX file is created, let's switch to Quickbooks Online and import created OFX file. Look for 'Banking' and click on it.And then select the account you want to import your data into. 

Click the 'File Upload' button. In your accounting software, look for 'Import a statement', 'Upload a bank file' or similar links to upload created OFX file. 

Then click the 'Browse' button and select the created OFX file. And click 'Next'. 

Then select an account in Quickbooks to import and click 'Next'. 

Once the transactions are imported, you can review, categorize them under the account and add to the register. 

Step by step instructions for macOS

Make sure you are using the latest version of PDF2OFX. Download it from the PDF2OFX download page. IMPORTANT: PDF2OFX is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Start PDF2OFX and select a PDF file. Review transactions before converting. Check that dates are correct, have the correct year (Date), amount, withdrawals, and deposits are shown in corresponding columns, check number (Doc/Check#) is assigned. 

Set the Account ID (number) and the Account Type. Account ID must be all digits for Quickbooks. For multiple accounts, use a different Account ID for each account. 

Make sure to set Currency. And you can set Bank ID, Branch ID if your accounting software requires. 

Set the OFX target to match your accounting software. You can select "Regular OFX" as a default setting or you can select a specific list, like Quickbooks Online.  Choose the OFX Target: Regular OFX, Quickbooks Online, YNAB, iBank, Ariett, Microsoft Money 99, GoDaddy Outright, PeachTree, Dominio Contabil, Xero. 

Click the 'Convert' button to create an OFX file. 

Confirm the file name and location. 

Import created OFX file into Quickbooks Online

Now the OFX file is created, let's switch to Quickbooks Online and import created OFX file. Look for 'Banking' and click on it.And then select the account you want to import your data into. 

Click the 'File Upload' button. In your accounting software, look for 'Import a statement', 'Upload a bank file', or similar links to upload created OFX file. 

Then click the 'Browse' button and select the created OFX file. And click 'Next'. 

Then select an account in Quickbooks to import and click 'Next'. 

Once the transactions are imported, you can review, categorize them under the account and add to the register.