Discover the Perfect Consulting Invoice Example for Teams

Consulting invoice example for teams

good morning or afternoon everyone thank you so much for joining us today um today we're going to be looking at automating AP accounts payable invoices using Office 365 and teams I have a couple minutes um actually about one more minute till the toy hour ing to my watch so I'll give everyone another here to um go ahead and come into the webinar all right um it looks like ing to my watch for right at the top of the hour so we'll go ahead and get started again thank you everyone so much for joining us today uh it's going to be a brief meeting half hour here just looking at automating AP invoices using Office 365 and teams um a few um housekeeping things I will do my best to monitor the questions so if you want to go ahead and put a question in there as we're going through I will try to keep my eye on that and then if there's a break I'll go ahead and pause um and address any questions as we're going through this again my name is Mike uh I work for dynamic point I'm the Director of Business Development and today we'll be going over invoice automation using Office 365 and teams for sake of full disclosure we will be showing um our product here that is a Office 365 app that you could add to the mix um but even if you don't plan to use our product hopefully you'll still leave with some um tips and tricks and some knowledge of how you could use Office 365 just to support AP processing and invoice automation so let's go ahead and get it going looks like we are set everyone's on the call and I'm going to um go ahead and Advance the slide here so just a quick introduction of who Dynamic point is so Dynamic Point um are claim to fame or or what we do here is we create apps on top of Office 365 and for those of you who are not familiar with this concept um the best analogy that I've sort of been able to come up with to to explain it is it's very similar to an app that resides on your mobile phone I'm sure we've all installed apps on our mobile phone and when we do it asks us all these questions can I use your you know camera your location and and all these things that we probably don't read and we just you know select yes to but that is the app leveraging this platform that is provided by either your iPhone or your Android device and Microsoft provides this whole framework for products and app development companies like us within an Office 365 ecosystem so that's exactly what we do is we build apps within this framework that most of our customers already own so we get to leverage all of this product functionality that I'll talk about in the next slide here um in conjunction with our products to make them more flexible we are created in 2009 which um if those of you have followed Office 365 it was not around it was its predecessor um Bas back in the day and we used to create products on top of SharePoint and then about six years or so ago with the you know gain in Steam and the adoption of Office 365 began moving all of our products to that new framework so that's just a little history on us as far as our product lineup um we have a portal product and we have an expense management we're going to skip those today and the focus today is on this guy right here and this is our invoice automation product again leveraging this Office 365 framework today we're focusing on the teams integration as well and really the process that we are trying to accommodate is everything that happens before this invoice is created in your Erp or your accounting system so that's like the endgame if you will but before that invoice gets in there um generally speaking of course it has to be received so it's going to come in from a vendor um we're going to maybe apply some workflow to this and some approval processes we could use OCR or optical character recognition to extrapolate data from this invoice such that we don't have to type it in there's the whole AP management component of that and what I mean by that is whether or not I'm doing a PO match or just assigning account elements to this if it's a nonp invoice coming in and then ultimately it is ready for integration so all of these steps sort of occur before I could put this invoice into my um accounting system for payment and posting obviously so that is the breath of what our application is focused on um as well as how we're leveraging Office 365 to manage this process so the suite of products all right and you know all of these apps if you will um are coming with Office 365 subscription and I say that a little bit in air quotes because there's many different ways to License Office 365 but most all of them um include the a whole Suite of products of which I'll cover today and what we are doing is our app is really being added to this mix and being installed on top of SharePoint so this ecosystem gives us the ability to add apps to SharePoint which you could you know download from the App Store um or just upload directly to your SharePoint tenant and SharePoint is providing this framework for the product it's really the user interface it's where the data is being stored for today we're talking about AP invoices those are going to be stored in SharePoint in document libraries and things of that nature so it's really secure in your tenant with Office 365 you know the data is not being stored anywhere art cloud or anything of that nature it is with Office 365 and specifically with your tenant with Microsoft workflow is really important to the AP automation Pro process right I have an invoice that comes in I maybe want to automate and apply some RPA to this um or maybe I want to round it to individuals such that they could review this invoice and you know approve or reject it so for that Microsoft gives us this tool by the name of power automate it is a framework for workflow that is extremely powerful um I could probably spend days just talking about the options on it but today we are going to focus on how it's being used with the AP automation process to Route invoices to the appropriate people for review and approval so when it comes to Gathering the data for invoice submission probably the more common thing uh that we see is that emails um are I'm sorry the invoices are being submitted via email vendors are just emailing them and by all means we can certainly support that but what I will introduce to you today is the use of some other methods including power apps including forms including teams obviously teams is our Focus today um which is very integrated with SharePoint as well as the rest of these Suite of products so we'll be looking at that as well on different ways I could submit these invoices and then when it comes to reporting and analytics Microsoft provides their go-to reporting tool by the name of powerbi all of this data is again being stored in my tenant so I could use this tool to begin reporting on this information and looking at outstanding invoices and doing analysis on this process okay so let's talk about the steps generally speaking from an AP automation perspective and generally speaking there's you know three simple steps if you will and this first step is I need to get the invoice right it's going to come in from a vendor of course because we're talking about AP automation. AR so I need to receive this invoice um from the vendor and you know like I said probably the one that wins the most amount of votes in my experience is email it's easy right I have a shared inbox and um a vendor could just submit that uh invoice via a shared inbox you know at you know accounting at dynamic point.com or something of that nature accounts payable um but there's most certainly all kinds of different methods that I could do this I could use power apps um if I have my employee is submitting the invoices maybe I want to do an up a mobile upload or if I have contractors in the field that are submitting the um invoices I could do that I could do a portal entry I could scan it and all of these other different methods which honestly I could take credit for inventing none of them they all are leveraging out of the Box Office 365 functionality in conjunction with a SharePoint library and this library is serving as our Central repository for all these invoices coming in so they're no longer being buried in email I can now see them receive them and begin taking action on Gathering data routing to the appropriate people Etc and I'll show as part of my demo a lot of these different options of how I could use these Office 365 Technologies again including teams here and we'll go ahead and do an upload from teams to get those invoices into the system and really the method is going to be driven by your business process and your relationship with your vendor ERS right if I am working with contractors um getting them to do you know a mobile upload or maybe a portal entry could be very applicable because I have that type of influence over those contractors if I you know my vendor is I don't know Home Depot for sake of argument they're not going to do any of that for me right like I don't have that influence over them um they're going to give me their invoice however they want to and I really can't um influence that submission method okay so after we get the invoice then we um begin step two here which is the processing of this invoice and this includes using OCR um to extrapolate data includes the workflow component and includes use of our app that gives us the integration with the accounting elements whether this be vendors or um POS or accounts Etc such that we could begin coding this invoice and processing it and putting it to the right GL accounts or doing P matching to get it ready for the third and final step which is bringing that into the accounting system okay enough of my scribbling and uh talking let's go ahead and start looking at this all right so here I have um a demo site and this site happens to be integrated with Microsoft business Central but we do have if you look at our integration page on our website we do have Integrations with all kinds of different Erp products and um the layout of this I mean I I guess first of all to introduce this this is just a SharePoint site right which those of you who are familiar with Office 365 are probably recognizing that um the only thing quote unquote special about this is I happen to have our app deployed so if I were to go to the site contents here you would see that I've added our app to this site otherwise it's just a normal SharePoint site and I've laid it out um basically using those um steps that I just introduced incoming invoices is that Library um it's serving as basically the cue of receiving all these invoices from vendors I have my processing cue that represents those that are within the workflow um and then I have a link just to my Erp application in this case business Central to show those that have already integrated we talk about the powerbi powerbi and powerbi is something that I could build all these rep reports um and I could absolutely start using this um to share information or provide metrics of where invoices are in this approval process and I saw a quick question come through um is this being recording the answer is absolutely and you will all receive a recording of this as well so don't uh worry about taking I guess too much notes or anything I'll go ahead and send the recording to everyone after the call okay so we talked about the layout we talked about the presentation let's talk about the users who cares about um invoices and again that's going to vary a little bit about your process probably the more common people is Accounts Payable because they're managing this whole process but maybe you know I want to bring managers into this or other people that I want to invite into this dashboard to have visibility to where these invoices are in the review process okay so let's start with this step one incoming invoice is and um lo and behold you know we're talking about teams um and I have a teams site here and if you guys are familiar with Team sites um they are highly highly highly integrated with SharePoint right by creating a team site I basically create a SharePoint site and let's say I want to submit an invoice um that I receive from the vendor and employes doing this or if I'm inviting vendors to do this like I said is is really depending on your business process says maybe your vendors would never do this and we just want to stick with email or maybe I have a very distributed buying environment where the invoices are going to employees and I want them to upload them to um this Library so I'm going to do that I'm going to click this simple uh upload here and I am going to pick an invoice let's go ahead and pick one more too just to get a couple going uh okay you can't see it but it did open up a little popup and what we will see here is if I refresh my screen that of course I've just uploaded two invoices to this library and you know if I were to go over to SharePoint and refresh you would see those same invoices here too again teams is highly integrated with SharePoint so great right like who cares I've uploaded them um you know big deal right um the more interesting thing is what's going on in the the background is now we have um kicked off a workflow and what this workflow is doing is saying all of these invoices that come into this library and I actually have the flow up here if you guys are familiar with power automate so I say when this file is created we want it to upload it to an OCR process and I am using a cloud-based OCR tool that extrapolates data from invoices um the one that we're using is um by the name of verify um but what it is doing is getting the data off of those invoices and if you notice they're now gone um I'm going to upload one more just so I could see it really quick and sort of take a pause here to show you but what it is doing is it's extrapolating data from these invoices that maybe otherwise I would have um needed to manually type in so I now have a new one in the system and what we will see is this workflow here again if I go look at this you could see it's running in the background and you can see here's my runs that are going on um but it is being submitted to this OCR process and then when it's done who it's going so fast I'm sorry I'm not uh talking too much um but what you'll see is it writes the data that was captured by this um OCR process right back to this library and then after it captures this data um we bring it into our app so it's just really here for a brief moment and what this is serving as is basically a Dropbox for all the invoices coming into the system so maybe I could catch it this time but what you'll see is if I sit here and refresh like a madman um that all of the data from this invoice is being captured and written to these columns maybe this time it'll take too long since I'm actually waiting on it usually happens in a brief minute or two but if you understand this concept what I'm going to show you next is all of these different ways that I use to get this okay got it right so you see all of the data that OCR was able to recognize and write that immediately back to the library and boom it's gone right so no one's really hanging out here waiting for this to happen I'm just showing you how this works so let's start using our imagination right I uploaded that from teams um but maybe as opposed to using teams you know I have more of a a mobile process or um the need to submit these from a mobile device and I happen to have my phone open here and this is leveraging the one drive app again another Microsoft tool here and sure enough I have that same invoice library and let's just go ahead and take a picture so I happen to have an invoice sitting here on my desk lo and behold and we'll go ahead and take a picture of this using this one drive app as you can see see this one drive app is sort of cool it just doesn't take a picture it cleans it up it calls it a scan right so I um I could adjust it and everything but you could see here that it's actually getting rid of my desk and everything else and if I go ahead and hit done here it's going to give me the ability to enter some metadata I'm going to say forget it because I'm going to um allow the OCR process to get all that information for me but if I go ahead and refresh of course where do you think that scan went went right into this Library T so again we're going to see OCR kickoff on this and I'm not going to um take you through the pain of me refreshing but you'll see all of the data be extrapolated from this invoice and rent to this Library so everything I've shown you so far none of it is really involving you know dynamic points product this is just all Office 365 functionality you know working with this ecosystem of tools they provided so I have uploaded one I've taken a picture of one from my phone let's talk about you know Old Faithful the idea that um my vendors are going to email this to me so I have this AP um Dynamic point.com I have an email here of course on my email I am submitting an invoice because it would sort of not be fun without that so here's my invoice and I want to go ahead again and submit or send this and you've probably figured out that this is going to again go into this library but now it is being received from an external email and being routed to this Library so not to be a dead horse but there's even more options right so if I say here and refresh or you guys could just trust me that this will um briefly take us oh there it is okay so that's the one I just submitted via an email and as you probably figure it out it's going to be going to CR process uh to extrapolate data and into our app okay so let's just talk about a couple others um again depending on your process if I wanted a form right generally what we call it is a check request where internal employees or external users can submit these same invoices if you're familiar with Microsoft forms forms has the ability to save the content of the form to SharePoint right so I didn't mean to do that so if I fill out this form here and just put in some key data it's going to ask me for an upload of my invoice but as opposed to just sending an email I could require some Fields so maybe you're tracking projects or something like that and I want to go ahead and require them to submit this um as part of the um submission process so I could capture some additional detail here I'm going to go ahead and upload my invoice voice skip the comments and hit submit so that was a form um as you probably figured out it's going to go into that same space into that Library if I want to do that from a a website form I can most certainly do that from a website form as well so this is the same idea just a little bit prettier because it's integrated with our website okay so enough of that let's talk um let's move forward so now that we've submitted this in you know plethora of different options let's talk about where these invoices are going and where these invoices are going is into a processing queue we've received them we've got all kinds of data metadata from the invoice and now they're in this queue and you can see you know I have a ton here that are all autocreated um taking the results of the OCR process and bringing them into our app and the reason we bring them into our app is now we have this ability to start assigning attributes whe whether it be po matches right so this happened to be for a PO uh invoice or nonp where so these are all po let's see if I have nonp no no all mine are po ones um but I could create one really quick and I'll add an allocation item which means as opposed to being matched to a PO we're going to go ahead and assign things like expense types to this or maybe other things such as like dimensions and we'll go ahead and save this so depending on how these invoices are coming here they're either being matched to posos or I'm putting GL accounts associated to them and they're all coming into this um workbench if you will or dashboard that now I have a place to manage them to perform validation to match the POs to also check against Erp data so you can see here I'm actually getting a warning message saying that this me this invoice has already been received and the reason it's already been received is I use that invoice quite often for demos um so I'm just going to go ahead and change the date here and update it and you'll note that it's going to requery the Erp in this case business Central and say okay um this is now a valid uh invoice it's no longer a duplicate my air Message is gone all right so now that I have a m coming into this dashboard right this was all automatic um this is where account's payable is going to live I could submit it and what submitting it is going to do is call again this workflow so again we're leveraging power automate it's going to kick off an approval process that is going to submit this for reveal and as advertised you know where does teams come into play I submitted it via teams I could also review and approve it via teams so what we'll see is I'm going to get a notification in fact I'll open up my email too so we could see that um aspect as well um but this notification is going to be generated from Power automate so you can see here I just got a notification and I can click on it here obviously um but what I should also see coming into my email is a new invoice ready to review and approve so let's start with the email and then we'll go look at the other views or other ways I should say to manage this task right so here's the first and foremost one I got an email and included that invoice it's included some of the data that I was able to extrapolate this again is using this power automate approval Associated to it and I can approve or reject it or I could edit it if my reviewers are part of this review Pro or assignment process I should say they could also edit it but let's go look at this from teams too so I'm going to go ahead and get rid of my email for a a sec and open up teams hopefully there it is found it too much stuff I'm apologize and got it well you can see here is I also um have a feed coming in through my activity feed here saying I have a new invoice ready to review and approve so if you want to look at it at teams it's very similar to the email I could obviously look at the attachment I could reject it or I could edit it or there is also an approval app that you could add to teams to that's part of this power automate framework and it's just a little bit different view um it's obviously it's similar to the activity feed but as as opposed to being um jumbled up with the other things that come in the activity feed I see all of the workflow items separately here in the approval and last but not least um as you probably figured m Microsoft does have an app for this so if I were again bring over my phone here and sure enough I have the power automate app installed you can see here's you know again all my invoices that are ready to review and approve um I could click on any of these and approve or reject them as well as um look at the invoice all right so let's go ahead and go back to the email and say hey this looks good or and carry it forth in the workflow so the workflow continues to run um you see here I did get a notification that it has been approved so that's great right and the workflow will continue to run and as this workflow runs if I refresh my screen here we will see this invoice gets updated in our dashboard right so the workflow is being assigned to approvers and different people in the field you can see it actually dropped out of my view um that's because I have a filter here but if I clear that filter what you will see is that the audit log is being populated with each of these steps in the workflow who to get submitted to what was their action taken so it went to my Dynamic Point demo account and they approved it and then this actually represent the last step in the workflow so the workflow in this case was only a one tiered approval and then after that approval it um integrated directly with my Erp system of which I could show you here in a second as well and then all of the notes that were captured as part of the review are also being listed in this note section so that was my this looks good and the user who took action on this was the dynamic Point demo so if we want to follow this guy all the way through if I look at my Erp details here you'll see this is the transaction that just got created and it gets created in real time and it leverages um what are called um web services to call that integration immediately so if I were to go here and just go to my purchase invoice oops sorry I fat fingered that I don't want purchase orders I want purchase invoice and purchase invoices that looks better and what we'll see is an invoice that has been created created with all of the details as well as the invoice attachment has been passed to it as well so we'll go down to the very bottom here because that's my latest and greatest here's my invoice the GL account account items have been assigned and if I look here there's the attachment so after it was finally approved um it did call those web services and integrated in real time so just to recap um the steps that we covered we went through the receipt and the different ways I get to use Office 365 we went through the processing the different ways I get to use Office 365 from an approval perspective and last but not least it broughten into the accounting system ready to be posted and paid so those are the steps we're taking you through again the hope of all this right is that we are leveraging what you own and it is a framework that is you know more flexible and more robust than you know anything that we could have developed on our own um our customers already own it um so we don't have to of course charge them for that because they're already using Office 365 and what we are doing is if you look at the various components that we covered today the RP integration the invoice repository the workflow we're really just focused on that one part of the pie and the rest of it is being provided by Office 365 one more question it looks like just came in uh is the attachment business Central a link back actually it is configurable we could either pass the attachment or provide a drill back um there is a configuration option either pass that URL as a link so you could drill back to it which is stored obviously in SharePoint or sometimes people want the actual attachment included in the Erp in my case it actually passed it as an attachment but that's not required we could just pass the URL as well and it looks like ing to my watch we're right on time here so I want to again thank you everyone for joining here's some more information uh on Dynamic Point um a lot of information on on on our website as well as um here's my personal email and Marson Dynamic point.com I will be following up everyone to include this recording I can't thank you enough for your time today take care and thanks again