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
- Collect the hours per employee in a spreadsheet during the month.
- Open each employee in KLARA and add the salary item for the hours.
- 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.
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.
More for teams on KLARA
- I want orders from my webshop to become invoices in KLARA without typing them in twice.
- I want to invoice customers in their currency and still have the invoice in my KLARA books.
- I want revenue per customer per month and per year without adding up invoices.
- I want a statement per supplier with its invoices and payments for a period I choose.
- I want costs I booked for a customer to end up on that customer's invoice.
- I want late customers to get the reminder fee and interest without me calculating it.
- I want my KLARA figures in a spreadsheet each month, compared with last year.
- Everything for KLARA