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.
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.
More From The Blog
How To Run A Construction Knowledge Quiz In An Interview
Run the construction knowledge quiz live, one question at a time, as a conversation. A candidate who hasn't done the work can't keep it going for long.
Read the post 2 min readSubcontractsShould A GC Subcontract Every Trade?
In-house crews come with vehicles, gas and insurance. Subbing out most trades turns your company into a management company that can grow past ten million.
Read the post 2 min readStandard operating proceduresHow Much Are Systems Worth When You Sell?
Two contractors with the same three million in revenue and the same profit can sell for very different prices. The one with documented systems is worth several times more.
Read the post 2 min read