New in the kilnbank → csvstl → gcodemp3 → midipsd → pngpdf → csva/b significance
Bank Statement to QBO Converter
Convert a bank statement PDF to a QuickBooks .qbo (Web Connect) file — plus .qfx for Quicken and plain .ofx — entirely in your browser. Your statement never leaves your machine.
Private by construction. Your file is opened with JavaScript inside this page. It is never transmitted, and the tool keeps working with the network unplugged.
Every bookkeeper hits the same wall: a bank feed reaches back ninety days, and the cleanup job on the desk is from last year. The transactions exist — as PDF statements — and QuickBooks' native way in is a .qbo Web Connect file, the format it treats as "a download from your bank." The usual converters will make you one, after you upload a client's bank statement to their server. This tool won't, because it can't: the statement is parsed by JavaScript inside this page, and the .qbo you download is assembled in your own browser's memory. Load the page, go offline, convert — it still works, and "your client's statement never touched a server" is a sentence you can say to the client.
The parser is the same one behind our bank statement to CSV tool: it finds rows that begin with a date and carry an amount, joins wrapped description lines, reads debit/credit/balance columns from the statement's own headers, and shows every parsed transaction in a table before you download anything. The writer then does the format's paperwork for you — full dates from year-less statements (December→January rollovers handled), deterministic FITID fingerprints so a double import can't duplicate, DEBIT/CREDIT typing from the sign, and a bank label QuickBooks will accept without the dreaded "unable to verify financial institution" error. Quicken users: the QFX button is the same file wearing Quicken's badge.
Questions this tool gets asked
How do I import the .qbo file into QuickBooks?
QuickBooks Desktop: File → Utilities → Import → Web Connect Files, choose the .qbo, pick the account it belongs to, Continue. QuickBooks Online: Transactions → Bank transactions → Upload from file. Either way the transactions land in the bank-feed review queue, ready to categorize and match.
Why does QuickBooks show a different bank name during import?
A .qbo file carries a bank label called INTU.BID, and QuickBooks checks it against a directory of enrolled banks. The label is cosmetic: you choose the real account during import, and the transactions go there. This tool defaults to a label every QuickBooks accepts; if seeing your own bank's name matters to you, pick it in the bank-label option or enter its number.
Is my bank statement uploaded to convert it?
No - the statement is never uploaded, full stop. Parsing runs in your browser tab using Mozilla's open-source pdf.js, and the .qbo file is assembled in your tab's memory. There is no upload endpoint on this site. You can verify it: load the page, go offline, and convert.
Will transactions duplicate if I import the same file twice?
No. Every transaction in the file carries a FITID - a fingerprint built from its date, amount, and description - and QuickBooks skips FITIDs it has already imported. The fingerprints are deterministic, so re-importing the same statement is safe.
What is the difference between QBO, QFX, and OFX?
They are the same transaction format (OFX) wearing three badges: .qbo is QuickBooks' Web Connect flavor, .qfx is Quicken's, and .ofx is the plain standard most other accounting software reads. This tool downloads all three from the same parse, so use whichever your software asks for.
My statement dates have no year. How does the file get one?
Many statements print dates as 07/15 with no year, but the .qbo format requires full dates. The statement-year option supplies it, and a December-to-January rollover inside one statement is detected and carried into the next year automatically. Dates that already include a year are used as printed.
Why did it say my statement is a scan?
Some statements are scanned images of paper, which contain no machine-readable text - reading them requires OCR, which this tool does not pretend to do yet. Statements downloaded as PDF from online banking are digital text and parse.