Sheet Audit works with Excel and CSV files — not PDFs directly. Here's how to convert one first, in a couple of minutes, using a free tool.
Bank statement PDFs vary enormously in layout from one bank to the next, and reliably extracting a clean table from an arbitrary PDF is a genuinely error-prone problem — one that a dedicated tool built specifically for that purpose handles far better than we could bolt on as an afterthought. Rather than build unreliable PDF parsing ourselves, the honest answer is: use a tool that's actually good at it, then bring the result here.
Google's NotebookLM includes a feature that extracts tables from PDFs — including ones with merged cells and awkward layouts — and exports them directly to a spreadsheet.
Go to notebooklm.google.com, create a new notebook, and add your PDF bank statement as a source.
Look for a table or "Data Tables" feature within the source view — this identifies the transaction table in your PDF and prepares it for export.
Export the extracted table as an .xlsx file, or to Google Sheets (then download as .xlsx from there).
Bring the exported spreadsheet to Reconciliation (to compare it against your ledger) or Single File Audit (to check it on its own).
Upload it to Reconciliation to compare it against your ledger, or run it through Single File Audit on its own.
Go to Reconciliation →Yes, NotebookLM is a free Google product.
It depends on the quality of the scan and how NotebookLM's extraction handles it — a clean, text-based PDF (most digitally-downloaded bank statements) will convert far more reliably than a low-quality photo or scan.
No — this conversion step happens entirely outside Sheet Audit, in NotebookLM. Sheet Audit only ever sees the spreadsheet you choose to upload afterward.