Bank Statement to QuickBooks
Convert a text-based bank statement PDF, or the CSV or Excel download, into a QuickBooks Online 3-column CSV: Date, Description and Amount, with money in as a positive amount and money out as a negative one. Every row is checked against the running balance before you download, and nothing leaves your browser.
Your statement stays on your device. The PDF or spreadsheet is read by your browser and is never uploaded to ERPPlugs or anyone else. No account is needed, and nothing is stored after you close the page.
Choose your statement
A text-based PDF downloaded from net banking, or the CSV / Excel (.xlsx) download. Password-protected PDFs are fine: you will be asked for the password, and it never leaves your browser.
How It Works with QuickBooks
QuickBooks Online can upload bank transactions from a CSV file in a 3-column layout (Date, Description, Amount) or a 4-column layout (Date, Description, Credit, Debit). The converter writes the 3-column layout, with dd/mm/yyyy dates and amounts without thousands separators; choose that date format when QuickBooks asks. It does not produce QBO (Web Connect) files.
Step 1: Convert the Statement
The QuickBooks download is CSV (QuickBooks Online 3-column) with these columns: Date, Description, Amount.
- 1
Choose the statement
Pick a text-based bank statement PDF (enter the password if it is protected) or the CSV or Excel download. The file is read in your browser and never uploaded.
- 2
Check the rows
The converter finds the table from its column headers, then checks every row against the running balance and the totals against the closing balance. Flagged rows can be edited or deleted in the preview.
- 3
Download
Download the QuickBooks (CSV (QuickBooks Online 3-column)) file. Downloads use the rows exactly as they appear in the preview, including your edits.
Step 2: Import Into QuickBooks
- Convert the statement above, check the flagged rows, then download the QuickBooks CSV.
- In QuickBooks Online, open the banking area and choose the option to upload transactions from a file.
- Select the CSV and the bank account it belongs to.
- Map Date, Description and Amount, choose the dd/MM/yyyy date format, then review the transactions before adding or matching them.
Menu names can differ between QuickBooksversions; check your version's help if an option is labelled differently.
Checks Before You Import
A converted statement is only useful if it agrees with the bank's own balances. The converter runs the first two checks for you; do the last two by eye before you import the CSV (QuickBooks Online 3-column) file.
Running balance, row by row
For every row, the previous balance minus the withdrawal plus the deposit must equal the balance printed on the bank statement, within one paisa. A row that fails usually means a misread amount, a missed row or a junk line.
Opening to closing balance
The opening balance plus total deposits minus total withdrawals should equal the closing balance. For example, an opening balance of ₹1,00,000 with ₹2,50,000 of deposits and ₹1,80,000 of withdrawals should close at ₹1,70,000.
Date range
The first and last dates shown should match the statement period you downloaded, with no pages missing in between.
References intact
Spot-check a few UPI, NEFT and cheque rows to confirm the full narration came through, because that text is what you match against ledger entries.
If a check fails, fix or delete the row in the converter's preview table before downloading rather than editing the file afterwards, so the export and the statement stay in step.
Bank Statement Pages
Notes on common statement layouts. The converter is not limited to these banks: any text-based statement with a recognisable header row can be tried.
Frequently Asked Questions
CSV (QuickBooks Online 3-column) with the columns Date, Description, Amount. Dates are written as dd/mm/yyyy (real Excel dates in .xlsx files), and amounts are plain numbers without thousands separators.
It has no per-bank templates. It reads text-based statements whose table has a recognisable header row, using common Indian bank column names such as Narration, Particulars, Withdrawal Amt., Deposit Amt., Debit, Credit and Closing Balance. Bank pages for HDFC Bank, SBI, ICICI Bank, Axis Bank and others are linked on this page; statements from other banks can be tried the same way.
Each row is checked against the running balance (previous balance minus withdrawal plus deposit must equal the printed balance), and the opening balance plus deposits minus withdrawals is compared with the closing balance. Failed rows are flagged in the preview, where you can edit or delete them before downloading.
No. The browser tool reads the text layer of a PDF and does not do OCR. If a PDF has no text layer, as with a scanned or photographed statement, the tool says so. Download the statement again from internet banking as a PDF, CSV or Excel file instead.
No. The converter runs entirely in your browser. The PDF or spreadsheet is read on your device, nothing is uploaded to ERPPlugs or anyone else, and nothing is kept after you close the page. A PDF password is used only to open the file in that browser tab.
Other Output Formats
Bank statements, ready for QuickBooks
- Free consultation
- No commitment
- Tailored to your team