Open Statements in Kotak Net Banking, choose Account Statements and Download Statements, save the correct PDF, then verify transaction direction and balances before using Excel.
Kotak Mahindra Bank publishes a Net Banking sitemap that identifies the account-statement path: Statements, Account Statements, Download Statements, and Download. The same official document also distinguishes current and past billed credit card statements under the Cards menu.
Use the bank-generated PDF as the source record. Convert it into a working spreadsheet only after checking the account, period, withdrawal and deposit direction, wrapped descriptions, and running balance.
- Follow the official Kotak Net Banking statement menu
- Choose the right account and a complete statement period
- Preserve date, description, reference, withdrawal, deposit, and balance
- Keep account and credit card statement paths separate
Download an Account Statement in Kotak Net Banking
Sign in through the official Kotak Net Banking channel. Open Statements from the left menu, choose Account Statements, then Download Statements. Select the account and statement options shown in your authenticated session and use Download to save the file.
Open the PDF before conversion and confirm the account label, covered dates, and page count. Keep the original file unchanged; renaming it with a masked account label and period is fine, but printing it to an image removes useful document structure.
- Use only Kotak official Net Banking or Mobile Banking channels.
- Open Statements before Account Statements.
- Choose Download Statements rather than copying visible activity.
- Verify the account and period after the PDF opens.
Know the Separate Kotak Credit Card Paths
Kotak documents credit card statements separately from bank account statements. For a current card statement, the path is Cards, Credit Card, Statement, and Current Statement. For an older billed cycle, choose Past Billed Statement instead.
Do not combine a Kotak deposit-account PDF and a Kotak card PDF as though they share the same debit and credit meaning. Card purchases, payments, refunds, and fees follow card-account direction, while withdrawals and deposits describe cash movement in a bank account.
Choose a Complete Statement Period
Decide the required period before downloading. Monthly bookkeeping needs complete, non-overlapping months; an audit, tax, loan, or visa request may need a longer range. If the site creates several PDFs, list the expected periods and check them off before combining rows.
A successful download can still contain the wrong account or month. Compare the first and last dates in the PDF with the requested period, and confirm that every page opens before upload.
- Keep separate accounts in separate source files.
- Avoid overlaps when joining monthly statements.
- Retain a source-file column in a combined workbook.
- Prefer the statement PDF to screenshots of transaction history.
Handle Protected PDFs Without Sharing Banking Credentials
If the downloaded PDF is protected, follow the document-password instructions supplied by Kotak for that file. A statement password is used to unlock the document; it is never a reason to disclose a Net Banking password, OTP, card PIN, CVV, or remote access.
Opening the file and extracting it are separate checks. After the document is unlocked, compare the resulting table with the PDF before treating the conversion as complete.
Convert the Kotak PDF to Excel or CSV
Upload the account statement to the Kotak converter. Supported layouts can preserve date, description, cheque or reference number, withdrawal, deposit, and balance. Search for a familiar UPI, NEFT, IMPS, ATM, interest, or charge row in the preview before export.
Choose Excel for formulas and review, CSV for a portable table, or an accounting format only after validation. Keep amount columns numeric and preserve the original description so a reviewer can trace the row back to the source statement.
Validate Transactions and Running Balances
Match one withdrawal, one deposit, and one charge or interest row when available. Check transactions immediately before and after page breaks, and confirm that repeated headers or opening and closing balance labels did not become transaction rows.
Use the running balance as a strong review signal. A withdrawal should reduce the prior balance and a deposit should increase it, subject to the ordering printed by the bank. Investigate unexplained balance jumps rather than editing an amount to force agreement.
- Compare the first and final transaction with the PDF.
- Check long descriptions and reference numbers for line wrapping.
- Confirm debit and credit totals use only transaction rows.
- Keep a note for every manual correction.
Troubleshoot Missing or Messy Rows
If rows are missing, confirm the source period, PDF page count, and password first. Image-only printouts and unfamiliar layouts may need the AI converter and a closer review. When several statements are combined, check period overlap and source filenames before assuming the parser duplicated rows.
Return to the affected PDF page for every uncertain value. The goal is a traceable working file, not a spreadsheet that merely looks complete.
A Kotak account PDF becomes a traceable workbook
A business owner converts one quarter and checks UPI, fee, income, and interest rows before sending the file to an accountant.
- Period: 3 months
- Source files: 1 PDF
- Review samples: 6
| Date | Description | Reference | Withdrawal | Deposit | Balance |
|---|---|---|---|---|---|
| 04 Jan | Salary credit | NEFT...001 | 85,000.00 | 85,000.00 | |
| 06 Jan | UPI food order | UPI...314 | 780.00 | 84,220.00 | |
| 08 Jan | Debit card annual fee | TBMS...222 | 236.00 | 83,984.00 | |
| 31 Mar | Interest paid | 4.00 | 105,489.00 |
- Withdrawal and deposit values stay in separate columns.
- References remain available for matching and support follow-up.
- The final balance is checked against the source PDF.
Result: The accountant receives searchable rows with the source period, account context, and PDF retained for traceability.
Account statement vs credit card statement
| Decision point | Without this workflow | With Parse Statement |
|---|---|---|
| Official menu | Statements and Account Statements | Cards, Credit Card, and Statement |
| Amount meaning | Withdrawals reduce bank cash | Purchases increase card liability |
| Period choice | Custom account statement range | Current or past billed cycle |
Real use cases
Business owner
Need: Prepare quarterly Kotak activity.
Outcome: Checks balances and sends the PDF plus workbook to an accountant.
Accountant
Need: Trace UPI and transfer rows.
Outcome: Uses descriptions, references, and source filenames for matching.
Cardholder
Need: Find an older billed card cycle.
Outcome: Uses Past Billed Statement instead of the deposit-account menu.
Frequently asked questions
How do I download a Kotak Bank account statement?
Kotak documents this Net Banking path: Statements, Account Statements, Download Statements, then Download. Select the required account and statement options shown after sign-in.
How do I find a Kotak credit card statement?
Under Cards, choose Credit Card and Statement. Use Current Statement for the active cycle or Past Billed Statement for an older billed cycle.
Can I convert a Kotak statement PDF to Excel?
Yes. Upload the PDF to the Kotak converter, review date, description, reference, withdrawal, deposit, and balance fields, then export the checked rows.
What if my Kotak PDF needs a password?
Use the document-password instructions supplied by Kotak for that statement. Never enter or share a Net Banking password, OTP, card PIN, or CVV.
Should I combine Kotak bank and card statements?
Keep them as separate source accounts. Their amount direction and statement summaries differ. Combine reviewed rows only when the destination model preserves account and document type.
Is the converted Excel file an official statement?
No. The downloaded Kotak PDF remains the bank statement. Excel or CSV is a derived working file for review and accounting.