Bank statement PDF to OFX
OFX is the bank-feed file format most accounting and money software imports without any column mapping. Brought Forward writes OFX 1.0.2 (the version everything accepts) in GBP, with your sort code and account number from the statement and a stable ID for every transaction.
What’s in the file
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20261026090000
<LANGUAGE>ENG
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>1
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<STMTRS>
<CURDEF>GBP
<BANKACCTFROM>
<BANKID>000000
<ACCTID>00000000
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>20260301
<DTEND>20260331
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260302
<TRNAMT>-82.47
<FITID>20260302D8247N1
<NAME>NORTHGATE ENERGY
<MEMO>DD NORTHGATE ENERGY
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260303
<TRNAMT>1777.79
<FITID>20260303C177779N1
<NAME>FENWICK DESIGN LTD INVOICE 1093
<MEMO>CR FENWICK DESIGN LTD INVOICE 1093
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260304
<TRNAMT>-3.85
<FITID>20260304D385N1
<NAME>HARBOUR COFFEE CO- Each transaction’s ID is built from its date, amount and position that day, so exporting the same statement twice gives the same IDs and software can skip duplicates.
- The closing balance goes in as the ledger balance, for software that checks it.
- Text is plain ASCII, as OFX 1.0.2 requires: “£” becomes “GBP”.
Last checked 26 October 2026.