Reconcile bank statements against your ledger
Month-end reconciliation usually means copying transactions out of PDF statements by hand. With Altera, you extract them, match them against your ledger, and keep only what doesn't line up.
The challenge
Statements arrive as PDFs, in a different layout for every bank. Copying them into a spreadsheet takes hours, and one mistyped amount is enough to throw off the whole reconciliation.
Documents it handles
- Bank and credit card statements
- Payment provider reports
- Ledger or accounting exports (Excel or CSV)
- Supplier statements
The workflow
This is a live canvas: drag the nodes around, or zoom with the controls.
Step by step
- 1PDF Converter
Extract the transactions
Highlight the transaction table in the PDF Converter, and Altera turns it into rows of date, description, reference, and amount.
- 2Cleaner
Clean the text
Trim spaces and strip currency symbols, so amounts and references match exactly.
- 3Change Type
Make amounts numeric
Convert the amount column to numbers, so it can be compared and totalled.
- 4Merge
Match against the ledger
Load your ledger export with Input Data and connect it to Merge's Extra Data port. Rows are matched on reference and amount.
- 5Filter · Export
Keep what needs attention
Filter down to the entries with no match, and export them to Excel for review.
What you get
- Reconcile a month of transactions in minutes instead of hours
- No retyping, so no typos in amounts
- Reuse the same workflow next month: swap the PDF and run it again
More use cases
Ready to turn your PDFs into data?
Download Altera, open a PDF, and build your first workflow in minutes.