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

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 PDF2OFX utility.

Step by step instructions for Windows

See below steps 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.

PDF2OFX Windows Step 1: 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.

PDF2OFX Windows Step 2: review transactions before converting

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.

PDF2OFX Windows Step 3: Target

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.

PDF2OFX Windows Step 4: Account ID, Account Type

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.

PDF2OFX Windows Step 5: currency

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

PDF2OFX Windows Step 6: click Convert

Confirm the file name and location.

PDF2OFX Windows Step 7: file name and location, save

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 the 'Banking' and click on it.

PDF2OFX Windows Step 8: Banking in Quickbooks

And then select the account you want to import your data into.

PDF2OFX Windows Step 9: select account in Quickbooks

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.

PDF2OFX Windows Step 10: File Upload in Quickbooks

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

PDF2OFX Windows Step 11: click browse in Quickbooks

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

PDF2OFX Windows Step 12: select an account in Quickbooks

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

PDF2OFX Windows Step 13: data is imported in Quickbooks

Step by step instructions for macOS

Make sure you are using the latest version of PDF2OFX. Download it from the PDF2OFX download page. Start PDF2OFX and select a PDF file.

PDF2OFX Mac Step 1: 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.

PDF2OFX Mac Step 2: review transactions before converting

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.

PDF2OFX Mac Step 3: Account ID and Account Type

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

PDF2OFX Mac Step 4: currency

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.

PDF2OFX Mac Step 5: OFX Target

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

PDF2OFX Mac Step 6: click Convert

Confirm the file name and location.

PDF2OFX Mac Step 7: confirm 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 the 'Banking' and click on it.

PDF2OFX Mac Step 8: Banking in Quickbooks

And then select the account you want to import your data into.

PDF2OFX Mac Step 9: select an account in Quickbooks

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.

PDF2OFX Mac Step 10: File Upload in Quickbooks

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

PDF2OFX Mac Step 11: click Browse in Quickbooks

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

PDF2OFX Mac Step 12: select an account in Quickbooks

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

PDF2OFX Mac Step 13: transactions are imported in Quickbooks

Related articles