Convert PDF to OFX and import into Xero, QB Online, Sage One, YNAB, AccountEdge
Need to import bank or credit card transactions in a PDF file into Xero, Sage One or other OFX importing software or online service, but cannot seem to make it work? The problem is that your bank only provides transactions in a PDF format that Xero, Sage One or other OFX importing software or online service cannot read.
The Solution: try ProperConvert PDF2OFX app. It can convert your transactions into a format from PDF to OFX can import.
Convert PDF transaction files to the OFX format
- ProperConvert (PDF2OFX) extracts transactions from PDF files. It creates OFX files ready to import into Xero, Sage One or other OFX importing software or online service.
- No data entry: convert data you already have in bank or credit card transactions file format to the OFX format
- Smart: ProperConvert (PDF2OFX) understands many PDF layouts. It finds columns like date, amount, description, etc. of your transactions.
- Easy to use: Converting your banking transactions into OFX files could not be any easier. In a few clicks, you will have all your transactions converted to importable by Xero, Sage One or other OFX importing software or online service format in no time at all.
- Free trial and support: try it for Free before you buy and receive full support before and after you order.
- Safe to use: ProperConvert (PDF2OFX) converts all your banking transactions on your computer.
Convert PDF to OFX (how to use PDF2OFX)
This tutorial shows how to convert PDF bank or credit card statement files to OFX format and import into Quickbooks Online, Xero, Sage, MS Money, and other accounting software.
Use the ProperConvert app to convert PDF and OFX. Other formats are supported as well.
Step by step instructions for Windows
Follow these simple 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 them to the register.
See this Windows tutorial as a video:
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 ProperConvert 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 it.
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 them to the register.
See this macOS tutorial as a video: