RekeningKoran.id
ID EN

Import a PDF Bank Statement into QuickBooks Online

No retyping: a whole statement done in seconds.

Drop your PDF bank statement (rekening koran) into the box below, then pick QuickBooks in the Export for… menu on the statement result. You get a 3-column CSV file for one account, ready to upload with Upload from file in QuickBooks Online.

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

    After the PDF is converted, pick QuickBooks in the Export for… menu on the statement result. The CSV file you download uses the QuickBooks Online 3-column format:

    Column Contents
    Date Transaction date, in dd/mm/yyyy format
    Description Transaction description from the bank statement
    Amount One amount column: positive for money in, negative for money out

    All dates use one format, dd/mm/yyyy, as Intuit recommends. Each file holds one account, because each upload goes into one QuickBooks account.

    How to upload to QuickBooks Online

    1. Step 1 in QuickBooks: Accounting1Accounting
    2. Step 2 in QuickBooks: Bank transactions2Bank transactions
    3. Step 3 in QuickBooks: Link account3Link account
    4. Step 4 in QuickBooks: Upload from file4Upload from file
    5. Step 5 in QuickBooks: Continue5Continue
    6. Step 6 in QuickBooks: Yes6Yes
    7. Step 7 in QuickBooks: Done7Done
    Upload transactions in QuickBooks Online (QuickBooks) · Official guide →
    Illustration, not the official app screen
    1. On this page, drop your PDF bank statement into the box above, then pick QuickBooks in the Export for… menu on the account you want to import.
    2. In QuickBooks Online, go to Accounting > Bank transactions.
    3. Click the arrow on Link account, then choose Upload from file.
    4. Drag in the CSV file from this page or select it, then click Continue.
    5. Choose the QuickBooks account, then match the Date, Description and Amount columns.
    6. Select the transactions to import, click Continue, then Yes.
    7. Click Done.

    The QuickBooks steps are taken from the QuickBooks help centre. The screens in the app may look slightly different.

    If the import fails

    • File too large. According to the QuickBooks help centre, one upload can be 350 KB or less and up to 1,000 lines. If your statement is longer, split it into several files, for example by converting one month's PDF at a time.
    • Dates read wrong. Files from this page use dd/mm/yyyy on every row. If you opened the file in Excel and saved it again, the dates may have changed format: download it again and upload the original file unchanged.
    • Several accounts. Each upload goes into one account. Pick QuickBooks 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 QuickBooks 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 QuickBooks 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 QuickBooks 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.

    Does QuickBooks support Indonesian rupiah?

    IDR is on QuickBooks' list of supported currencies for multicurrency. See the list in the QuickBooks help centre.

    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.