If you bank with Bandhan Bank and run your books in Xero, you have probably done the painful dance of retyping transactions from a PDF statement into your accounting software. Learning to import Bandhan Bank statement into Xero the file-based way turns that chore into a ten-minute routine: download the statement, convert it to a clean CSV, and let Xero do the matching. No manual typing, no transposed digits, and a reconciliation that actually balances.
This guide walks through the whole flow — from the Bandhan Bank statement download to a reconciled Xero bank account — plus the small formatting details that trip people up the first time.
Why a clean import beats manual entry in Xero
Manual entry is where most bookkeeping errors are born. A single misread digit in an amount, a date typed as March instead of May, or a skipped row all create differences that surface weeks later when the Xero balance refuses to match the bank. Each one then costs an hour of detective work. Importing statement lines directly removes the transcription layer entirely: the dates, descriptions, and amounts in Xero are exactly what the bank reported.
There is a second payoff that matters more over time. Imported transactions carry consistent descriptions, which means Xero's bank rules can learn to categorize them automatically. After two or three months of clean imports, most of a Bandhan Bank statement categorizes itself, and the monthly close shrinks to a quick review. Manual entry never gets faster; clean imports compound.
Step 1 — Download your Bandhan Bank statement as a PDF
Start in Bandhan Bank's net banking portal or mobile app and navigate to the account statement section. Select the account and the period you want — a single month is ideal for Xero imports, because it keeps each import batch small enough to review comfortably. Download the file in PDF format and save it somewhere obvious, like your Desktop or a "statements" folder.
If the PDF is password-protected, you will need the password at conversion time. Most statement converters ask for it during upload, decrypt the file in memory only to read the tables, and never store the password or the file afterward. If you have forgotten the password, reset it through the bank's portal before converting — there is no shortcut around that.
Step 2 — Turn the PDF into an import-ready CSV
Xero's bank import accepts CSV files (along with OFX and QIF), so the conversion target is a CSV with one transaction per row and columns for date, description, and amount. Upload the Bandhan Bank PDF to a statement converter such as Convert Statement and choose the CSV output. The first 8 pages are free, which covers most monthly statements, and the conversion typically takes under a minute.
Before you import, open the CSV and scan it for two things. First, the date format: Xero accepts common formats, but a file that mixes formats will confuse the importer — pick one and stick with it. Second, the running balance column: compare the opening and closing balances in the CSV against the PDF. If those two numbers match, every row between them converted correctly, and you can import with confidence.
Step 3 — Import the CSV into Xero and map the columns
In Xero, go to the bank account under Accounting, open the account, and choose the option to import a statement. Upload your CSV. Xero will ask you to map the columns — tell it which column is the date, which is the description, and which holds the amount. If your CSV uses separate debit and credit columns, map both; Xero handles that layout fine.
Xero then shows a preview of the statement lines. This is the moment to catch problems: look for rows with blank dates, amounts that landed in the wrong column, or a first line whose date is older than your last import. If anything looks off, fix the CSV and re-upload — it is far easier to correct the file now than to untangle imported transactions later. When the preview looks right, confirm the import and Xero pulls the lines into the bank account's "for review" tab.
Reconciling in Xero after the import
Importing puts the transactions in Xero; reconciling is what makes them trustworthy. Work through the "for review" tab line by line. For each transaction, Xero suggests a match or a category — accept the suggestion when it is right, and when it is wrong, set the correct account and let Xero learn from the correction. Pay special attention to transfers between your own accounts: recording both sides as a transfer keeps the books balanced.
When the tab is empty, check the bank account balance in Xero against the statement's closing balance. They should agree to the cent. If they do not, the usual suspects are a duplicated import (two overlapping statement periods), a transaction dated outside the period, or a manual entry that the import duplicated. A clean monthly routine — one statement, one import, no overlaps — prevents nearly all of these.
Tips for monthly Bandhan-to-Xero imports
Set a fixed rhythm: download the statement on the same day each month, convert it, and import it before entering anything manually for that account. Manual entries and imports for the same account in the same period are the classic source of duplicates — pick one path per account and stay with it.
Use Xero bank rules aggressively. After a few months, rules can auto-categorize recurring items like rent, utilities, and subscriptions, which turns reconciliation into a review exercise. And keep your statement PDFs: Xero stores the imported lines, but the original PDF is your audit evidence if a question ever comes up. A deeper look at formats is in our guide to converting bank statements to CSV, and the same workflow works for other banks — see importing Barclays statements into Xero.
Frequently asked questions
What file format does Xero need for a Bandhan Bank statement?
Xero imports CSV, OFX, and QIF files. A converted CSV from your Bandhan Bank PDF is the most flexible choice — just make sure it has date, description, and amount columns.
Can I import several months of Bandhan Bank statements at once?
Yes, but import them one month at a time and in chronological order. Non-overlapping periods are the single best defense against duplicate transactions in Xero.
What if my Bandhan Bank PDF is password-protected?
Enter the password at upload time in the converter. The file is decrypted in memory only for reading, and neither the password nor the file is stored afterward. More on this in our Bandhan Bank converter page.
Do I need to delete manual entries before importing?
If you already entered some transactions manually for the same period, either delete them before importing or skip the import for those dates. Mixing both paths for one account is how duplicates happen.
Ready to stop retyping statements? Convert your Bandhan Bank PDF to CSV free — your first 8 pages are on us — and import it into Xero in minutes.