Use one row per transaction
A reconciliation sheet works when each transaction has one row. Split debit and credit into separate columns, keep the running balance, and store the bank reference beside the description.
This structure lets you match invoices, receipts, bank charges, transfers, and loan payments without retyping the PDF.
Balance checks catch data errors
After extraction, compare the first and last balance in Excel with the PDF. If a page has a wrapped description or a missing amount, the balance check exposes it before you import the file.
SEA Bank OCR keeps bank-specific balance fields, including Maybank running balances, Public Bank balances, and RHB signed amount rows.
Prepare for client review
Accountants can send clients a clean spreadsheet with one tab per account and one export per month. The PDF stays as source evidence, while Excel handles filtering, tagging, and review comments.
Step by step
How to do it
- 01Convert the PDF
Upload the bank statement PDF and export it as Excel or CSV.
- 02Sort and match
Sort rows by date and match deposits and withdrawals to invoices and bills.
- 03Check the balance
Compare the closing balance in Excel with the PDF.
- 04Import or share
Import the reconciled rows into your accounting software or send the spreadsheet for review.
Checklist
Use this workflow
- 01Convert the bank statement PDF to Excel.
- 02Sort rows by transaction date.
- 03Match deposits to invoices and receipts.
- 04Match withdrawals to bills, fees, and transfers.
- 05Compare the closing balance to the PDF.