Improve Your Project Funding with the Right Invoice Wording for R&D

Invoice wording for R&D

[Music] hey everyone so we've been getting a lot of requests about how do you use automation and ai to extract data from invoices so we're going to give you a quick demo all right so here are some at t invoices um from multiple dates um you know jim what i'm looking to do is uh take the name address um account number total amount and extract it from these invoices how hard or easy is that well andrew that's pretty relatively straightforward you have a a standardized form here that's clearly digital of course the data changes month over month but it seems like it's relatively in the same place all the time it's in the same format so it's relatively simple to do that extraction all right great um maybe you can show me how you do this sure so the first thing we do is we're using microsoft's power automate ai builder and we use the form processing tool it's already a built-in model that we can use to train on invoice documents and that's what i did the second thing i did then was i created a flow which is nothing more than just an automation this automation will be triggered manually since we're doing the demo here it's going to look through all files in a particular folder it's going to then apply some conditional checks and process each one of those files and then do certain things based on what it finds and here are the files that we have we have three att's and i also threw in a comcast here just so that we could see what the bot does when it encounters something that it's really not trained to handle yet got it okay so we're going to go ahead and run this and as i said before this is a manual run so we're going to go ahead and click that click save and run it's loading and now we're running over here we're gonna see that it's processing it's already ran through the first couple of steps it does a couple of uh checks per second here you'll see this counter run up okay so we're here it took a total of about 35 seconds here we can see that the flow ran successfully now what we're going to do is we're going to go over here and we're going to look at our data so that we can see what was actually extracted from those invoices and there we go we can see that on our around 203 today you can see the time here we extracted the account number we extracted the customer name customer address the amount due the due date i've also uh put in a processing algorithm so that we know exactly what bot would have processed this and you'll note that you can only see three out of the four invoices and over here what you'll see is the failure that says hey sorry about this but i cannot process this invoice if you want to add that format to the model etc etc all right that looks great all right so this was really just intended to show you what is possible using automation nai with regards to extracting data from invoices uh if you like this video please go ahead and hit like if you'd like more videos like this go ahead and hit subscribe leave us some comments below we'll certainly be making more videos like this all right thank you you