Home › Countries › Sri Lanka › Hatton National Bank › Statement to CSV
Hatton National Bank is a bank based in Colombo, Sri Lanka. Its account statements are issued as PDFs through online and mobile banking. Upload the statement PDF below and download a CSV file — extracted, normalized and reconciled first.
This export writes the Hatton National Bank transactions as comma-separated values, UTF-8 encoded so descriptions with accented characters survive, amounts in plain decimal form, ready for any system that takes a file upload.
The main use is moving figures between systems that do not share a native format. Every conversion is checked against the statement itself: where the statement prints opening and closing (or running) balances, the extracted transactions must add up to them, or the conversion is flagged and the mismatched rows are marked. A statement whose layout the reader cannot parse is reported honestly — never passed off as converted.
Trust in the output comes from the statement's own arithmetic. Hatton National Bank prints balances that its transaction list must sum to; the converter repeats that sum independently on the extracted data. A dropped row, a duplicated row or a misread digit breaks the chain and is flagged at the row where it breaks, with the expected and printed balances shown side by side.
Two habits make Hatton National Bank statements easier to work with. First, convert the issued PDF rather than a portal screen print — print views paginate differently and can drop the balance lines the check needs. A reconciliation difference is most often one of those large items — a duplicate, a drop, or a digit misread — and knowing the candidates in advance shortens the search considerably.
In Sri Lanka, bookkeepers commonly work in QuickBooks and Xero; the Excel and CSV exports from this converter are the files those tools import, and the QuickBooks export is laid out for direct import where the tool accepts it.
A workable rhythm: download the month's PDF the day the period closes, convert it, read the reconciliation verdict, then import. Months proven in order chain together — each closing balance becomes the next month's opening — so a difference is always owned by exactly one month.
A CSV carries no formatting to hide behind, which is its virtue: what you see in a text editor is exactly what an importer will read. If a figure looks wrong in the file, it was flagged in the check — compare that row with the PDF before importing.
These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.
Tip: keep the downloaded PDFs in a folder named by account and month. A tidy folder makes batch conversion and later review almost mechanical.
Save the statement as a PDF from Hatton National Bank online banking, add it to the converter above, and take the a CSV file it produces. Extraction, column normalization and the reconciliation check all happen before the download is offered.
Expect the order printed on the statement itself dates and amounts with the grouping printed on the statement itself on a Hatton National Bank statement. The reader is locale-aware, so those conventions are handled rather than misread, and the output columns come out in the standard layout regardless.
Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.
Date, Description, Amount, Debit, Credit and Balance — the same normalized columns for every bank, so a Hatton National Bank file and a file from any other bank in Sri Lanka can be imported and reviewed the same way.
The conversion is flagged, and the rows whose running balance disagrees with the statement are marked with the expected and printed figures. Nothing is silently adjusted — you see exactly where the statement and the extraction part company.
Yes. Scans and photo-based PDFs are read with OCR and marked as OCR-extracted. The reconciliation check applies identically; on a poor scan it is the check that tells you whether the read can be trusted.
No. There is no sign-up: upload the PDF, check the reconciliation result, download the file. Uploaded files and exports are deleted automatically within 15 minutes.
The statement PDF. It is the issued document and it carries the opening and closing balances the reconciliation check verifies against; a portal CSV has the transactions but nothing to prove them against.
No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.
Convert the same Hatton National Bank statement PDF to Excel instead.
Convert the same Hatton National Bank statement PDF to OFX instead.
Convert the same Hatton National Bank statement PDF to QuickBooks instead.
Back to the Hatton National Bank statement converter hub or the Sri Lanka bank directory. Other Sri Lanka banks: Commercial Bank of Ceylon statement to CSV · Sampath Bank statement to CSV · Seylan Bank statement to CSV · People's Bank statement to CSV
Your first conversion is free — no card, no sign-up — and every result is checked against the statement itself before you download it.