The cheapest way to get a payslip to Excel is usually to check your payroll portal for a download first, then type the six to ten figures that matter if there is none. Converting PDFs only starts to compete with typing for a year or more of payslips, and only if the tool reads the payslip layout cleanly.
Which payslip lines belong in an Excel sheet?
A payslip sheet needs the pay date, gross pay, each tax and deduction you care about, and net pay. Year-to-date columns are worth keeping on the last payslip of a period as a check, but not on every row. Most people track six to ten numbers per payslip, not the full page.
A typical payslip prints far more than you will use: the employer's address, your employee number, tax codes, leave balances and a long list of deduction lines that are zero most months. Copying all of that turns a quick job into a slow one. Decide on your columns first, and type or keep only those.
Here is a column layout that covers most uses, from budgeting to checking a tax return. The column names are suggestions; rename them to match the labels on your own payslip.
| Column | What goes in it | Example value |
|---|---|---|
| pay_date | The date the money was paid | 2026-09-30 |
| period | The pay period the payslip covers | 2026-09-16 to 2026-09-30 |
| gross | Total pay before anything is taken off | 2,450.00 |
| income_tax | Income tax withheld | 312.40 |
| social_tax | Social security or national insurance type deductions | 187.43 |
| pension | Retirement contribution taken from pay | 122.50 |
| other_deductions | Health plan, union dues and similar, added together | 64.00 |
| net | What reached your bank account | 1,763.67 |
The example values are made up. Add one row per payslip, in date order. A formula in a spare column, gross minus every deduction, should equal net on each row. When it does not, either a deduction is missing from your columns or a figure was typed wrong.
If you have a reason to keep more detail, such as tracking overtime or a bonus, add a column for that line only. A sheet with forty columns of mostly zeros is harder to read and easier to get wrong.
The payroll portal download: a payslip file you may already have
Many employers publish payslips through an online payroll or HR portal, and some portals offer more than a PDF per pay date: an annual pay summary, a history view you can copy, or an export to a spreadsheet file. If yours has an export, it beats both typing and converting, because the numbers arrive as data with no reading step.
Portals differ by employer and payroll provider, so look in the pay or documents area for words such as "export", "download history", "pay summary" or "CSV". Check three things before you rely on what you find:
- What the export covers. Some exports list only gross and net. Others include every deduction line.
- How far back it goes. A portal may keep only recent years online, and a former employer's portal may close once you leave.
- Which format it uses. A CSV or spreadsheet file is ideal. A PDF bundle of all payslips is still a PDF.
If the portal has nothing usable, ask the payroll or HR team. They can often run a year-to-date or annual earnings report for an employee in a few minutes, and it costs you nothing. That single report may answer your question without any per-payslip sheet at all, for example when a landlord or lender only needs annual income.
Typing a payslip into Excel: the minutes per month
Typing a payslip into Excel takes a few minutes per payslip when you keep to six to ten columns. For a year, that is about an hour for someone paid every two weeks, and less for monthly pay. The time grows with the number of columns, not the length of the payslip.
The arithmetic is worth doing with your own numbers. The figures below are an example, not a measurement: assume three minutes per payslip, including a check of the gross-minus-deductions formula.
| Pay schedule | Payslips a year | Minutes at 3 each | Hours |
|---|---|---|---|
| Monthly | 12 | 36 | 0.6 |
| Twice a month | 24 | 72 | 1.2 |
| Every two weeks | 26 | 78 | 1.3 |
| Weekly | 52 | 156 | 2.6 |
Typing has two strengths that are easy to undervalue. You choose exactly which lines to keep as you go, and you read each figure, which catches odd entries such as a one-off deduction. Its weakness is fatigue: by the fortieth payslip a transposed digit is easy to miss, so the row check matters more on a long run.
For one or two payslips, typing wins outright. Setting up any other route takes longer than the typing itself.
What does converting a year of payslip PDFs cost?
Converting a year of payslip PDFs can cost nothing or a few dollars, depending on the tool and on whether it reads payslips at all. Most PDF converters are built for tables. A payslip is a table of earnings and deductions with current and year-to-date columns, which some tools read cleanly and others scramble.
Free converters often have caps on pages, files or conversions per day. A year of weekly payslips is 52 files, which can hit a free quota quickly. How those quotas are counted and when they reset is explained in the post on free PDF converter daily limits.
CheapBankConvert is built for bank statements, and its homepage describes it for text-based PDF statements from checking, savings and credit card accounts. It does not describe payslip support, so treat any payslip result as a test you check, not a promise. Its first 2 pages of a file are free to preview, which lets you see whether a payslip's layout comes out as usable rows before anything is paid. The early prices are $2.99 for a document up to 10 pages and $5.99 for 11 to 40 pages.
Whatever tool you try, a converted payslip needs the same check a typed one does. Gross minus deductions should equal net, and the net figure should match a deposit on your bank statement. A converter that returns every line can also return the zero lines, the leave balances and the header text, so plan time to delete columns you do not need.
Payslip to Excel options priced side by side
For most people, a payroll portal export or an HR report is free and fastest, typing is free and takes about an hour a year, and converting is a few dollars that saves little time unless the layout reads cleanly. The table below compares the routes for 12 and 26 payslips using example figures.
The typing cost uses an example value of $20 an hour for your time; use your own. The merged PDF row assumes the payslips joined into one file of about one page each, at the early CheapBankConvert prices, and they leave out cleanup time, which depends on the layout.
| Route | 12 monthly payslips | 26 fortnightly payslips | Notes |
|---|---|---|---|
| Portal export or HR report | $0, minutes | $0, minutes | Best when it exists |
| Typing 8 columns | 36 min, about $12 of time | 78 min, about $26 of time | Exact, you choose the lines |
| One merged PDF of all payslips | 12 pages: $5.99 | 26 pages: $5.99 | Must be checked; not a statement |
| Free converter | $0 | $0 | Watch daily caps and layout errors |
Two points stand out. First, the portal or HR route wins whenever it is available, so ask before you do anything else. Second, typing and converting are close for a single year, because cleanup of a converted payslip can take as long as typing the few columns you need. Converting pulls ahead only for several years of payslips with a layout that converts cleanly.
If the payslips exist only on paper, both typing and scanning are on the table. Scanning paper bank statements into Excel walks through the same choice for statements, and the reasoning carries over: for a few pages of a few numbers each, typing from the paper is usually quicker than scanning and fixing the result.
Payslip edge case: year-to-date figures after a correction
Year-to-date figures on a payslip can stop matching the sum of your monthly rows when payroll corrects an earlier mistake. The correction often appears only in the year-to-date column, or as a one-off adjustment line, so adding up the current-period figures gives a different total from the payslip itself.
Here is an example with made-up figures. Your September payslip shows gross of 2,450.00 and a year-to-date gross of 22,410.00. Your sheet's sum of January to September gross is 22,050.00. The 360.00 gap is a back-pay adjustment that payroll added to the year-to-date total without printing it as a separate earnings line on any one payslip.
When the totals disagree:
- Check the latest payslip for an adjustment, arrears or correction line, and add it as its own row.
- If there is none, compare each month's year-to-date figure with the one before it. The month where the jump differs from that month's gross is where the correction landed.
- Ask payroll if the gap is still unexplained. A year-end tax form from your employer is the figure that counts for taxes, so reconcile to that.
Tax year boundaries add one more wrinkle. Year-to-date columns reset at the start of a tax or payroll year, which may not be January 1 in every country. Keep your sheet's year in step with the year your payslip uses, or the year-to-date check will fail on the first payslip after the reset.
Matching payslip net pay to bank statement deposits
Each payslip's net pay should appear as a deposit on your bank statement on or near the pay date. Matching the two is the quickest proof that your payslip sheet is complete. It also catches a missed payslip, a late payment or a split deposit sent to two accounts.
Lay the two side by side. Put your payslip sheet in one tab and your bank statement rows in another, and for each payslip find the deposit with the same amount within a few days of the pay date. A simple lookup on amount is often enough, since net pay amounts rarely repeat exactly.
Watch for these patterns:
- A split deposit. Some people send part of their pay to a savings account. The checking deposit then shows less than net pay, and the rest sits on the savings statement. If that is you, turning a savings account statement into Excel covers a statement with few rows, which often fits a free preview.
- Pay onto a prepaid card. Some employers pay onto a payroll card instead of a bank account. Those deposits sit in the card's online history, and getting prepaid card transactions into Excel shows where to find them.
- A missing deposit. A payslip with no matching deposit needs a call to payroll before anything else.
When every payslip has a matching deposit, the sheet is ready for whatever you needed it for: a budget, a loan application or a tax check. If the bank side is where you are stuck, CheapBankConvert turns a PDF bank statement into CSV or Excel rows at a one-time price per statement, and the homepage shows the early prices.