For accountants
PDF tools for accountants
Most accounting PDF work is one of three jobs: getting a statement into a spreadsheet, breaking a batch of invoices into separate files, and assembling documents for filing. All three run on your own machine here, which matters when the documents are other people’s financial records.
By Suprabhat Updated How we write these
What tends to go wrong
- Client bank statements, payroll runs and tax documents are exactly the files that should not pass through a free conversion service you cannot audit.
- Re-typing a statement into Excel is slow and introduces exactly the errors that are hardest to find later.
- Accounting systems export a month of invoices as one long PDF, when what you need is one file per invoice, named correctly.
- Month-end means assembling the same bundle from the same sources every time, and any step done by hand gets skipped eventually.
The workflow
Every one of these works today, and runs on your own device.
- 1
Get a bank statement into a spreadsheet
Column positions are detected from the page, wrapped cells are rejoined, and repeated headers on every page are dropped. Numbers come through as numbers, so the balance column sums. Check the opening and closing balances against the statement before you rely on it — that single check catches almost anything that went wrong.
PDF to Excel - 2
Feed a bookkeeping system instead
Where the destination is an import rather than a spreadsheet, CSV is usually what it wants. Decimal commas are handled, so European statements do not arrive with every figure multiplied by a thousand.
PDF to CSV - 3
Break a batch run into one file per invoice
Split wherever a phrase appears — "Invoice Number", "Tax Invoice", a client name. A 200-page month-end run becomes 200 files in one pass, which is the job that otherwise eats an afternoon.
Split PDF by Text - 4
Assemble the filing bundle
Combine the return, the schedules and the supporting statements into one document in the order the authority expects. Bookmarks from each source file are kept, so a long bundle stays navigable.
Merge PDF - 5
Send a workbook that keeps its layout
Sheets become pages that look the same everywhere, with column widths, number formats and currency symbols preserved — so a client cannot accidentally change a figure, and nobody has to have the right version of Excel.
Excel to PDF - 6
Get a scanned set under a portal limit
Filing portals and client upload forms cap attachments, often at 2 MB or 5 MB. Scans compress heavily because they are photographs; the text layer, where there is one, is left alone.
Compress PDF
Reading a converted statement before you trust it
A conversion is a reading of the page, not a data feed, and a statement is the worst place to discover an error late. Three checks take under a minute and catch nearly everything.
Where the statement is a scan rather than a generated PDF, none of this applies yet: there is no text to read, and OCR is not live here. Ask the bank for the CSV or the machine-readable copy — most provide one, and it is better than any conversion.
- Do the balances agree? Opening balance, plus the sum of the movements, should equal the closing balance. If it does, the rows are almost certainly all there.
- Did every page come through? Compare the row count against the statement’s own page and transaction totals.
- Are negatives still negative? Statements show debits in several ways — a minus sign, brackets, a separate column, or a trailing CR/DR. Check a known debit reads as a negative number.
Questions
Can it convert a scanned bank statement?
No. A scan holds a picture of the page with no characters in it, so there is nothing to read into columns. That needs OCR, which is not live here yet. Most banks will supply a CSV or a text-based PDF on request, and either beats converting an image.
Are client financial records uploaded anywhere?
No. Every conversion runs inside your browser tab, and there is no endpoint to send a file to. You can watch the network panel while a statement converts and see that nothing leaves.
Will the transaction dates import correctly?
Dates are kept as text in the order the statement printed them, which avoids the worst spreadsheet failure — a tool guessing between day-first and month-first and silently getting half the year wrong. Format the column once on import and you control the interpretation.
How do I split a batch where every invoice is a different length?
Split by text rather than by page count. Give it a phrase that appears once per invoice, such as "Invoice Number", and each new occurrence starts a new file — so invoices of two pages and of nine pages both come out whole.
More in PDF to Word, Excel & PowerPoint, or browse every tool.