I'm building a small tool that converts bank CSV files into .qbo files for QuickBooks (qbofile.com)....
I'm building a small tool that converts bank CSV files into .qbo files for QuickBooks (qbofile.com). When a generated file is wrong, QuickBooks rejects it with vague errors and the OFX spec doesn't tell you what QuickBooks actually checks. So I ran some experiments. Notes below, in case someone else hits the same wall.
The file is not XML
.qbo is Intuit's version of OFX 1.0.2, which is SGML. Leaf tags have no closing tag:
<TRNAMT>-42.50
<FITID>8f3a2b...
Every importer has one moment where it tells you it is done. Here is that moment, at the end of a...
If you've ever tried converting a bank statement PDF to CSV and ended up with a jumbled mess of...
Every time I get an invoice or a broker deposit instruction, I do the same dumb, error-prone thing:...
Find exact CSV cells that spreadsheets may reinterpret before import, with source provenance and explicit import guidance.
Building invoicing into your app sounds straightforward—until you open the QuickBooks API...
If you have ever built an application or pipeline that accepts CSV uploads, you have probably run...
