Paul Barnhurst demonstrates how to use an AI-powered tool to convert raw billing data (about 300 rows) into a deferred revenue schedule for monthly revenue recognition. He outlines the input columns (invoice, contract, start/end dates, months, amount, product, address fields), specifies desired output columns (customer, product, contract amount, contract start/end) and requests monthly recognition columns from Jan 1, 2026 through Dec 31, 2029, with per-row checks ensuring recognized amounts equal contract amounts. The clip is a hands-on walkthrough of prompting the tool and initiating the run.
So what I have here is about 300 rows of data with a invoice number, a contract. Let's make this a little larger. Contract start and end date, contract months, the amount, the product name, address, city, state. What I'm going to do is I'm going to ask the tool to create a deferred revenue schedule for me. Right? Anyone who's done any accounting knows I can't recognize the full. You know, in this case, basically $24,000 up front. I need to recognize that over 24 months, and that could take a little bit of time. Anyone who's built a deferred revenue schedule. So let's see how it does. I have a prompt. Here's the prompt I gave it. We'll go through it. I think this is a relatively complex task, much more than the pvm. So I'm going to go ahead and just make this a little bigger. I'm going to select Plot Opus. We kind of talked about that. But using the data on the raw billing data sheet, build a deferred revenue schedule that can be used to recognize the revenue by month. And I've told it what the column header should be. Include customer name, product name, contract amount, contract start date, contract end date, and then have columns for every month from January 1, 2026 through December 31, 2029. The rows should include every dealership, the amount of revenue to recognize each month, and a check to make sure the amount is recognized equals the contract amount over the period. This should be done in a new worksheet. So pretty straightforward. Let's see how it does. We're going to kick it off and then we'll pause here.
