Supplier invoices and statementsready for accounts payable.
Invoices arrive by email as PDFs, each supplier with its own template; statements come as PDFs from different banks; reimbursements come as photos. Colunar extracts the fields your payment and reconciliation flow needs and returns validated tables, with the source of every value.
20 free credits · No credit card · Delete your data anytime
WHERE TIME GOES
Three problems this page solves
Every supplier, a different invoice
Number, due date, amount and payment details move around. The playbook fixes what comes out; the AI finds it in each layout.
PDF statements do not reconcile
The statements template turns every transaction into a row with date, description and signed amount, ignoring balance lines.
Reimbursements depend on receipt photos
Photographed receipts are read and classified; whatever cannot be read raises a warning for human review.
DOCUMENTS AND FIELDS
What goes in, what comes out
- Supplier invoices and bills
- Service invoices
- Bank statements in PDF
- Corporate card statements
- Reimbursement receipts
- Contracts with amounts and dates
Fields in the ready-made playbook
- Supplier
supplier_name - Invoice number
invoice_number - Issued
issue_date - Due
due_date - Amount
total_amount - Currency
currency
Illustrative example: invoices from different suppliers in the payment queue.
| file | supplier | number | issued | due | amount |
|---|---|---|---|---|---|
| cloud-sep.pdf | Example Cloud Ltd | INV-2026-0912 | 2026-09-01 | 2026-09-15 | 3,420.00 |
| rent-sep.pdf | Fictional Realty | 0987 | 2026-09-05 | 2026-09-10 | 8,900.00 |
| internet-sep.pdf | Example Telecom | 55.412.879 | 2026-09-03 | 2026-09-20 | 489.90 |
HOW IT WORKS
From the pile of files to the spreadsheet
- 01
Start with the invoices template
Supplier, number, issue date, due date and amount. Add payment details (barcode, bank keys) if you want them in the system.
- 02
Drop the week's invoices
Email attachments saved to a folder, all at once. The table shows each invoice as soon as it is read.
- 03
Import into the ERP or cash-flow sheet
CSV or Excel in your system's layout; JSON for internal automations.
BEFORE YOU START
Frequently asked questions
Does it extract payment slip barcodes?
Yes, as text, when printed on the document. Add a 'barcode' field to the playbook and an instruction to copy the digits without spaces.
Can I separate debits and credits in statements?
The statements template uses signed amounts: negative for debits, positive for credits. Add a category field to classify fees, transfers and payments.
Invoices in another currency?
The currency field records the code (USD, EUR). Amounts come out as plain numbers, ready for conversion in your spreadsheet.
Who else on the team can use it?
Accounts are individual today. For teams, talk to us about the Enterprise plan.