Articles and updates on bank statement conversion, reconciliation and automation.
MT940 is the SWIFT end of day bank statement message. Here is what each tag holds, how to read tag 61 and tag 86, and how to turn one into a spreadsheet that reconciles.
Read articleQuicken can export a register report to Excel, but the layout is awkward for accounting work. Here are the three ways to get transactions out, what each one loses, and which produces a spreadsheet you can actually reconcile.
Read articleQuicken will not read a plain CSV of bank transactions. Here is what it does accept, how to turn a spreadsheet into a QFX file it imports cleanly, which columns matter, and how to fix the errors that stop an import.
Read articleExpress Web Connect, Direct Connect, and Web Connect are three different ways Quicken gets transactions from your bank. Here is how each one works, which is more reliable, what each costs, and what to do when your bank supports none of them.
Read articleGnuCash imports OFX natively and matches transactions by ID so re-imports do not duplicate. Here is the exact import path, how to use the Import Matcher, and why imports fail.
Read articleQuicken Web Connect failing or downloads not importing? Here are the five real causes, in order, and the dependable manual QFX workaround for when your bank has dropped Web Connect entirely.
Read articleOFX carries transaction IDs and a closing balance, so it will not duplicate on re-import. CSV is easier to edit. Here is which format to use for reconciliation, and when.
Read articleA QFX file is Quicken's branded version of the OFX format. Here is what is inside one, how QFX differs from OFX and QBO, and how to open, create, and fix QFX files for Quicken.
Read articleExcel cannot read OFX natively, and the usual XML import advice fails on OFX 1.x. Here is why, plus the reliable way to get an OFX into a clean spreadsheet.
Read articleQuicken rejecting your OFX or QFX file? Here are the common causes, from a plain OFX Quicken does not accept to a missing bank ID on a QFX, and the CSV route that works for converted statements.
Read articleGet started converting bank statements to OFX.
USD
per month
per month
$294 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion with bulk upload, custom templates and reports.
USD
per month
per month
$894 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
