Skip to content
Toolspike

PDF bank statement to OFX

OFX, Open Financial Exchange, is the file format banks use to send transactions to accounting software. Most programs that import bank data accept it, so a statement converted to OFX can go into Xero, Zoho Books, GnuCash and many more without mapping any columns.

No sign-up to read and check a statement, and 5 pages a day download free with a free account. A PDF with text is read in your browser and not uploaded; scans and photos go to AI only if you choose.

5 statement pages free every day with a free account, and every row and the balance check to see first. A Statement Pass covers bigger jobs, paid once.

  • Stays on your deviceA PDF with text is read in this browser and never uploaded. A scan is sent to our AI provider only if you choose.
  • Checked against the balanceEvery row has to land on the running balance the bank printed, so a misread figure shows up before it reaches your books.
  • Nothing keptNo statement or download is stored on our servers, and a password only opens the file.

See it before you upload

From PDF lines to rows your books accept

The first rows of the made-up sample statement, as printed and as you download them. Press “Try a sample statement” above to open all of it.

What the statement prints

  1. 08/01POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA5.45Withdrawals
  2. 08/02CHECK 10451,200.00Withdrawals
  3. 08/03ACH DEPOSIT NORTHWIND LLC PAYROLL2,500.00Deposits
  4. 08/05WIRELESS BILL AUTOPAY89.99Withdrawals
  5. 08/08POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA6.10Withdrawals

What you download

  1. Blue Door Coffee SeattleRestaurants and takeaway−$5.45Aug 1
  2. Check 1045Uncategorized−$1,200.00Aug 2
  3. Northwind LLC PayrollPayroll and wages+$2,500.00Aug 3
  4. Wireless Bill AutopayPhone and internet−$89.99Aug 5
  5. Blue Door Coffee SeattleRestaurants and takeaway−$6.10Aug 8

Reconciled: every running balance matches

Opens in the software you use

  • QuickBooks OnlineQBO or CSV
  • QuickBooks DesktopQBO or IIF
  • XeroOFX or CSV
  • QuickenQFX
  • SageCSV
  • WaveCSV
  • FreeAgentCSV
  • MYOBOFX or QIF
  • Zoho BooksCSV, OFX or QIF
  • GnuCashOFX or QIF
  • Excel and Google SheetsXLSX or CSV
  • TallyXML

Product names belong to their owners; Toolspike is not connected with them. Each file is one that program’s own import reads.

Insights on every statement

Average daily balance
$7,103.26
Biggest spending category
Rent and mortgage, $2,000.00
Recurring payment found
Blue Door Coffee Seattle, weekly, about $5.45
Returned, NSF or overdraft rows
1

Figures from the made-up sample. Your own statements get the same panel, and the full lists in the Insights sheet of the Excel download.

Programs that import OFX

  • Xero: Manage account, then Import a statement
  • Zoho Books: Banking, then Import Statement
  • GnuCash: File, Import, Import OFX/QFX
  • Moneydance: File, Import
  • QuickBooks and Quicken: use the QBO or QFX download instead

Why OFX 1.0.2

Version 1.0.2 is the older, SGML-based form of OFX, and it is the one importers have supported the longest. The file carries each transaction with a type, date, amount, name, memo and a stable ID, along with the account details and the closing balance.

Bank ID and account type

Some programs use the bank routing number and the account number to decide which account an OFX file belongs to. Enter your routing number if you have one, and choose checking, savings, money market or line of credit to match the account.

Questions

What is the difference between OFX, QFX and QBO?

All three share the same structure. QFX and QBO add a few Intuit tags that Quicken and QuickBooks look for, such as a bank ID. For any program other than Quicken or QuickBooks, plain OFX is the one to choose.

How are long descriptions handled?

OFX gives the payee name only 32 characters, so the name holds the start of the description and the full text, with the reference, goes into the memo field that most programs show alongside it.

Are accented letters and the rupee sign kept?

OFX 1.0.2 files are plain ASCII, so accents are dropped and the rupee sign is written as INR. Amounts and dates are unaffected, and the Excel download keeps the original characters if you need them.

Can I merge several months into one OFX file?

Yes. Add up to 12 statements and one OFX file is made with every transaction, oldest first, and duplicates from overlapping statements removed. The period in the file runs from the first statement to the last.