PDF2OFX: Convert PDF to OFX

Easy to use secure solution to review/convert your transactions and import into your accounting software. Convert PDF to OFX and import into Xero, QB Online, Xero, QB Online, Sage One, YNAB, AccountEdge, Banktivity, Ace Money



What can I do with PDF2OFX (PDF to OFX Converter)?

Why should I trust PDF2OFX?

If I need any help with conversion, can you help me?

Can I try before purchasing?

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 a 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 Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set.

PDF2OFX Windows Step 5: currency

Click '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 'Browse' button and select 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 a 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

Before converting the QBO file make sure that you 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 '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 'Browse' button and select 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