---
title: "KLARA payroll hours import from a spreadsheet · Hypamoon"
description: "Typing hours from a spreadsheet onto each KLARA payslip at month end? The hours go onto the open payslip of each employee after you check the list."
url: https://hypamoon.com/connect-to/klara/hours-to-payroll
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [KLARA](https://hypamoon.com/connect-to/klara)
3.  Payroll hours import

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.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=klara/hours-to-payroll)

## 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.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~klara/hours-to-payroll&say=hours%20from%20our%20monthly%20spreadsheet%20on%20each%20employee's%20open%20KLARA%20payslip%2C%20after%20I%20approve%20the%20list.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=klara/hours-to-payroll)

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.**](https://hypamoon.com/connect-to/klara/shop-orders)
-   [**I want to invoice customers in their currency and still have the invoice in my KLARA books.**](https://hypamoon.com/connect-to/klara/foreign-currency-invoices)
-   [**I want revenue per customer per month and per year without adding up invoices.**](https://hypamoon.com/connect-to/klara/revenue-by-customer)
-   [**I want a statement per supplier with its invoices and payments for a period I choose.**](https://hypamoon.com/connect-to/klara/partner-statements)
-   [**I want costs I booked for a customer to end up on that customer's invoice.**](https://hypamoon.com/connect-to/klara/rebill-expenses)
-   [**I want late customers to get the reminder fee and interest without me calculating it.**](https://hypamoon.com/connect-to/klara/late-payment-fees)
-   [**I want my KLARA figures in a spreadsheet each month, compared with last year.**](https://hypamoon.com/connect-to/klara/monthly-report)
-   [**Everything for KLARA**](https://hypamoon.com/connect-to/klara)
