LedgerBox
Sign in Get started

Convert pay stubs to Excel or CSV

Upload a pay stub, digital or scanned, and download a clean spreadsheet: pay period, gross pay, every earning and deduction line, and a net pay that is checked, not copied.

Convert a pay stub See pricing
9
Header fields, verified
2
Record types: earning, deduction
±$0.01
Net pay check tolerance

What comes back · sample

Schema v1

Employer
Acme Manufacturing
Employee
Ada Lovelace
Period start
Feb 16, 2026
Period end
Feb 28, 2026
Pay date
Mar 06, 2026
Gross pay
$5,384.62
Total deductions
$1,134.62
Net pay
$4,250.00
Currency
USD

Gross − deductions = net

Line items CSV

Field names are the LedgerBox extraction schema for pay stubs, version 1. Sample values are illustrative.

How to convert a pay stub

  1. Upload the pay stub

    PDF, scan, or photo, from any payroll provider. LedgerBox reads fields, not templates, so an in-house format converts the same way as a big provider's.

  2. We extract earnings and deductions

    Employer, employee, period, and pay date from the header. Every earning and deduction in its own row, each tagged with its kind. Gross minus deductions must equal net pay, or the stub is flagged.

  3. Download the line CSV

    One row per earning or deduction, typed, so the two never mix in your workbook. Ready for Excel or Google Sheets.

Pay stub anatomy

A sample semi-monthly pay stub, and how LedgerBox reads each part during extraction and verification.

The pay period anchors the dates

Stubs print period start, period end, and pay date in different corners depending on the provider. All three are extracted as separate fields, so period reporting comes straight off the export.

Earnings and deductions stay typed

Regular, overtime, and bonus lines are tagged as earnings; taxes, retirement, and premiums as deductions. The export keeps the two apart, one row each, instead of one mixed column.

Gross minus deductions must equal net

The deduction rows are summed and subtracted from gross pay, and the result must match the printed net pay within a cent. A stub that does not balance comes back flagged.

Any provider's layout

Pay stubs vary more than any other document type: two columns, four tables, current and year-to-date side by side. Reading fields rather than positions means the layout does not matter, and anything LedgerBox is not sure about is flagged rather than filled in.

Pay stub conversion FAQ

How do I convert a pay stub PDF to Excel or CSV?

Create a free LedgerBox account, upload the stub, and download the CSV. The free trial includes enough pages to try several stubs, and no credit card is required.

Which fields are extracted from a pay stub?

Nine header fields: employer, employee, pay period start and end, pay date, gross pay, total deductions, net pay, and currency. Plus every earning and deduction line as its own typed row.

Does it work with scanned pay stubs?

Yes. OCR-backed extraction reads image-based PDFs, scans, and photos the same way as digital files, and flags any line it cannot read with confidence.

Does it work with any payroll provider?

Yes. LedgerBox reads the fields on the stub rather than matching a provider template, so in-house formats convert the same way as the major platforms.

Is my payroll data secure?

Documents are encrypted in transit and at rest, processed in isolated storage, and never used to train models. You can delete uploaded documents at any time and they are permanently removed.

Ready to convert your pay stubs?

Upload a stub and download a clean spreadsheet in under a minute. No card required.

Get started free