Extract National Pension System (NPS) PDF Statement to Excel
Export transaction records and asset allocations from your NPS CRA account statement PDF into clean Excel sheets. GoluPDF processes your files locally.
Drop your files here
or click to browse — up to 1 file
🔒 Your files never leave your device — processing happens in your browser.
Why use GoluPDFs for this?
- 1Predefined mapping for NSDL / KFintech NPS account statements
- 2Separates Tier-I and Tier-II account transactions and investment values
- 3100% browser-based calculations protect your PRAN and personal finance details
What you get inside Table Extractor
- Visual Table Grid Editor: Select, edit cells, delete rows/columns manually
- OCR Table Recovery Mode: Simulated parser interface to digitize scanned documents
- Merged Cells & Multi-Page Joining: Clean row grouping across pages
- Smart Column Mapper: Dropdown categorizer (Date, Description, Debit, Credit, etc.)
- Financial Template Presets: Invoice, Bank Statement, and Income Statement parser options
- Multi-Sheet Excel Export: Compile multiple parsed tables into separate sheet tabs natively
Technical Guide: Extracting NPS CRA Statements to Excel
The National Pension System (NPS) statement (issued by CRA NSDL or KFintech) tracks your retirement contributions. NPS features Tier-I accounts (mandatory pension lock-in, eligible for extra ₹50,000 deduction under Sec 80CCD(1B)) and Tier-II accounts (voluntary withdrawable investment).
An NPS transaction statement lists multiple pages of contribution tables, scheme holdings, asset classes (E, C, G, A), and transaction units. Copying this data directly breaks row schemas. GoluPDF parses your NPS statements locally, outputting structured Excel transaction ledgers.
NPS Excel Ledger Columns
Our tool extracts transaction dates, contributions, units allocated, NAV values, and investment amounts:
- PRAN: PRAN (Permanent Retirement Account Number) verification field.
- Tier Type: Separates Tier-I and Tier-II transactions.
- Contribution Amt: Net contribution amount before brokerage or fees.
- Asset Allocation: Splits units across Equity (E), Corporate Bonds (C), and G-Secs (G).
- NAV & Unit Allocation: Tracks NAV value and allocated pension units.
Secure Pension Statement Auditing
Your NPS statement contains your PRAN, financial holdings, employer details, and personal coordinates. Keeping this private is critical.
🔒 GoluPDF processes statements entirely client-side using local WebAssembly. No PRAN or retirement assets statistics are uploaded to third-party databases.
Disclaimer: GoluPDFs is a private, independent utility platform. It is not affiliated with, authorized, endorsed by, or in any way officially connected with the State Bank of India (SBI), HDFC Bank, ICICI Bank, Axis Bank, Kotak Mahindra Bank, Punjab National Bank (PNB), Bank of Baroda (BOB), Paytm, EPFO, CAMS, Karvy (KFintech), LIC, NPS, or any of their subsidiaries or affiliates. The official websites of these entities can be found at their respective domains. All product and service names, logos, brands, trademarks, and registered trademarks mentioned on this website are the property of their respective owners. Their use on GoluPDFs does not imply any affiliation with or endorsement by them.
🔒 Data Privacy: All document decryption, processing, and table extractions are conducted 100% client-side inside your browser sandbox using WebAssembly. No files or personal/financial data are uploaded, stored, or transmitted to our servers.
Frequently asked questions
Upload your CRA NPS statement PDF to GoluPDF's Table Extractor, select NPS mapping, and run. The holdings and transactions will parse to Excel.