Ledgerbox

Payslip converter

A payslip is a small document with a dense table: earnings on one side, deductions on the other, and a net figure at the foot. 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 payslip 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. 1Description
  2. 2Rate
  3. 3Units
  4. 4This period
  5. 5Year to date

The part that is hard

Earnings and deductions are often two separate tables printed side by side. The converter returns the dominant one — convert the payslip twice and take one table each time, or crop the page, if you need both.

Payroll checks, loan applications, and anyone rebuilding a year of income.

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 payslip layout we read badly? Describe the columns to hello@ledgerbox.example — please do not send the document itself.