Bank Statement CSV to OFX/QBO Converter

The Problem

Your bank only exports CSV, but your accounting software (QuickBooks, Xero, etc.) wants OFX or QBO — manually recreating transactions isn't realistic for more than a handful of rows.

About this problem

OFX and QBO are strict formats. Each transaction needs a unique identifier, dates in a specific format and amounts with the correct sign, and QBO adds institution details that accounting software checks. Bank CSV exports differ widely in column layout, date format and the way debits and credits are shown, so a converter has to be written for each bank.

People usually come to this when their bank does not offer a format their accounting software can import, and typing in transactions by hand is slow and prone to error.

What's Included

• A script built around your specific bank's CSV export format
• Correct mapping of dates, amounts, descriptions and transaction types to OFX/QBO fields
• Validation that the output file imports cleanly into your accounting software
• A short usage note for converting future statements yourself

What's NOT Included

• Reconciling the imported transactions within your accounting software
• Converting from scanned/PDF statements (CSV export required as the source)
• Ongoing monthly conversion unless set up as a standing tool

How It Works

1. I examine a sample export from your bank to learn its columns, date format and how debits and credits are represented.
2. I write a script that parses the CSV and normalises dates, amounts and descriptions.
3. I map each row to OFX or QBO transaction fields and generate a stable unique ID per transaction.
4. I produce the file with the header and account details your accounting software expects.
5. I test importing the result into your software and check the totals match the statement.
6. I provide a usage note for converting future statements.

In practice: you buy the service, send over whatever access or details the job needs, I investigate and do the work, and you confirm it's resolved before we call it done.

Frequently Asked Questions

How do I import bank CSV into QuickBooks or Xero?

Convert the CSV to OFX or QBO first, which is what this script does for your bank's format.

Does it work for any bank?

It is built for the CSV layout from your specific bank. Other banks would need their own mapping.

Will duplicate transactions be avoided?

Each transaction gets a stable ID so that repeated imports are less likely to duplicate, though your software's own matching rules also apply.

Can it convert PDF statements?

No. A CSV export is required.

Do you reconcile the transactions?

No. Reconciling in your accounting software is not included.

Will it run monthly by itself?

Only if set up as a standing tool, which is separate.