Ledgerbox

Loan statement converter

A loan statement prints a repayment schedule: one row per instalment, split into principal, interest and the balance left. You get that table back as a spreadsheet — same columns, same headings, same text in every cell. The file is read in this tab and never uploaded.

No statement to hand? Try one:

What a loan statement looks like

The columns these usually print — and the headings you will get back, read from your own document rather than from this list:

  1. 1Due Date
  2. 2Instalment
  3. 3Principal
  4. 4Interest
  5. 5Outstanding

The part that is hard

Schedules run for hundreds of rows across dozens of pages, reprinting their headings every time. Those repeats are dropped, so you get one header row and every instalment.

Borrowers checking an amortisation schedule against what was actually charged.

Other documents

Questions

Is my bank statement uploaded anywhere?
No. The PDF is opened by JavaScript running in your own browser tab, and the table is extracted on your device. Nothing is sent to a server, so there is no copy of your statement for anyone — including us — to lose, sell or hand over.
Will the columns match my statement?
Yes, that is the whole point. The header row of your download is the header row of your PDF, word for word, and the columns come out in the order the statement printed them. Nothing is renamed to a house standard, merged, split or reordered.
Does it change the values in any way?
No. A cell arrives as the text that was in it — the same date format, the same thousands separators, the same Dr/Cr markers, the same currency symbols. The one optional exception is clearly labelled: for .xlsx you can have cells that are nothing but a figure typed as numbers rather than text, so Excel will add them up. The digits are unchanged, and you can switch it off.
What happens to a description that wraps onto two lines?
It stays as two rows, because that is what the PDF printed. Every line inside the table becomes one row, with the cells it actually had and the rest left empty. You can merge or delete rows yourself in the table before downloading.
Does it work with password-protected statements?
Yes. Enter the password when prompted; it is used to decrypt the file locally, in the same tab, and is never transmitted or stored.
What formats can I export to?
Excel (.xlsx), CSV, and JSON if you are feeding another tool. Accounting formats like OFX and QIF are not offered, because building one would mean deciding which of your columns is the date and which is a signed amount — exactly the guessing this tool does not do.
My bank is not in the list. Will it still work?
There is no list to be on. Columns are found from the gutters between them — the vertical stripes of the page that no row prints into — so the extractor never needs to recognise the bank, the language or the layout. The bank pages here describe layouts; they do not enable them.
Can it read a scanned statement?
Not yet. A scan is an image with no text layer, which needs OCR. Statements downloaded as PDF from online banking are text and work fine — if you scanned or photographed a printed statement, download the original from your bank instead.

A loan statement layout we read badly? Describe the columns to hello@ledgerbox.example — please do not send the document itself.