When your business banks with Standard Chartered across Singapore, Hong Kong, and Dubai, month-end looks nothing like a domestic company's. You hold USD, SGD, AED, and HKD accounts, money moves between them weekly, and every transaction needs to land in Xero without losing the currency trail. To import your Standard Chartered statement into Xero cleanly, you have to solve three problems at once: convert the bank's PDF into the CSV format Xero expects, route each currency to its own Xero bank account, and handle exchange rates so the books actually reconcile. Get any one of these wrong and you will spend hours hunting penny differences that turn out to be rate mismatches.
Why Standard Chartered statements complicate Xero imports
Standard Chartered serves clients across Asia, Africa, and the Middle East, and its statements reflect that footprint. A corporate client on Standard Chartered Straight2Bank can download per-currency or consolidated statements, while retail users grab PDFs from the SC mobile app. Either way, the statement layout was designed for human reading, not for Xero's importer.
The biggest structural mismatch is the amount columns. Standard Chartered statements typically show separate debit and credit columns (or money-in and money-out columns). Xero's CSV import expects a single Amount column where money out is negative and money in is positive. Dates print in DD/MM/YYYY format, reference numbers sit in their own column, and multi-currency accounts sometimes appear on one consolidated statement where each line carries its own currency code. None of this imports directly. You must reshape the data before Xero will accept it.
Step 1: set up one Xero bank account per currency
Every bank account in Xero holds exactly one currency. There is no multi-currency bank account object, so importing a USD line into a USD-denominated Xero account and a SGD line into a separate SGD-denominated Xero account is not optional, it is how the system works. Create one Xero bank account for each currency you hold with Standard Chartered, for example SC USD Operating, SC SGD Operating, SC AED Payroll, and SC HKD Collections. Clear naming saves you every single month.
When you add each account in Xero under Accounting, Bank accounts, set the account currency to match the statement currency exactly. Xero automatically pulls daily exchange rates from XE.com against your organization's base currency, which gives every foreign-currency transaction a converted home-currency value for reporting. If your base currency is USD and you are importing a AED statement into a AED bank account, Xero converts each line at the rate on the transaction date. Never import foreign-currency lines into a home-currency Xero account just to save setup time. The amounts will look right in the account register but every report will be wrong, and untangling it later takes longer than the five minutes of setup you skipped.
Step 2: convert your Standard Chartered PDF to a Xero-ready CSV
Corporate users can sometimes export CSV or Excel directly from Straight2Bank, but the export still uses the bank's column layout, and retail users only get PDFs from online banking or the SC mobile app. Either way, the reliable path is to produce a CSV that matches Xero's expectations exactly. See the full walkthrough in our guide on how to convert a bank statement to CSV.
Xero's CSV import needs three columns at minimum: Date, Description, and Amount. Date must be in a consistent format such as DD/MM/YYYY, which matches Standard Chartered statements nicely. Description becomes the transaction narrative Xero uses for matching rules, so keep the payee and reference text intact rather than truncating it. Amount is the critical one: one column, positive for money in, negative for money out. Map the bank's credit column to positive amounts and the debit column to negative amounts. Drop the running-balance column entirely, Xero ignores it and it only confuses the column mapping step.
Build one CSV per currency per Xero bank account. If your consolidated Standard Chartered statement mixes USD and SGD lines, split them into separate files before importing. A single mixed-currency CSV imported into a single-currency Xero account is the most common cause of reconciliation disasters with this bank. Check the file in a spreadsheet before upload: scan for blank dates, stray currency symbols inside the amount column, and thousands separators that can shift columns in some locales. Five minutes of spreadsheet review prevents an hour of cleanup.
Step 3: handle exchange rates on import and transfers
For ordinary receipts and payments, Xero applies its daily XE.com rate based on each transaction's date, and that is usually fine. The trouble starts with currency conversions, the moment money moves between your own Standard Chartered accounts. When you transfer 10,000 USD from your SC USD account to your SC AED account, Standard Chartered executes the conversion at its own rate, which will differ slightly from the XE.com rate Xero applied to each side of the transfer.
Record the movement as a transfer between the two Xero bank accounts using the actual rate the bank applied, not the system rate. Enter the transfer with the real amounts on both sides, and Xero posts the difference to foreign currency gains and losses automatically. If you let Xero default both sides to its own rates, the two accounts will each reconcile to the statements, but a phantom balance appears in your currency gain/loss account that grows every month. For businesses converting six figures a month across SC's Asian and Middle East corridors, that phantom number gets material fast.
One more discipline: lock the rate on the transaction date, not the import date. If you import January's statement in February, Xero uses each line's date for the rate lookup, which is correct. Do not re-date transactions to the import day to make rates look tidier. Consistency between statement dates and Xero dates is what makes the next step, reconciliation, actually work.
Step 4: reconcile foreign-currency accounts without losing your mind
Open each Xero bank account and reconcile in the account's own currency. Xero's Find and Match screen shows foreign amounts alongside their home-currency equivalents, so match on the foreign amount, that is what the Standard Chartered statement shows. Bank rules are your best friend here: build rules per currency that match on description keywords, because a rule written for your USD account will never fire on AED lines anyway.
Watch for three recurring headaches. First, bank charges deducted in a different currency than the account, Standard Chartered occasionally debits fees in USD from a SGD account. Record the fee as a spend-money transaction in the account's currency using the converted amount from the statement. Second, partial customer receipts where the received amount differs from the invoice by a few dollars after correspondent-bank deductions. Write off small differences to a bank-charges or rounding account rather than leaving invoices open forever. Third, month-end revaluation: Xero's foreign currency revaluation report recalculates open balances at period-end rates and posts unrealized gains and losses. Run it monthly so your balance sheet reflects reality, and review the currency gains and losses account for anything that looks like a data problem rather than a market move. Accountants doing deeper period-end work will find more techniques in our bank statement analysis guide for accountants.
Frequently asked questions
Can I import a Standard Chartered PDF directly into Xero?
No. Xero does not accept PDF statements for import. It accepts CSV files or direct bank feeds. Convert your Standard Chartered PDF, whether from Straight2Bank or the SC mobile app, into a CSV with Date, Description, and Amount columns first, then import that file.
Does Xero offer a direct bank feed for Standard Chartered?
Feed availability varies by country and account type, and many Standard Chartered corporate accounts have no supported feed at all. CSV import is the dependable method everywhere. Even where a feed exists, many multi-currency businesses prefer CSV because it gives them full control over column mapping and per-currency file splitting.
What date format should my CSV use?
Use DD/MM/YYYY to match your Standard Chartered statement. Xero lets you confirm the date format during the import mapping step, but keeping the file consistent with the statement removes a whole class of errors, especially around dates like 03/04 that read differently in US and international formats.
How do I fix an import where currencies got mixed?
Delete the imported statement lines from the wrong Xero bank account before reconciling anything against them, split your CSV by currency, and re-import each file into its matching single-currency account. Fixing it after partial reconciliation takes three times longer, so check the currency mapping on the import preview screen every time.
Why does my currency gain/loss account keep growing?
Usually because transfers between your own Standard Chartered currency accounts were recorded at Xero's system rate instead of the bank's actual conversion rate. Re-record those transfers with the real amounts from the statement and Xero will post the true realized difference instead of an accumulating phantom balance.
Multi-currency bookkeeping with Standard Chartered and Xero is genuinely manageable once the pipeline is right: one Xero account per currency, clean CSVs shaped to Xero's three-column format, real bank rates on every transfer, and monthly revaluation. Set it up once and month-end drops from a dreaded two-day scramble to a routine review. If you are still hand-retyping statement lines or wrestling with spreadsheet conversions, see plans and convert your next Standard Chartered statement in minutes instead of hours. Start free at convertstatement.online and import this month's statements today.