Home › Countries › Bangladesh › The City Bank › Statement to QuickBooks
The City Bank is a bank based in Dhaka, Bangladesh. Its account statements are issued as PDFs through online and mobile banking. Upload the statement PDF below and download a QuickBooks-ready CSV (Date, Description, Amount) — extracted, normalized and reconciled first.
QuickBooks wants a simple three-column file, and this export produces it from the The City Bank PDF: date, description, signed amount — ready for the Banking upload screen without deleting balance columns or splitting debits and credits yourself.
The main use is bookkeepers who standardize every client bank into one upload shape. Every conversion is checked against the statement itself: where the statement prints opening and closing (or running) balances, the extracted transactions must add up to them, or the conversion is flagged and the mismatched rows are marked. A statement whose layout the reader cannot parse is reported honestly — never passed off as converted.
Reconciliation is what separates conversion from copying. Once the The City Bank transactions are extracted, the converter replays them: opening balance plus each row in turn must reproduce every printed running balance and land exactly on the closing figure. A conversion only reports as reconciled when both tests agree to the cent — and when they do, the figures have been proven against the bank's own document, not merely read from it.
Read a The City Bank statement as three zones. The header zone names the account and the period — check those first, because a wrong-period PDF converts beautifully and reconciles against the wrong month. The middle zone is the transaction list itself. The closing zone carries the balances and any fees or interest summaries; it is the closing zone the reconciliation check answers to, and the first place to look when a conversion is flagged.
In Bangladesh, bookkeepers commonly work in QuickBooks and Xero; the Excel and CSV exports from this converter are the files those tools import, and the QuickBooks export is laid out for direct import where the tool accepts it.
A workable rhythm: download the month's PDF the day the period closes, convert it, read the reconciliation verdict, then import. Months proven in order chain together — each closing balance becomes the next month's opening — so a difference is always owned by exactly one month.
Import one statement at a time and reconcile in QuickBooks before uploading the next month. The converter proved each file against its own statement; importing in order lets QuickBooks' reconciliation continue the same chain.
These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.
Tip: a statement that covers a partial period (account opened or closed mid-month) still converts and reconciles; its balances simply anchor a shorter chain.
Get the PDF from The City Bank's statements area, upload it here, and download the converted a QuickBooks-ready CSV (Date, Description, Amount). The converter reads the transactions, standardizes the columns and verifies the totals against the statement before the file is ready.
The City Bank statements generally print dates as the order printed on the statement itself and amounts with the grouping printed on the statement itself. The converter reads the figures as printed and normalizes the output columns the same way for every bank.
Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.
No. The converter changes layout, not currency: figures stay in Tk exactly as The City Bank printed them.
Yes — convert each account's statements separately so each one reconciles against its own balances, then combine the exports in your software if you need a single view.
Scan the statement as flat and straight as you can and upload the scan. OCR reads it, and the reconciliation check verifies the read against the printed balances; rows it cannot verify are flagged for a manual look.
That depends on the bank's portal — most keep at least a year of PDFs online, and older periods can usually be requested. However far back you go, download each period as its own PDF.
The QuickBooks and Xero exports are laid out in the column order those tools import. The plain CSV and Excel exports suit everything else, including spreadsheet review before import.
No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.
Convert the same The City Bank statement PDF to Excel instead.
Convert the same The City Bank statement PDF to CSV instead.
Convert the same The City Bank statement PDF to OFX instead.
Back to the The City Bank statement converter hub or the Bangladesh bank directory. Other Bangladesh banks: BRAC Bank statement to QuickBooks · Dutch-Bangla Bank statement to QuickBooks · Islami Bank Bangladesh statement to QuickBooks · Prime Bank statement to QuickBooks
Your first conversion is free — no card, no sign-up — and every result is checked against the statement itself before you download it.