Case study Fintech
Accounting Software Integration & Automation for a Financial Advisory Company
Bookkeeping reconciliation automated in an application unicrew took over, with no issues reported as transaction sizes grew in testing.
unicrew took over a partially built financial software solution for a UK financial advisory firm and extended it: automated reconciliation of transactions against invoices, data encryption, account protection, and proposed methods for analysing transaction descriptions with natural language processing.
- Focus
- Fintech
- Market
United Kingdom- Engagement
- Takeover of an unfinished build
- Stack
- NLP
MySQL
ASP.NET
C#
Outcome at a glance
What this project delivered.
- 01Less manual work: automated reconciliation of transactions and invoices freed the delivery team for more strategic work
- 02Data and accounts secured: encryption and user authentication now cover the financial data and the accounts on the system
- 03No wrong answers: the client's review reports no instance of the system doing the wrong thing, which they put down to the communication
- 04Domain knowledge developed quickly: on Clutch, the client says the team learned the domain quickly and repurposed technologies they had used before
Project Overview
A financial advisory firm supporting early-stage tech startups wanted to reduce the time its delivery team spent on routine accounting processes. The firm covers accounts management, tax advisory, EMI schemes, and R&D tax credits, and it is 100% Xero-certified, so anything built for it had to align with that. The goal was software that automated bookkeeping tasks and held financial data securely.
unicrew was brought in to take over a partially completed solution, improve what was there, and add the automation the firm needed.
Challenge
The firm’s delivery teams relied on time-consuming, error-prone manual processes. Key challenges of the accounting software integration included:
-
Manual processes: recurring tasks such as reconciling invoices and processing transactions were done by hand, which took time and allowed errors to occur.
-
An unfinished build: an existing solution, built with MySQL, ASP.NET MVC, and C#, needed further development to meet the business requirements.
-
Knowledge that is hard to hand over: the tool had to replicate accountancy logic that is not easy to communicate remotely, and a team joining mid-build had to absorb it before extending anything.
-
Security from the start: the system handles financial data, so encryption and user account protection were requirements from day one, not a later hardening pass.
-
Domain-specific complexity: the software needed to read transaction descriptions with natural language processing, which takes domain knowledge to get right.
Solution
unicrew’s team took over the build and worked on it alongside the firm. The work included:
-
Picking up the existing code: unicrew took on the MySQL-based solution, refined the functionality already in place, and added the features that automate the bookkeeping tasks.
-
Bookkeeping automation: the software now reconciles transactions against invoices automatically, which is where a share of the manual input had been going.
-
Encryption and account protection: unicrew encrypted the financial data and secured the user accounts, as part of the same accounting software integration.
-
A route through the NLP problem: reading transaction descriptions and acting on what they say is a research problem rather than a configuration one, so unicrew proposed the technical methods for addressing it.
-
A small team that learned the domain: the firm worked directly with unicrew’s developer and CTO, who repurposed techniques from earlier work instead of asking for a long ramp-up on the business logic.
Result
The engagement reduced repetitive work for the delivery team and added encryption and account protection to the system.
One part of the brief was still open when the client wrote that review. The natural language work on transaction descriptions was in progress rather than finished, and unicrew’s contribution there was methods for addressing it. Bookkeeping automation was delivered while the research continued.
Automation of this kind rarely arrives as a greenfield project. See how unicrew doubled data-entry throughput with a custom recognition tool, or read what other clients say on our client reviews page.
What the client says
Even though Artelogic didn’t have a background in this area, they learned quickly and repurposed technologies they’d used before in order to solve the business problem. I was very impressed with this ability, as most of the people we contacted before implied that they’d need to spend a lot of time of trying to understand our business logic.
05/Technologies
Technologies on this project
Backend
- ASP.NET
- C#
AI & Data
- NLP
- MySQL
06/Quick answers
The questions behind the project
What did unicrew build for the financial advisory firm?
unicrew extended an existing application for a financial advisory firm, automating transaction and invoice reconciliation to free the delivery team for more strategic work. It also encrypted financial data, secured user accounts and proposed methods for categorizing transaction descriptions with natural language processing. The firm is 100% Xero-certified, so the software needed to align with its accounting processes.
What technology was the accounting automation built on?
The existing solution used MySQL, ASP.NET MVC, and C#, and unicrew picked that up rather than starting again, refining what was already there while adding the automation the firm needed. The natural language work on transaction descriptions was the research problem in the brief and was still in progress at the time of the client's review; unicrew's contribution there was methods for addressing it. Encryption and secure user authentication were added as part of the same accounting software integration.
What security work was part of the integration?
The system handles financial data, so encryption and user account protection were requirements from the first day rather than a later hardening pass. unicrew encrypted the financial data the software holds and secured the user accounts on it, as part of the same accounting software integration.
Can unicrew pick up a codebase someone else started?
Yes, and that is what this engagement was. unicrew's developer and CTO took over an existing MySQL, ASP.NET MVC, and C# build, refined what was already there, and added the automation on top. The harder part was the accountancy logic the tool had to replicate, which is not easy to communicate remotely; according to the client's review on Clutch, the team learned the domain quickly and repurposed technologies they had used before to solve the business problem. Understanding the existing code and accounting logic was essential to extending the application.