Finance

What is the Finance module and what is it for?

The Finance module turns your validation history into monthly aggregates useful for accounting reconciliation:

  • Statistics: Of all your operations carried out in Veriko.
  • Account statements: Monthly, in different formats (pdf, xlsx, csv, html).
  • Detailed reports: Of valid transfers, not-found ones, average tickets, and much more.
  • CEP receipts downloadable in ZIP: Download a large number of receipts (CEP) and pack them in .zip format.

What counts as "verified"

A validation is "verified" only when status='valid' AND cep_xml was accessible through Banxico.
Any other terminal verdict [not_found, cep_unavailable, returned, invalid, failed, error] falls into the "unverified" aggregate and adds to the "unverified" amount, not to the "verified" one. The definition is the same one used by Electronic Payment Receipt (CEP). A validation that moves from valid to returned in a follow-up check stops counting as verified: its amount leaves the "verified" total and enters the "unverified" one, even in a period already closed: the aggregates are computed when they are queried.

The finance summary

GET /v1/finance/summary?month=YYYY-MM returns, for the requested period, the data shown in the "Finance" panel of the Veriko console:

  • counts — totals and per-verdict breakdown (valid, not_found, cep_unavailable, returned, invalid, failed, error).
  • amounts — total_volume, verified_volume, unverified_volume, avg_ticket, median_ticket, max_ticket, min_ticket.
  • success_rate — percentage of terminal rows with the valid verdict.
  • avg_processing_ms — average latency from creation to terminal close.
  • top_counterparties / top_banks_receptor / top_banks_emisor — top 5 each, with count + valid + verified_volume.
  • verdict_distribution — counts per verdict in chart format.
  • comparison_prev_month — totals, the previous month's verified volume, and percentage deltas.

Account statement and reports

GET /v1/finance/statement?month=YYYY-MM&format=... issues the monthly account statement in four formats:

  • format=pdf (default)
  • format=xlsx — multi-sheet workbook (Resumen / Detalle diario / Top contrapartes / Top bancos / KPIs / Transacciones).
  • format=csv — [HEADER] / [KPIS] / [TRANSACTIONS] / [TOTALS] sections.
  • format=html — the same template as the PDF, useful for printing from the browser.

The four detailed reports (monthly / counterparties / by-bank / accounting) accept format=csv|xlsx|pdf|preview and, on accounting, decimal=comma|dot for SAT/accounting tooling. The PDF has a limit of 1000 rows.

CEP archive

GET /v1/finance/ceps?from=YYYY-MM-DD&to=YYYY-MM-DD returns a ZIP with all the cep_xml (and cep_pdf_path when present) in the range, plus two parallel manifests (manifest.csv and manifest.xlsx) with columns validation_id, fecha, clave_rastreo, archivo.
Only rows with cep_xml are included, so the archive is exactly the verified subset of the period. If the range is empty the response is 404 no_ceps.