How OmaVero reconciliation automation removed repetitive manual work at Carisma and now posts tax account transactions straight into Fivaldi. The target was 90 % accuracy, and the automation reached 98 %.
Carisma, an accounting firm based in Seinäjoki, Finland, runs the finances of hundreds of client companies. The firm had been looking for help with tax account reconciliation for a long time.
”We had tried for years to get help with this same challenge from our software vendor, without results”, says Juha Tuuri from Carisma.
Every client company has its own tax account in OmaVero, the Finnish Tax Administration's online service, and every account has to be gone through each month.
Every transaction is posted, even those paid on time
Carisma has agreed that every transaction on the OmaVero statement is always posted: prepaid taxes, VAT, employer contributions and other self assessed taxes, even when they were paid on time. In the books the payment first sits on an OmaVero clearing account, and the payment shown on the statement is posted against that clearing account.
Done by hand, this means opening each company's transaction statement, coding the rows and entering a memo voucher into the books. The work is almost the same every month, but it repeats for every company separately.
Fivaldi raised doubts at first
Carisma's accounting software is Fivaldi. It is very old fashioned, which is why Carisma first doubted whether automation would work with it at all.
The solution was a software robot. Each company gets a memo voucher, which the robot imports into the right company's books in Fivaldi. When Carisma gets a new client company, the automation looks up its Fivaldi company number by itself. The number is saved only when the match is certain. Otherwise the automation doesn't guess, it reports.
The target was 90 %, the result 98 %
Now the reconciliation starts on its own on the second business day of the month, and nobody has to remember it. For every company the automation fetches the month's transaction statement and monthly summary directly from the Finnish Tax Administration's API. It codes every transaction according to Carisma's own posting rules and checks that the rows explain the change in the balance. Letters in Swedish are read too.
At the start of the project the target was set at 90 % accuracy. The OmaVero reconciliation reached 98 % accuracy.
People only see the exceptions
Every accountant in charge receives one email digest for their own companies. A company needing action means an exception: an item that doesn't fit the posting rules, or a row that couldn't be read. Other companies appear as a short table with the company name, business ID and balance.
If a posting doesn't reach Fivaldi for some reason, the company is raised as needing action in the digest and the reason is given in one line. The accountant can make the posting with the details in the digest, and nothing goes unnoticed.
No new system to learn
The automation is controlled with a Google Sheets spreadsheet. It holds the companies included, the people in charge and the accounts for the posting rules. Leaving a company out of a run is a single mark in the sheet.
The automation runs in Carisma's own Google Cloud environment in Finland, so client data stays under the accounting firm's control. Every run is logged in monitoring, and if any step fails, an alert goes out immediately.
”Working with Hugo was efficient and replies to messages came quickly. We were kept well up to date on how the development work was progressing”, Tuuri says.
Would recommend 10/10
When Carisma was asked how likely it would be to recommend Aika's services to others, the answer was 10/10.
”Aika automated routine work that required a lot of repetition, quickly and professionally. I warmly recommend Aika's services”, Tuuri sums up.
Quotes translated from Finnish.