{"product_id":"construction-job-cost-tracker","title":"Construction Job Cost Tracker Spreadsheet","description":"\u003cp\u003eThis job costing spreadsheet shows which jobs made money and which did not, at any point in the year. In the demo, eight jobs ran and seven made money; the tracker tells you which one did not. It is built for builders, trades and any contractor who prices and runs jobs.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eFive cost heads on every job\u003c\/h2\u003e\u003cp\u003eLabor, materials, subcontractor, plant and other are tracked on each job against the contract value and against what you have actually invoiced. Gross profit, margin and a status appear on each row, and the strip at the top counts how many jobs are losing money. That job profit view is the core of the file.\u003c\/p\u003e\u003ch2\u003eStill to invoice\u003c\/h2\u003e\u003cp\u003eStill to invoice is the figure that catches contractors out, and it is here for each job and in total: 424,130 across the demo's eight jobs. Invoiced reads the income register, so a progress claim entered once against the job name shows up without being typed twice.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eJob Costing: 30 jobs, five cost heads each\u003c\/li\u003e\n\u003cli\u003eGross profit, margin and a status per job, with losses flagged\u003c\/li\u003e\n\u003cli\u003eStill to invoice, per job and in total\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe books behind the jobs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e1,000 ledger rows, with two years of demo data in the filled copy\u003c\/li\u003e\n\u003cli\u003eProfit and loss by category, with monthly and quarterly views\u003c\/li\u003e\n\u003cli\u003eA custom date range, and a year-on-year comparison\u003c\/li\u003e\n\u003cli\u003eEvery figure calculated: totals, margins and percentages\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eThere are seventeen connected tabs, and everything recalculates from two registers, money in and money out. Nothing is typed twice and there are no pivot tables to refresh. It works as a contractor tracker and a construction budget record for each project cost.\u003c\/p\u003e\u003cp\u003eYou get a filled-in copy with two full years already entered, so you can click through it working, and a blank ready for your own numbers, in Excel and Google Sheets. There are no dynamic arrays, no macros and no add-ins, and the Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros, no subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for use in your own business; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. You get Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eWhat costs are tracked on each job?\u003c\/h3\u003e\u003cp\u003eFive cost heads: labor, materials, subcontractors, plant and other, against the contract value and what has been invoiced.\u003c\/p\u003e\u003ch3\u003eHow many jobs can I track?\u003c\/h3\u003e\u003cp\u003eThe Job Costing tab holds 30 jobs, and the ledger holds 1,000 rows.\u003c\/p\u003e\u003ch3\u003eHow does it know what I have invoiced?\u003c\/h3\u003e\u003cp\u003eInvoiced reads the income register. Enter a progress claim once against the job name and it shows on the job.\u003c\/p\u003e\u003ch3\u003eDoes it flag jobs that lose money?\u003c\/h3\u003e\u003cp\u003eYes. Each job has gross profit, margin and a status, and the top strip counts the jobs losing money.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864239198,"sku":"OPX-074","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/construction-job-cost-tracker-01.jpg?v=1790832350","url":"https:\/\/opxviashop.com\/products\/construction-job-cost-tracker","provider":"OPXVIA","version":"1.0","type":"link"}