Bank Statement PDF to Excel

Menu

More statement pages with Pro

  • 500 pages per month or 6,000 per year
  • Text PDFs, scans and photos
  • Running-balance checks and Excel / CSV exports
  • Convert up to 20 statements at once into one Excel file
  • One-time page packs never expire
Choose a plan

Secure checkout by Stripe. Your pages are tied to this email. See our Refund Policy.

PDF to OFX Converter for Bank Statements

Turn a bank statement PDF into an OFX file you can import into GnuCash, Xero, Moneydance or QuickBooks Online. Balances are checked row by row before you export.

  • 10 pages free every day. No account needed.
  • Original file and PDF password stay in your browser.
  • Closing balance in the OFX comes from reconciled rows.

Drop your bank statement here

Choose a bank statement

PDF, JPG or PNG · Up to 20 MB · Up to 50 pages

Your original file and PDF password stay in this browser. Only extracted text and scanned-page images are sent for conversion; statement content is not stored unless you actively submit a problem report (deleted after 30 days).

Text PDFScanned PDFPassword-lockedPhoto
10 free pages per day

Unlock your PDF locally

This password is used only in your browser and is never sent to the server.

How it works

How to convert PDF to OFX

  1. Upload the statement PDF

    Choose a text PDF, a scanned PDF or a photo, up to 20 MB and 50 pages. Password-protected PDFs are unlocked in your browser; the password is never uploaded.

  2. Review the reconciliation

    Each row's running balance is checked against the previous balance plus the transaction amount. Rows that do not reconcile, or that have no date or amount, are highlighted so you can compare them with the original.

  3. Download the OFX file

    Enter an account number or nickname (required): a different one for each bank account, the same one every month, so your accounting app keeps accounts apart. Then download the .ofx file and import it.

Balance-checked export

Why the balance check comes before the OFX export

A spreadsheet lets you fix a wrong row before anyone sees it. An OFX import does not: GnuCash, Xero and QuickBooks post every amount in the file straight into the account register, and a single misread digit carries forward into every later balance. That is why this converter reconciles the statement before it writes the file.

When all balances reconcile, the OFX download is ready immediately and its ledger balance (the LEDGERBAL field your accounting app compares against) is the statement's closing balance. When a row does not reconcile, or the statement prints no running balance to check, you first see which rows need checking and confirm that you have compared them with the original statement. Rows without a date or amount are left out of the file, and the tool tells you how many.

File details

What's inside the OFX file

OFX fieldWhat we write
VersionOFX 1.02 (SGML), the format GnuCash, Moneydance, Xero and Quicken for Mac read
STMTTRNOne record per transaction: TRNTYPE (CREDIT or DEBIT), DTPOSTED, TRNAMT with sign, NAME and MEMO
FITIDA stable ID built from date, amount and description, so re-importing the same text-PDF transactions is recognised as a duplicate
NAME / MEMONAME holds the first 32 characters of the description; MEMO keeps the full text and any reference number
CURDEFThe currency detected on the statement, or USD if none is printed
LEDGERBALThe closing balance after reconciliation, dated on the last transaction
BANKACCTFROMThe account number or nickname you enter (letters, digits and hyphens), so later imports map to the same account

Sample: a fictional US checking statement

This 3-page sample statement has 35 transactions from 2026-08-02 to 2026-08-31. Every balance reconciles, so the OFX file's LEDGERBAL is -$2,197.71. The first three transactions look like this:

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260802120000[0:GMT]
<TRNAMT>-748.92
<FITID>20260802--74892-1eb72442-1
<NAME>COSTCO WHSE #1109 CEDAR PARK TX
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260803120000[0:GMT]
<TRNAMT>-565.41
<FITID>20260803--56541-a4817f7a-1
<NAME>CHECK #1043
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260803120000[0:GMT]
<TRNAMT>2846.15
<FITID>20260803-284615-f9be4b8e-1
<NAME>IRS TREAS 310 TAX REF
</STMTTRN>

Download sample PDF (186.1 KB) · Download sample OFX (7.1 KB)

Import guide

Import the OFX file into your accounting software

SoftwareMenu pathWhat to expect
GnuCashFile → Import → Import OFX/QFX…Pick the GnuCash account the first time; GnuCash remembers it for later files with the same account ID. The import matcher flags transactions that already exist.
XeroAccounting → Bank accounts → Manage account → Import a statementBrowse to the .ofx file and click Import, then reconcile the statement lines against contacts and accounts.
MoneydanceFile → Import, or drag the file into the windowChoose the account to import into; tick "Remember this choice" to skip the question next time. Duplicate FITIDs are recognised.
QuickBooks OnlineBank transactions → Link account ▾ → Upload from fileChoose the .ofx file and the bank account. QuickBooks Online accepts files up to 350 KB and 1,000 transactions per upload.
Quicken for MacFile → Import → Bank or Brokerage File (OFX, QFX)Quicken may expect a .QFX file from a participating bank. If it rejects the OFX, use the CSV download and Quicken's CSV import instead.
Quicken for WindowsFile → File Import → Web Connect FileAccepts .QFX only, not plain OFX. Use the CSV download instead.

Tip: import one statement at a time and check the account balance in your app against the statement's closing balance before importing the next month.

When another format fits better

OFX is for accounting and personal finance software. If you want to sort, filter or total the transactions yourself, the bank statement PDF to Excel converter gives you an Excel workbook or a CSV file from the same conversion. Pages are counted once per conversion, so a converted statement can be downloaded in every format. Bookkeeping in TallyPrime? Use bank statement to Tally for voucher XML. See pricing for Pro page packs and batch conversion.

PDF to OFX FAQ

Is this PDF to OFX converter free?

Yes, you can convert 10 pages per day without an account, and the OFX download is included. Pro adds more pages and batch conversion of up to 20 statements at once.

Can I convert a scanned bank statement to OFX?

Yes. Scanned pages and photos go through image recognition before the balance check. Recognition errors are more likely on scans, so review highlighted rows before you export the OFX file.

Which OFX version do you create?

OFX 1.02 in SGML format, with a bank statement (STMTRS) for a checking account. Most personal finance and accounting tools that import OFX files read this version.

Will importing the same month twice create duplicates?

Each transaction has a stable FITID built from its date, amount and description. GnuCash, Moneydance and Quicken use FITIDs to recognise transactions they have already imported, so re-importing the same transactions from a text PDF is recognised. Scans can be read slightly differently each time, so check the import screen for possible duplicates.

Can I import the OFX file into QuickBooks?

QuickBooks Online can upload an OFX file: open Bank transactions, choose Link account ▾ → Upload from file and select the .ofx file. QuickBooks Desktop only imports .QBO Web Connect files, so use the CSV download there.

Why is the OFX download asking me to check rows first?

Some running balances did not reconcile, or a row is missing its date or amount. An OFX import posts every amount into your books, so the tool asks you to compare the highlighted rows with your statement before downloading.

Do you store my statement?

No. Original files and passwords stay in your browser. Only extracted text and scanned-page images are sent for conversion, and they are not saved. The OFX file is created in your browser.