Resource
Videos

Transform AR/AP Analytics into Strategic Advantage with GSmart Ledger

Transform AR/AP Analytics into Strategic Advantage with GSmart Ledger

Download

Your AR/AP data is money left on the table. While your team spends hours analyzing payment data in spreadsheets, you're missing critical insights about customer behavior, cash timing, and strategic opportunities. As CFOs demand greater forecast accuracy and real-time visibility, manual processes can't deliver the precision needed for modern treasury operations.

Watch a recording of “Transform AR/AP Analytics into Strategic Advantage with GSmart Ledger,” hosted by GTreasury's Evan Ryan. This exclusive 30-minute session demonstrates leading finance teams are transforming AR/AP analytics with AI-powered automation to achieve over 30% improvement in forecast accuracy.

In this webinar, you'll learn how to:

  • Eliminate hours of manual AR/AP data analysis with automated ERP integration
  • Leverage AI to understand customer-specific payment behaviors and timing
  • Transform static forecasting assumptions into dynamic, data-driven predictions
  • Generate board-ready cash flow forecasts in minutes, not days

Explore how GSmart Ledger delivers intelligent automation for AR/AP analytics while seamlessly integrating with comprehensive treasury intelligence.

Transcript

00:03:59.880 --> 00:04:08.950

GTreasury Marketing: Hello, everyone, and thank you for joining us today. We will be starting in a few minutes to give all of our attendees time to join the webinar, so sit tight, and we will be starting shortly.

00:05:30.470 --> 00:05:34.209

GTreasury Marketing: Hello, everyone. Thank you for joining us today for our webinar.

00:05:34.480 --> 00:05:41.159

GTreasury Marketing: Transform AR-AP analytics into strategic advantage with GSmart Ledger.

00:05:41.250 --> 00:05:44.729

Evan Ryan: Let's cover a couple of housekeeping items before we get started.

00:05:48.080 --> 00:06:02.259

GTreasury Marketing: Today's event is scheduled to last 30 minutes, including time for questions at the end. All participants are muted, and if you have any questions at any time throughout the presentation, please enter them into the Q&A section on your Zoom control bar.

00:06:02.590 --> 00:06:04.609

GTreasury Marketing: This webinar is being recorded.

00:06:04.610 --> 00:06:08.600

Evan Ryan: And a link to the recording will be sent via email to all participants.

00:06:09.570 --> 00:06:15.590

GTreasury Marketing: Our speaker today is Evan Ryan, therefore I will hand it over to him for a quick introduction.

00:06:16.500 --> 00:06:23.590

Evan Ryan: Thanks very much, Anne. My name is Evan Ryan. I'm a cash forecasting product manager here at,

00:06:23.730 --> 00:06:29.180

Evan Ryan: Chief Treasury, and excited to, jump into the presentation today.

00:06:31.380 --> 00:06:36.279

Evan Ryan: So today, talking through Transform AR and AP Analytics.

00:06:36.480 --> 00:06:41.599

Evan Ryan: And just into strategic advantage, with the GSmart Ledger.

00:06:43.410 --> 00:06:54.779

Evan Ryan: So, to talk through what I'm actually going to be, going through today, brief introduction, then the AI transformation, see how

00:06:54.920 --> 00:06:59.729

Evan Ryan: Ai is, across the G Treasury platform.

00:06:59.930 --> 00:07:03.050

Evan Ryan: Second piece around the hidden cost of manual

00:07:03.350 --> 00:07:15.029

Evan Ryan: payment analysis, jumping onto the intelligent automation for AR and AP, and then jump into the actual system itself, the Smart Ledger itself, for a quick demo.

00:07:17.320 --> 00:07:27.229

Evan Ryan: So, this slide really illustrates where AI is across the whole GTreasury platform, and, you know.

00:07:27.430 --> 00:07:42.840

Evan Ryan: AI is nothing new to GTreasury. It's actually existed within GTreasury for the last number of years. You can see there are different types of AI models, so, you know, there's the agentic type statistical modeling, fuzzy logic.

00:07:43.130 --> 00:07:51.110

Evan Ryan: And today we're going to be focusing on that second piece, that cash forecasting, GSmart Ledger, and statistical modeling.

00:07:52.370 --> 00:07:56.520

Evan Ryan: So… What does the GSmart Ledger…

00:07:56.620 --> 00:07:59.709

Evan Ryan: actually tried to do, and what does it achieve?

00:08:00.090 --> 00:08:03.440

Evan Ryan: So, essentially, it's an AI-driven module.

00:08:03.610 --> 00:08:08.170

Evan Ryan: And it automates the short- to mid-term cash flow forecasting.

00:08:08.390 --> 00:08:16.370

Evan Ryan: And what it does is it analyzes the real-time accounts receivable, accounts payable.

00:08:16.600 --> 00:08:24.279

Evan Ryan: And it uses machine learning to learn how your customers have been paying you in the last

00:08:24.770 --> 00:08:31.339

Evan Ryan: year, six months, and also how you've been paying your vendors over the last.

00:08:31.610 --> 00:08:33.900

Evan Ryan: Over the last historical period.

00:08:35.049 --> 00:08:39.149

Evan Ryan: It uses that data, then, to generate a forecast.

00:08:39.539 --> 00:08:54.900

Evan Ryan: And it's continually learning, okay? So every time we take in a new load of data, that data then is added into that database, so the system, the GSmart ledger, actually gets more accurate.

00:08:55.030 --> 00:08:56.220

Evan Ryan: Over time.

00:08:57.070 --> 00:09:12.040

Evan Ryan: We've actually done some analysis, and we've shown that GSmart Ledger is up to 30% more accurate for accounts receivable, and predicting when customers are going to pay, compared to what our clients see

00:09:12.040 --> 00:09:17.419

Evan Ryan: within their ERP systems. And I'll touch on that in a little bit more detail

00:09:17.580 --> 00:09:19.309

Evan Ryan: In a couple of moments.

00:09:21.630 --> 00:09:29.500

Evan Ryan: So, I really want to get into, how the GSmart Ledger is really transforming forecast accuracy.

00:09:29.670 --> 00:09:38.079

Evan Ryan: So, I touched on that 30%, figure on the previous slide, and we need to delve in a little bit more

00:09:38.250 --> 00:09:40.630

Evan Ryan: Into that figure, and what that means.

00:09:42.020 --> 00:09:48.390

Evan Ryan: So… Before I do that, I just want to talk about the AR and AP pain points.

00:09:49.340 --> 00:09:52.080

Evan Ryan: I'm sure, you know, I'm preaching to the choir here.

00:09:52.500 --> 00:09:56.969

Evan Ryan: A lot of folks on this call, can really relate to this slide.

00:09:57.880 --> 00:10:03.929

Evan Ryan: But essentially, you know, we're talking about varying payment behaviors across customers.

00:10:04.160 --> 00:10:13.069

Evan Ryan: Really, vendors making it really difficult to, accurately predict when those customers are going to pay you.

00:10:13.570 --> 00:10:20.499

Evan Ryan: And we know then that customers don't pay to terms. They really do have their own payment habits.

00:10:21.840 --> 00:10:28.009

Evan Ryan: Also, An extra challenge is dealing with large volumes of data.

00:10:28.580 --> 00:10:31.229

Evan Ryan: Be it customers or vendors.

00:10:31.340 --> 00:10:37.720

Evan Ryan: And often this data is siloed across multiple ERP systems.

00:10:37.920 --> 00:10:39.630

Evan Ryan: Across your organization.

00:10:39.890 --> 00:10:47.680

Evan Ryan: And the Smart Ledger really gives you that consolidated bird's-eye view of your AR and AP payment behavior.

00:10:48.860 --> 00:10:51.520

Evan Ryan: Again, you know, uncertainty over timing.

00:10:51.660 --> 00:10:55.590

Evan Ryan: Really then can lead into inaccurate forecasts.

00:10:56.120 --> 00:11:02.710

Evan Ryan: I've spoken to a number of CFOs in the past, where because of that uncertainty.

00:11:02.900 --> 00:11:09.550

Evan Ryan: They really have to build up those liquidity buffers, and this essentially is cash that's

00:11:10.120 --> 00:11:13.389

Evan Ryan: Not working for you, you know?

00:11:13.510 --> 00:11:15.890

Evan Ryan: And I show how, you know.

00:11:16.110 --> 00:11:18.459

Evan Ryan: Tying or freeing up that cash.

00:11:18.610 --> 00:11:24.280

Evan Ryan: It's beneficial, essentially, due to the fact that you have a more accurate forecast.

00:11:27.350 --> 00:11:35.349

Evan Ryan: So here, you know, transforming AR and AP and working capital with the Smart Ledger, is it a science? Is it an art?

00:11:35.520 --> 00:11:36.329

Evan Ryan: It's both.

00:11:36.930 --> 00:11:46.689

Evan Ryan: You know, a couple of challenges I want to call out on the left-hand side, and then the solutions on the right-hand side, and how GSmart Ledger can really assist with that.

00:11:47.770 --> 00:11:50.379

Evan Ryan: So, firstly, you know, a lack of confidence.

00:11:50.520 --> 00:11:57.999

Evan Ryan: Inaccuracy for cash flow forecasting. And this, as I said, is due to that variance

00:11:58.250 --> 00:11:59.940

Evan Ryan: Of your customers paying.

00:12:01.260 --> 00:12:10.619

Evan Ryan: And the solution there is really to integrate that AI and AP ledgers, and using that historical analysis, AI

00:12:10.800 --> 00:12:17.789

Evan Ryan: Model, we can calculate and predict much more accurately when those customers are going to pay you.

00:12:18.740 --> 00:12:21.520

Evan Ryan: Second piece here is around visibility.

00:12:21.990 --> 00:12:26.789

Evan Ryan: So it really is that limited visibility into your cash flow drivers.

00:12:27.320 --> 00:12:32.730

Evan Ryan: During the demo, I'll jump into not only the Smart Ledger itself.

00:12:32.870 --> 00:12:42.399

Evan Ryan: but a consolidated, like, working capital view, dashboards, which are, you know, I'm excited to actually show you today.

00:12:43.500 --> 00:12:48.009

Evan Ryan: So the second piece, so the solution to that, then, is those cash flow

00:12:48.330 --> 00:12:58.220

Evan Ryan: forecasts, they're auto-adjusted with that learned behavior for better accuracy. So, it's not a case that you need to come in every time the

00:12:58.540 --> 00:13:10.209

Evan Ryan: refresh of data comes in, and you need to adjust things, you know, it's really kind of set it and forget it, and I'll show you how you can utilize the rules within the Smart Ledger to then feed into your forecast.

00:13:11.450 --> 00:13:21.569

Evan Ryan: Final challenge, then, that people are facing at the moment is really, as I said on the previous slide, you know, dealing with large ERP extracts.

00:13:21.900 --> 00:13:26.409

Evan Ryan: … We can integrate with any ERP,

00:13:26.700 --> 00:13:37.550

Evan Ryan: pull in the data, be it on a daily basis, on a weekly basis. The data is then refreshed, can set it up on a scheduler, and then that comes in to feed into your,

00:13:38.040 --> 00:13:42.880

Evan Ryan: the GSmart Ledger, and you can really do a deep dive analysis on a customer level.

00:13:43.140 --> 00:13:45.709

Evan Ryan: Vendor level, and then those…

00:13:45.950 --> 00:13:51.980

Evan Ryan: That data then feeds into your forecast, and ultimately then into those working capital dashboards.

00:13:55.020 --> 00:14:00.389

Evan Ryan: So, how does the GSmart Ledger actually work?

00:14:00.720 --> 00:14:05.180

Evan Ryan: So it's an ERP integration for the automated short-term forecast.

00:14:05.590 --> 00:14:13.159

Evan Ryan: And the historical data is analyzed with machine learning. And this one is what then generates

00:14:13.350 --> 00:14:16.769

Evan Ryan: Those historical average days to pay.

00:14:17.480 --> 00:14:21.349

Evan Ryan: So, for example, if an invoice comes in.

00:14:21.460 --> 00:14:26.770

Evan Ryan: You know, sent to a customer with terms of 45 days, but…

00:14:27.040 --> 00:14:37.130

Evan Ryan: Smart Ledger can tell you, well, actually, on average, this customer doesn't pay within 45 days, this customer typically pays within 50 days.

00:14:37.760 --> 00:14:43.989

Evan Ryan: And what that due date… what actually happens to that 45-day due date?

00:14:44.160 --> 00:14:55.080

Evan Ryan: That's auto-adjusted within your forecast to 50 days, so you have a more accurate forecast. So again, you know when cash is going to be coming in.

00:14:55.260 --> 00:14:58.419

Evan Ryan: From your client… from your customers, more accurately.

00:15:00.080 --> 00:15:08.980

Evan Ryan: The fourth piece here is around that consolidated ARNAP performance dashboard, so you really have a bird's eye view

00:15:09.130 --> 00:15:09.950

Evan Ryan: …

00:15:10.170 --> 00:15:21.760

Evan Ryan: You know, at a very high level, and then you can quickly drill down to an invoice level, just really see, you know, from an overdue perspective, see what's outstanding at a customer level.

00:15:25.080 --> 00:15:31.840

Evan Ryan: So… as I said, we ran some analysis, and we saw that, on average.

00:15:32.090 --> 00:15:40.869

Evan Ryan: The GSmart Ledger improves short-term forecasting by up to 30% for accounts receivable, compared to how…

00:15:41.110 --> 00:15:46.270

Evan Ryan: our clients were seeing the payment terms within their ERP system.

00:15:46.910 --> 00:16:05.880

Evan Ryan: It was run on an individual invoice level, and compared the data within the GSmart Ledger, and essentially the due date in the GSmart Ledger, using those historical average days to pay, comparing that to the standard terms within the ERP system.

00:16:06.280 --> 00:16:11.320

Evan Ryan: And the G Smart Ledger was up to 30% more accurate.

00:16:15.340 --> 00:16:19.250

Evan Ryan: So, you know, what does… 30%.

00:16:19.720 --> 00:16:23.619

Evan Ryan: increase in forecast accuracy mean for your Treasury team?

00:16:24.310 --> 00:16:31.320

Evan Ryan: Well, so the first one then is, you know, you can really free up working capital so the business can run on

00:16:31.670 --> 00:16:34.159

Evan Ryan: As, run on less cash.

00:16:34.430 --> 00:16:37.789

Evan Ryan: So, I would say as, you know, as lean as possible.

00:16:38.210 --> 00:16:41.690

Evan Ryan: Safely reduces excess cache buffers.

00:16:42.210 --> 00:16:48.190

Evan Ryan: And then, you know, avoids that costly short-term borrowing for collection surprises.

00:16:48.740 --> 00:16:53.739

Evan Ryan: Obviously, then you, and I'll show this within the dashboards, that excess cache.

00:16:53.890 --> 00:17:03.179

Evan Ryan: You can place it out on a term, or use it to pay down a credit facility as well. We can actually calculate that figure as well, which is very useful.

00:17:03.670 --> 00:17:10.419

Evan Ryan: But ultimately, We're enabling clients to make faster and more confident decisions.

00:17:13.140 --> 00:17:18.230

Evan Ryan: I know, Shannon is going to now pop up a, poll question.

00:17:27.990 --> 00:17:30.369

Evan Ryan: Shannon, do we have that poll question?

00:17:44.640 --> 00:17:50.929

Evan Ryan: I'm not too sure what's, happening with that poll question.

00:17:51.080 --> 00:17:55.219

Evan Ryan: But essentially, I can, … Read out the…

00:17:55.540 --> 00:17:56.669

Evan Ryan: Shannon, do you have it there?

00:17:56.670 --> 00:17:59.960

GTreasury Marketing: Yes, the poll question, is being answered.

00:18:00.420 --> 00:18:03.069

Evan Ryan: Okay, sorry, I just can't see it on my screen.

00:18:50.160 --> 00:18:51.899

GTreasury Marketing: Can you see the results, Evan?

00:18:52.200 --> 00:18:57.140

Evan Ryan: … I can't, actually. I don't know if… could you read them out, Shannon?

00:18:57.140 --> 00:18:58.169

GTreasury Marketing: Yes, I can.

00:18:59.470 --> 00:19:01.630

Evan Ryan: So….

00:19:02.020 --> 00:19:09.450

GTreasury Marketing: the… Question is, what best describes your organization's current use of AI in cash flow forecasting?

00:19:09.580 --> 00:19:29.020

GTreasury Marketing: So we have 38% planning to implement AI within the next 12 months. We have 46% researching AI options, but unsure where to start, and 15% haven't considered AI for forecasting processes yet.

00:19:30.240 --> 00:19:32.030

Evan Ryan: Thanks very much, …

00:19:32.210 --> 00:19:42.920

Evan Ryan: So, yeah, we, … well, actually, I'll discuss, the usage of, AI in the demo here, and, you know, we can discuss that,

00:19:43.220 --> 00:19:44.120

Evan Ryan: So…

00:19:44.510 --> 00:19:54.749

Evan Ryan: there were, yeah, the largest result here, 46%. People are currently researching AI options, but unsure where to start, so…

00:19:55.090 --> 00:19:59.880

Evan Ryan: Hopefully folks have a, kind of, a good idea. …

00:19:59.990 --> 00:20:07.540

Evan Ryan: Once I've finished the demo here, so let me just… Jump into the demo…

00:20:11.120 --> 00:20:12.060

Evan Ryan: I just…

00:20:17.320 --> 00:20:19.220

Evan Ryan: Okay…

00:20:29.150 --> 00:20:33.080

Evan Ryan: So, Shannon, you can see the screen here.

00:20:33.080 --> 00:20:33.800

GTreasury Marketing: Yes.

00:20:34.060 --> 00:20:35.320

Evan Ryan: Perfect. Okay.

00:20:35.670 --> 00:20:43.669

Evan Ryan: So, where we're gonna actually start off first is within the actual forecasting sheet.

00:20:44.090 --> 00:20:53.929

Evan Ryan: Okay, so here I have my actuals, so what happened in the previous week, and here's my forecast of what's happening in the next 13 weeks.

00:20:54.380 --> 00:21:02.800

Evan Ryan: I've jumped into the Ireland business unit here, and I can see my cash flow line items, my cash flow categories on the left-hand side.

00:21:04.210 --> 00:21:18.759

Evan Ryan: I have my AR collections here, and then I have my AP collection, or my AP payments here, and my specific line item here, my suppliers, but I'm just going to focus on the AR collections first.

00:21:20.620 --> 00:21:26.629

Evan Ryan: So, I can see I have a number of different weeks, … Out here into the future.

00:21:26.870 --> 00:21:30.659

Evan Ryan: And if I double-click on the first cell here.

00:21:30.780 --> 00:21:34.359

Evan Ryan: I can get a breakdown of that 1.2 million.

00:21:35.100 --> 00:21:42.059

Evan Ryan: euros that's feeding into that, and that data is ultimately coming from the GSmart Ledger.

00:21:42.960 --> 00:21:47.130

Evan Ryan: So, whatever invoices are forecasted

00:21:47.950 --> 00:22:04.789

Evan Ryan: to be collected in week 4 are appearing in that 1.2 million amount. I can drill down to an invoice level, and then if I drill down a little bit deeper, I can see that there was an original due date on this.

00:22:04.930 --> 00:22:08.269

Evan Ryan: But then that's actually been auto-adjusted due to that.

00:22:08.540 --> 00:22:11.070

Evan Ryan: Historical average days to pay.

00:22:11.970 --> 00:22:15.260

Evan Ryan: So, that's basically the starting point.

00:22:15.430 --> 00:22:19.840

Evan Ryan: For the demo, and I'll jump into the actual Smart Ledger itself now.

00:22:21.110 --> 00:22:26.129

Evan Ryan: So I can jump into the, Smart Ledger demo, or Smart Ledger.

00:22:26.360 --> 00:22:27.230

Evan Ryan: itself.

00:22:27.990 --> 00:22:30.950

Evan Ryan: So, here, within the Smart Ledger.

00:22:31.220 --> 00:22:34.699

Evan Ryan: This is where that ERP data lives.

00:22:35.090 --> 00:22:39.539

Evan Ryan: There's a number of different data sets that we take in from your ERP.

00:22:39.690 --> 00:22:44.310

Evan Ryan: The open reports, so your current AR and AP aging report.

00:22:44.500 --> 00:22:46.269

Evan Ryan: All payments.

00:22:46.380 --> 00:22:47.680

Evan Ryan: And also…

00:22:48.070 --> 00:22:56.680

Evan Ryan: any closed data. So, closed data being invoices that have been paid. In this case, in the last week, it could be in the last month.

00:22:58.450 --> 00:23:08.800

Evan Ryan: So I can see I have a number of different items across here. I can see at an invoice level, you know, really what's happening at an invoice level.

00:23:09.240 --> 00:23:15.999

Evan Ryan: I'm… I can see all of my open invoices, so this is the current aging bucket.

00:23:16.260 --> 00:23:21.020

Evan Ryan: I have less in less than 30 days. I'm…

00:23:21.220 --> 00:23:24.049

Evan Ryan: Projected or forecast to collect 15…

00:23:24.400 --> 00:23:27.600

Evan Ryan: Million euros, 31 to 60.

00:23:27.960 --> 00:23:30.569

Evan Ryan: 7 million euros, and so on and so forth.

00:23:30.740 --> 00:23:33.949

Evan Ryan: I can also view what's overdue as well.

00:23:34.230 --> 00:23:38.420

Evan Ryan: Also, a currency breakdown and so on. So at the moment, I just have Euros in this.

00:23:38.540 --> 00:23:43.130

Evan Ryan: Ledger, but we can handle multiple currencies as well.

00:23:44.840 --> 00:23:52.670

Evan Ryan: Also, I can view my paid invoices, so all the payments, or all invoices that have been paid over the past, period.

00:23:54.620 --> 00:23:55.900

Evan Ryan: All payments…

00:23:57.100 --> 00:24:04.690

Evan Ryan: But what I want to focus on here is the customer profiles. So if I jump into T-Mobile here…

00:24:04.920 --> 00:24:10.220

Evan Ryan: I can see a breakdown of my customer behavior.

00:24:10.390 --> 00:24:17.119

Evan Ryan: So these are all invoices that have been collected over the last, you know, let's say year in this case.

00:24:17.410 --> 00:24:18.600

Evan Ryan: T-Mobile.

00:24:19.200 --> 00:24:26.229

Evan Ryan: have, paid. Also, I have a view of the payment distribution and losses, so I can see, you know.

00:24:27.160 --> 00:24:31.610

Evan Ryan: The majority of payments coming are in around the 60-7 day mark.

00:24:32.290 --> 00:24:42.250

Evan Ryan: But perhaps, you know, we can take a look at orange. Orange seemed to be a bit more, let's say, well-behaved when it comes to, payment distribution.

00:24:43.070 --> 00:24:45.680

Evan Ryan: If I roll back up here into T-Mobile.

00:24:45.830 --> 00:24:57.189

Evan Ryan: What I want to focus on is this figure here, so your average days to pay. And that average days to pay is what's used to calculate that new due date.

00:24:57.320 --> 00:25:02.459

Evan Ryan: for… any invoice that's associated with T-Mobile.

00:25:03.350 --> 00:25:07.830

Evan Ryan: So when an invoice, a new invoice is sent to T-Mobile.

00:25:08.310 --> 00:25:16.939

Evan Ryan: You know, and as I said, when I was talking through the slides, maybe the, you know, payment terms were 30 days or 45 days.

00:25:17.080 --> 00:25:23.630

Evan Ryan: Historically, what's been calculated here using AI, And that statistical modeling is…

00:25:23.920 --> 00:25:30.220

Evan Ryan: To calculate the historical average terms for each individual client.

00:25:30.960 --> 00:25:43.340

Evan Ryan: So, if I jump back into my open report here, I can see I have T-Mobile. If I open this, okay, I can see my historical average days to pay for T-Mobile at an individual customer level.

00:25:44.170 --> 00:25:46.209

Evan Ryan: And if you remember back to that

00:25:46.480 --> 00:25:56.150

Evan Ryan: first or second slide within the presentation. One of the key pieces was then how this feeds into your forecast.

00:25:57.230 --> 00:26:01.220

Evan Ryan: So, if I take a look at my… Rules here

00:26:01.850 --> 00:26:06.720

Evan Ryan: Basically, I can see that I have a customer payment behavior rule here.

00:26:07.580 --> 00:26:10.059

Evan Ryan: And what I can do is I can set

00:26:11.550 --> 00:26:18.640

Evan Ryan: All clients, or all customers, for this ledger, to use that historical average days to pay.

00:26:18.970 --> 00:26:20.689

Evan Ryan: And I can see them here.

00:26:21.360 --> 00:26:26.399

Evan Ryan: But… Typically, what a lot of our clients will do is they will

00:26:26.950 --> 00:26:41.600

Evan Ryan: Set up kind of a blanket rule, and use the historical average days to pay for all customers or all vendors, but you can then go in and start tweaking and customizing that rule at a customer level.

00:26:41.900 --> 00:26:51.630

Evan Ryan: So it's not a case that, you know, you need to go in and it's just, you know, one blanket rule. You can really go down at a customer level and, you know, …

00:26:52.160 --> 00:26:53.230

Evan Ryan: updates.

00:26:53.350 --> 00:26:55.709

Evan Ryan: And, customize.

00:26:55.820 --> 00:27:05.900

Evan Ryan: when that customer is going to pay you. So I've, in this case, I have historical average dates to pay, but I can add dates to my due date, and I can do that at an individual client level as well.

00:27:07.660 --> 00:27:10.140

Evan Ryan: So once I've set my customers…

00:27:10.420 --> 00:27:15.129

Evan Ryan: my customer payment behavior. Then, essentially, I can map

00:27:15.670 --> 00:27:21.399

Evan Ryan: All of these invoices to a specific line item within my forecast.

00:27:21.880 --> 00:27:27.029

Evan Ryan: So that was that AR collections line item that you saw just a couple of moments ago.

00:27:29.370 --> 00:27:46.550

Evan Ryan: it's not the case that you need to map it all to one line item. You can specifically… you can, map specific, invoices or specific customers based off of, you know, keywords, descriptions, really to get a more granular level.

00:27:48.420 --> 00:27:57.120

Evan Ryan: So… The final piece of the demo, I just want to jump into the actual, dashboards here.

00:27:57.370 --> 00:28:05.800

Evan Ryan: So if I just, change up my… My date here… Let's see…

00:28:12.290 --> 00:28:13.710

Evan Ryan: Second…

00:28:18.680 --> 00:28:19.580

Evan Ryan: Perfect.

00:28:20.130 --> 00:28:26.610

Evan Ryan: So what I can see here is my… Current…

00:28:27.310 --> 00:28:30.529

Evan Ryan: AR balance at a consolidated level.

00:28:30.690 --> 00:28:42.809

Evan Ryan: So again, if you have multiple entities, multiple cost centers, multiple business units within your organization, this really gives you that 10,000-foot view of, you know, what's happening.

00:28:42.920 --> 00:28:55.049

Evan Ryan: So here I can see I have 226 million euros, but I can easily change up what business unit I want to filter here, you know, what currencies I want to view.

00:28:55.160 --> 00:28:58.510

Evan Ryan: And also, I can actually rewind the clock.

00:28:58.800 --> 00:29:02.889

Evan Ryan: And view the historical balances as well.

00:29:03.650 --> 00:29:11.720

Evan Ryan: So I like to kind of divide this screen up into two halves. I have my customer AR collections analysis up top.

00:29:12.100 --> 00:29:13.690

Evan Ryan: I can click into my…

00:29:13.880 --> 00:29:19.930

Evan Ryan: Current outstanding, invoices at a customer level, and then drill down.

00:29:20.460 --> 00:29:21.779

Evan Ryan: but also…

00:29:23.300 --> 00:29:32.629

Evan Ryan: bottom half of the screen here is I can see what customers are overdue. So in this case, I can see I have 78 million overdue.

00:29:33.310 --> 00:29:40.730

Evan Ryan: And also, again, like the top screen here, I can see overdue customer analysis,

00:29:42.440 --> 00:29:48.150

Evan Ryan: At a customer level, but also it's broken out per bucket.

00:29:48.510 --> 00:30:03.419

Evan Ryan: and, you know, like the top as well, the top of the screen, I can drill down into an invoice level, so you can really go from that, you know, very high bird's-eye consolidated view, down to that invoice level very, very quickly.

00:30:03.720 --> 00:30:09.610

Evan Ryan: … So, you know, really the key takeaways here is… …

00:30:09.850 --> 00:30:15.599

Evan Ryan: The data is taken from your ERP into that GSmart Ledger module that I just showed you.

00:30:16.170 --> 00:30:21.349

Evan Ryan: The historical average days to pay is calculated, feeds into your forecast.

00:30:21.500 --> 00:30:33.560

Evan Ryan: That forecast, then, is more accurate because of those… that historical average days to pay. And also, that data is feeding into your, working capital dashboards.

00:30:34.580 --> 00:30:38.379

Evan Ryan: So, I'll, pause there.

00:30:38.690 --> 00:30:42.380

Evan Ryan: And welcome… Any questions that folks may have?

00:30:59.450 --> 00:31:02.050

Evan Ryan: So I'll see a couple of questions.

00:31:03.640 --> 00:31:10.010

Evan Ryan: Coming in here… so, first one, how does Smart Ledger forecast

00:31:12.000 --> 00:31:15.820

Evan Ryan: Forecast collections of future period billings.

00:31:15.990 --> 00:31:22.839

Evan Ryan: That haven't been invoiced yet. Yeah, so there's, a number of different,

00:31:23.040 --> 00:31:28.840

Evan Ryan: ways that we can take in that data. But typically what customers

00:31:29.310 --> 00:31:33.820

Evan Ryan: You know, could do is… …

00:31:35.270 --> 00:31:38.949

Evan Ryan: So, things like, purchase orders, you know, they can be…

00:31:39.120 --> 00:31:45.389

Evan Ryan: loaded into the system, and they can be actually… they can actually then feed into your Smart Ledger.

00:32:34.170 --> 00:32:41.740

Evan Ryan: Just a couple of more minutes there, folks, if anybody has any… so this module…

00:32:42.420 --> 00:32:53.819

Evan Ryan: So is it a paid module? As far as I'm aware, It's, … Included in the, …

00:32:54.050 --> 00:32:55.499

Evan Ryan: And the overall price.

00:33:01.420 --> 00:33:10.440

GTreasury Marketing: We have another question, and it says, what kind of historical data do you need to get started, and how do you handle data quality issues?

00:33:11.440 --> 00:33:15.960

Evan Ryan: Yeah, so… his… From a historical perspective.

00:33:17.170 --> 00:33:27.170

Evan Ryan: the data is taken in, via, you know, API, or we do a file upload, and typically we take in a

00:33:27.280 --> 00:33:29.920

Evan Ryan: Years worth of historical data.

00:33:30.130 --> 00:33:35.500

Evan Ryan: And the implementation team then work with the client,

00:33:35.780 --> 00:33:39.070

Evan Ryan: To essentially clean that data, …

00:33:39.510 --> 00:33:43.909

Evan Ryan: And ultimately get the data into the correct format.

00:33:45.050 --> 00:33:46.560

Evan Ryan: So…

00:33:47.010 --> 00:33:59.880

Evan Ryan: just to answer that question, yeah, I'd say a year's worth of historical data to get that kind of seasonality, behavior down, and the clients then, you know, the customer success team, implementation team.

00:34:00.090 --> 00:34:04.429

Evan Ryan: Work with the, customer to get that data in the correct format.

00:34:23.580 --> 00:34:29.140

Evan Ryan: So just see one here on, receivables factoring.

00:34:29.830 --> 00:34:34.090

Evan Ryan: Yeah, so we have a number of different ways we can, model that.

00:34:34.350 --> 00:34:40.660

Evan Ryan: It's either, we have a special line item, which sits outside of the Smart Ledger.

00:34:40.810 --> 00:34:50.019

Evan Ryan: Also we have a budget forecast tool, where we can model breaking down, you know, a budget amount into specific weeks as well.

00:34:54.330 --> 00:35:04.519

Evan Ryan: I just shot one of the sales guys a quick message on that pricing, so he actually confirmed it's an additional model that would be, …

00:35:04.700 --> 00:35:07.660

Evan Ryan: An additional paid model, or module.

00:35:16.300 --> 00:35:22.109

Evan Ryan: Yeah, so another question here, can the forecast be shown by day, or by week?

00:35:22.320 --> 00:35:33.559

Evan Ryan: So, yeah, we have a daily view model, weekly view model, monthly views, and those, you know, can roll up, into.

00:35:33.670 --> 00:35:39.960

Evan Ryan: So you can have a daily model that rolls up into the weekly model, and a weekly that rolls up into

00:35:40.210 --> 00:35:41.889

Evan Ryan: The daily model as well.

00:35:42.260 --> 00:35:52.610

Evan Ryan: how many systems can be connected to, GSmart Ledger, really depends on how many, you know, ERPs, you have as a client.

00:35:52.770 --> 00:35:55.259

Evan Ryan: You know, we've claimed such.

00:35:55.410 --> 00:36:01.399

Evan Ryan: operate with one or two ERPs, and, you know, we can connect to, multiple ERPs.

00:36:06.300 --> 00:36:08.999

Evan Ryan: Okay, folks, I think we can, …

00:36:09.190 --> 00:36:13.970

Evan Ryan: Leave it there. If anybody has any other, questions, please,

00:36:14.250 --> 00:36:17.879

Evan Ryan: Reach out to us, we'll be happy to answer them offline.

00:36:19.550 --> 00:36:32.430

GTreasury Marketing: Thank you, Evan. And just as a reminder, the recording of this webinar will be sent out in a few days, and once again, thank you for joining us, and please reach out if you have any questions. Have a great rest of your day, everyone.

00:36:34.460 --> 00:36:35.529

Evan Ryan: Bye, folks.

Videos

Transform AR/AP Analytics into Strategic Advantage with GSmart Ledger

Transform AR/AP Analytics into Strategic Advantage with GSmart Ledger

Written by
GTreasury
Published
Sep 15, 2025
Last Update
Sep 8, 2025
Download the guide

Your AR/AP data is money left on the table. While your team spends hours analyzing payment data in spreadsheets, you're missing critical insights about customer behavior, cash timing, and strategic opportunities. As CFOs demand greater forecast accuracy and real-time visibility, manual processes can't deliver the precision needed for modern treasury operations.

Watch a recording of “Transform AR/AP Analytics into Strategic Advantage with GSmart Ledger,” hosted by GTreasury's Evan Ryan. This exclusive 30-minute session demonstrates leading finance teams are transforming AR/AP analytics with AI-powered automation to achieve over 30% improvement in forecast accuracy.

In this webinar, you'll learn how to:

  • Eliminate hours of manual AR/AP data analysis with automated ERP integration
  • Leverage AI to understand customer-specific payment behaviors and timing
  • Transform static forecasting assumptions into dynamic, data-driven predictions
  • Generate board-ready cash flow forecasts in minutes, not days

Explore how GSmart Ledger delivers intelligent automation for AR/AP analytics while seamlessly integrating with comprehensive treasury intelligence.

Transcript

00:03:59.880 --> 00:04:08.950

GTreasury Marketing: Hello, everyone, and thank you for joining us today. We will be starting in a few minutes to give all of our attendees time to join the webinar, so sit tight, and we will be starting shortly.

00:05:30.470 --> 00:05:34.209

GTreasury Marketing: Hello, everyone. Thank you for joining us today for our webinar.

00:05:34.480 --> 00:05:41.159

GTreasury Marketing: Transform AR-AP analytics into strategic advantage with GSmart Ledger.

00:05:41.250 --> 00:05:44.729

Evan Ryan: Let's cover a couple of housekeeping items before we get started.

00:05:48.080 --> 00:06:02.259

GTreasury Marketing: Today's event is scheduled to last 30 minutes, including time for questions at the end. All participants are muted, and if you have any questions at any time throughout the presentation, please enter them into the Q&A section on your Zoom control bar.

00:06:02.590 --> 00:06:04.609

GTreasury Marketing: This webinar is being recorded.

00:06:04.610 --> 00:06:08.600

Evan Ryan: And a link to the recording will be sent via email to all participants.

00:06:09.570 --> 00:06:15.590

GTreasury Marketing: Our speaker today is Evan Ryan, therefore I will hand it over to him for a quick introduction.

00:06:16.500 --> 00:06:23.590

Evan Ryan: Thanks very much, Anne. My name is Evan Ryan. I'm a cash forecasting product manager here at,

00:06:23.730 --> 00:06:29.180

Evan Ryan: Chief Treasury, and excited to, jump into the presentation today.

00:06:31.380 --> 00:06:36.279

Evan Ryan: So today, talking through Transform AR and AP Analytics.

00:06:36.480 --> 00:06:41.599

Evan Ryan: And just into strategic advantage, with the GSmart Ledger.

00:06:43.410 --> 00:06:54.779

Evan Ryan: So, to talk through what I'm actually going to be, going through today, brief introduction, then the AI transformation, see how

00:06:54.920 --> 00:06:59.729

Evan Ryan: Ai is, across the G Treasury platform.

00:06:59.930 --> 00:07:03.050

Evan Ryan: Second piece around the hidden cost of manual

00:07:03.350 --> 00:07:15.029

Evan Ryan: payment analysis, jumping onto the intelligent automation for AR and AP, and then jump into the actual system itself, the Smart Ledger itself, for a quick demo.

00:07:17.320 --> 00:07:27.229

Evan Ryan: So, this slide really illustrates where AI is across the whole GTreasury platform, and, you know.

00:07:27.430 --> 00:07:42.840

Evan Ryan: AI is nothing new to GTreasury. It's actually existed within GTreasury for the last number of years. You can see there are different types of AI models, so, you know, there's the agentic type statistical modeling, fuzzy logic.

00:07:43.130 --> 00:07:51.110

Evan Ryan: And today we're going to be focusing on that second piece, that cash forecasting, GSmart Ledger, and statistical modeling.

00:07:52.370 --> 00:07:56.520

Evan Ryan: So… What does the GSmart Ledger…

00:07:56.620 --> 00:07:59.709

Evan Ryan: actually tried to do, and what does it achieve?

00:08:00.090 --> 00:08:03.440

Evan Ryan: So, essentially, it's an AI-driven module.

00:08:03.610 --> 00:08:08.170

Evan Ryan: And it automates the short- to mid-term cash flow forecasting.

00:08:08.390 --> 00:08:16.370

Evan Ryan: And what it does is it analyzes the real-time accounts receivable, accounts payable.

00:08:16.600 --> 00:08:24.279

Evan Ryan: And it uses machine learning to learn how your customers have been paying you in the last

00:08:24.770 --> 00:08:31.339

Evan Ryan: year, six months, and also how you've been paying your vendors over the last.

00:08:31.610 --> 00:08:33.900

Evan Ryan: Over the last historical period.

00:08:35.049 --> 00:08:39.149

Evan Ryan: It uses that data, then, to generate a forecast.

00:08:39.539 --> 00:08:54.900

Evan Ryan: And it's continually learning, okay? So every time we take in a new load of data, that data then is added into that database, so the system, the GSmart ledger, actually gets more accurate.

00:08:55.030 --> 00:08:56.220

Evan Ryan: Over time.

00:08:57.070 --> 00:09:12.040

Evan Ryan: We've actually done some analysis, and we've shown that GSmart Ledger is up to 30% more accurate for accounts receivable, and predicting when customers are going to pay, compared to what our clients see

00:09:12.040 --> 00:09:17.419

Evan Ryan: within their ERP systems. And I'll touch on that in a little bit more detail

00:09:17.580 --> 00:09:19.309

Evan Ryan: In a couple of moments.

00:09:21.630 --> 00:09:29.500

Evan Ryan: So, I really want to get into, how the GSmart Ledger is really transforming forecast accuracy.

00:09:29.670 --> 00:09:38.079

Evan Ryan: So, I touched on that 30%, figure on the previous slide, and we need to delve in a little bit more

00:09:38.250 --> 00:09:40.630

Evan Ryan: Into that figure, and what that means.

00:09:42.020 --> 00:09:48.390

Evan Ryan: So… Before I do that, I just want to talk about the AR and AP pain points.

00:09:49.340 --> 00:09:52.080

Evan Ryan: I'm sure, you know, I'm preaching to the choir here.

00:09:52.500 --> 00:09:56.969

Evan Ryan: A lot of folks on this call, can really relate to this slide.

00:09:57.880 --> 00:10:03.929

Evan Ryan: But essentially, you know, we're talking about varying payment behaviors across customers.

00:10:04.160 --> 00:10:13.069

Evan Ryan: Really, vendors making it really difficult to, accurately predict when those customers are going to pay you.

00:10:13.570 --> 00:10:20.499

Evan Ryan: And we know then that customers don't pay to terms. They really do have their own payment habits.

00:10:21.840 --> 00:10:28.009

Evan Ryan: Also, An extra challenge is dealing with large volumes of data.

00:10:28.580 --> 00:10:31.229

Evan Ryan: Be it customers or vendors.

00:10:31.340 --> 00:10:37.720

Evan Ryan: And often this data is siloed across multiple ERP systems.

00:10:37.920 --> 00:10:39.630

Evan Ryan: Across your organization.

00:10:39.890 --> 00:10:47.680

Evan Ryan: And the Smart Ledger really gives you that consolidated bird's-eye view of your AR and AP payment behavior.

00:10:48.860 --> 00:10:51.520

Evan Ryan: Again, you know, uncertainty over timing.

00:10:51.660 --> 00:10:55.590

Evan Ryan: Really then can lead into inaccurate forecasts.

00:10:56.120 --> 00:11:02.710

Evan Ryan: I've spoken to a number of CFOs in the past, where because of that uncertainty.

00:11:02.900 --> 00:11:09.550

Evan Ryan: They really have to build up those liquidity buffers, and this essentially is cash that's

00:11:10.120 --> 00:11:13.389

Evan Ryan: Not working for you, you know?

00:11:13.510 --> 00:11:15.890

Evan Ryan: And I show how, you know.

00:11:16.110 --> 00:11:18.459

Evan Ryan: Tying or freeing up that cash.

00:11:18.610 --> 00:11:24.280

Evan Ryan: It's beneficial, essentially, due to the fact that you have a more accurate forecast.

00:11:27.350 --> 00:11:35.349

Evan Ryan: So here, you know, transforming AR and AP and working capital with the Smart Ledger, is it a science? Is it an art?

00:11:35.520 --> 00:11:36.329

Evan Ryan: It's both.

00:11:36.930 --> 00:11:46.689

Evan Ryan: You know, a couple of challenges I want to call out on the left-hand side, and then the solutions on the right-hand side, and how GSmart Ledger can really assist with that.

00:11:47.770 --> 00:11:50.379

Evan Ryan: So, firstly, you know, a lack of confidence.

00:11:50.520 --> 00:11:57.999

Evan Ryan: Inaccuracy for cash flow forecasting. And this, as I said, is due to that variance

00:11:58.250 --> 00:11:59.940

Evan Ryan: Of your customers paying.

00:12:01.260 --> 00:12:10.619

Evan Ryan: And the solution there is really to integrate that AI and AP ledgers, and using that historical analysis, AI

00:12:10.800 --> 00:12:17.789

Evan Ryan: Model, we can calculate and predict much more accurately when those customers are going to pay you.

00:12:18.740 --> 00:12:21.520

Evan Ryan: Second piece here is around visibility.

00:12:21.990 --> 00:12:26.789

Evan Ryan: So it really is that limited visibility into your cash flow drivers.

00:12:27.320 --> 00:12:32.730

Evan Ryan: During the demo, I'll jump into not only the Smart Ledger itself.

00:12:32.870 --> 00:12:42.399

Evan Ryan: but a consolidated, like, working capital view, dashboards, which are, you know, I'm excited to actually show you today.

00:12:43.500 --> 00:12:48.009

Evan Ryan: So the second piece, so the solution to that, then, is those cash flow

00:12:48.330 --> 00:12:58.220

Evan Ryan: forecasts, they're auto-adjusted with that learned behavior for better accuracy. So, it's not a case that you need to come in every time the

00:12:58.540 --> 00:13:10.209

Evan Ryan: refresh of data comes in, and you need to adjust things, you know, it's really kind of set it and forget it, and I'll show you how you can utilize the rules within the Smart Ledger to then feed into your forecast.

00:13:11.450 --> 00:13:21.569

Evan Ryan: Final challenge, then, that people are facing at the moment is really, as I said on the previous slide, you know, dealing with large ERP extracts.

00:13:21.900 --> 00:13:26.409

Evan Ryan: … We can integrate with any ERP,

00:13:26.700 --> 00:13:37.550

Evan Ryan: pull in the data, be it on a daily basis, on a weekly basis. The data is then refreshed, can set it up on a scheduler, and then that comes in to feed into your,

00:13:38.040 --> 00:13:42.880

Evan Ryan: the GSmart Ledger, and you can really do a deep dive analysis on a customer level.

00:13:43.140 --> 00:13:45.709

Evan Ryan: Vendor level, and then those…

00:13:45.950 --> 00:13:51.980

Evan Ryan: That data then feeds into your forecast, and ultimately then into those working capital dashboards.

00:13:55.020 --> 00:14:00.389

Evan Ryan: So, how does the GSmart Ledger actually work?

00:14:00.720 --> 00:14:05.180

Evan Ryan: So it's an ERP integration for the automated short-term forecast.

00:14:05.590 --> 00:14:13.159

Evan Ryan: And the historical data is analyzed with machine learning. And this one is what then generates

00:14:13.350 --> 00:14:16.769

Evan Ryan: Those historical average days to pay.

00:14:17.480 --> 00:14:21.349

Evan Ryan: So, for example, if an invoice comes in.

00:14:21.460 --> 00:14:26.770

Evan Ryan: You know, sent to a customer with terms of 45 days, but…

00:14:27.040 --> 00:14:37.130

Evan Ryan: Smart Ledger can tell you, well, actually, on average, this customer doesn't pay within 45 days, this customer typically pays within 50 days.

00:14:37.760 --> 00:14:43.989

Evan Ryan: And what that due date… what actually happens to that 45-day due date?

00:14:44.160 --> 00:14:55.080

Evan Ryan: That's auto-adjusted within your forecast to 50 days, so you have a more accurate forecast. So again, you know when cash is going to be coming in.

00:14:55.260 --> 00:14:58.419

Evan Ryan: From your client… from your customers, more accurately.

00:15:00.080 --> 00:15:08.980

Evan Ryan: The fourth piece here is around that consolidated ARNAP performance dashboard, so you really have a bird's eye view

00:15:09.130 --> 00:15:09.950

Evan Ryan: …

00:15:10.170 --> 00:15:21.760

Evan Ryan: You know, at a very high level, and then you can quickly drill down to an invoice level, just really see, you know, from an overdue perspective, see what's outstanding at a customer level.

00:15:25.080 --> 00:15:31.840

Evan Ryan: So… as I said, we ran some analysis, and we saw that, on average.

00:15:32.090 --> 00:15:40.869

Evan Ryan: The GSmart Ledger improves short-term forecasting by up to 30% for accounts receivable, compared to how…

00:15:41.110 --> 00:15:46.270

Evan Ryan: our clients were seeing the payment terms within their ERP system.

00:15:46.910 --> 00:16:05.880

Evan Ryan: It was run on an individual invoice level, and compared the data within the GSmart Ledger, and essentially the due date in the GSmart Ledger, using those historical average days to pay, comparing that to the standard terms within the ERP system.

00:16:06.280 --> 00:16:11.320

Evan Ryan: And the G Smart Ledger was up to 30% more accurate.

00:16:15.340 --> 00:16:19.250

Evan Ryan: So, you know, what does… 30%.

00:16:19.720 --> 00:16:23.619

Evan Ryan: increase in forecast accuracy mean for your Treasury team?

00:16:24.310 --> 00:16:31.320

Evan Ryan: Well, so the first one then is, you know, you can really free up working capital so the business can run on

00:16:31.670 --> 00:16:34.159

Evan Ryan: As, run on less cash.

00:16:34.430 --> 00:16:37.789

Evan Ryan: So, I would say as, you know, as lean as possible.

00:16:38.210 --> 00:16:41.690

Evan Ryan: Safely reduces excess cache buffers.

00:16:42.210 --> 00:16:48.190

Evan Ryan: And then, you know, avoids that costly short-term borrowing for collection surprises.

00:16:48.740 --> 00:16:53.739

Evan Ryan: Obviously, then you, and I'll show this within the dashboards, that excess cache.

00:16:53.890 --> 00:17:03.179

Evan Ryan: You can place it out on a term, or use it to pay down a credit facility as well. We can actually calculate that figure as well, which is very useful.

00:17:03.670 --> 00:17:10.419

Evan Ryan: But ultimately, We're enabling clients to make faster and more confident decisions.

00:17:13.140 --> 00:17:18.230

Evan Ryan: I know, Shannon is going to now pop up a, poll question.

00:17:27.990 --> 00:17:30.369

Evan Ryan: Shannon, do we have that poll question?

00:17:44.640 --> 00:17:50.929

Evan Ryan: I'm not too sure what's, happening with that poll question.

00:17:51.080 --> 00:17:55.219

Evan Ryan: But essentially, I can, … Read out the…

00:17:55.540 --> 00:17:56.669

Evan Ryan: Shannon, do you have it there?

00:17:56.670 --> 00:17:59.960

GTreasury Marketing: Yes, the poll question, is being answered.

00:18:00.420 --> 00:18:03.069

Evan Ryan: Okay, sorry, I just can't see it on my screen.

00:18:50.160 --> 00:18:51.899

GTreasury Marketing: Can you see the results, Evan?

00:18:52.200 --> 00:18:57.140

Evan Ryan: … I can't, actually. I don't know if… could you read them out, Shannon?

00:18:57.140 --> 00:18:58.169

GTreasury Marketing: Yes, I can.

00:18:59.470 --> 00:19:01.630

Evan Ryan: So….

00:19:02.020 --> 00:19:09.450

GTreasury Marketing: the… Question is, what best describes your organization's current use of AI in cash flow forecasting?

00:19:09.580 --> 00:19:29.020

GTreasury Marketing: So we have 38% planning to implement AI within the next 12 months. We have 46% researching AI options, but unsure where to start, and 15% haven't considered AI for forecasting processes yet.

00:19:30.240 --> 00:19:32.030

Evan Ryan: Thanks very much, …

00:19:32.210 --> 00:19:42.920

Evan Ryan: So, yeah, we, … well, actually, I'll discuss, the usage of, AI in the demo here, and, you know, we can discuss that,

00:19:43.220 --> 00:19:44.120

Evan Ryan: So…

00:19:44.510 --> 00:19:54.749

Evan Ryan: there were, yeah, the largest result here, 46%. People are currently researching AI options, but unsure where to start, so…

00:19:55.090 --> 00:19:59.880

Evan Ryan: Hopefully folks have a, kind of, a good idea. …

00:19:59.990 --> 00:20:07.540

Evan Ryan: Once I've finished the demo here, so let me just… Jump into the demo…

00:20:11.120 --> 00:20:12.060

Evan Ryan: I just…

00:20:17.320 --> 00:20:19.220

Evan Ryan: Okay…

00:20:29.150 --> 00:20:33.080

Evan Ryan: So, Shannon, you can see the screen here.

00:20:33.080 --> 00:20:33.800

GTreasury Marketing: Yes.

00:20:34.060 --> 00:20:35.320

Evan Ryan: Perfect. Okay.

00:20:35.670 --> 00:20:43.669

Evan Ryan: So, where we're gonna actually start off first is within the actual forecasting sheet.

00:20:44.090 --> 00:20:53.929

Evan Ryan: Okay, so here I have my actuals, so what happened in the previous week, and here's my forecast of what's happening in the next 13 weeks.

00:20:54.380 --> 00:21:02.800

Evan Ryan: I've jumped into the Ireland business unit here, and I can see my cash flow line items, my cash flow categories on the left-hand side.

00:21:04.210 --> 00:21:18.759

Evan Ryan: I have my AR collections here, and then I have my AP collection, or my AP payments here, and my specific line item here, my suppliers, but I'm just going to focus on the AR collections first.

00:21:20.620 --> 00:21:26.629

Evan Ryan: So, I can see I have a number of different weeks, … Out here into the future.

00:21:26.870 --> 00:21:30.659

Evan Ryan: And if I double-click on the first cell here.

00:21:30.780 --> 00:21:34.359

Evan Ryan: I can get a breakdown of that 1.2 million.

00:21:35.100 --> 00:21:42.059

Evan Ryan: euros that's feeding into that, and that data is ultimately coming from the GSmart Ledger.

00:21:42.960 --> 00:21:47.130

Evan Ryan: So, whatever invoices are forecasted

00:21:47.950 --> 00:22:04.789

Evan Ryan: to be collected in week 4 are appearing in that 1.2 million amount. I can drill down to an invoice level, and then if I drill down a little bit deeper, I can see that there was an original due date on this.

00:22:04.930 --> 00:22:08.269

Evan Ryan: But then that's actually been auto-adjusted due to that.

00:22:08.540 --> 00:22:11.070

Evan Ryan: Historical average days to pay.

00:22:11.970 --> 00:22:15.260

Evan Ryan: So, that's basically the starting point.

00:22:15.430 --> 00:22:19.840

Evan Ryan: For the demo, and I'll jump into the actual Smart Ledger itself now.

00:22:21.110 --> 00:22:26.129

Evan Ryan: So I can jump into the, Smart Ledger demo, or Smart Ledger.

00:22:26.360 --> 00:22:27.230

Evan Ryan: itself.

00:22:27.990 --> 00:22:30.950

Evan Ryan: So, here, within the Smart Ledger.

00:22:31.220 --> 00:22:34.699

Evan Ryan: This is where that ERP data lives.

00:22:35.090 --> 00:22:39.539

Evan Ryan: There's a number of different data sets that we take in from your ERP.

00:22:39.690 --> 00:22:44.310

Evan Ryan: The open reports, so your current AR and AP aging report.

00:22:44.500 --> 00:22:46.269

Evan Ryan: All payments.

00:22:46.380 --> 00:22:47.680

Evan Ryan: And also…

00:22:48.070 --> 00:22:56.680

Evan Ryan: any closed data. So, closed data being invoices that have been paid. In this case, in the last week, it could be in the last month.

00:22:58.450 --> 00:23:08.800

Evan Ryan: So I can see I have a number of different items across here. I can see at an invoice level, you know, really what's happening at an invoice level.

00:23:09.240 --> 00:23:15.999

Evan Ryan: I'm… I can see all of my open invoices, so this is the current aging bucket.

00:23:16.260 --> 00:23:21.020

Evan Ryan: I have less in less than 30 days. I'm…

00:23:21.220 --> 00:23:24.049

Evan Ryan: Projected or forecast to collect 15…

00:23:24.400 --> 00:23:27.600

Evan Ryan: Million euros, 31 to 60.

00:23:27.960 --> 00:23:30.569

Evan Ryan: 7 million euros, and so on and so forth.

00:23:30.740 --> 00:23:33.949

Evan Ryan: I can also view what's overdue as well.

00:23:34.230 --> 00:23:38.420

Evan Ryan: Also, a currency breakdown and so on. So at the moment, I just have Euros in this.

00:23:38.540 --> 00:23:43.130

Evan Ryan: Ledger, but we can handle multiple currencies as well.

00:23:44.840 --> 00:23:52.670

Evan Ryan: Also, I can view my paid invoices, so all the payments, or all invoices that have been paid over the past, period.

00:23:54.620 --> 00:23:55.900

Evan Ryan: All payments…

00:23:57.100 --> 00:24:04.690

Evan Ryan: But what I want to focus on here is the customer profiles. So if I jump into T-Mobile here…

00:24:04.920 --> 00:24:10.220

Evan Ryan: I can see a breakdown of my customer behavior.

00:24:10.390 --> 00:24:17.119

Evan Ryan: So these are all invoices that have been collected over the last, you know, let's say year in this case.

00:24:17.410 --> 00:24:18.600

Evan Ryan: T-Mobile.

00:24:19.200 --> 00:24:26.229

Evan Ryan: have, paid. Also, I have a view of the payment distribution and losses, so I can see, you know.

00:24:27.160 --> 00:24:31.610

Evan Ryan: The majority of payments coming are in around the 60-7 day mark.

00:24:32.290 --> 00:24:42.250

Evan Ryan: But perhaps, you know, we can take a look at orange. Orange seemed to be a bit more, let's say, well-behaved when it comes to, payment distribution.

00:24:43.070 --> 00:24:45.680

Evan Ryan: If I roll back up here into T-Mobile.

00:24:45.830 --> 00:24:57.189

Evan Ryan: What I want to focus on is this figure here, so your average days to pay. And that average days to pay is what's used to calculate that new due date.

00:24:57.320 --> 00:25:02.459

Evan Ryan: for… any invoice that's associated with T-Mobile.

00:25:03.350 --> 00:25:07.830

Evan Ryan: So when an invoice, a new invoice is sent to T-Mobile.

00:25:08.310 --> 00:25:16.939

Evan Ryan: You know, and as I said, when I was talking through the slides, maybe the, you know, payment terms were 30 days or 45 days.

00:25:17.080 --> 00:25:23.630

Evan Ryan: Historically, what's been calculated here using AI, And that statistical modeling is…

00:25:23.920 --> 00:25:30.220

Evan Ryan: To calculate the historical average terms for each individual client.

00:25:30.960 --> 00:25:43.340

Evan Ryan: So, if I jump back into my open report here, I can see I have T-Mobile. If I open this, okay, I can see my historical average days to pay for T-Mobile at an individual customer level.

00:25:44.170 --> 00:25:46.209

Evan Ryan: And if you remember back to that

00:25:46.480 --> 00:25:56.150

Evan Ryan: first or second slide within the presentation. One of the key pieces was then how this feeds into your forecast.

00:25:57.230 --> 00:26:01.220

Evan Ryan: So, if I take a look at my… Rules here

00:26:01.850 --> 00:26:06.720

Evan Ryan: Basically, I can see that I have a customer payment behavior rule here.

00:26:07.580 --> 00:26:10.059

Evan Ryan: And what I can do is I can set

00:26:11.550 --> 00:26:18.640

Evan Ryan: All clients, or all customers, for this ledger, to use that historical average days to pay.

00:26:18.970 --> 00:26:20.689

Evan Ryan: And I can see them here.

00:26:21.360 --> 00:26:26.399

Evan Ryan: But… Typically, what a lot of our clients will do is they will

00:26:26.950 --> 00:26:41.600

Evan Ryan: Set up kind of a blanket rule, and use the historical average days to pay for all customers or all vendors, but you can then go in and start tweaking and customizing that rule at a customer level.

00:26:41.900 --> 00:26:51.630

Evan Ryan: So it's not a case that, you know, you need to go in and it's just, you know, one blanket rule. You can really go down at a customer level and, you know, …

00:26:52.160 --> 00:26:53.230

Evan Ryan: updates.

00:26:53.350 --> 00:26:55.709

Evan Ryan: And, customize.

00:26:55.820 --> 00:27:05.900

Evan Ryan: when that customer is going to pay you. So I've, in this case, I have historical average dates to pay, but I can add dates to my due date, and I can do that at an individual client level as well.

00:27:07.660 --> 00:27:10.140

Evan Ryan: So once I've set my customers…

00:27:10.420 --> 00:27:15.129

Evan Ryan: my customer payment behavior. Then, essentially, I can map

00:27:15.670 --> 00:27:21.399

Evan Ryan: All of these invoices to a specific line item within my forecast.

00:27:21.880 --> 00:27:27.029

Evan Ryan: So that was that AR collections line item that you saw just a couple of moments ago.

00:27:29.370 --> 00:27:46.550

Evan Ryan: it's not the case that you need to map it all to one line item. You can specifically… you can, map specific, invoices or specific customers based off of, you know, keywords, descriptions, really to get a more granular level.

00:27:48.420 --> 00:27:57.120

Evan Ryan: So… The final piece of the demo, I just want to jump into the actual, dashboards here.

00:27:57.370 --> 00:28:05.800

Evan Ryan: So if I just, change up my… My date here… Let's see…

00:28:12.290 --> 00:28:13.710

Evan Ryan: Second…

00:28:18.680 --> 00:28:19.580

Evan Ryan: Perfect.

00:28:20.130 --> 00:28:26.610

Evan Ryan: So what I can see here is my… Current…

00:28:27.310 --> 00:28:30.529

Evan Ryan: AR balance at a consolidated level.

00:28:30.690 --> 00:28:42.809

Evan Ryan: So again, if you have multiple entities, multiple cost centers, multiple business units within your organization, this really gives you that 10,000-foot view of, you know, what's happening.

00:28:42.920 --> 00:28:55.049

Evan Ryan: So here I can see I have 226 million euros, but I can easily change up what business unit I want to filter here, you know, what currencies I want to view.

00:28:55.160 --> 00:28:58.510

Evan Ryan: And also, I can actually rewind the clock.

00:28:58.800 --> 00:29:02.889

Evan Ryan: And view the historical balances as well.

00:29:03.650 --> 00:29:11.720

Evan Ryan: So I like to kind of divide this screen up into two halves. I have my customer AR collections analysis up top.

00:29:12.100 --> 00:29:13.690

Evan Ryan: I can click into my…

00:29:13.880 --> 00:29:19.930

Evan Ryan: Current outstanding, invoices at a customer level, and then drill down.

00:29:20.460 --> 00:29:21.779

Evan Ryan: but also…

00:29:23.300 --> 00:29:32.629

Evan Ryan: bottom half of the screen here is I can see what customers are overdue. So in this case, I can see I have 78 million overdue.

00:29:33.310 --> 00:29:40.730

Evan Ryan: And also, again, like the top screen here, I can see overdue customer analysis,

00:29:42.440 --> 00:29:48.150

Evan Ryan: At a customer level, but also it's broken out per bucket.

00:29:48.510 --> 00:30:03.419

Evan Ryan: and, you know, like the top as well, the top of the screen, I can drill down into an invoice level, so you can really go from that, you know, very high bird's-eye consolidated view, down to that invoice level very, very quickly.

00:30:03.720 --> 00:30:09.610

Evan Ryan: … So, you know, really the key takeaways here is… …

00:30:09.850 --> 00:30:15.599

Evan Ryan: The data is taken from your ERP into that GSmart Ledger module that I just showed you.

00:30:16.170 --> 00:30:21.349

Evan Ryan: The historical average days to pay is calculated, feeds into your forecast.

00:30:21.500 --> 00:30:33.560

Evan Ryan: That forecast, then, is more accurate because of those… that historical average days to pay. And also, that data is feeding into your, working capital dashboards.

00:30:34.580 --> 00:30:38.379

Evan Ryan: So, I'll, pause there.

00:30:38.690 --> 00:30:42.380

Evan Ryan: And welcome… Any questions that folks may have?

00:30:59.450 --> 00:31:02.050

Evan Ryan: So I'll see a couple of questions.

00:31:03.640 --> 00:31:10.010

Evan Ryan: Coming in here… so, first one, how does Smart Ledger forecast

00:31:12.000 --> 00:31:15.820

Evan Ryan: Forecast collections of future period billings.

00:31:15.990 --> 00:31:22.839

Evan Ryan: That haven't been invoiced yet. Yeah, so there's, a number of different,

00:31:23.040 --> 00:31:28.840

Evan Ryan: ways that we can take in that data. But typically what customers

00:31:29.310 --> 00:31:33.820

Evan Ryan: You know, could do is… …

00:31:35.270 --> 00:31:38.949

Evan Ryan: So, things like, purchase orders, you know, they can be…

00:31:39.120 --> 00:31:45.389

Evan Ryan: loaded into the system, and they can be actually… they can actually then feed into your Smart Ledger.

00:32:34.170 --> 00:32:41.740

Evan Ryan: Just a couple of more minutes there, folks, if anybody has any… so this module…

00:32:42.420 --> 00:32:53.819

Evan Ryan: So is it a paid module? As far as I'm aware, It's, … Included in the, …

00:32:54.050 --> 00:32:55.499

Evan Ryan: And the overall price.

00:33:01.420 --> 00:33:10.440

GTreasury Marketing: We have another question, and it says, what kind of historical data do you need to get started, and how do you handle data quality issues?

00:33:11.440 --> 00:33:15.960

Evan Ryan: Yeah, so… his… From a historical perspective.

00:33:17.170 --> 00:33:27.170

Evan Ryan: the data is taken in, via, you know, API, or we do a file upload, and typically we take in a

00:33:27.280 --> 00:33:29.920

Evan Ryan: Years worth of historical data.

00:33:30.130 --> 00:33:35.500

Evan Ryan: And the implementation team then work with the client,

00:33:35.780 --> 00:33:39.070

Evan Ryan: To essentially clean that data, …

00:33:39.510 --> 00:33:43.909

Evan Ryan: And ultimately get the data into the correct format.

00:33:45.050 --> 00:33:46.560

Evan Ryan: So…

00:33:47.010 --> 00:33:59.880

Evan Ryan: just to answer that question, yeah, I'd say a year's worth of historical data to get that kind of seasonality, behavior down, and the clients then, you know, the customer success team, implementation team.

00:34:00.090 --> 00:34:04.429

Evan Ryan: Work with the, customer to get that data in the correct format.

00:34:23.580 --> 00:34:29.140

Evan Ryan: So just see one here on, receivables factoring.

00:34:29.830 --> 00:34:34.090

Evan Ryan: Yeah, so we have a number of different ways we can, model that.

00:34:34.350 --> 00:34:40.660

Evan Ryan: It's either, we have a special line item, which sits outside of the Smart Ledger.

00:34:40.810 --> 00:34:50.019

Evan Ryan: Also we have a budget forecast tool, where we can model breaking down, you know, a budget amount into specific weeks as well.

00:34:54.330 --> 00:35:04.519

Evan Ryan: I just shot one of the sales guys a quick message on that pricing, so he actually confirmed it's an additional model that would be, …

00:35:04.700 --> 00:35:07.660

Evan Ryan: An additional paid model, or module.

00:35:16.300 --> 00:35:22.109

Evan Ryan: Yeah, so another question here, can the forecast be shown by day, or by week?

00:35:22.320 --> 00:35:33.559

Evan Ryan: So, yeah, we have a daily view model, weekly view model, monthly views, and those, you know, can roll up, into.

00:35:33.670 --> 00:35:39.960

Evan Ryan: So you can have a daily model that rolls up into the weekly model, and a weekly that rolls up into

00:35:40.210 --> 00:35:41.889

Evan Ryan: The daily model as well.

00:35:42.260 --> 00:35:52.610

Evan Ryan: how many systems can be connected to, GSmart Ledger, really depends on how many, you know, ERPs, you have as a client.

00:35:52.770 --> 00:35:55.259

Evan Ryan: You know, we've claimed such.

00:35:55.410 --> 00:36:01.399

Evan Ryan: operate with one or two ERPs, and, you know, we can connect to, multiple ERPs.

00:36:06.300 --> 00:36:08.999

Evan Ryan: Okay, folks, I think we can, …

00:36:09.190 --> 00:36:13.970

Evan Ryan: Leave it there. If anybody has any other, questions, please,

00:36:14.250 --> 00:36:17.879

Evan Ryan: Reach out to us, we'll be happy to answer them offline.

00:36:19.550 --> 00:36:32.430

GTreasury Marketing: Thank you, Evan. And just as a reminder, the recording of this webinar will be sent out in a few days, and once again, thank you for joining us, and please reach out if you have any questions. Have a great rest of your day, everyone.

00:36:34.460 --> 00:36:35.529

Evan Ryan: Bye, folks.

See GTreasury
in Action

Get connected with supportive experts, comprehensive solutions, and untapped possibility today.

Request a Demo