Skip to content
Hypamoon

For teams that run on KLARA

KLARA payroll hours import from a spreadsheet

Staff paid by the hour often write their hours somewhere else: a spreadsheet, a course planner, a time app. At the end of the month those hours are typed onto each payslip in KLARA, one employee at a time.

How it goes today

  1. Collect the hours per employee in a spreadsheet during the month.
  2. Open each employee in KLARA and add the salary item for the hours.
  3. Check the total against the spreadsheet before the payroll run.

How it can go

Hours from your list land on each payslip in KLARA.

At month end you drop the spreadsheet or export with the hours. Each row is matched to an employee in KLARA, and you get a list per employee with the hours and the salary item they go on, as KLARA allows it for that contract. After you approve, each item is added once to the open payslip of that month; employees without hours and names that do not match are listed separately. Corrections are made in KLARA. The KLARA key for this needs the role Mitarbeiter und Lohn.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your KLARA key in the portal, never in the chat.

Your request

With Hypamoon, at the end of every month, take the spreadsheet with hours I give you and match each row to an employee in KLARA. Show me a list per employee with the hours and the salary item they go on. After I approve it, add each item once to that month's open payslip in KLARA. List the employees without hours and the names you could not match.

You create the KLARA key yourself under Benutzer and give it the role the tool needs. It stays yours, and you can delete it there at any moment.