Hi,
we are a hospitality & real estate company based in Vienna (Austria) and are looking for an experienced Frappe/ERPNext developer for a very specific HR / time-tracking project.
We have already interviewed 5 candidates on generic freelance platforms, but most of them were not familiar enough with Frappe and could not answer more advanced, implementation-level questions. This time, we would like to work directly with someone from the Frappe/ERPNext community who really knows the framework.
Project overview
We are using Frappe HR and have the following requirements:
Phase 1 (priority – should be a fixed-price project if possible):
-
Historical data import:
- We have structured “Working Hours” PDFs for about 7 employees (various months).
- These contain daily punch-in / punch-out times, total hours, overtime, vacation usage, etc.
- Goal: extract this data and import it into our Frappe HR instance so that all balances (normal hours, overtime, vacation, etc.) are correct.
-
Weekly CSV import:
- We use an NGTeco time-tracking device in our office.
- We export weekly CSV files with punch records.
- Goal: implement a workflow to import these CSVs, match punch records to employees, and calculate hours, overtime, vacation, etc.
-
Exception handling:
- Missing punches (in/out) must be flagged and shown to HR for manual review.
- HR should be able to correct records and recalculate balances.
-
Calculation logic:
- Expected hours per month,
- Overtime (1.0 / 2.0 multipliers – e.g. Sundays / public holidays),
- Vacation and other leave types,
- Cumulative balances.
-
Monthly PDF report:
- Generate a monthly “Working Hours” PDF per employee that matches a sample layout we already use (we will share the sample PDF).
Phase 2 (later, but should be considered in the architecture):
- Recommendation of a fingerprint time-tracking device with an API.
- Integration of this device with Frappe HR (device → Frappe via API), so that in the future we no longer rely on CSV exports.
What we expect from the developer
- Strong, hands-on experience with Frappe/ERPNext (preferably HR/Attendance modules).
- Very good understanding of:
- Scripted reports / Query reports,
- DocType design,
- Server scripts / background jobs,
- PDF print formats (Jinja/HTML → PDF),
- Data import architecture.
Our in-house developer will join the call and ask detailed technical questions about:
- PDF data extraction strategy (tables, parsing, validation),
- How you would model the data in Frappe DocTypes,
- How you would implement the CSV import logic,
- How you would design the exception handling UI/flow,
- How you would structure the calculation logic,
- How you would prepare Phase 1 so Phase 2 (API integration) is easy to plug in later.
What you should send us BEFORE the call
To filter out unprepared candidates, we kindly ask you to send the following before we schedule an interview:
-
A short confirmation that you have read this post and are familiar with these kinds of implementations.
-
A rough price indication for:
- Phase 1 (fixed price preferred)
- Phase 2 (rough estimate is enough)
-
Optional but helpful:
- 2–3 sentences describing your general technical approach (no long document required),
- Links to relevant Frappe/ERPNext work (GitHub, apps, previous projects, forum posts, etc.).
We will then invite 3 candidates to a 30-minute technical call with our in-house developer to discuss details.
If you feel that this project matches your skills and experience, please reply here or send me a direct message with your price indications and a short introduction.
Thank you and best regards,
Roman
