Skip to the content

An internal payment accounting and control system

Invoices and payments were tracked in scattered places, and reconciliation with accounting cost hours and bred errors. We built storage, search and automatic reconciliation against 1C.

Client
A company reconciling payments by hand
Industry
Finance
Year
2026
Duration
In production, with a roadmap
The problem

Invoices and payments were tracked in scattered places, and reconciling the data with the accounting system cost a lot of manual time and was prone to errors.

Solution

What we did
and why we did it that way.

01

Structured storage

A single base of payment documents with search, status sorting and filtering by document.

02

A full record cycle

Create, edit, search and delete records. User authorisation and access control.

03

Automatic reconciliation with 1C

A module matches the system data against 1C exports and surfaces discrepancies: missing invoices, extra unpaid items, mismatched amounts.

04

Import and export

Data exchange through Excel. On the roadmap: a web version with multi-user access and a role model.

Result

What changed
and what we measured it with.

Automatching against 1C exports
Lesstime spent chasing discrepancies
Fullrecord management cycle
Exceldata import and export
Stack
PythonSQLite1C
Timeline

How it went
day by day and week by week.

  1. Brief

    Types of discrepancy

    Worked out exactly where the data diverges from accounting.

  2. Build

    Accounting and reconciliation

    Built the record storage and the matching module against 1C.

  3. Production

    Manual control gone

    Replaced the manual reconciliation with an automatic one and cut the error risk.

Screens

How it looks
in schematics.

These are screen schematics. We do not publish client interfaces without permission

Next

A similar problem
on your side?

Describe it in the brief. In working hours we come back with an estimate of time and cost within two hours.