Union Bank statements are often needed for bookkeeping, loan review, tax preparation, and month-end cleanup. A PDF statement is useful as the source record, but it is hard to sort, filter, total, or hand off to an accountant. Converting the statement into CSV or Excel gives you rows that can be reviewed before the data is used elsewhere.
Bank Statement Converter extracts transaction tables from Union Bank PDF statements and turns them into spreadsheet-ready rows. The safest workflow is to start with the original bank-issued PDF, convert the visible transaction table, then compare the exported rows against the statement before using the file for accounting or reconciliation.
Prepare the Union Bank PDF
Use the original statement
Use the original PDF downloaded from Union Bank whenever possible. Original PDFs usually preserve clearer text and table structure than screenshots, phone photos, or printed scans. If the statement is encrypted, provide only the PDF open password for that document. Keep online banking passwords, OTPs, card PINs, and account credentials inside Union Bank's official login flow.
Check the period before conversion
Before uploading, confirm the account suffix, statement period, page count, opening balance, and closing balance. Union Bank PDFs can include summaries, account details, transaction rows, notes, and repeated page headers. Build the final CSV or Excel workbook around the transaction rows and use the other statement details for validation.
How to convert a Union Bank statement PDF
- Upload the Union Bank statement PDF. Add the document open password if the file is protected.
- Preview extracted rows. Check that transaction pages produced rows and that summaries or notices were not mixed into the table.
- Review transaction fields. Confirm dates, descriptions, debits, credits, and balances before reshaping the file.
- Export Excel for review. Use Excel when you need filters, notes, formulas, or a workbook for an accountant.
- Export CSV for import. Use CSV after repeated headers, blank rows, and non-transaction lines have been removed.
Fields to check in the exported file
A practical Union Bank spreadsheet should preserve transaction date, description or narration, debit amount, credit amount, and balance where the statement provides it. Keep the source text during review because payment references, cheque numbers, transfer IDs, fees, interest, and card activity can explain how a row should be categorized.
If your accounting system expects one amount column, create a working copy where debits are negative and credits are positive. Keep the raw export in a separate sheet or file so a reviewer can trace every value back to the source PDF.
| Field | Review note |
|---|---|
| Date | Controls period, sorting, and import order. |
| Description | May include transfer references, cheque details, card activity, fees, or interest. |
| Debit | Confirm withdrawals stay in the money-out direction. |
| Credit | Review income, refunds, transfers, and reversals carefully. |
| Balance | Helps detect skipped rows, duplicate rows, or shifted amount columns. |
CSV or Excel for Union Bank statements?
Use Excel when a person needs to inspect the conversion, add notes, apply filters, or prepare a workbook for accountant handoff. Use CSV when the reviewed data needs to be imported into accounting software, reconciliation templates, or internal systems.
For most cleanup work, Excel is the safer first export. Review the workbook, keep the source PDF nearby, then create a simplified CSV only when the transaction rows are clean.
Common cleanup checks
Repeated headers
Long PDF statements often repeat the table header on each page. Remove those header rows before using the file for import or analysis.
Wrapped descriptions
Long descriptions can wrap onto a second visual line in the PDF. After conversion, review rows where the date or amount is blank but text continues. Those lines may belong to the transaction above.
Summary lines
Opening balance, closing balance, and account summary values are useful validation points, but they should not usually become transaction rows in the final CSV.
About Union Bank references
This guide is for converting Union Bank statement PDFs that you already have permission to use. Use official Union Bank channels for login, statement download, account questions, and password help. After the PDF is ready on your device, upload it to BsConv for CSV or Excel preparation.
Convert a statement before your next review
Upload a PDF bank statement, review the extracted tables by page, then export clean CSV, Excel, or copy-ready data for accounting and reconciliation work.