StatementCSV

Convert a bank statement PDF to OFX

Some apps would rather take an OFX file than a CSV, and your bank may only give you a PDF for older months. StatementCSV reads a text-based statement PDF in your browser, lets you fix the rows, and writes an OFX 1.02 file from the table.

Steps

  1. Open the statement PDF in the StatementCSV app. It's read in your browser, not uploaded. The free preview shows how many transactions it finds and the first 5 rows, so you can see whether your PDF works before you pay.
  2. Unlock for $9.99 one-time. Download OFX and the export options are part of the paid export; the free preview doesn't include them.
  3. Check the rows and fix anything that looks off. You can edit or delete rows, and the OFX file is built from the table as you leave it. Type or check the opening and closing balances to see whether the rows add up to the statement.
  4. Under Export options, check three settings. Statement year is prefilled from the latest year printed in the PDF. Account is Bank account or Credit card. Flip signs is for statements that print charges as positive numbers. When the app spots a credit card statement (American Express, or text like "minimum payment due" or "credit limit"), it picks Credit card and ticks flip signs for you.
  5. Select Download OFX. The file has the PDF's name with .ofx on the end. The app tells you how many rows it exported and how many it left out.
  6. Import the file into your app (see below), then compare the imported total with the PDF before you reconcile.

What's in the file

Here's part of a file the converter writes for a checking statement that closes in 2026, with two rows (a Dec 30 coffee and a Jan 2 deposit) and a closing balance of 2,045.50:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
...
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20251230120000
<TRNAMT>-4.50
<FITID>SCSV1911ea7a
<NAME>Coffee Shop
<MEMO>Coffee Shop
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260102120000
<TRNAMT>1250.00
<FITID>SCSVe31e51e8
<NAME>Payroll deposit
<MEMO>Payroll deposit
</STMTTRN>
...
<LEDGERBAL>
<BALAMT>2045.50
<DTASOF>20260102
</LEDGERBAL>

Importing it

Limits

Sources

Preview your statement freeUnlock on Whop, $9.99 once