Your accountant asked for last year's transactions and supporting schedules in Excel. You only have the PDFs HMRC (or the IRS, or wherever) gave you back.
Tax PDFs are some of the cleanest documents to convert. They were designed for clarity.
Tax forms convert well — usually
Tax authorities tend to use simple, well-spaced forms with clear table structure. HMRC PDFs, IRS PDFs, ATO PDFs — all convert reliably with Flint's PDF to Excel. Numbers come across numeric, dates as dates, and form fields (where present) as text columns.
The edge cases are old-style scanned returns and forms with lots of optional blocks.
Verification matters here
Tax numbers feed into legally significant filings. Don't trust any conversion — yours or anyone else's — without cross-checking totals. Run SUM on relevant columns and verify against the printed sum on the original PDF. If they don't match exactly, find the discrepancy before passing the file on.
Supporting schedules
If you have multiple schedules (income, deductions, capital gains), convert each one separately and stack them into different sheets of one workbook. Keeps the structure clean and makes your accountant's life easier than one giant catch-all sheet.
If the original PDF combined multiple schedules into one document, split the PDF by schedule first.
Keep originals as the source of truth
The PDF is the legal document. The Excel is the working file. Don't replace the PDF in your archive — keep both, alongside any signed or stamped versions. If you need to share the data without the form structure, convert the PDF directly or export the cleaned Excel as CSV.
FAQ
Are scanned tax forms supported?
Yes — OCR runs automatically. Accuracy on tax forms is typically excellent (clean print, large fonts). Verify totals anyway.
What about forms with checkboxes?
Checkboxes come across as text indicators ("X" or blank) rather than form controls. Easy to filter or count.
Will this work for international tax forms?
Most major-jurisdiction tax PDFs work. Less standard formats may need manual cleanup. OCR supports common languages.
Can I edit the form after conversion?
The Excel is a working copy, not a legal form. Submit the original PDF; use the Excel for analysis and record-keeping.
Tax PDFs are conversion-friendly. Convert your tax PDF to Excel and verify the numbers.