ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
CONSTRUCTION JOB COSTING TEMPLATE
3
by ontraq.ai
4
5
HOW TO USE THIS TEMPLATE
6
7
1. Start on the "Job Setup" tab. Enter your project info and estimated budget by cost code.
8
2. Use the "Cost Log" tab daily to log every expense, time entry, and sub invoice as it happens.
9
3. The "Job Summary" tab auto-calculates budget vs. actual, variance, and % complete for each cost code.
10
4. Review the Job Summary weekly to catch overruns before they become unfixable.
11
12
COLOR CODING
13
14
Blue text = cells you fill in (inputs)
15
Black text = formulas (don't edit these)
16
Yellow background = key cells that need your attention
17
Green background = under budget
18
Red background = over budget
19
20
TIPS
21
22
• Log costs within 24 hours. Stale data is useless data.
23
• Be consistent with cost codes. If it's labor, always code it to Labor.
24
• Review the Job Summary every Friday. 5 minutes of review can save thousands.
25
• When you outgrow this template, check out ontraq.ai — it automates everything here and syncs with QuickBooks.
26
27
QUESTIONS? Visit ontraq.ai/construction-job-costing/ for the complete guide.
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100