Bank statement guides
Convert a UBL statement to Excel
Start with a digital statement where you can select the transaction text. Keep the original open while checking the worksheet.
Find the activity summary
Look for the Date, Particulars, Debit, Credit and Balance headings. The opening balance gives you a starting point. Review long transfer descriptions across line breaks, especially when a reference continues on the following line.
Check where each page starts and ends
A repeated account heading, contact number or website belongs outside the transaction list. Compare the last balance on one page with the first movement on the next. For example, an opening balance of PKR 3,000 followed by a debit of PKR 450 should leave PKR 2,550.
Open the Excel converter · Review extraction issues · Check running balances