ERPNext Project Management: Tasks, Timesheets & Costing

 · 8 min read

ERPNext project Gantt chart with timesheets and project profitability

Project businesses usually have two systems that never agree: a task tool where the team tracks work, and an accounting system where finance tracks money. At the end of a project, someone builds a spreadsheet to find out whether it was profitable, and by then it is too late to fix anything.

ERPNext project management puts tasks, timesheets, purchases, stock issues, expense claims and invoices against the same project record, so project costing is live rather than a post-mortem. This guide shows how to set it up for service firms, IT companies, engineering and contracting businesses in India and the GCC, based on ERPNext v15 and v16.

Key takeaways

  • A Project is also a cost object. Timesheets, purchase invoices, stock entries and expense claims that carry the project roll up into its costing.
  • Use project templates for repeatable work so every new project starts with the same tasks and durations.
  • Activity Costs set the costing rate and billing rate per employee and activity type, which drives both project cost and timesheet billing.
  • Profitability comes from one screen: the project shows total costing, billed amount and gross margin, and reports compare projects.

Do you know which projects actually make money?

Bring one finished project. In a free 30-minute call we will show how ERPNext would have tracked its hours, purchases and margin.

Review one project → WhatsApp us: +91 8089051848

Or email info@nexeves.com

The building blocks

Document Role in a project
Project The container: customer, dates, expected end, status, percent complete, costing and billing totals
Task Units of work with dependencies, expected time, assignees and progress; shown in list, Kanban and Gantt views
Project Template A reusable set of tasks with offsets and durations
Activity Type Kinds of work such as design, development, site supervision, testing
Activity Cost Costing and billing rates per employee (or default) per activity type
Timesheet Hours logged by employees against project and task, billable or not
Purchase, Stock Entry, Expense Claim Material, subcontract and expense costs tagged with the project
Sales Order / Sales Invoice Billing against the project: fixed price, milestones or time and material

Step 1: Build project templates

Most firms do the same kind of project again and again: a website build, an ERP rollout, an HVAC installation, an interior fit-out. Create a Project Template for each with its tasks, the day each task starts relative to the project start, and its duration. Mark dependent tasks so the Gantt chart shows the critical path. When a new project is created from the template, all tasks are created with dates.

Step 2: Create the project

Create the project from a template, or directly from a Sales Order so the customer, value and items are linked. Set:

  • Customer and, if used, the sales order
  • Expected start and end dates
  • % complete method: manual, based on task completion, task progress or task weight
  • Cost center, so project costs also reach branch or department P&L
  • Project users if the customer should see progress in the portal

Step 3: Plan and track tasks

Tasks can have parent tasks, dependencies, expected hours, assignees and priority. Teams use the Kanban view for daily work and the Gantt view for planning. Assignments and comments notify users, and the project's percent complete updates as tasks close. Keep the task list practical: tasks of half a day to two weeks are easy to track; tasks of three months are not.

Step 4: Set activity costs and log time

Create activity types and then Activity Cost records with a costing rate and billing rate. You can set a default per activity type and override it per employee. The costing rate should be the loaded hourly cost (salary plus overheads), which finance should calculate once a year. Employees log hours on Timesheets against the project and task and mark each line billable or not.

Timesheet discipline is the hard part, not the software. Make it weekly at minimum, review missing timesheets every Monday, and keep activity types few and clear. Biometric or mobile attendance can help verify hours; see attendance automation with biometrics.

Want our project setup checklist?

We will send the project template, activity cost and billing checklist we use for service, IT and contracting firms.

Send me the checklist → WhatsApp us: +91 8089051848

Or email info@nexeves.com

Step 5: Charge materials, subcontractors and expenses to the project

  • Purchases: set the project on the purchase order and invoice lines. Subcontractor bills and direct purchases then appear in project cost.
  • Materials from stock: issue items with a Stock Entry (Material Issue or Transfer) carrying the project, so consumed material cost is recorded.
  • Expense claims: travel and site expenses claimed by employees can carry the project.
  • Budgets: create a Budget with Budget Against set to Project, so ERPNext can warn or stop purchases that exceed it. Pair it with an approval workflow for exceptions.

Step 6: Bill the customer

Billing model How it works in ERPNext
Fixed price Sales order for the contract value; invoice in full or in parts
Milestones Payment schedule on the sales order, or invoices raised when tasks or milestones close
Time and material Create the sales invoice from billable timesheets, using billing rates from activity costs
Retainer or AMC Subscription for recurring monthly or quarterly invoices
Progress billing (contracting) Invoice a percentage of contract value per period, with retention tracked in a separate account or custom fields

Invoices follow your GST or VAT templates as usual. For service companies in India, the place of supply decides CGST/SGST or IGST; for GCC customers, VAT rules on services apply. See our GST setup guide and UAE VAT guide.

Step 7: Read project profitability

The Project form shows total costing amount from timesheets, total purchase cost, total consumed material cost, total expense claim, total billable and billed amounts and the gross margin. Useful reports include:

  • Project Summary and project-wise costing for a list of projects
  • Timesheet Billing Summary and Daily Timesheet Summary for hours
  • Delayed Tasks Summary for slippage
  • General Ledger or P&L filtered by project for the accounting view

A simple discipline: review open projects every fortnight with three numbers, percent complete, percent of budget spent and percent billed. If spend runs ahead of completion, or billing runs behind it, act now. For the wider profitability view, see customer and product profitability.

A worked illustration (hypothetical)

Item Amount (₹)
Contract value (fixed price) 10,00,000
Timesheet cost: 600 hours at an average loaded cost of ₹900 5,40,000
Subcontractor and purchases 1,80,000
Expense claims 30,000
Total cost 7,50,000
Gross margin 2,50,000 (25%)

These numbers are invented to show the arithmetic. If the same project overran by 200 hours, margin would fall to 7%, which is why live hours matter more than end-of-project reviews.

Customer visibility

Customers can be given portal access to see their projects, tasks and timesheets, which reduces status-update calls. Decide carefully what to share: many firms share tasks and progress but not internal hours.

Industry notes

Frequently asked questions

Does ERPNext have project management?

Yes. ERPNext has a Projects module with projects, tasks, dependencies, Kanban and Gantt views, templates, timesheets and project costing, linked to accounting, buying, stock and HR.

How does project costing work in ERPNext?

Costs reach a project from timesheets at the activity costing rate, purchase invoices, stock issues and expense claims tagged with the project. The project shows total cost, billed amount and gross margin.

Can I bill customers from timesheets in ERPNext?

Yes. Billable timesheet hours can be pulled into a sales invoice using the billing rate from activity costs, which suits time and material contracts.

What is a project template in ERPNext?

A reusable list of tasks with start offsets and durations. New projects created from the template get all tasks and dates automatically.

Can customers see project progress in ERPNext?

Yes, through the customer portal when they are added as project users. You can control which details are visible.

Is ERPNext suitable for construction project accounting?

It covers project costing, material issue, subcontractor bills and progress billing. Retention and certain contract-specific reports are often added through configuration or light customisation.

Run projects and accounts in one system

Nexeves Technologies sets up ERPNext projects, timesheets, project billing and profitability reports for service, IT, engineering and contracting companies in India and the GCC.

Book a free demo → WhatsApp us: +91 8089051848

Or email info@nexeves.com

Nexeves Technologies serves India & the GCC: UAE (Dubai, Abu Dhabi), Saudi Arabia (Riyadh, Jeddah), Qatar (Doha), Kuwait and Bahrain.


No comments yet.

Add a comment
Ctrl+Enter to add comment