Built on Table Extractor

Extract EPFO EPF Passbook PDF to Excel

Need to export your EPF transaction passbook PDF into Excel for interest calculation or retirement planning? GoluPDF extracts EPFO transaction tables locally in your browser.

Browser-side Sub-second 4.9 / 5

Why use GoluPDFs for this?

  • 1Byte-perfect extraction of EPFO passbook tables
  • 2Separates employee share, employer share, and pension contribution fields
  • 3100% browser-based processing guarantees complete privacy of your UAN and balance
  • 4Instantly compiles multi-year transactions onto a single sheet

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

Comprehensive Guide: Exporting EPF Passbooks to Excel

The Employees' Provident Fund Organisation (EPFO) provides members with a monthly contribution ledger, also known as the EPF Passbook. This PDF contains critical fields: employer contributions, employee share deductions, pension fund credits, interest transactions, and cumulative balances.

For individuals auditing their pension funds, checking employer compliance, or calculating interest compounding payouts, copying data directly from the EPFO portal PDF is highly frustrating. It contains complex multi-page tables, headers, and footer details that break grid row mappings when copied.

Mapped EPF Passbook Ledger Columns

GoluPDF isolates the transaction tables of the passbook and structures them into six distinct ledger fields:

Excel HeaderEPF Matching FieldType
Date/MonthTransaction deposit timestampDate
ParticularsWage month description (e.g. "03/2026")Text
Employee ShareEmployee EPF deduction (12% of basic wage)Decimal
Employer ShareEmployer share (3.67% of wage)Decimal
Pension FundPension contribution (8.33% of wage)Decimal
Cr / DrInterest additions or withdrawal debitsDecimal

Security & Decryption Details

EPF passbooks downloaded directly from the EPFO unified member portal are standard PDFs but contain sensitive financial identity tags like your **Universal Account Number (UAN)**, PAN, and Member IDs.

🔒 Browser Sandbox Decryption: GoluPDF performs all decryption, text indexing, and table building locally on your device. We do not use third-party APIs or upload passbooks to servers. Your UAN, wage records, and provident balance remain private.

💡 Password Hint: If your EPF statement PDF is encrypted, the default password is usually a set combination of your birth year or account identifier. Input the decryption key locally when prompted.

EPFO Passbook Download & Verification Checklist

Verify your employer monthly credits with these simple auditing steps:

STEP 1Log in to the official EPFO Member Portal (passbook.epfindia.gov.in) using your UAN and Password.
STEP 2Select your Member ID block and download the PDF passbook for the current or previous financial year.
STEP 3Drag and drop the PDF into GoluPDF and select the EPFO passbook mapping configuration.
STEP 4Compare the Employee Share (12%) and Pension Share (8.33%) totals with your salary slips to detect credits mismatches.

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 password-protected or unlocked EPF passbook PDF to GoluPDF's Table Extractor, select EPFO preset mapping, and click run. Your passbook tables will compile into a downloadable Excel worksheet.