RekeningKoran.id
ID EN

Import a PDF Bank Statement into Xero

No retyping: a whole statement done in seconds.

Drop your PDF bank statement (rekening koran) into the box below, then pick Xero in the Export for… menu on the statement result. You get a CSV file for one account, ready to import with Import a Statement in Xero.

Which statements would you like to convert?

Your file is never sent to a server. It's read right here in this browser, and gone when you close the tab. Check for yourself →

Not sure your bank works? Just try it. Nothing is uploaded, and if the file can't be read you'll see why.

    PDF · BCA, Mandiri, Jago, BNI, BRI, BSI, SeaBank, blu, GoPay, Gojek

    Free, no page limits ·No signup ·Never sent to a server

    • Processed on your computer
    • Every balance checked
    • No ads, no cookies

    What's in the Xero file from this page

    After the PDF is converted, pick Xero in the Export for… menu on the statement result. The CSV file you download contains:

    Column Contents
    Date Transaction date, in dd/mm/yyyy format
    Amount One amount column: money in is positive, money out is negative. Dot as the decimal separator, no thousands separators
    Description Transaction description from the bank statement
    Reference Reference number, filled only when the bank statement prints one

    The header row is in row 1. Each file holds one account, because Xero imports one file per bank account. Balance columns, the account number and empty rows are left out, as Xero's guide asks.

    How to import into Xero

    1. Step 1 in Xero: Accounting1Accounting
    2. Step 2 in Xero: Bank accounts2Bank accounts
    3. Step 3 in Xero: Import a Statement3Import a Statement
    4. Step 4 in Xero: Select file4Select file
    5. Step 5 in Xero: Next5Next
    6. Step 6 in Xero: Complete import6Complete import
    Import a bank statement in Xero (Xero) · Official guide →
    Illustration, not the official app screen
    1. On this page, drop your PDF bank statement into the box above, then pick Xero in the Export for… menu on the account you want to import.
    2. In Xero, go to Accounting > Bank accounts.
    3. Click the menu icon on the matching bank account, then choose Import a Statement.
    4. Under File to upload, drag in the CSV file from this page or click Select file, then click Next.
    5. Assign the columns. Date and Amount are required. Description and Reference are optional. Click Next.
    6. If Xero asks for the date format, choose DD/MM/YYYY. Xero keeps this choice for future imports.
    7. Review the transactions, then click Complete import.

    The Xero steps are taken from Xero's guide. The screens in the app may look slightly different.

    If the import fails

    • Amounts read wrong. Xero does not accept commas as decimal separators. Files from this page use a dot. If you opened the file in Excel and saved it again, numbers or dates may have changed format: download it again and upload the original file unchanged.
    • Many transactions. According to Xero's guide, one file can have at most 100,000 rows.
    • Several accounts. Import one file per bank account. Pick Xero in the Export for… menu for each account separately.
    • Rows flagged as not matching. If the balance check flags a row, compare it with the original bank statement before importing.

    Questions

    Which banks can I import into Xero with this page?

    Any bank this converter can read: BCA, Mandiri, Jago, GoPay history, plus BNI, BRI, BSI, SeaBank, blu and other banks in beta.

    Is my file sent to Xero or to your server?

    No. The PDF is read and converted in your browser. The CSV file is downloaded to your computer, and you upload it to Xero yourself.

    Are the numbers checked?

    Yes. Before download, each bank statement is checked: the opening balance plus the transactions must equal the printed balance. Rows that don't match are flagged on screen.

    Is Xero available in Indonesia?

    Xero has an Indonesia pricing page at xero.com/id/pricing-plans. Check plans and prices there.

    Updated: 2026-10-20

    Three steps

    How to convert a bank statement to Excel

    1. 1

      Drop your PDFs

      The original e-statement PDF from your bank, one or several at once. If the PDF is locked, enter its password.

    2. 2

      Look for the tick

      Preview every transaction. A green tick means opening balance + transactions = closing balance, and every row matches.

    3. 3

      Download Excel or CSV

      Several statements merge into one file, with a column showing where each row came from.

    Privacy and accuracy

    Your data stays on your computer

    Other converters upload your statement to their servers. Here, the PDF is read directly in your browser and never sent anywhere.

    Never uploaded

    The PDF is read and converted in your browser. The page is even locked so it cannot send data to other sites.

    Every balance checked

    Running balances are checked row by row. If anything doesn't match, the first wrong row is flagged.

    Free, no limits

    No signup, no credit card, no daily page limit.

    Password-protected PDFs

    Locked e-statements open with their password. The password is never stored.

    Many files at once

    A client's whole year of statements merged into one Excel file.

    Indonesian number formats

    1.234.567,89, DB/CR markers and dates without a year are read correctly, so the numbers in Excel are ready to sum.

    Check for yourself that nothing is uploaded

    1. Open your browser's Developer Tools (F12, or Cmd+Option+I on a Mac) and choose the Network tab.
    2. Drop your PDF onto this page and convert it.
    3. Look at the request list: none carries your file (small requests to /ingest are anonymous counts with no file content). You can also disconnect from the internet once the page has loaded, and conversion still works.

    For accountants & tax consultants

    Client bank statements, without retyping

    For accountants, tax consultants, audit firms and bookkeepers: many statements at once, numbers that are checked, and client data that never leaves your computer.

    A whole year at once

    Drop 12 or more PDFs at once. You get one Excel file, with the source file and account on every row.

    Straight into accounting software

    Export each account for Jurnal, Xero, QuickBooks, Odoo or Zoho Books, in each tool's own import format.

    Numbers you can stand behind

    Every running balance and total is checked against what the bank printed. Rows that don't match are flagged, so you know exactly what to look at.

    Client data stays confidential

    PDFs are read in your browser and never sent to a server. No account, and nothing is stored.

    Password-protected PDFs

    Enter the password once. Other files locked with the same password open too.

    Free, no limits

    No signup and no page limits, for one client or a hundred.

    More for accountants →

    Supported banks

    Supported banks and e-wallets

    BCA e-Statement Mandiri Livin' Jago Kantong GoPay Riwayat Gojek Perjalanan BNI beta BRI beta BSI beta SeaBank beta blu beta CIMB Niaga beta Danamon beta Permata beta OCBC beta UOB beta Panin beta bjb beta Other banks beta

    Beta means that format hasn't been tested on a real statement yet: results are still checked against the printed balances, but check them more carefully. Other banks can be tried too. Something not read? Use the Send an anonymised sample button or let us know, without sending your statement.