From the course: Excel: Building a 13-Week Cash Flow

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Build transaction mapping tab

Build transaction mapping tab - Microsoft Excel Tutorial

From the course: Excel: Building a 13-Week Cash Flow

Start my 1-month free trial Buy for my team

Build transaction mapping tab

“

- [Instructor] Okay, so now that we have a lot of our infrastructure mapped out in the file, now it's time to get back to the cash flow forecasting. And so I have the CFO's email pulled up here. One of the things that the CFO sent us, in addition to the bank data, which we already put in, "I started to put transactions into buckets," which was attached. So let's go take a look at that now. That's this file right here that comes with the video. It's the bank data description mapping. And so this is something you'd open up in an attachment from the CFO. And what the CFO is basically saying is if the description contains any one of these names, well then here's the category that I want you to put it in. And that's going to map to the cashflow shell that the CFO also sent us. So you can see logically it kind of flows together. The CFO has a format that they prefer, and these are the categories that they want based on the customers or vendors. So let's go ahead and bring this into our…

Contents