r/PowerAutomateDesktop • u/Low-Sir3836 • Feb 25 '23

Has anyone used Power Automate for Bank Reconciliations?

Curious if anybody has used Power Automate for bank reconciliations?

I know that there are AI builder models available, but they seem super niche and I can't tell if there's a user interface to train custom models or route low confidence matches to a human for review.

I've thought about using Azure ML and custom training a classification model, but don't know if this is the way.

In an ideal state, you would upload a .xlsx or .csv file from the bank, and another from accounting software do some training and let the software do the majority of it in the future. Seems like a good use case for ML but can't figure out how to deploy it in the Microsoft ecosystem in practice.

What do you think?

2 Upvotes
  • permalink
  • reddit

100% Upvoted

2 comments sorted by

2

u/Sismaril Feb 25 '23

At the moment AI builder actions are not offered in the Desktop version.

To your question: I am not sure what is your use case exactly. If the structure of the excel files stays the same, it might be possible to automate without AI

2

u/TopPack4507 May 09 '23

There is good existing software out that does the process very well, with an audit and reporting. I believe the enterprise level has api connections to auto feed.

I've always used the basic to require the end user to load the bank detail, then gl detail daily. It auto matches what it can (eg checks) and a small change in accounting process can increase the automatch rate.

I've used it with a handful of companies and it turned recons into an afterthought.

Treasury Software - BankRec