AI-Pay Stub, Payslip Parser in Power Automate

PDF4me AI-Pay Stub, Payslip Parser extracts structured data from pay stubs and payslips using AI-powered machine learning through Power Automate flows. Process pay stub PDFs or images via Power Automate triggers, binary data, base64 strings, or public URLs to automatically extract gross pay, net pay, tax information, employee details, employer information, earnings breakdown, deductions, benefits, year-to-date totals, and other pay stub fields with high accuracy and intelligent field recognition. This solution is ideal for pay stub processing automation, payroll digitization, employee verification, income verification, tax document processing, automated payroll data extraction, wage statement processing, and pay stub management workflows that require AI-powered extraction with structured output and seamless Microsoft 365 integration.

Authenticating Your API Request

To access the PDF4me Web API through Power Automate, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Power Automate flows and PDF4me's powerful AI-powered pay stub processing services.

Get your API Key

Key Features

• AI-Powered Extraction: Advanced machine learning technology for accurate pay stub data extraction
• Multi-Format Support: Process pay stubs and payslips in PDF, PNG, JPG, and JPEG formats
• Comprehensive Financial Information: Extract gross pay, net pay, pay period, and pay date
• Tax Details Extraction: Extract federal income tax, state income tax, social security tax, Medicare tax, and local city tax
• Employee Information: Extract employee name, ID/SSN, address, and job title
• Employer Information: Extract company name, employer address, and employer EIN
• Earnings Breakdown: Extract regular hours, overtime hours, rates, and total hours
• Deductions & Benefits: Extract health insurance, retirement 401k, other benefits, and garnishments
• Year-to-Date Totals: Extract YTD gross pay, net pay, federal tax, and state tax
• Additional Details: Extract check number, direct deposit information, vacation/sick time, and commission/bonus
• Flexible Data Structure: Dictionary-based field extraction for dynamic and extensible data access
• Microsoft 365 Integration: Seamlessly integrate extracted data with SharePoint, Excel, Dynamics 365, and Power BI

Parameters

Complete list of parameters for the AI-Pay Stub, Payslip Parser action. Configure these parameters to control pay stub processing and data extraction.

Important: Parameters marked with an asterisk (***) are required and must be provided for the action to function correctly.

Document Source Parameters

Parameter	Type	Description	Example
Pay Stub File Content***	Binary	Source Pay Stub/Payslip Binary Data • Map pay stub or payslip file content from previous Power Automate action • Supports dynamic expressions: body('Get_file_content') • Compatible with Dropbox, SharePoint, OneDrive, and email attachments • Supports .pdf, .png, .jpg, .jpeg formats	body('Get_file_content')
Pay Stub Name***	String	Pay Stub/Payslip File Identifier with Extension • Specify the name of the input pay stub or payslip file with proper extension • Used for format detection and AI processing optimization • Supports dynamic naming from flow variables • Must include file extension (.pdf, .png, .jpg, .jpeg) • Enables document tracking in logs and audit trails	paystub_2024_03.pdf

Advanced Parameters

Parameter	Type	Description	Example
Body/customFieldKeys	Array	Optional Custom Field Keys List • Optional list of custom field keys to extract from the pay stub or payslip • Specify additional fields beyond standard pay stub data • Supports multiple custom field keys for enhanced data extraction • Enables extraction of domain-specific or custom pay stub fields • Each item in the array represents a custom field key to extract	["customField1", "customField2"]

Output

The PDF4me AI-Pay Stub, Payslip Parser action returns comprehensive output data for seamless Power Automate flow integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
fields	Object	Dictionary object containing extracted pay stub fields where each key is a field name and each value is a FieldData object with a Value property
grossPay	Number	The gross pay amount before deductions, with precise decimal handling
netPay	Number	The net pay amount after all deductions, with precise decimal handling
payPeriod	String	The pay period for the pay stub (e.g., "Bi-weekly", "Monthly", "2024-01-01 to 2024-01-15")
payDateStr	String	The pay date extracted and formatted in ISO 8601 format (YYYY-MM-DD)
federalIncomeTax	Number	The federal income tax amount deducted, with precise decimal handling
stateIncomeTax	Number	The state income tax amount deducted, with precise decimal handling
socialSecurityTax	Number	The Social Security tax amount deducted, with precise decimal handling
medicareTax	Number	The Medicare tax amount deducted, with precise decimal handling
localCityTax	Number	The local or city tax amount deducted, with precise decimal handling
employeeName	String	The name of the employee extracted from the pay stub
employeeIdSsn	String	The employee ID or Social Security Number (often masked for security)
employeeAddress	String	The address of the employee extracted from the pay stub
jobTitle	String	The job title or position of the employee
companyName	String	The name of the company or employer extracted from the pay stub
employerAddress	String	The address of the employer extracted from the pay stub
employerEin	String	The Employer Identification Number (EIN) extracted from the pay stub
regularHours	Number	The number of regular hours worked during the pay period
overtimeHours	Number	The number of overtime hours worked during the pay period
regularRate	Number	The regular hourly rate of pay, with precise decimal handling
overtimeRate	Number	The overtime hourly rate of pay, with precise decimal handling
totalHours	Number	The total hours worked during the pay period
healthInsurance	Number	The health insurance deduction amount, with precise decimal handling
retirement401k	Number	The retirement 401k deduction amount, with precise decimal handling
otherBenefits	Number	The amount deducted for other benefits, with precise decimal handling
garnishments	Number	The amount deducted for garnishments, with precise decimal handling
ytdGrossPay	Number	The year-to-date gross pay total, with precise decimal handling
ytdNetPay	Number	The year-to-date net pay total, with precise decimal handling
ytdFederalTax	Number	The year-to-date federal tax total, with precise decimal handling
ytdStateTax	Number	The year-to-date state tax total, with precise decimal handling
checkNumber	String	The check number or payment reference number
directDepositInfo	String	The direct deposit information including account details
vacationSickTime	String	The vacation and sick time balance information
commissionBonus	Number	The commission or bonus amount, with precise decimal handling
warnings	Array	Array of warning messages indicating potential data quality issues or extraction challenges encountered during processing
fallbackUsed	Boolean	Boolean flag indicating whether fallback extraction methods were used during processing
rawOcrText	String	The raw OCR text extracted from the pay stub document
jobId	String	Unique identifier for the AI processing job, used for tracking and debugging
jobIdExt	String	External job identifier for integration with third-party systems, if applicable
success	Boolean	Boolean flag indicating the success or failure of the AI-powered pay stub data extraction
message	String	Descriptive message indicating the result of the AI-powered pay stub data extraction process

JSON

JSON Response Format

The raw JSON response from the action:

{
  "fields": {
    "grossPay": {
      "value": "5000.00"
    },
    "netPay": {
      "value": "3750.00"
    },
    "payPeriod": {
      "value": "Bi-weekly"
    },
    "payDate": {
      "value": "2024-03-15"
    }
  },
  "grossPay": 5000.00,
  "netPay": 3750.00,
  "payPeriod": "Bi-weekly",
  "payDateStr": "2024-03-15",
  "federalIncomeTax": 650.00,
  "stateIncomeTax": 250.00,
  "socialSecurityTax": 310.00,
  "medicareTax": 72.50,
  "localCityTax": 50.00,
  "employeeName": "John Michael Smith",
  "employeeIdSsn": "XXX-XX-1234",
  "employeeAddress": "123 Main Street, New York, NY 10001",
  "jobTitle": "Software Engineer",
  "companyName": "Tech Corporation Inc.",
  "employerAddress": "456 Business Park, New York, NY 10002",
  "employerEin": "12-3456789",
  "regularHours": 80.00,
  "overtimeHours": 5.00,
  "regularRate": 50.00,
  "overtimeRate": 75.00,
  "totalHours": 85.00,
  "healthInsurance": 200.00,
  "retirement401k": 250.00,
  "otherBenefits": 50.00,
  "garnishments": 0.00,
  "ytdGrossPay": 30000.00,
  "ytdNetPay": 22500.00,
  "ytdFederalTax": 3900.00,
  "ytdStateTax": 1500.00,
  "checkNumber": "12345",
  "directDepositInfo": "Account ending in 1234",
  "vacationSickTime": "Vacation: 10 days, Sick: 5 days",
  "commissionBonus": 500.00,
  "warnings": [],
  "fallbackUsed": false,
  "rawOcrText": "PAY STUB...",
  "jobId": "12345678-1234-1234-1234-123456789012",
  "jobIdExt": "PAY-2024-001",
  "success": true,
  "message": "Pay stub data extracted successfully using AI technology"
}

Flow Integration

Power Automate Flow Usage

The extracted pay stub data enables powerful automation across Microsoft ecosystem:

• SharePoint Lists: Store extracted pay stub data in SharePoint lists for payroll management
• Excel Integration: Export pay stub data to Excel workbooks for payroll analysis and reporting
• Dynamics 365: Create payroll records in Dynamics 365 Finance automatically
• SQL Database: Insert extracted pay stub data into SQL Server databases for payroll systems
• Power BI: Feed pay stub data into Power BI dashboards for payroll analytics
• Email Notifications: Send pay stub processing confirmations via Outlook
• Approval Workflows: Route pay stubs for verification using Power Automate approvals
• Income Verification: Verify employee income using extracted pay stub data
• Tax Reporting: Generate tax reports from extracted pay stub information
• Document Storage: Link extracted pay stub data with original documents in SharePoint document libraries

Workflow Examples

The PDF4me AI-Pay Stub, Payslip Parser action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

Payroll Processing Automation

Automated Payroll Processing Workflow

Streamline payroll processing with AI-powered pay stub data extraction:

Complete Workflow Steps:

1. Trigger: Pay stub uploaded to SharePoint or received via email
2. AI Pay Stub Parser: Extract earnings, taxes, deductions, and employee information using PDF4me AI
3. Data Validation: Validate extracted gross pay, net pay, and tax amounts
4. Employee Verification: Verify employee name and ID against employee database
5. Create Payroll Record: Insert pay stub data into Dynamics 365 Finance or payroll system
6. Update SharePoint: Store extracted pay stub data in SharePoint list with metadata
7. Tax Calculation Verification: Verify tax calculations match payroll system records
8. Approval Workflow: Route pay stubs for manager approval if discrepancies found
9. Email Notification: Notify payroll team with pay stub processing summary
10. Archive: Move processed pay stub to archive folder with extracted metadata

Business Benefits:

• Automates pay stub data entry for payroll processing
• Reduces manual data entry time by 90%
• Eliminates human errors in payroll processing
• Accelerates payroll processing cycles
• Maintains complete audit trail of all processed pay stubs

Create Flow

Income Verification Automation

Automated Income Verification Workflow

Verify employee income using extracted pay stub data:

Complete Workflow Steps:

1. Trigger: Pay stub received for income verification request
2. AI Pay Stub Parser: Extract gross pay, net pay, YTD totals, and employee information
3. Income Calculation: Calculate average income from extracted pay stub data
4. YTD Verification: Verify YTD totals for annual income verification
5. Employee Matching: Match extracted employee name and ID with verification records
6. Create Verification Record: Document income verification results in SharePoint list
7. Update Verification System: Link verified income information to verification system
8. Approval Routing: Route high-value verifications for manager review
9. Notification: Send income verification results to verification team
10. Archive: Store processed pay stub with verification metadata

Business Benefits:

• Automated income verification using pay stub data
• Faster income verification processes
• Improved accuracy in income verification
• Real-time income verification capabilities
• Streamlined verification workflows

Create Flow

Tax Reporting Automation

Automated Tax Reporting Workflow

Generate tax reports using extracted pay stub data:

Complete Workflow Steps:

1. Trigger: Pay stub uploaded to SharePoint tax reporting folder
2. AI Pay Stub Parser: Extract tax information, YTD totals, and employee data
3. Tax Data Aggregation: Aggregate tax data from multiple pay stubs
4. Tax Report Generation: Generate tax reports from extracted pay stub data
5. Excel Export: Export tax data to Excel workbook for tax reporting
6. Power BI Update: Send tax data to Power BI dataset for tax analytics
7. Compliance Check: Verify tax compliance using extracted tax information
8. Tax Filing: Prepare tax filing data from aggregated pay stub information
9. Reporting: Generate quarterly and annual tax reports
10. Archive: Store processed pay stubs with tax reporting metadata

Business Benefits:

• Automated tax reporting from pay stub data
• Real-time tax data aggregation and reporting
• Improved tax compliance and accuracy
• Faster tax reporting processes
• Comprehensive tax analytics and insights

Create Flow

Employee Onboarding Automation

Automated Employee Onboarding Workflow

Streamline employee onboarding using extracted pay stub data:

Complete Workflow Steps:

1. Trigger: Pay stub uploaded during employee onboarding process
2. AI Pay Stub Parser: Extract employee information, job title, and employer details
3. Employee Record Creation: Create employee record in HR system using extracted data
4. Payroll Setup: Configure payroll settings using extracted pay stub information
5. Benefits Enrollment: Process benefits enrollment using extracted deduction information
6. Tax Setup: Configure tax withholding using extracted tax information
7. Direct Deposit Setup: Configure direct deposit using extracted direct deposit information
8. Update SharePoint: Store employee onboarding data in SharePoint list
9. Notification: Send onboarding confirmation to HR team
10. Archive: Store processed pay stub with onboarding metadata

Business Benefits:

• Automated employee onboarding using pay stub data
• Faster onboarding processes
• Improved accuracy in employee data entry
• Streamlined payroll and benefits setup
• Enhanced employee onboarding experience

Create Flow

Industry Use Cases & Applications

Human Resources & Payroll

Human Resources & Payroll Use Cases

• Payroll Processing: Automate payroll processing using extracted pay stub data
• Employee Verification: Verify employee information using extracted pay stub details
• Benefits Administration: Manage benefits using extracted deduction information
• Tax Reporting: Generate tax reports from extracted pay stub data
• Employee Onboarding: Streamline employee onboarding using pay stub information

Finance & Accounting

Finance & Accounting Use Cases

• Financial Reporting: Generate financial reports from extracted pay stub data
• Expense Tracking: Track employee expenses using extracted pay stub information
• Budget Management: Manage budgets using extracted payroll data
• Audit Compliance: Maintain audit trails using extracted pay stub data
• Financial Analytics: Analyze payroll costs using extracted pay stub information

Banking & Financial Services

Banking & Financial Services Use Cases

• Loan Processing: Verify income for loan applications using extracted pay stub data
• Credit Verification: Verify creditworthiness using extracted income information
• Mortgage Processing: Process mortgage applications using extracted pay stub data
• Income Verification: Verify income for financial services using extracted pay stub information
• Compliance Tracking: Track compliance using extracted pay stub data

Government & Public Sector

Government & Public Sector Use Cases

• Benefits Verification: Verify eligibility for government benefits using extracted pay stub data
• Tax Compliance: Ensure tax compliance using extracted tax information
• Public Records: Manage public records using extracted pay stub data
• Compliance Reporting: Generate compliance reports from extracted pay stub information
• Audit Trails: Maintain audit trails for government payroll processing

Real Estate & Rental

Real Estate & Rental Use Cases

• Rental Applications: Verify income for rental applications using extracted pay stub data
• Tenant Verification: Verify tenant income using extracted pay stub information
• Lease Processing: Process lease applications using extracted income data
• Property Management: Manage properties using extracted tenant income information
• Compliance Tracking: Track compliance with rental regulations using pay stub data

Get Help

PDF4me ConnectGet your API KeyPower Automate Documentation