Automating generation of weekly payroll reports

  • Location: USA
  • Industry: Fintech
PHP
PHP
jQuery
jQuery
Node.js
Node.js
MySQL
MySQL
Client & product

Our client is a US-based fintech company that optimizes the performance of various business departments with custom digital solutions. Their goal is to minimize inefficient routines, paperwork, and billing delays for their customers by streamlining their workflows.

Payroll is an application that automatically calculates payrolls for accounting departments. It was designed with customization and flexibility in mind and can adapt to any workflow with minimal alterations. It’s also considerably faster than generic accounting software and requires less manual input and calculations.

Challenges

The Payroll database was large and complex, so it needed to be optimized to prepare for future expansion. Moreover, Payroll takes into account 50+ parameters in its calculations, so we had to build an efficient algorithm and a good way to present that data to the end user. As sometimes, accounting software produces incorrect figures due to bugs or user error, there had to be a way to detect such issues.

Job done

We built Payroll from the ground up. Development was led by our project manager, who also acted as the business analyst. Since the user experience was important, the team included a UX designer.

Payroll’s backend was written with Node.js and Yii — a fast, secure,
and efficient PHP framework. The front-end was built with Bootstrap and jQuery. Once complete, Payroll was put through rigorous testing by our quality assurance specialists.

Implemented features

1 (1)

Sophisticated payroll calculation algorithm

The algorithm conducts complex calculations in a single click, taking into account 50+ parameters. Each of these parameters can be set for a single agent or a predefined group.

2 (1)

Error prevention system

The system has a second, smaller database of common variables. All reports are checked against it, and all possible inconsistencies are highlighted.

3 (1)

Report and statistics system

Aside from payroll information, the system automatically produces a master report on the state of the company. It includes crucial information like income, commissions, overrides, and revenue.

Outcomes

Our client received a payroll calculation app according to their specifications that significantly improves the efficiency of accounting departments. Payroll is used to:

  • Simplify the workflow of payroll specialists by decreasing the number of manual calculations.
  • Increase the redundancy and reliability of reports on large projects.
  • Provide an overview of internal accounting in a simple, intuitive form.

Success cases

FirstHomeCoach
Fintech
UK
FirstHomeCoach
View case
Bidly
Real estate
The Netherlands
Bidly
View case
Wait!

Do you know that we helped 200+ companies build web/mobile apps and scale dev teams?

Let's talk about your engineering needs.

Write to us