The Evidilo blog
How a bank statement is read into an import file, what the balance check catches before a download, and where the reading still needs a person.
Password-protected bank statement PDF: what converts
A bank statement PDF can open with no password and still be encrypted. Which kinds Evidilo reads, which it refuses as locked, and how to make one it reads.
When a bank statement prints the date once a day
A bank statement that prints the date once a day leaves the other rows blank. How Evidilo carries that date, why neither the file nor the balance check shows it, and what to check.
Bank statement to Excel or CSV: which one to open
Opening a bank statement CSV lets the spreadsheet decide what each cell means. What Evidilo's CSV and Excel files stored for six rows, and which one to open.
PDF bank statement to QuickBooks without duplicates
A PDF bank statement reaches QuickBooks as an upload, a CSV or a QBO file. Which route stops a month importing twice, per Intuit’s own guides on 26 October 2026.
When one page of a statement will not open
When one page of a statement goes unanswered, the rows that were read are kept and the page is named. What you can do next, and when the balance check misses the gap.
Bank statement photo: what a reader has to prove
A photo of a bank statement has no text layer, so the proof of a correct read is what the bank printed. What shrinking, shadow and tilt did to one measured page, and what the check covers.
What a tied-out statement tells you, and what it does not
The balance check proves the amounts add up against the balances the bank printed. We injected 22,053 errors and error pairs to see what it catches, how far it narrows the search, and what slips through.
Bank statement dates with no year: which year a row gets
A bank statement row printed as 12/30 has no year. How Evidilo takes it from the statement period, what Excel does instead, and what to check at New Year.
How to download Chase statements in Excel, by year
How to download Chase statements in Excel: Chase gives two years of CSV on desktop and up to 7 years of PDF statements. What to do for the PDF-only months.
Bank feed: how far back it reaches in six tools
How far back a bank feed reaches in QuickBooks, Xero, Wave, FreshBooks and Sage, per each tool’s own help page, and which statements fill the gap before.
QFX file: what is inside one, line by line
A QFX file is an OFX file plus one INTU.BID line. We wrote both from the same five rows, compared them, and quote what Quicken says about converted ones.
IIF file format: build one and check it before import
The IIF file format puts a QuickBooks Desktop bank import in blocks that sum to zero. We built one, broke it six ways, and noted what no check catches.
How to import bank transactions into QuickBooks Desktop
How to import bank transactions into QuickBooks Desktop: a Web Connect file, Batch Enter from Excel or CSV, or IIF, and what Intuit says each one checks.
Catch-up bookkeeping starts from the oldest statement
Catch-up bookkeeping starts from the oldest statement's opening balance: where QuickBooks, Wave and FreshBooks take it, and how to check the monthly chain.
QIF file format: what it leaves to the importer
What a QIF file holds and what it leaves out: no row id, no date order. One statement read month first and day first, and which programs still import QIF.
OFX file format: one name, two formats
The OFX file format is SGML in version 1.x and XML in 2.x. We ran one statement in both through seven readers to see which opened each and which refused.
Bank reconciliation discrepancy: what its size tells you
A bank reconciliation discrepancy of one row, twice a row or a multiple of 9 hints at its cause. We ran 10,000 cases to see how often each rule misleads.