RekeningKoran.id
ID EN

Import a PDF Bank Statement into Zoho Books

No retyping: a whole statement done in seconds.

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

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 Zoho Books file from this page

    After converting, pick Zoho Books in the Export for… menu on the statement result. You get a CSV file with these columns:

    Column Contents
    Date Transaction date, in dd-mm-yyyy format
    Description Transaction description
    Deposit Money in (the Kredit column on the bank statement)
    Withdrawal Money out (the Debit column on the bank statement)
    Reference Reference number, only when the statement prints one

    All amounts are positive, and each row fills only one of Deposit or Withdrawal. Each file holds one account. Nothing is uploaded to our server: the file is made in your browser, and you upload it to Zoho Books yourself. Balances are checked before download.

    How to import into Zoho Books

    1. Step 1 in Zoho Books: Banking1Banking
    2. Step 2 in Zoho Books: Select the bank account2Select the bank account
    3. Step 3 in Zoho Books: Import Statement3Import Statement
    4. Step 4 in Zoho Books: Configure4Configure
    5. Step 5 in Zoho Books: Map Fields5Map Fields
    6. Step 6 in Zoho Books: Preview6Preview
    7. Step 7 in Zoho Books: Import7Import
    Import a bank statement in Zoho Books (Zoho Books) · Official guide →
    Illustration, not the official app screen
    1. On this page, drop your PDF bank statement into the box above, then pick Zoho Books in the Export for… menu on the account you want to import.
    2. In Zoho Books, open Banking and select the matching bank account.
    3. Click Import Statement and select the CSV file from this page.
    4. Go through the Configure, Map Fields and Preview steps. In Map Fields, choose Double Column for amounts, because money in and money out are in separate columns.
    5. Click Import. The rows appear as uncategorized transactions.

    The Zoho Books steps are taken from the Zoho Books help centre. The screens in the app may look slightly different. Besides CSV, Zoho Books also accepts TSV, XLS, OFX, QIF and CAMT.053/054 files.

    If the import fails

    • Amounts rejected. According to the Zoho Books import error guide, amounts must be positive in the Double Column layout. Files from this page already are. Make sure you chose Double Column, not a single-column option.
    • Dates not read. The same guide gives the date format DD-MM-YYYY, which is what files from this page use. If you opened the file in Excel and saved it again, the dates may have changed: download it again and upload the original file.
    • Rows flagged as not matching. If the balance check flags a row, compare it with the original bank statement before importing.

    According to the Zoho Books release notes, Bahasa Indonesia was added to Zoho Books in April 2020.

    Questions

    Which banks can I import into Zoho Books 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 Zoho Books 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 Zoho Books 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.

    Which option do I pick when mapping amounts?

    Pick Double Column. The file from this page has separate Deposit and Withdrawal columns, and all amounts are positive.

    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.