{"product_id":"quote-estimate-and-job-costing-tracker","title":"Quote, Estimate and Job Costing Tracker","description":"\u003cp\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Quotes sit in one place, job costs in another, and nobody remembers which quotes are about to lapse. It is hard to say how many quotes you won, how much is still open and whether a job is running over what you budgeted.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of customers, one of quotes, one of jobs and one of costs. The workbook works out which quotes are open, expiring or expired, your win rate, the value won and lost, and whether each job is within or over its budget, then counts it all on a dashboard.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee open quotes, quotes expiring soon, your win rate and jobs over budget at a glance.\u003c\/li\u003e\n\u003cli\u003eSee quotes by status and by job type, with value won and value lost.\u003c\/li\u003e\n\u003cli\u003eCheck expiry: open quotes are shown as Expiring soon, Expired or Valid, using the window you type.\u003c\/li\u003e\n\u003cli\u003eSee each job's cost to date, budget left and quote less costs.\u003c\/li\u003e\n\u003cli\u003eSee costs by type, as a table and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSpot mistakes: a Quote ref or Job ref that is not found, or a job set up from a quote that is not won, is flagged.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (home services, building trades or professional services) to load suitable lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and four export sheets repeat your customers, quotes, jobs and cost lines under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry and type your statuses and expiring-soon window.\u003c\/li\u003e\n\u003cli\u003eAdd your customers, then quotes, jobs and cost lines.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard each week.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Trade businesses, sole traders and small service businesses who write their own quotes and want to see what is open, what is expiring and whether each job is on budget.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need software that prices a job, builds or sends quotes, takes payments or sends reminders. This is a spreadsheet: you type the records, and it does not send anything or connect to other software.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e300 customers, 800 quotes, 500 jobs and 1,500 cost lines are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eNothing is set for you. Your statuses, which status means won, lost or open, the expiring-soon window and every budget are typed by you.\u003c\/li\u003e\n\u003cli\u003eQuote less costs uses the quote amount only. It is not a profit figure and no tax is worked out.\u003c\/li\u003e\n\u003cli\u003eAmounts are added as typed, so totals make sense within one currency.\u003c\/li\u003e\n\u003cli\u003eThis workbook holds customer names, emails and phone numbers, so keep the file protected.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up business shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262451917,"sku":null,"price":306.0,"currency_code":"NOK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_d76daca9-cd35-4953-9cd4-2f4b13629c4c.png?v=1795097498","url":"https:\/\/www.teleworld.online\/en-no\/products\/quote-estimate-and-job-costing-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}