ledgaroo

Bank statement PDF to OFX

Drop the PDF as you downloaded it. We check every row against the figures your bank printed, then write an OFX file your accounting software imports.

OFX comes with Premium. Excel and CSV are free for a whole statement at a time, with no account and no limit on how many. See what Premium costs.

Importing it into MYOB

Download the OFX

  1. In MYOB, go to the Banking menu and choose Banking hub.
  2. On the account, click the three dots, choose Import statement and pick the file.

In AccountRight on the desktop, go to Banking, then Reconcile Accounts, then Get Statement. The file has to be under 10MB. MYOB takes a QIF too, with its dates day first, but an OFX writes every date year first, so it cannot be misread, and it carries an id for each transaction and the currency, which a QIF cannot.

What is in the OFX file

OFX 1.02, the older of the two kinds.
OFX 2 is XML, and older importers reject it. The 1.02 form is the one accounting software has read for longest, so it is the one we write.
The currency and the period are written into the file.
The currency is read off the statement and shown on the OFX button. The period runs from the first transaction’s date to the last.
The closing balance goes in as the ledger balance.
Where the statement prints one. Software that compares its own balance with the file’s has the statement’s figure to compare with.
Every transaction has an id of its own.
It is built from the date, the row’s place in the statement and the amount, so the same statement converted twice gives the same ids.
The payee goes in the name field, and the description is kept whole.
The name is cut out of the description, or set by your rule, and the full description goes in the memo. OFX has no field for a category.
A credit card statement is written as one.
It goes in the credit card section of the file, with the balance owed as a negative figure.
Your account number is not in the file.
The account is written as "STATEMENT", and you choose the account when you import.

Every format holds the same checked transactions. The other files we write are on the import page.

Questions

Is my statement uploaded anywhere?

No. The statement is read in your browser, on your computer. Nothing in it is sent to us or to anyone else.

Should I pick OFX or QIF?

OFX, where your software takes it. It records the currency, the period, the closing balance and an id for each transaction. QIF records none of those.

Is this the file QuickBooks wants?

No. QuickBooks wants a QBO, which is an OFX file with a sign-on block added. We write both.

Does it handle scanned statements?

Yes, as a PDF, JPG, PNG or WebP. The text is read off the picture by OCR in your browser, and the file never leaves your computer. The first scan takes longer while the reader loads. OCR can misread a figure, so a scan is checked like any other statement. If it prints no running balance, no totals and no closing balance, nothing can check the figures, so the download is held as it is for a failed check, and you look the figures over first. A date misread within the statement period passes every check, so a date OCR was unsure of is marked for you to compare with the scan. A PDF downloaded from online banking is more reliable than a scan. More about scanned statements.

Is it free, and do I need an account?

Excel and CSV are free for a whole statement at a time, with no limit on how many. Premium adds every other format, a CSV in a layout of your own, payee names with rules that set the payee and category, the working paper, part of a statement, several statements joined into one, and downloading every open statement at once. Neither needs an account: Premium is a licence key, which you paste into the page or activate from the email it comes in, and your browser keeps it. The pricing page lists each format and the price.