Manually typing a month of Bank Central Asia transactions into Xero is slow, boring, and error-prone, and it is exactly the kind of work a converter exists to remove. Learning to import Bank Central Asia statements into Xero turns that chore into a short routine: download the official statement, convert it to a clean CSV, map the columns once, and let Xero match the rest. This guide covers the full routine, including the date-format and sign-convention traps that catch first-time importers.

Bank Central Asia, known as BCA, is one of Indonesia's largest private banks, and its internet banking and mobile app issue account statements as PDFs. Those PDFs are fine for reading but useless for importing, which is why the conversion step sits at the heart of this workflow. The method here works for personal and business accounts alike, and for one month or a full year of statements.

Download the Right Bank Central Asia Statement PDF

Start in BCA internet banking or the mobile app, and download the official monthly statement for the period you need, not a transaction-history screen or a screenshot. The official statement carries your name, the account number, the statement period, and opening and closing balances, which makes it the document accountants accept. Save each month as its own file, named by account and month, so a full year stays easy to assemble later. For background on the bank itself, see our Bank Central Asia bank page.

If your statement is password-protected, unlock it with the password the bank set before converting; converters cannot read a locked PDF. Keep the password with the file's own notes rather than inside the spreadsheet, and never share the unprotected statement more widely than necessary.

import bank central asia statements into xero — checking a bank statement on a laptop at home
Download the official monthly PDF, not a screen capture or mini-statement.

Convert the Statement to a Xero-Ready CSV

Upload the PDF to a statement converter that reads the statement's table structure rather than guessing from raw text. Choose CSV as the output, then check the shape of the data before doing anything else: dates in one column, descriptions in the next, and amounts in their own column, with the sign convention clearly visible. The conversion itself usually takes under a minute; the check that follows is what matters, because a converter that silently drops rows creates errors that surface weeks later during reconciliation.

Xero's import expects a consistent date format and a single signed amount column, or separate debit and credit columns it can map. Indonesian statements typically use day-month-year ordering, so tell Xero to read the dates that way, or January 3 becomes March 1 across the whole file. If your statement uses separate debit and credit columns, combine them into one amount column before importing, with withdrawals as negative numbers. For the general method, see our guide on converting a bank statement PDF to Excel, which covers the same checks in spreadsheet form.

Map Columns and Import Into Xero

In Xero, open the bank account, choose the import option, and upload the CSV. Map the date column to the date field, the description to the description field, and the amount column to the amount field. Import one month first and review it row by row before importing the rest of the year. Correct categorization on the first month teaches Xero's bank rules, and those rules then apply cleanly to later months.

Before importing, check whether Xero already holds transactions for the same period through a connected bank feed. If it does, import into a review step first and exclude the overlap, or the same transactions will arrive twice. Overlapping statement periods cause the same problem in a quieter way: a reissued statement can overlap the original, and importing both counts the boundary transactions twice. Keep a simple import log with account, statement period, import date, and row count, and check statement periods before combining months into one annual file.

import bank central asia statements into xero — mapping spreadsheet columns on a laptop screen
Map date, description, and one signed amount column, then review month one.

Reconcile in Xero and Keep the Routine Monthly

After import, reconcile the Xero bank account against the statement's closing balance. If the two do not match, the difference is usually a missing row, a duplicated boundary transaction, or a sign error on one column, and all three have clean fixes once identified. A reconciled account is the proof the import is right; an unreconciled one is a warning that something is still off. For the matching workflow, see our guide on how to reconcile a bank statement.

Make the routine monthly rather than annual. A monthly import takes minutes, keeps bank rules current, and means December never becomes a catch-up project. File the original PDFs by year and account alongside the CSVs: the PDF is the bank-issued record, and the CSV is your working file.