Match your bank statement to your ledger, without uploading either.

Drop the bank statement (PDF, Excel or CSV) on the left and your ledger or cash book (Excel or CSV) on the right. SheetFern pairs entries with the same amount on the same or a nearby date and lists what is only in the bank and only in the books.

1. Bank statement

Choose a file PDF statement, or Excel/CSV export

2. Your ledger

Choose a file Excel or CSV with date and amount columns

Dates may differ by up to

How matching works

Each file is read in your browser. SheetFern finds the date, description and amount (or money-in / money-out) columns from the header row.
Entries with the same amount on the same day are paired first. Then entries with the same amount within the date window you choose, closest date first.
Each ledger entry is used once, so two identical payments need two matching lines.
If your ledger records money in and out with the opposite sign (for example debit = money in), SheetFern notices and flips it.

Questions

What can the ledger file look like?

Any Excel (.xlsx) or CSV file with a date column and either one amount column or separate money-in and money-out columns. Exports from accounting software usually work. Korean CSVs saved in EUC-KR are read too.

Can I use a PDF statement?

Yes. Put the PDF on the bank side and it is converted the same way as on the converter. If you just converted a statement here, the reconciliation page picks it up automatically.

Does it match one payment against several ledger lines?

Not yet. Each bank line is matched to at most one ledger line. Split and grouped matching are planned for paid features.

Is anything uploaded?

No. Both files are read and matched in this browser tab. See the privacy policy.