How to Convert an Earnings Statement to CSV
Convert earnings statement PDFs to CSV format with AI extraction. Works with corporate, government, and university pay documents automatically.
An earnings statement is your employer’s detailed record of what you earned and what was deducted during a pay period. Many large corporations, government agencies, and universities use the term “earnings statement” instead of “pay stub” or “paycheck.” Whatever your employer calls it, the data locked inside that PDF is valuable — and converting it to CSV format makes it usable for financial planning, tax preparation, and income verification.
Quick Summary: Upload your earnings statement PDF to StubToCSV for instant AI-powered extraction to CSV. Dual verification handles corporate, government, and academic payroll formats automatically. Under 30 seconds, no templates required.
Earnings Statement vs. Pay Stub: Is There a Difference?
The terms are often used interchangeably, but there are subtle distinctions in how different employers use them.
| Term | Typical Employer | Usually Includes |
|---|---|---|
| Earnings statement | Large corporations, universities, government | Detailed breakdown with leave balances, retirement, benefits |
| Pay stub | Small/mid-size businesses | Core earnings, taxes, deductions, net pay |
| Pay advice | Financial institutions, some enterprises | Similar to earnings statement |
| Leave and earnings statement (LES) | US military and federal government | Full earnings plus detailed leave tracking |
Note: Earnings statements from large employers tend to be more detailed than pay stubs from small businesses. They often include additional information like leave balances, retirement plan details, and employer-paid benefits — all of which StubToCSV extracts.
Step-by-Step Conversion
-
Download your earnings statement. Access your employer’s portal (Workday, Oracle, SAP, PeopleSoft, or similar). Navigate to your pay documents and download the PDF.
-
Upload to StubToCSV. Go to the CSV converter and upload your PDF.
-
Dual-AI extraction runs. Two independent AI models extract and verify every field from your earnings statement. Processing takes under 30 seconds.
-
Review and download. Check the structured output and download as CSV.
What Gets Extracted
Earnings statements typically contain more detail than simple pay stubs. Here is what a thorough extraction captures.
| Category | Fields | Why It Matters |
|---|---|---|
| Personal info | Employee ID, name, department, cost center | Record identification |
| Pay period | Dates, pay frequency, check number | Period tracking |
| Earnings | Base pay, overtime, differentials, bonuses, allowances | Income analysis |
| Federal taxes | Federal withholding, FICA, Medicare | Tax reconciliation |
| State/local taxes | State withholding, city/county taxes, SDI | Multi-jurisdiction tracking |
| Pre-tax deductions | Retirement, HSA, FSA, medical, dental, vision | Benefits cost analysis |
| Post-tax deductions | Roth, union dues, garnishments, charity | After-tax obligations |
| Employer contributions | Retirement match, insurance share, TSP | Total compensation picture |
| Leave balances | Vacation, sick, personal, comp time | Time-off tracking |
| YTD totals | Running totals for all categories | Year-end reconciliation |
Common Earnings Statement Sources
| System | Common Employer Type | Layout Complexity |
|---|---|---|
| Workday | Enterprise corporations | Multi-section, detailed |
| Oracle/PeopleSoft | Large enterprises, universities | Dense, multi-page possible |
| SAP | Global corporations | Structured with cost centers |
| DFAS (myPay) | US military and DoD civilians | LES format with leave detail |
| NFC | Federal civilian agencies | Standard federal format |
| ADP Enterprise | Large corporations | Complex multi-section |
| Ellucian Banner | Universities | Academic pay with stipends |
StubToCSV’s AI handles all of these formats because it reads contextually rather than relying on templates. Whether your earnings statement comes from a Fortune 500 company or a state university, the extraction adapts automatically.
Why CSV Format for Earnings Statements?
CSV is particularly well-suited for earnings statement data because of how the data is typically used.
| Use Case | Why CSV Works Best |
|---|---|
| Import into accounting software | QuickBooks, Xero, and others accept CSV imports |
| Database storage | CSV imports directly into SQL databases |
| Programmatic analysis | Python, R, and Excel macros process CSV natively |
| Cross-system integration | CSV is the universal exchange format |
| Archival records | No proprietary format dependencies |
Tip: If you need to import earnings data into QuickBooks or another accounting system, CSV is almost always the required import format. Converting your earnings statement to CSV eliminates the intermediate step of manual data entry into the accounting system.
Use Cases for Converted Data
Federal employee tax preparation. Federal earnings statements (LES) contain detailed TSP contributions, FEHB premiums, and FERS/CSRS retirement deductions. Converting to CSV makes it easy to verify your W-2 against YTD totals and ensure your TSP contributions match your annual goals.
University employee benefits analysis. Academic earnings statements often include tuition remission, research stipends, and summer salary in addition to base pay. A spreadsheet lets you separate these income types for accurate financial planning.
Corporate compensation reviews. When preparing for a salary negotiation or evaluating a job offer, converting your earnings statement shows your complete compensation — including employer-paid benefits that do not appear in your net pay.
Leave balance tracking. Many earnings statements show leave accrual and usage. Converting multiple statements to a spreadsheet lets you track your vacation and sick leave balances over time.
Pro Tip: If you are a federal employee, convert your LES and compare the TSP contribution amount to the annual limit. Also verify that your FERS contribution rate is correct — it should be 0.8%, 1.0%, 1.3%, or 4.4% depending on when you were hired.
Get Started
Convert your earnings statement to CSV with StubToCSV. AI-powered dual extraction handles corporate, government, and academic payroll formats. Try it free — Pro plans for regular conversions.