Bank statement to Excel & CSV

Any bank whose statement is a digital PDF (you can select the text) with a transactions table: a date column plus money in/out or amount, and ideally a balance column. CSV and Excel exports from online banking work with most banks.

For each row, LedgerLift checks that the amount explains the change in the running balance. ✓ 99% means it matches exactly. ⚠ means it couldn’t be confirmed (for example there is no balance column, or the row has no date), so compare that row with your statement.

The PDF is a scanned image, so there is no text to read. Download the statement again from your bank’s website or app, where it’s usually a digital PDF, or choose CSV/Excel.

Many banks protect statements with a password, often built from your date of birth, customer ID or part of your account number. Your bank’s statement email usually explains the format. Enter it when prompted.

Yes. After extracting, click Export Excel to download an .xlsx file with the same columns as the CSV: date, merchant, description, category, amount and balance. Dates are real Excel dates and amounts are numbers, so you can sort, filter and add up columns straight away. The header row stays visible as you scroll.

Choose Excel if you’ll work in Excel, Numbers or Google Sheets yourself. Choose CSV if you’re importing into accounting software such as QuickBooks or Xero, which usually ask for CSV. Both files contain the same rows.

Click Draft email, add their address, edit the message, then download the CSV or Excel file and click Open in email app. Attach the file before sending, because email links can’t attach files automatically.

Yes. Click a row’s category and choose another. Exports and email drafts use your changes.

Every row is checked against the running balance, so a missing or misread row shows up as a ⚠ on the rows around it. When a PDF statement prints its total money in and money out, LedgerLift also adds up what it extracted and tells you whether the totals match. Compare the Money in and Money out figures with your statement too.

Day and month order is decided once for the whole statement. If any date has a first number above 12 it's read day-first; if the second number is above 12 it's month-first. If every date is ambiguous, LedgerLift goes by the statement's currency: month-first for US and Canadian dollars, day-first for most others. Check the first few dates against your statement.

By keywords in the description: salary, interest, bank fees, cash withdrawals, utilities, food, travel, software and more. Transfers (for example ACH, wire, UPI or NEFT) become Transfer in or Transfer out, and anything unrecognized is Income if money came in or Uncategorized if it went out. It's a starting point; change any category before you export.

No. See Security. Nothing is uploaded, and refreshing the page clears everything.