OpenForm by abgroup.tech — Reporting Automation System | Russian SW Registry

The abgroup.tech team introduces OpenForm — a modern data entry system designed to automate reporting in accordance with corporate regulations. The solution helps organizations systematize information, minimize errors, and comply with established document formatting standards.

The platform is included in the Russian Software Register: https://reestr.digital.gov.ru/reestr/5217371/

OpenForm is a data entry system intended for generating reports in compliance with corporate regulations. The system ensures information collection and structuring. The product is adapted for complex business processes, supports multi‑page documents, calculations, and strict data control, and eliminates manual data entry and errors in Excel.

What is the OpenForm service for?

🔹 Centralized reporting management — a unified document workflow system, consolidation of all reports in one place, elimination of scattered files.

🔹 Two‑way exchange with Excel — data import and export, loading existing spreadsheets and exporting completed forms while preserving validation and formatting.

🔹 Metadata and report management — developing report layouts, managing field properties, creating directories, and setting up relationships between elements using meta.

🔹 Status tracking for completion — monitoring the workflow, tracking report statuses and the responsible persons for filling them out.

🔹 User management system — security and access control, permission differentiation, change history, and assignment of responsible parties.

🔹 Directory integration and filtering — working with directories, searching, loading data, and flexible filtering of information by various criteria.

Technology stack:

Backend: Python, SQLAlchemy, Pydantic, SQLAlchemy, Falcon

Frontend: React, Effector, React Router, Sass

Databases: PostgreSQL

Design: Figma

Data flow diagram

Keycloak — a service required for user authentication in the system.

Frontend — a microservice responsible for displaying the service to the user.

Backend API — a microservice handling internal interactions between services that require OpenForm data.

Integrations API — a microservice responsible for integrating external systems and data consumers.

PostgreSQL — the database storing all OpenForm service data.

S3 — a file storage system used to store files attached to OpenForm.

Excel parser — a microservice responsible for processing Excel files. It enables bidirectional data conversion between the database and Excel format based on meta JSON schemas.

Traefik — a service responsible for proxying requests from external consumers to system components.

OpenForm functionality

The core functionality of the sections provides static information display and navigation elements, as well as enabling data visibility control during viewing.

The report cards screen is a convenient monitoring panel displaying all reports from the selected section as intuitive cards. These cards show key information: status, creation date, author, and main parameters. This allows users to quickly locate necessary documents and manage them efficiently.

Flexible data editing enables users to make changes to reports via an intuitive interface: adjusting existing values and removing outdated information.

A comprehensive editing toolkit with a commenting system significantly simplifies document approval processes and enables effective exchange of comments among participants.

OpenForm is suitable for various industries

Industry

▪️Automating reporting on production metrics

▪️Tracking fulfillment of production plans

▪️Recording downtime and non‑productive losses

Construction

▪️Monitoring construction and installation work progress

▪️Inventory tracking of materials and equipment at the site

▪️Tracking construction schedule adherence

FMCG and Retail

▪️Managing warehouse stock and turnover

▪️Generating sales and inventory reports

▪️Planning purchases based on seasonality

Financial sector

▪️Automating financial transaction reporting

▪️Ensuring compliance with regulations and standards

▪️Analyzing departmental performance efficiency

OpenForm is not just a data entry tool — it is a comprehensive solution for corporate reporting management. Thanks to its flexibility, reliability, and ease of integration, the system optimizes business processes and enhances data management efficiency.