LedgermereHow-to guides for bank files and accounting imports
Practical answers to the questions bookkeepers search for most – with the free manual method first, the limits of each program, and where a converter actually helps.
CSV into QuickBooks DesktopQuickBooks Desktop cannot read a bank CSV directly. Here are the three ways that work – Web Connect (.QBO), IIF and manual entry – with steps and pitfalls.What is a QBO file?A .qbo file is a QuickBooks Web Connect bank download (OFX inside). How to open it without QuickBooks, view it in Excel or CSV, and how it differs from .QBW.QuickBooks Online CSV formatThe exact CSV layout QuickBooks Online accepts for bank uploads (3 or 4 columns), the 350 KB / 1,000-line limits, and fixes for the most common upload errors.Import CSV into QuickenQuicken for Windows imports bank CSVs only in a strict 7-column layout and doesn't de-duplicate them. The exact format, the steps, and the QFX alternative.QFX won't import into QuickenWhy Quicken refuses a QFX (Web Connect) file – unsupported bank ID, malformed dates, wrong account type, duplicates – and how to fix each one.QIF vs QFX vs OFX vs QBOThe differences between QIF, QFX, OFX and QBO bank files, which program accepts which, and how to convert QIF to QFX, OFX to QIF or QFX to QBO.IIF file format (QuickBooks Desktop)How an IIF file for QuickBooks Desktop bank transactions is built (TRNS/SPL/ENDTRNS), a working example, how to import it and how to fix common IIF errors.Xero bank statement CSV importHow to format a CSV bank statement for Xero (Date, Amount, Payee, Description, Reference), date formats, size limits and fixes for common errors.BAI2 format explainedPlain-English guide to the BAI2 bank file format: record types 01–99, common type codes, amounts in cents, an example, and how to read or convert a file.camt.053 vs MT940How ISO 20022 camt.053 differs from SWIFT MT940 (XML vs text, richer data, camt.052/054), what the migration means, and how to read or convert either file.ProperConvert / Bank2QBO alternativeHonest comparison of ProperConvert (now including Bank2QBO and CSV2QBO) and Ledgermere: price, install, formats, privacy, and when each is the better choice.
Converter pages
PDF to QBO / OFXCSV to QBOExcel to QBOExcel / CSV to IIFQFX / OFX to QBOOFX / QIF to CSV or ExcelMT940 to Excelcamt.053 to ExcelBAI2 file viewer
Try it with your own file. Ledgermere converts PDF/CSV/Excel statements, OFX/QFX/QBO, QIF, MT940, camt.053, BAI2 and Norma 43 to QBO, QFX, IIF, QuickBooks Online CSV, Xero CSV, OFX, QIF, CSV or Excel – in your browser, nothing is uploaded. The free version exports the first 20 transactions so you can test the import first; a 30-day pass is $9, lifetime $29.
Sources and product names: QuickBooks and Quicken are trademarks of Intuit Inc. or Quicken Inc.; Xero is a trademark of Xero Limited. Ledgermere is independent and not affiliated with them.