Structur

Start Free

All posts
Cost code management

How To Code A Supplier Statement For Job Costing

Split every supplier statement line by line to the job and the cost code. One materials line can't show you what any part of the job cost.

2 min read

Code a supplier statement line by line, to the job and to the cost code each item belongs to. The drywall goes to drywall, the framing lumber to framing and the concrete to concrete. One line called materials for the whole statement is the worst way to do it. You can't open the job afterward and see what you spent on drywall.

What are the five job cost buckets?

Every dollar on a project lands in one of five buckets: labor, material, subcontractor, equipment and other. Each line on the statement gets a cost code, and every cost code sits in one of those buckets.

In Structur, every cost code carries one of those five types. Every account comes with a standard cost code list already loaded. You can add custom codes alongside it, or import CSI format codes from a CSV file.

How do you split the statement?

Enter the statement as one expense, with a line for each cost code on it. Lumber and sheetrock from the same vendor go on different lines, even though they're on the same statement.

Pick each line from the job's budget in Structur, so the cost lands against the item you priced. A cost code picked from the full catalog shows zero available and lands under Uncategorized in the budget.

You decide how fine to split it. If you want to be detailed, be detailed. Just keep it off a single materials line.

How often should you code your statements?

At least once a month, before the books close. Wait longer than that and nobody remembers what the material was for.

Then your bookkeeper reconciles the job costs against your accounting system every month. That only ties out when your cost codes line up with the categories in your chart of accounts. When they don't, the PM says the job made money and the accountant says it lost money.

What does the budget show you?

Open the budget for any job and you see what you estimated against what you've spent, cost code by cost code. If you estimated ten grand for drywall and spent eleven, you're a thousand dollars in the red. If you spent eight, you're two thousand under.

Expand a cost code in the Structur budget and it lists every expense, bill, subcontract and timesheet hour recorded against it. A negative variance shows in red, so you can see which part of the job is running over.

You find that out while the job is still running, when you can still do something about it.

Before your books close this month, pull the statement from your biggest supplier and split it by job and cost code.

Code every statement to the job budget in Structur.Start For Free