Why the Workbook Is Built the Way It Is

Every so often I get a call a week or two after we've delivered a workbook. The person on the other end has it open and they're trying to make sense of it. That isn't a complaint about the work. It's a thousand or more line items, and that is a lot of data and information to process no matter who you are.

Those calls are the reason the workbook is structured the way it is. Every column is there because somebody on the receiving end, a receiver, an attorney, a judge, an investor, needs to get an answer out of it without walking the property themselves.

It Follows the Walk

The first thing to know is that the rows go in the order we walked the facility. I like to start literally how I started walking through the building. On a multi-story property that means floor first. Whatever sat on the third floor is logged under the third floor, and you can read the workbook top to bottom the same way we moved through the building.

On a single-story property, floor isn't enough on its own, so the location column gets more specific. Something like "Floor 1, adjacent room to north hallway." If you're standing in the building with the workbook, you should be able to find the item from the description.

How we walk, and therefore how the workbook is ordered, depends on what the job is trying to accomplish. That's really what it comes down to. More on that below.

Category and the Photo Link

The category column exists because of what actually ends up on site. Industrial equipment, artwork, everything you can think of. A reader who only cares about the mechanical equipment shouldn't have to scroll past the furniture to find it, so each line gets a category they can sort or filter on.

Then there's the photo link. One photo per line item, and it shows the whole unit or piece. Without it, a line that says "condensing unit, quantity 2" is just a claim. With it, the reader can see the unit for themselves, where it sat and what condition it was in, without going back out to the property. For the people using these workbooks in legal or financial settings, that matters.

Quantity and Unit

Quantity and unit sound like the easy columns until you hit a room with a hundred boxes and fifty pieces in each box. Is the quantity 100 or 5,000? Both are true depending on what you're counting. The workbook has to say which one it means, and it has to say it the same way every time, or two readers will come away with two different totals from the same page.

How It Got This Way

Our workbook has changed drastically from the first version to what it is today. Our first big inventory case was a massive cannabis distribution and manufacturing location, and it had us way in over our heads. We methodically got through it. What that job really came down to was cross-referencing thousands of line items against thousands of line items, and that was the birth of our in-house tools.

Every job since has changed the workbook a little. Someone calls with a question the structure didn't answer cleanly, or we hit a situation in the field the columns didn't cover, and the next version accounts for it. The test I use when I'm reviewing the layout is simple: if I were the owner of this property, what would I be looking for?

A Receiver's Workbook and an Investor's Workbook Aren't the Same Job

This is where "what are we trying to accomplish" shows up in the structure.

A receiver, most of the time, wants what's on site compiled into one workbook. They've just taken over a property and they need a reliable record of what's there. The walk and the workbook are built to get them that.

An investor is usually holding a list from a seller or an operator, and the question is whether the list is true. That's a reconciliation. We still walk and document everything, but now the workbook has to line our findings up against their list, with summaries by floor and by equipment and a discrepancy report showing where the two don't match. Same columns, different purpose, different amount of work on the back end.

Without that structure, it's just data you would personally have to go through.

Floor, category, location, quantity, unit, photo link. None of it is complicated on its own. The point of all of it is that a person who wasn't in the building can open the file and know what's there. Without that structure, it's just data you would personally have to go through.

Need a property documented so the people reviewing it can actually use the record? Schedule a consultation with Cultiva.

Next
Next

The Cannabis Debt Wall Is Here. Do You Know What Your Collateral Actually Looks Like?