S2SStmt2Sheet

Guide

How to convert a bank statement to Excel

From the bank's PDF to a workbook you can reconcile.

1. Start with a text-based PDF

Download the statement from your bank rather than photographing it. A text PDF has a text layer; the converter can read the date, description and amount columns without OCR. If you only have a scan, download the statement again from online banking; scans are not supported.

2. Upload and read the preview

Upload the PDF, then compare the preview with the statement: the first and last dates, the number of rows, the opening/closing balance. If a column is shifted, stop and try a different page or a cleaner PDF.

3. Export to XLSX

Download the workbook. The columns are Date, Description, Debit, Credit, Amount and Balance. Add a category column, a reconciliation checkbox and any formulas you need. Keep the original PDF beside the workbook.

4. Reconcile, don't assume

Match the statement total to the workbook total. If they differ, find the missing row before you import anything into your ledger. A converter saves typing; it does not replace reconciliation.

Common problems

  • Scanned PDF: no text layer; download the original PDF from your bank.
  • Multi-column statement: preview first; a non-standard header can shift columns.
  • Parentheses or trailing minus: check the debit/credit side in the preview.
Open the Excel converterCSV guidePricing

Questions

Do I need Excel installed?

No. The converter runs in the browser and produces an XLSX file you can open in Excel, Google Sheets or LibreOffice.

Why does the row count differ from the statement?

A page may be missing, a row may be a continuation, or the PDF may be a scan. Check the preview and the page count.