The Banking Buzz: Easily Build, Share, and Analyze Data Reports

Good afternoon, and thank you for joining our banking buzz presentation on Accu accounts reporting module to easily build, share, and analyze data reports. I'm Jamie Biggs. I'm a product sales specialist for AccuAccount with Allegiant. I'm based in Colorado, and I've been with the company for about fifteen years. So if you have any questions questions as we go through today's webinar, feel free to post those in the questions panel on the GoToMeeting, excuse me, the GoToWebinar panel, and I'll answer those questions at the end of our presentation. For today's webinar, we're gonna go over AccuAccount's reporting options, but I'll give you an idea of what AccuAccount is just in case you haven't used the product. But it is a core integrated system for the life of the loan and stores and tracks documents, task, and policy exceptions. AccuAccount is a web based software. It allows you to have unlimited users working in the system to view and manage documents and exceptions, as well as pull on demand reports or schedule reports, which we'll get into more on the demo today. So just a little bit more in-depth on AccuAccount and what we offer. We do offer early capture with AccuApproval to track, and do workflows on your loan applications. We integrate with your core system, so we will bring in data from your core and keep it updated so that we stay in sync with your core. We also can bring in documents or data from e sign products or any LOS product that you're currently using, so we have several interfaces in place already. We offer imaging. So any credit, loan, collateral, or account documents that you wanna image can be put into the AccuAccount system. We do our exception tracking. So our exceptions are based on your imaging, or you can use it without imaging if you would like. But that would track any missing or expired documents. You can do task exceptions, policy exceptions, category reporting, anything that you want to use for your exceptions. And, of course, all of those filter into our reporting options, which, again, we're gonna look at in-depth today. So the reporting options in AccuAccount empower users to build, save, share reports in the system all within AccuAccount. So we do have canned reports, which are pre built reports in the system. We have eleven standard exception reports. We have several other reports that are available in the system that any user has access to view. For those canned reports, you can set up a subscription and have those emailed out on a regular basis. So for example, if you are using an exception report by officer, every officer can get their exception report maybe every Monday morning at eight thirty. Maybe the branch manager wants it monthly and a regional manager wants it quarterly. You can set up those subscription options to be generated when you want them to be sent out. We also have our our custom reporting options within the system. So a user can go in with permissions to do so. They can go in and build reports without any help from your IT or administrators, or you can also, customize some pre built reports that we have in our dynamic reporting module as well. You can mix and match the records and fields that you care about most. You can have customer information, loans or applications, deposits, trusts, and then pull in additional data like the exception tracking information, user information, tasks, any dates you want to see. Really, any important information that you want to have on your reports, you can add to those custom reports in the system. It it's really easy to use. It lets you drag and drop fields around really quickly so you can organize the data, you can group information together, and you can filter on any of the fields that are available on the reports. In those custom reports, you can also bring in flex fill data. So it doesn't have to be one of our standard fields within AccuAccount. If you either import flex field data, so any custom fields you want in your AccuAccount system, that might be coming from your core. It could be coming from a third party product like an LOS, or it can be information that you're adding manually into Accu account. We can add that Flexfill data into your reports. So we do have a lot of different sharing options for both the canned reports and the custom reports. They can be exported. They can be emailed. You can set up the subscriptions. You can share those reports, within your institution. So we'll look at some of those sharing options today. And your custom reports can be added to your dashboards when you log into AccuAccount. So when you initially open up AccuAccount, you can have all of those important reports showing right there on your dashboard. So before we get into the demo, I just wanted to mention some additional features that AccuAccount offers. We're not gonna go into detail on these today, but if you'd like additional information on any of these features, feel free to reach out to us. And we can either set up a mini demo on these, features or send you a video on how to use them. But we do offer emailing documents out of the system. We offer a participations module. It's also used for document sharing. So if you want an automated way to share documents either with downstream participating banks or with third parties, we can set up, an automation to do that. We offer an audit module, so you can build out a dataset to give to your auditors or an examiner. You do not have to give them access into your Accu account system. We have offer a built in quality control for everything that you do with your documents in Acu accounts. You can see a history of everything that's being done as well as be able to go in and approve or reject changes in the system. Again, those flex fields that we can bring in, so custom fields that you wanna track on your customers or accounts. We do handle related entities. So if you're wanting to tie customers together, maybe they're sister companies, DBAs, something where you're wanting to tie the actual customer together, not just accounts. We handle that through related entities and offer reports on those as well. We handle cross collaterals in the system, so you're only having to image and track collateral data one time for multiple loans. And we have a built in purge process, so you can set up document retention rules to purge data out of your system on your timeline. So for our demo agenda today, we're gonna cover just a few things here. The customer and account layout. So I'm gonna give you a high level overview of what the customer page looks like and where you would find that data. We're going to focus mainly on the reporting options that are available within AccuAccount and how to pull out that data and talk about some of the best practices for using those reports in the system. So So I'm gonna go ahead and jump into AccuAccount. Let me go ahead and bring up the site here. I'm gonna log in to AccuAccount. Typically, you would have Microsoft authentication turned on, so you would automatically be logged into your Accu Accu account site based on your the user that you're logged into your PC as. So I'm logged in as myself. And when I initially come into Accu account, we're gonna be looking at the dashboard. So this dashboard is customizable by user. Everybody can see exactly what they want to see when they open up Accu account. So there are several widgets that you can turn on here to be displayed. They can be rearranged. They can be resized. I even have one of my custom reports, my exception report by officer, that's displaying here on my dashboard. So if that's something that I need to keep up with regularly, it could be something on the dashboard, and I can work the report right from here if I wanted to. You can also have multiple dashboards. You can actually have unlimited dashboards set up. I have an exception reporting dashboard. I have, just a standard report dashboard or tracking dashboard. So if I were to click into, like, this reports dashboard, these are four different reports that I need to focus on as part of my job duties. And you can have that as your dashboard page when you initially log into the system. So everybody's going to see exactly what they want, and these reports also have hyperlinks to get directly to your customer pages. So of course you have your search options, but you can also click on these hyperlinks which would jump right to the customer, which is just a quicker way to get that information. I'm gonna go ahead and search out a customer's page now. I'm gonna go to Amalgamated Industries, which if you've been on any of my webinars before, you know that's kind of my go to customer here that we look at. And just to give you a high level overview of what you're seeing here on the customer page, and every customer would have their own page to image and or track exception information. But up along the top, you're going to have all of the customer data. This is coming in from your core system and we will update it nightly so that we stay in sync with your core. The customer type is going to drive the documents that are going to be required for the customer or credit side of the customer page. So when you implement the software, you would build out what documents you want to see for each of your customer types and they would be listed here. We can see items that have an image indicator, and I can view the images very easily by clicking on these icons. We can track expiration dates to, show up on your reports automatically. We'd also have any missing images show up on your reports automatically, so anything that doesn't have an image there is going to track. And the right side of the customer page is then going to be focused on all of the account specific information. So I'm on the loan tab. You optionally can have deposits and trusts coming into the system as well. You're going to system as well. You're going to have the banner for your account information displaying, which comes from your core system as well, and we we update that nightly. And your loan type is going to drive the document structure that's going to be required on this specific loan. So you have a lot of the same features. You can have the images, you can add comments, your expiration dates, and so on to track on your reports. Down below the loan is where you're going to have the additional collateral information. So we can see this loan above has five pieces of collateral. I'm looking at collateral number one. We have some additional information coming in from the core system as well as a document structure to track the documents that are associated with this collateral that we're viewing. So I just wanted to give you a high level of how the layout looks for your customer page or an Accu account. So when you are building data reports in AccuAccount using our custom report module, which is called dynamic reporting, you can pull in any of this data. So any of the customer data, any of the loan data, document information, exception information. We can even build reports for, your related entities, your cross collaterals, expiration dates, anything that you find on the customer page, we can pull that into a custom report. As far as flex field information goes that shows on your reports, you're gonna see that information in this, expand and collapse option. So if you are pulling in flex field data at the customer level, you're going to see it up here at the top with the customer banner. So again, this information can come in from your core system, from a third party, or you can enter this information manually. There's also a section where you can add that flexfill data at the loan level. So if it's loan specific, you're going to see that option here. And that information can also be added down on the collateral as well. It works the same way. So for this specific loan, I have some HMDA information that I have collected, and we can pull reports on this information or it can be just something that you're viewing if it's gonna be informational that you need to look at, per customer. The exception tab that you see here about the credit, you're gonna see that on the loan or any account that you're viewing, and you also have it down in the collateral section. This is also a big part of our reporting is showing the exception information on your report. So we have a lot of reports and features built around our exception options in here. We can see if we go into the exception tab for this particular loan. I have a set of task exceptions that are tracking as active for this loan. I also have a document exception, so my borrowing base certificate has expired. So that automatically starts tracking. If we look at the credit exceptions over here on the left, I also have some task exceptions. I have a couple policy exceptions that are tracking, so we know it's a policy exception because it has this little p icon next to it. And then also some missing documents, so I have a couple missing images from my documents tab. Those automatically track on your exceptions and on your reports as well. So any of this information that we've looked at again can pull onto your reports. There's more information, but I just want to give you a high level, overview of how this works. Now before I get into the actual reports, I want to show you a search option that you can use to build a custom report. So everybody has access to this. Our main search screen allows you to search for anything in the system, basically, that's on the customer page. So I have customer information. I have the customer's flex field information that I can search by. I have my account and collateral information, flex field datas that that I can search by, and then we also have our approval information. So if you're using AccuApproval to track your loan applications, you can search by that data as well. So you can see that there is a ton of fields that you can search for information by here on our customer page. So I want to give you an example of how this can be used. I'm going to use this, flood zone on my collateral level to do a search. If I'm wanting to see all pieces of collateral that are flagged in a flood zone, I can use my search option here. Go ahead and hit search. It's going to give me a search results page for any collateral that is is marked as in a flood zone. Now this is our our normal search page. You can use this to create a report for any search that you do. So up here at the top, there's this option to view grid. When you click on this, it's going to give you, a grid view of that data that we had on the previous page for the properties that are in a flood zone. You can go in and do additional filtering options in here. So you can set equal to, not equal to, contains on any of these, header fields that you see up here at the top. So you can filter that information. You can sort on this information. And there's also an option up here at the top to create a PDF with this data or create an Excel with this data. So that is a way that you can export information. So anything that you search by on that main search screen, when you pull up that search results, you can turn it into a report by using this view grid option. I'm gonna go ahead and go back to our search page just to give you one more example of how powerful that is. You can also do like a collateral description search. So if there's a specific word that you're looking for, you need all collaterals that have a specific word in the description. You could type that in. So if I type in VIN, I and I typed in when. Let's do that again. If I type in VIN here, it's going to return any of my collaterals that have VIN in the description. So if I'm needing to see all all, vehicles or something like that, that would might be a word that I use in here. K. So same thing. Once I have that result, I can do my view grid option, filter, on any of the columns, and then I can export that to an Excel or a PDF to get the data. The next option we have for reports, and there are a ton of reporting options if you go under this drop down here, but just looking at our exception reports. It's usually a hot topic for AccuAccount. I do already have the exception report open just for time purposes. But in here, you have eleven standard canned reports that are in the system. We have our exception report by assigned user, by branch, by officers, by customers. There's a lot of different options that you already have in the system that you can view these reports on demand. So if I were to go into my exception report by officer, each report is going to have some different parameters that you can set up here at the top. So if I want to see all of Alex Haley's exceptions, I can also narrow down by branch, by exception state. So if I want to see pending exceptions, ones that are in the lead time. I can do date range. I can include or exclude policy exceptions. So a lot of different options here. And, again, all of those eleven exception reports have some different filtering options just depending on the type of report it is. When you render this report, so we are looking at Alex Haley's officer reports, It's going to show all of his exceptions that are tracking. So you'd see the customer information, the account information, the exception information, and any any comments that you add on your exception on the customer page are also going to show on the exception report. So you'll be able to see all comments that you add. No matter how many comments there are, they will be displayed here on the report. You also have a hyperlink. So the customer name, customer number, and account number or loan number is going to be a hyperlink. So if you click on that link, it's going to take you right to that customer's page if you needed to view some additional information on it. So really easy to pull these reports on demand. There are again several other reports that you can pull. You can do your classified accounts, cross collaterals, expiring documents. We have, account applications. So if you're using AccuApproval to track your loan applications, we have several prebuilt pipeline reports in there. Notices. You can see a history of all the notices that are generated out of AccuAccount. You can look at specific policy exception reports, related entities, document history. There's a ton of reporting options that you have that you can go in and pull on demand, and any of your users in AccuAccount are going to have access to view those reports on demand. These reports can also be set up on a subscription. So any of the reports that are listed here, you can have that subscription sent out. So you can go in and set a schedule for when you want that data to be generated and emailed out to anybody at your financial institution. So it might be your lenders, it could be your branch managers, whoever you want that to go to on a regular basis. When you send out that subscription, this is the email that they're going to get. So you actually have two options when you set up these subscriptions. You can have the report embedded into the email like you see here. So it looks the same as if you were to pull this report on demand. It's just showing in an email. Or you can have the report attached to the email as a PDF. So you have that option for each subscription that you build in AccuAccount. So when you're viewing the report in an email, again looks very similar to that on demand report. We're gonna have all the customer account and exception information that we were seeing before as well as the hyperlinks to get to the customer's page. So if your lender is working their exception report from the email, they should have all of the information that they need to, work the report, reach out to the customers to get this information. And but if there is additional information that they are wanting to see, they can optionally use the hyperlinks in here to jump right to that customer's page to view additional information or add comments to the exceptions that would show in the next report that gets generated. The next reporting option that I wanted to show under reporting is this my reports, and this is where you get into our dynamic reporting information. This is our module that allows you to build custom reports within Accu account. This can be any type of report. This can be exception reports, data reports, system log reports, user permission reports, anything that you're wanting to pull out of Accu account. When you come in here, you're going to see reports that you have created as long as you have permissions to do so, and you'd also be able to see reports that have been shared with you. So other users that build reports have the option to share it with specific users, or they can share it bank wide and you would have access to those reports down below. So you can see I have a lot of different reports built out here. Here you can build unlimited reports in our dynamic reporting module. You have the ability to create a report from scratch, which we'll look at in a moment, and you can import reports as well. So if you're wanting to start with something that is already pre built and then adjust it as you need, you can use this import report option. It'll take you out to our support site where you can download pre built reports and then modify them to your liking. These reports can be emailed out of the system. You can export the data. You can download the reports if you wanted to just email it to somebody else as an attachment. You can share it again with others, and you can do a copy option. That copy option is really nice because if you create a report, say, the exception report by officer, but I created that officer report to just show Alex Haley's reports I'm sorry. Just Alex Haley's exceptions, you can create another copy of it to show somebody else's exceptions one for every officer if you really wanted to without having to go in and rebuild the whole report. You can just make a copy of it and then change the officer drop down in that report. So that'll make more sense in just a moment. I'm going to get into a couple different examples of these reports. Let's first go ahead and go into this exception report by officer. I have a lot of this information already created for this report. So you can see we have the customer's name, customer number, officer, and so on. But over here on the left, you're going to have fields of information. This allows you to select additional fields to show as columns on your report as well as some filtering options. So if there's additional customer data, I can expand on that option, and you can see all of the fields that you have as an option to display on this report. So let's say, for example, I want the customer's branch to also be on this report. You just click on that option, and it creates it as a column. So it's very easy to add those and then you can go in and rearrange these columns for however you want to view that information. There's also filtering options. So if I wanted to filter by branch, I can click on this little filter option and I can either create a search field so if I want to type something specific into the search or if I want to do a multi select so it lists out all of the possible branches and then you can select which ones you're wanting to filter on from there. So not only can you go in and add those fields, add the filters, you can then click on the column names to sort ascending or descending. You can group the information by dragging the column up to the top. So if I want to group this by officer, since this is the exception report by officer, I'm gonna take the officer and just drag it up here to the top. And now I have it grouped. And don't mind. I have a blank officer in my system. I might ignore that one. But you can expand and collapse on this officer field. So Aaron Pittman is one of my officers, and then I can see all of the exceptions that are tracking under his name. And I can see Alex Haley's and again these can be expanded or collapsed as you're viewing the data on this report. You can also do that group option more than once. So if you wanted it grouped by officer but then you also wanted it to be grouped by customer to better organize the information, I can take the customer number or the customer name up here to the top. And now I have it I have Aaron Pittman's exceptions, but it's also grouped by customer. So if he's working this report, he can address this, this missing maintenance document and then just collapse it and continue going down all the exceptions that need to be worked and expand and collapse those fields as needed. So it's just a really easy way to help organize and easily view that exception information on these reports. Let's go ahead and create a report just so you can see what that looks like and how easy it is to build a report from scratch. I'm going to create a report and these templates are going to drive what data can be pulled onto that report. I'm going to build a HMDA report since I have that as a flex build option in this system. So it's a loan report because it's on the loan data, and I'll go ahead and call this, my HMDA report. You can also put in an optional description if you're wanting to. So I click on create. It gives me a blank slate where I can go in and start building this report report in the system. So I may wanna add my customer information. I wanna have my customer's full name, and I wanna have the customer number on there. You could add branch, officer, whatever information you would like to display. I also would like to have my loan number on here Here's my loan number We can add the loan officer branch, whatever you wanted to see in there And then I have my HMDA information You're gonna see it as a custom filled in here. So there's my custom HMDA data, and this is what I'm wanting to report on. So I wanna see if it's HMDA reportable. You may not necessarily need this as a column on your report. You can still filter by it. So I need to see if a loan is HMDA reportable. I'm gonna go ahead and do the filter option. I'll just do it as a multi select, so it gives me a yes or no. And down at the bottom, it gives me this filter for HMDA reportable. So I'm gonna go ahead and say yes. I wanna see all of my loans that are flagged as HMDA reportable. I'm gonna refresh that information, and that narrows down the loans that are HMDA reportable. I can then add, you know, the loan type, the reporting year, type of purchaser, whatever information you're wanting to display on this report. It's very, very easy to add those as columns. Then I can go ahead and say, you know, I need this grouped by officer. Now I have Aaron Pittman's HMDA reportable loans. I have Alex Haley's reportable loans. You can do the sorting options in here, really whatever you need. And then you can take this data and export it or email it from the system as needed. I'm going to go ahead and save that report. Once a report is saved, you can always go back into it. You don't have to set anything up again. It will keep all of the filtering and group options that you had selected when you when you built this report. Or if you go in and make changes to it, as long as you hit save, that's how it's going to open that report the next time you view it. Now I'm gonna circle back to our dashboard page that we originally looked at when we came into the system. I'm going to go ahead and edit this home dashboard that we're on and I'm going to change this exception report by officer. So I have this edit dashboard option and all of those custom reports that were created are going to show in this option, to show as a widget on your, for your report on your dashboard. So if I go ahead and go in and I find my HMDA report that I just created, I'm gonna go ahead and say done editing. There's that HMDA report. So if that's something really important that you need to go in and work every day and monitor, you would create that as a custom report, and you could have it here on your dashboard. And, again, there are options to turn on the hyperlinks so you can jump right to these customer pages as needed. So those are the reporting options that I wanted to highlight today in accu account. Let me go ahead and jump back to our presentation here. And just to let you know some of the other options that you have available for learning more about AccuAccount, we, of course, have these Banker Buzz webinars that you can join anytime. We do offer trial sites. So if you don't currently have AccuAccount and you want to have your own site to play around in, just let us know, and we'll set you up with a trial site of AccuAccount. We do offer one on one demos. And we can always do a price quote. So if you're interested in getting pricing information on Active account, just let us know. So I'm gonna go ahead and open it up for questions now. If you wanna type your questions into the questions or the chat window on the GoToWebinar panel, and it'll answer those questions. I do have a couple in chat here. Are there limits to how many fields can be added on the custom reports? No. There is not. You can add as many fields of information on those custom reports as you would like. When you export it, it's going to be in a CSV file, so it'll just open, in an Excel spreadsheet. So really it doesn't matter how many, how many fields you add in there. How many subscriptions can be set up for each report? The the subscription options are on our canned reports, and you can have as many subscriptions as you would like. So it really is unlimited there as well. And can categories be created to combine exceptions into one report? Yes. That's a great question. We do offer category options, so you can create as many categories as you'd like. We see a lot of, institutions do like an insurance category, a UCC category, financial category, and that allows you to tie multiple exceptions into that category and you can pull reports by category to combine those, yes. Any other questions? Feel free to type those into that questions panel. Alright, looks like that's it for now. If you do have any questions that come up after our webinar today, feel free to contact us here at Allergan. Thank you for everyone who joined, and have a great day.