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.
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.