Invoices and receiptsas spreadsheets, without retyping.
Every close brings the same pile: service invoices in different municipal layouts, tax invoices, receipts photographed on a phone and statements in PDF. When there is an XML, great; when there is only a PDF or an image, someone types. Colunar reads those documents, checks the fields against a schema and returns one spreadsheet per client, with the source of every value.
20 free credits · No credit card · Delete your data anytime
WHERE TIME GOES
Three problems this page solves
Service invoices differ by city
The layout is defined by each municipality. One playbook with the fields your entry needs (issuer, tax ID, number, date, amount, withholdings) works for all of them.
Receipts arrive as photos
Tilted phone photos with shadows are enlarged and read by vision models. Whatever is unreadable becomes a warning, never an invented number.
One typo costs a correction
Types and required fields are validated on every record. Invoice total, date and tax ID arrive in the format your spreadsheet expects.
DOCUMENTS AND FIELDS
What goes in, what comes out
- Service invoices
- Tax invoices in PDF
- Consumer receipts
- Receipts and proofs of payment
- Service bills
- Bank statements in PDF
Fields in the ready-made playbook
- Issuer
supplier_name - Issuer tax ID
supplier_tax_id - Invoice number
invoice_number - Issue date
issue_date - Due date
due_date - Total amount
total_amount
Illustrative example: invoices from two cities and a photographed receipt in the same table.
| file | issuer | tax ID | number | issued | total |
|---|---|---|---|---|---|
| invoice-sp-0421.pdf | Example Consulting Ltd | 12.345.678/0001-90 | 421 | 2026-09-10 | 4,800.00 |
| invoice-bh-77.pdf | Fictional Studio | 98.765.432/0001-10 | 77 | 2026-09-12 | 1,250.00 |
| taxi-receipt.jpg | Example Coop | — | — | 2026-09-15 | 68.50 |
HOW IT WORKS
From the pile of files to the spreadsheet
- 01
Pick the invoices template
Fields ready for the entry: issuer, tax ID, number, dates and amount. Add withholdings if your process needs them.
- 02
Drop the client's documents
PDFs, photos and spreadsheets together. One batch per client and period keeps things organized; the file name travels with every row.
- 03
Export to your system
Excel or CSV in your accounting system's import layout, or JSON for internal integrations.
BEFORE YOU START
Frequently asked questions
I already have the invoice XML. Do I need Colunar?
When an XML exists, use it: it is the structured source. Colunar solves what has no XML: PDF service invoices, receipts, proofs of payment, service bills and photographed documents.
Can I extract line items, not just the total?
Yes. Use the line items template or add item fields to your playbook. Each item becomes a row, with the invoice number repeated for reconciliation.
How do I handle documents from many clients?
Create one playbook per document type and run one batch per client. History keeps every run with the original files, which you can download or delete at any time.
Are the documents stored?
They stay encrypted on AWS until you delete the file, the extraction or the account. They are never used to train models.