{"product_id":"employee-cost-tracker-excel-google-sheets-rehab-labor-costs-and-job-allocation-spreadsheet","title":"Employee Cost Tracker | Excel \u0026 Google Sheets | Rehab Labor Costs and Job Allocation Spreadsheet","description":"\u003cp\u003eSee what each employee costs for a pay period, then allocate that cost across rental properties, rehab projects and office work.\u003c\/p\u003e\u003cp\u003eTRACK REHAB PROJECT LABOR\nLog each employee’s worked hours under a property address or rehab project name to see allocated labor costs for the pay period. Repeat with a saved copy for each period. Project totals use each employee’s average cost per worked hour, including entered employer taxes, benefits and other costs. Materials and subcontractor invoices are not tracked in this workbook.\u003c\/p\u003e\u003cp\u003eThis editable spreadsheet, available in Excel and Google Sheets, brings wages, employer payroll taxes, benefits and other employee costs together. Enter matching-period costs and worked hours to calculate an average cost per worked hour for each employee.\u003c\/p\u003e\u003ch3\u003eWHAT IS INCLUDED\u003c\/h3\u003e\u003cp\u003eOne Excel workbook (.xlsx), plus a separate Google Sheets access PDF to make your own editable copy. Both versions have four tabs: Overview, Employee Costs, Hours and Start Here. Capacity: 10 employee slots, 200 hour-allocation entries and 20 business\/project summary pairs. Fictional sample entries and instructions for clearing the examples are included.\u003c\/p\u003e\u003ch3\u003eHOW IT WORKS\u003c\/h3\u003e\u003cp\u003e1. Enter gross wages, employer taxes, benefits and other costs for the same pay period.\n2. Enter worked hours by employee, business and property or project. Include office\/admin worked time.\n3. Review employee costs, allocated costs, unallocated costs and flagged entries.\n4. Add your business\/project pairs to the Overview summary.\u003c\/p\u003e\u003cp\u003eGross wages include paid leave. Worked hours exclude paid leave, so leave costs are spread across worked time. One average employee cost rate applies across that employee's projects. This does not calculate employee pay, tax liabilities or customer invoices. Enter employer tax amounts from your payroll records. Employee tax withholding is already included within gross wages.\u003c\/p\u003e\u003cp\u003eAmber cells are editable inputs. Reuse a saved copy for each pay period. Enter optional cost categories only when applicable and prorate monthly expenses to the period being reviewed.\u003c\/p\u003e\u003cp\u003eDIGITAL\u003c\/p\u003e\u003ch3\u003eFILE DETAILS\u003c\/h3\u003e\u003cp\u003eDigital download. No physical item will be shipped. Excel workbook and Google Sheets version with editable inputs and formulas. Use Microsoft Excel for the .xlsx file. For Google Sheets, open the separate access PDF and select Make a copy while signed in to your Google account. Excel and Google Sheets copies do not sync. No macros, tax-rate tables or external data connections are included.\u003c\/p\u003e\u003cp\u003eThe pictured title-card laptop mockups are illustrative. The listing video shows actual workbook screens with fictional data.\u003c\/p\u003e\u003cp\u003eCreated with AI assistance and reviewed by Keys \u0026amp; Keep Property.\u003c\/p\u003e","brand":"Keys and Keep Property","offers":[{"title":"Default Title","offer_id":46108723445829,"sku":null,"price":7.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0771\/3767\/4309\/files\/eb43a654-il_fullxfull.8652057064_2vvo.jpg?v=1792789617","url":"https:\/\/keysandkeepproperty.com\/products\/employee-cost-tracker-excel-google-sheets-rehab-labor-costs-and-job-allocation-spreadsheet","provider":"Keys and Keep Property","version":"1.0","type":"link"}