Sheetminer
← Back to blog

Tax Form Data into Google Sheets: Extract Without Re-Typing

· Sean Harkin, Co-Founder, Sheetminer
tax forms Google Sheets document extraction self assessment

Tax season has a rhythm and it never changes: the tax forms arrive from different directions in January, and you spend a weekend re-typing figures that already exist in digital form. A P60 from the employer, a P45 from the last job, twelve payslips, the self assessment pages from the year before. Every number you need for your return is already on a document somewhere. The work is copying it into a spreadsheet without making a mistake.

For freelancers and small teams, this is where errors are born. A transposed digit on gross pay, a missed PRSI line, a tax figure typed from the wrong month’s payslip. Each one either overstates what you owe or understates what you paid, and you only find out when Revenue or HMRC writes back.

The alternative is to stop re-typing tax forms entirely: extract the data straight from the documents into Google Sheets, with a link from every figure back to its source. This post covers how that works and what to use it for.

The Tax Documents That End Up in Your Spreadsheet

For most freelancers and small businesses, tax prep pulls from a specific set of documents:

  • P60 and P45 (UK): year-end certificates from each employer, with gross pay, PAYE tax deducted, and National Insurance.
  • Payslips (Ireland and UK): monthly pay, tax, PRSI/USC (Ireland) or PAYE/NI (UK), pension contributions, sometimes benefits in kind.
  • Form 11 and Form 12 records (Ireland): the income, allowances, and relief figures that feed your self assessment.
  • Self assessment pages (UK): the SA100 and supplementary pages from the prior year, used as the baseline for this year’s return.
  • VAT return documents: the statements and invoices behind each VAT filing.
  • Bank interest and dividend statements (both): the small certificates that are easy to lose and impossible to reconstruct.

That is a lot of numbers, and each one has to match the document it came from. The version of this workflow that survives an audit is the one where every figure can be traced back to its source file.

Why Re-Typing Tax Forms Is Expensive

Manual transcription fails in three specific ways:

  1. Silent typos. A wrong digit in gross pay looks plausible. Nothing flags it until the return is queried.
  2. No trail. When a figure is questioned six months later, “I typed it from the P60” is not evidence. The document link is.
  3. It never gets faster. The same 40 to 60 figures get re-entered every year, and the spreadsheet starts from scratch each time.

The fix is not to type more carefully. It is to remove the typing step and keep the source document attached to every value.

What Tax Form Extraction Actually Does

Plain OCR reads a tax form and returns a block of text. That saves you typing the words, but you still have to find each figure and copy it into the right cell. Structured extraction goes further: it identifies which value is gross pay, which is tax deducted, which is the employer or payer, and writes each one to a named column.

Sheetminer does this inside Google Sheets. You open the add-on from the Extensions menu, pick the tax documents from Google Drive, and select the fields you need. It handles digital PDFs, scanned pages, and phone photos of paper forms, in both single and multi-page documents. The same extraction works for P60s, P45s, payslips, assessment records, and the other documents above, and it reads major European languages, so mixed-country records are fine.

Step-by-Step: P60 to Spreadsheet in Five Steps

Step 1: Install Sheetminer. Open any Google Sheet, go to Extensions → Add-ons → Get add-ons, and search for Sheetminer. Install and grant the permissions so it can read your Drive files and write to your spreadsheet.

Step 2: Select the tax documents. Open the Sheetminer sidebar and pick the P60s, P45s, or payslips from Google Drive. Select multiple files for batch processing.

Step 3: Choose the fields. Select the regions that contain the values you want: tax year, employer, gross pay, tax deducted, PRSI/USC or NI, pension contributions. Your selections are saved, so next year’s P60 extracts with the same field map automatically.

Step 4: Review with source highlighting. Before anything is written, Sheetminer shows each extracted value next to the original document with the field highlighted on the page. This is where you catch anything a scan quality issue might have affected, before it reaches your sheet.

Step 5: Write to the spreadsheet with source links. Confirm, and the values land in your columns. Select any cell and run source lookup to open the original document with the figure highlighted. That link is what makes a spreadsheet defensible.

A Column Layout That Survives an Audit

Whatever way the figures get into your sheet, use a layout that matches how Revenue and HMRC think. One row per document, one workbook per tax year:

  • Tax year (e.g. 2025/26)
  • Document type (P60, P45, payslip, Form 11 record, VAT statement)
  • Issuer (employer or payer name, and tax reference if shown)
  • Gross pay / income
  • Tax deducted (PAYE or income tax)
  • PRSI/USC or National Insurance
  • Pension contributions
  • Net received
  • Notes (employment period, benefits in kind, anything unusual)
  • Source link (the Drive file for the document)

Two formulas keep the sheet honest:

=SUM(F2:F100)      ' total tax deducted across all documents
=SUM(E2:E100)      ' total gross, to compare against your P60 batch total

If the sum of your payslips does not equal your P60 total, you have found a gap. That comparison is the whole point of the exercise, and it is the question an auditor would ask anyway.

The Difference Between This and Firm-Sized OCR Tools

Search for tax form extraction and you mostly find tools built for accounting firms: DocuClipper, TaxDocumentOCR, Docsumo, Parseur. They process batches of client W-2s and 1099s into Drake, Lacerte, or UltraTax, and they price like it, with per-firm or per-volume plans aimed at tax practices.

Sheetminer is a different shape. It runs inside Google Sheets, where your records already live. It writes to your spreadsheet with source references instead of into tax preparation software. And it starts free rather than with a firm license. If you are a freelancer or small team getting your own P60s, payslips, and assessment records in order, the firm tools are overkill and the free add-on does the job.

When to Do This (Tax-Season Timing)

The forms arrive on their own schedule, but the work has a deadline. UK self assessment: file and pay by 31 January. Ireland: the Form 11 filing date is 31 October, with Revenue extending the online deadline into mid-November in most years.

Work backwards from those dates. Extract as documents arrive, not the weekend before. Reconciling payslips to the P60 in November is calm work. Doing it on the 29th of January is not.

Keeping the Trail

The same source-tracing behaviour that makes invoice extraction audit-ready applies to tax documents: every extracted value in your sheet links back to the exact place in the original document. Anyone with access to the spreadsheet and the source folder can verify a figure themselves, no extra logins.

That turns “trust me, I typed it from my P60” into “here is the figure, and here is the document, and here is the highlighted cell in the PDF”. It is the difference between defending a return and having nothing to show.