Browse by topic
Bank statements in Excel
Clean up dates, signed amounts and transaction rows after conversion.
- How to get a bank statement as a PDF (online banking, app or branch)
- How to fix bank statement dates in Excel
- How to turn bank statement debits and credits into signed amounts in Excel
- How to calculate and verify a running bank balance in Excel
- How to clean repeated headers and wrapped bank statement rows
- How to combine monthly bank statements in Excel
PDF tables and CSV imports
Preserve identifiers, quoted fields and decimal separators when importing tables.
PDF extraction and OCR
Check selectable text, multi-page tables and OCR accuracy before export.
- How to tell if a PDF is scanned before converting it to Excel
- How to check OCR accuracy in a scanned statement before export
- How to extract a multi-page PDF table without losing boundary rows
- How to extract PDF tables with footnotes, subtotals, and mixed units
- What happens to your PDF when you convert it in your browser?
Transaction reconciliation
Trace balance differences, distinguish duplicates and match transfers.
- Bank reconciliation statement: format, example and how to prepare one
- Find duplicate bank transactions in Excel without losing real reversals
- How to match transfers between bank accounts in a spreadsheet
- Convert a credit card statement to a spreadsheet and verify the balance
- Check bank statement periods, opening balances and closing balances
- Prepare a clean transaction spreadsheet for a bookkeeping handoff