Financial statements in PDF: get them into Excel and analyze them with AI
Extract the tables of a trial balance to Excel, merge and compress the document package for the bank, convert it to PDF/A, and analyze financial statements with ChatGPT or Claude once they are pseudonymized: the assistant never sees your clients’ company names, VAT numbers or tax ID numbers. Designed to help you comply with the GDPR.
Does this sound familiar?
Your client sends you the trial balance as a PDF and you need the numbers in Excel: retyping them by hand is slow, and mistakes creep in.
You would like ChatGPT or Claude to analyze three years of financial statements, but they contain your client’s data.
You have to put together the package for the bank: financial statements, tax returns and supporting documents in a single PDF, in order, light enough to send and in PDF/A.
Analyze financial statements with AI in three steps
1. Upload the financial statements
PDFs, Excel and Word files, scans included: Omissis converts them to PDF and, when needed, reads the text with OCR. You can work on one file or on the client’s whole folder.
2. Pseudonymize
Omissis replaces company names, VAT numbers, tax ID numbers, IBANs and people’s names with placeholders, the same ones in every document. You choose the categories: for a financial analysis, the amounts stay. You can import your list of customers and suppliers from your accounting software, so they are detected in every file.
3. Ask the assistant
Connect ChatGPT or Claude: compare periods, spot the variances, draft a report. If you need the document with the real data, Edito puts it back together on its servers and emails it to you.
What you do with Edito in your firm
Three recurring jobs, from a single set of financial statements to the complete client file.
Tables from PDF to Excel
- Edito detects the tables on each page and extracts them to Excel: trial balances, balance sheets and income statements, revenue analyses. If you start from a scan, you make it readable with OCR first.
AI on financial statements, without exposing clients
Merge, compress, convert to PDF/A
- Merge and reorder financial statements, tax returns and supporting documents into a single file, compress it to send by email or upload to a portal, and convert it to PDF/A for long-term archiving.
Which modules should you choose?
Choose what you need today and add the others when your work calls for them.
PDF Editor
To read, annotate, sign and redact a document by hand on your computer, even offline. Free with a free account.
Edito Omissis
To pseudonymize financial statements and ledgers, using the customer and supplier list from your accounting software if you like, and analyze them with ChatGPT or Claude.
Edito in cloud
To extract tables to Excel, read scans with OCR, merge and compress document packages and convert them to PDF/A.
Frequently asked questions
How do I get a trial balance from PDF into Excel?
You upload the PDF: Edito detects the tables on each page and extracts them to an Excel file. If the trial balance is a scan or a photo, you first turn it into a PDF with readable text using OCR. After extraction, always check that the totals agree and the figures balance. The other conversions are on the Conversions page.
How do I prepare a single file for the bank or for archiving?
Merge the PDFs in the order you need, split or remove extra pages, and compress the file if it exceeds the size limits of email or of the portal. Then convert it to PDF/A: Edito checks the result, so you know the document is suitable for long-term archiving. You will find these features in Edito in cloud and on the PDF/A and PDF/UA page.
Can I have ChatGPT or Claude analyze my clients' financial statements?
Yes, once you have pseudonymized them with Omissis: the assistant receives only the text with the placeholders, while company names, VAT numbers and tax ID numbers stay on Edito’s servers, in Europe. The assistant’s calculations and comments need to be verified: it supports your analysis, it does not replace it. See how to connect ChatGPT and Claude.
Are the amounts hidden?
Only if you choose to. Omissis groups the data it finds by category and you decide which ones to replace: to analyze financial statements, you usually leave the amounts and replace the data that identifies companies and people. For a document you are going to publish, you can remove everything with redaction instead, which is permanent.
Do I have to mark customers and suppliers by hand in every file?
No. You import the list exported from your accounting software once, in CSV format, and it applies to every file in the folder: Omissis finds customers, suppliers, addresses and tax ID numbers in every ledger, even when a name is written surname first. When your customer and supplier records change, you import the updated file again.
Where do the documents I upload go?
Data detection and replacement take place on Edito’s servers in Europe, with a model trained by Jugaad: documents are not sent to external AI providers. Files stay in your space until you delete them; when you delete them, documents and metadata are erased immediately. The details are on the Security and privacy page.
How much does it cost?
Plans start at €5 a month and you can try them free for 15 days; Omissis uses 1 credit per page. PDF Editor is free to use with a free account; some features, such as redaction, require a plan. You will find everything on the Pricing page; for a firm with several users, write to us.
Not sure which features to choose?
Tell us what you do and we will help you