ELOVIT
UAEN
Discuss your task ↗
← Implemented Projects

11 / Finance

A payroll file ready for bank import

An external routine creates a DBF file from a UTP payroll statement, checks employee details and saves user settings.

UTP 1.2DBFPrivat24Payroll
Discuss bank file preparation ↗

Conceptual illustration. See the interaction diagram for data scope and directions.

The task

UTP → DBF → Privat24

Payroll statement data needs to be prepared for later import into Privat24.

Interaction diagram

UTP → DBF → Privat24

payroll-privat24Components and data directions in the described implementation.Payroll rowsPayroll rowsPayroll rowsPrepared dataPrepared dataPrepared dataFile handed to the userFile handed to the userFile handed tothe userManual importManual importManual importUTP 1.2 payrollUTP 1.2 payrollUTP 1.2 payroll1Payment detail checksPayment detail checksPayment detailchecks2DBF fileDBF fileDBF file3User importUser importUser import4Privat24Privat24Privat245payroll-privat24Components and data directions in the described implementation.Payroll rows1Prepared data2File handed to the user3Manual import4UTP 1.2 payrollUTP 1.2 payrollUTP 1.2 payroll1Payment detail checksPayment detail checksPayment detailchecks2DBF fileDBF fileDBF file3User importUser importUser import4Privat24Privat24Privat245
Selected connectionUTP 1.2 payroll → Payment detail checks

Payroll rows

Architecture

Technical description

An external routine converts a payroll statement into a DBF file. Employee detail lookup and data warnings are software steps. Importing the file into the bank is a separate user action.

Data scope

Payroll statement rows and employee payment details. User settings store the export directory, prefix and last document.

Our implementation

Bank file preparation for UTP 1.2. The routine does not call a Privat24 payment API, automatically import the file or execute salary payments.

Requirements for a new project

Check the DBF against the bank requirements for the intended workflow. An authorised user imports the file and approves payments separately.

What we developed

External routine for preparing a bank file

  1. Developed DBF file generation from a payroll statement.
  2. Added employee bank-detail lookup and warnings about problematic data.
  3. Saved the directory, prefix and last document in user settings.

Implementation result

Implementation result

The user receives a prepared file instead of re-entering rows. Bank import and payment execution remain separate user actions.

Discuss your task ↗

Related projects

NEXT STEP

Discuss your task

Describe your current system, task and intended result. We will agree the scope and prepare a proposal.

[email protected] ↗Contact us on Telegram ↗Vyvick Engineering on Telegram ↗
Company and preferred timing — optional

Enquiries and personal data