Calculate project costs
Solutions · Payroll

Payroll in DATEV, posting in SAP Business One

SAP Business One does not calculate wages and salaries – DATEV does. With the SAP package “Personalabrechnung mit DATEV HR” (payroll with DATEV HR) you transfer employee data to DATEV Lohn und Gehalt or LODAS and read the finished payroll back in as a posting document. It makes no difference whether your tax adviser runs the payroll or your own payroll team does.

SAP Business One Gold Partner in business since 1999 more than 400 midsize customers offices in Germany, Austria and Switzerland

1999in business since
400+midsize customers
70employees
DACHconsulting, rollout, support
GoldSAP Business One partner status

Payroll with SAP Business One – in brief

Payroll accounting calculates each employee’s net pay from gross pay, pays over wage tax and social security contributions and produces the statutory reports. Every payroll run ends with a posting document for financial accounting.

SAP Business One has no payroll in its standard scope. For companies in Germany, SAP provides the package “Personalabrechnung mit DATEV HR”: payroll runs in the DATEV applications Lohn und Gehalt or LODAS, SAP Business One supplies the employee data and takes over the result.

In practice this means employee data is maintained once in SAP Business One, the tax adviser receives it as a file, and the payroll arrives in financial accounting as a draft journal entry – to be checked and posted rather than retyped.

Classification
SAP package “Personalabrechnung mit DATEV HR” for SAP Business One
Payroll runs in
DATEV Lohn und Gehalt or LODAS
Who runs payroll
tax adviser or in-house payroll team
Return path
payroll as a draft journal entry
Technical basis
SAP Business One integration component, DATEV-HR scenario
Prerequisite
company database with German localization
Several companies
several company databases supported
Implemented by
init consulting AG, SAP Business One Gold Partner
Starting point

Where payroll costs midsize companies time

Typical situations when payroll in DATEV and accounting in SAP Business One run without a connection.

Payroll postings are retyped

The payroll journal arrives as a PDF from the tax adviser and the posting is entered by hand in financial accounting. Every month brings the same reconciliation work.

Employee data in two places

Name, address and bank details are held in the ERP and again at the tax adviser. Which version is correct only becomes clear when they differ.

Changes get lost

New hires, moves or new bank details are reported by email or phone – and sometimes reach the tax adviser only after the payroll run.

Month-end reconciliation

Payroll expense in the books and the payroll journal do not match because an item is missing or was entered twice. Tracking it down costs time at closing.

Several companies, several routines

Each company reports to the tax adviser differently and posts differently. There is no common process.

The tax adviser should stay

Payroll at the tax adviser works and nobody wants an in-house payroll system. What is needed is a clean connection, not new software in payroll.

Data flow

How SAP Business One and DATEV work together

This is how SAP describes the process in its guide to payroll with DATEV HR. Payroll is calculated in DATEV, data is maintained and posted in SAP Business One.

Capture in SAP Business One

Employee master data contains additional fields for DATEV. General data, home address, personal data and financial data are transferred.

Transfer to DATEV

In the employee list, the relevant employees are selected and transferred. The data is exported to a file that goes to the tax adviser.

Run payroll in DATEV

The tax adviser or the in-house payroll team runs payroll in DATEV Lohn und Gehalt or LODAS and adds any missing details, for example on social security.

Read in and post

The payroll file is placed in the inbound folder. SAP Business One creates a draft journal entry from it and notifies the responsible user, who checks and posts it.

Scope

What the DATEV HR payroll package covers

The scope follows SAP’s guide. The source is listed at the end of the page.

Additional fields in employee master data

Employee master data offers numerous additional fields that supply the master data in the DATEV applications with the most important information.

Transfer from the employee list

Select employees, transfer, done. Additional columns in the employee list show the last successful data transfer.

Payroll as a draft journal entry

The payroll file supplied by the tax adviser is read in and created as a draft journal entry – with a document number and a request to check and post it.

Messages in the system

In the Messages/Alerts Overview window, the package reports the start and end of processing, the name of the export file with the list of employees, and journal entries that have been read in.

Several company databases

Employee data can be transferred from several company databases and payroll results read into several company databases. The assignment uses the database name in the payroll file.

Existing authorizations

The standard SAP Business One authorizations for HR and employee master data apply. No separate role concept is needed.

Benefits

What changes in accounting and payroll

From feature to business result
FeatureWhat it means day to dayBusiness result
Employee data from SAP Business One The tax adviser receives a structured file instead of individual emails. Fewer queries and fewer errors in the payroll run.
Payroll as a draft journal entry The payroll posting is imported, not retyped from a printout. Faster month-end closing, no transfer errors in personnel cost postings.
Check before posting Accounting sees the document before it takes effect. Control stays with financial accounting.
Payroll stays in DATEV The tax adviser or payroll team keeps working in the application they know. No system change in payroll, existing expertise stays usable.
Transfer status in the employee list It is visible when which data was last transferred successfully. Traceability when the tax adviser has questions.
Limits

What payroll with DATEV HR does not do

These points belong before the decision, not in the first project meeting after signing.

SAP Business One does not calculate payroll

Calculation, reports to social security and the tax office, and certificates are produced in DATEV, not in SAP Business One.

Exchange via files

Employee data is exported to a file that goes to the tax adviser. The payroll also comes back as a file. An ongoing online connection to DATEV is not described in the guide.

Not all data is transferred

Passport details and employee costs are not transferred. Details such as social security information are added by the tax adviser in DATEV.

Posting follows a check

The payroll is created as a draft journal entry and is not posted automatically. Someone in accounting has to check and post it.

Germany only

A company database with German localization is required. For companies in Austria or Switzerland we discuss the right solution with you.

Integration component required

The package runs on the SAP Business One integration component with the DATEV-HR scenario activated. It has to be installed and operated.

Project process

From the current-state review to the first imported payroll

Current-state review

We clarify who runs payroll today, with which DATEV application, how many companies are involved and how the payroll posting reaches financial accounting today.

Setup

We install the integration component, activate the DATEV-HR scenario, define the folders for outbound and inbound files and decide who is notified about imported documents.

Complete master data

Employee master data in SAP Business One is extended with the details DATEV needs. Beforehand we agree who maintains which fields.

Alignment with the tax adviser

File exchange, assignment to the right company database and account assignment are agreed with your tax adviser. We recommend a test month before the new process replaces the old one.

Operation

After go-live your contacts stay the same. Support and maintenance come from the same company.

Terms

Payroll terms explained

Personalabrechnung mit DATEV HR
An SAP package for SAP Business One (payroll with DATEV HR). It supplies the DATEV payroll applications with employee data and reads the finished payroll back in as a posting document.
DATEV Lohn und Gehalt / LODAS
The two payroll applications from DATEV, the German software cooperative used by tax advisers and companies to calculate wages and salaries. The DATEV HR package supports both.
Gross-to-net calculation
The monthly pay calculation per employee: from gross pay via wage tax and social security contributions to the amount paid out.
Draft journal entry
A posting document in SAP Business One that has been created but not yet posted. It is checked first and only then posted.
Employee master data
The master record of an employee in SAP Business One with general, personal and financial details. It is the source of the data sent to DATEV.
Integration component
The SAP Business One integration component with the integration framework. The DATEV-HR scenario runs on it.
Localization
The country version of a company database in SAP Business One. DATEV HR requires the German localization.
Further reading

Topics related to payroll

How payroll postings are processed further in financial accounting is described on the accounting page. If personnel costs are to be allocated to projects, project management is the next building block.

For storing HR documents digitally, document management with B1ECM is the starting point. Licensing models and cost factors are summarized on prices and costs; an overview of the system as a whole is given in ERP for SMEs.

Frequently asked questions

Questions about payroll with SAP Business One

Is payroll included in SAP Business One?

No. SAP Business One has no wage and salary payroll in its standard scope. For companies in Germany, SAP provides the package “Personalabrechnung mit DATEV HR”: payroll is calculated in DATEV Lohn und Gehalt or LODAS, SAP Business One supplies the employee data and takes over the result.

Can our tax adviser keep running payroll?

Yes, that is exactly what the package is for. Your tax adviser keeps running payroll in DATEV and receives the employee data as a file from SAP Business One. The payroll comes back as a file.

Does it also work if we run payroll ourselves?

Yes. The package also supports companies that run payroll themselves with DATEV Lohn und Gehalt or LODAS.

How does employee data get to DATEV?

In the employee list in SAP Business One, employees are selected and transferred. The data is exported to a file that goes to the tax adviser. Additional columns show the last successful transfer.

Which employee data is transferred?

General data such as the name, the home address, personal data without passport details, and financial data without employee costs. Details such as social security information are added by the tax adviser in DATEV.

How do payroll postings reach financial accounting?

The tax adviser’s payroll file is placed in the inbound folder. SAP Business One creates a draft journal entry from it and notifies the responsible user, who checks and posts it.

What are the technical prerequisites?

A company database with German localization and the SAP Business One integration component with the DATEV-HR scenario activated. We take care of installation and setup.

Does it work with several companies?

Yes. Employee data can be transferred from several company databases and payroll results read into several company databases. The assignment uses the database name in the payroll file.

What does the connection cost?

The effort depends on the number of companies, the state of the employee master data and the alignment with your tax adviser. The online calculator gives a first estimate. Costs on the DATEV side are a matter for DATEV or your tax adviser.

Does this also apply to Austria and Switzerland?

No. The package requires a company database with German localization. For companies in Austria or Switzerland we discuss the right solution with you.

Who supports us after go-live?

The same contacts who accompanied the project. Consulting, implementation and support come from one company, with a personal direct line rather than a ticket number as the only contact.

Next step

Work out what connecting to DATEV will cost

The online calculator gives you a first, non-binding estimate. Useful for the conversation: the number of companies and employees, the DATEV application your tax adviser uses, and an example of how the payroll posting reaches financial accounting today.

Direct contact

Head office
Ruppertswies 14
85092 Kösching, Germany
Offices
Ingolstadt · Munich · Regensburg · Remscheid · Hanover · Rheine · Limburg an der Lahn · Innsbruck · Vienna · Switzerland

About this page

init consulting AG editorial team
SAP Business One Gold Partner, Kösching near Ingolstadt, Germany

Reviewed by the consulting team at init consulting AG. Technical articles appear on the b1-blog.

Status and review

Content as of:
Subject: the DATEV HR payroll package for SAP Business One
Next review: on a new SAP Business One release or a revised guide.

Sources

  • SAP SE: “Leitfaden zur Personalabrechnung mit DATEV HR” (guide to payroll with DATEV HR), user and configuration guide for SAP Business One 8.81 to 10.0, German, help.sap.com
  • SAP Business One product documentation, SAP SE
  • Licensing and pricing: Prices and costs

Accounting and management of HR data with SAP Business One

Payroll accounting is an extension (add-on) to SAP Business One for accounting and managing HR data. The payroll accounting system was specially designed to be used in small and medium-sized retail, industry, and service companies. Additional modules such as “construction wages” also allow it to be used for example by any trade in the construction industry. Other modules add support for short-time working pay (KUG) or partial retirement.

Digital HR office

The “Digital HR Office” module allows human resources files to be managed completely electronically. Any printed documents for employees, e.g. gross/net accounts or payroll tax certificates, are automatically archived in full, meaning that keeping copies is no longer necessary. The same applies to other documents, for example documents created in Word (certificates, employment contracts). Paper documents (e.g. applications) can also be added to the “digital HR office” using a scanning module.

Any documents subject to retention, e.g. payroll tax and health insurance lists or payroll accounts, can also be archived completely automatically, making fully electronic HR management a reality.

Travel expense accounting

The “travel expense accounting” module guides you through every accounting step from start to finish, directly verifies plausibility, and automatically transfers the correct amounts to the payroll account.

Key features of SAP Business One HR accounting

General

  • Windows 2000, Windows XP-Prof., Windows NT.
  • Hardware: min. P IV 1.6 GHz, 512 MB RAM (ideally 1.0 GB).
  • Multiusing, multitasking / database-based.
  • Suitable databases: MS-SQL 2000/2005.
  • Microsoft Office compatibility.
  • Supports multiple companies, up to max. 9999 companies.
  • Interface for business data entry and timekeeping.
  • Data archiving in accordance with digital document guidelines (GDPdU).

Evaluations

  • Payroll journal / payroll account.
  • Tax registration, including official form.
  • Health insurance lists with individual documents, proof of contribution.
  • Yearly employers’ liability insurance association report.
  • Accounting ledger with interface.
  • Time statistics / health statistics / working time account.
  • List of all wage types.
  • List of cost centers according to wage type or personnel.
  • Overview of vacation days.

Payroll account

  • Total remuneration / payments and deductions / vacation dates.
  • Other assessments / additional data.

Full Data Transmission Act (Voll-DEÜV) / DAKOTA

  • Basic DEÜV data.
  • Annual report / monthly report / separate report.
  • Data medium exchange / DEÜV certificates (§25).

Master data

  • Company master data with basic company data, company tax data, social insurance assessment thresholds, chamber contributions, online viewing of the bank code directory.
  • HR master data with basic, tax, social insurance, and employment data, employment benefits (VWL) and payment data, personal wage types, tariff classes, cost allocations, and garnishment data.
  • Insurance master data with bank details, individual documents, contribution rates, U1 and U2 contributions, online viewing of health insurance files.
  • Assessment threshold master data with risk class management, automatic consideration of annual assessment thresholds, monthly allocation and evaluation, annual evaluation/annual report.
  • 99999999 wage types master data, various types of calculation, average wage and garnishment control, wage type links via subsequent wage types, social insurance, tax, and assessment threshold controls.
  • 99 timesheets for managing standard working hours with automated overtime calculation.
  • Cost center and cost unit assignment.
  • Tariff class management according to tariff agreements.

Timekeeping and accounting

  • Automatic accounting of fixed wages or salaries
  • Data entry for variable salaries with or without calendar
  • Convenient copying and deleting functions for days, weeks, month
  • Multi-period entry
  • Automatic gross/net accounting on laser printer incl. form
  • Automatic discounting
  • Timekeeping evaluation and overtime list
  • End-of-period returns / retroactive accounting up to April of the previous year

Seasonal short-time working pay (KUG) / winter bonus pay (MWG/ZWG) (construction)

  • Timekeeping of worked hours in the calendar.
  • Payment of seasonal short-time working pay (KUG) with control and display of assigned hours.
  • Company work schedules are taken into account.
  • Overview of current working hour credits.
  • Determination of target/actual remuneration and corresponding flat-rate net remuneration.
  • Calculation of remuneration subject to contributions based on fictitious wages.
  • Winter bonus pay (MWG) for worked hours during the applicable period.
  • Winter bonus pay (ZWG) with winter bonus advances.
  • Reimbursement calculations for employment agency for seasonal KUG, MWG, ZWG.
  • Application lists for health insurance funds.

Complementary pension scheme (ZVK)

  • ZVK certification, payment of contributions, provident insurance list.
  • ZVK individual documents / data medium exchange.

Vacation / wage adjustment

  • Automatic determination of vacation days and vacation pay.
  • Vacation accounts managed in days and in €.
  • Automatic calculation of 13th salary.
  • Payment of vacation pay and additional vacation allowance.
  • Accounts with vacation funds / payment of contributions to vacation funds.

Short-time working pay (KUG)

  • Recording of hours in the calendar / determination of payable KUG.
  • Determination of target/actual remuneration and flat-rate net remuneration.
  • Calculation of remuneration subject to contributions based on fictitious wages.
  • Application lists for employment agency and health insurance funds.

Partial retirement module

  • Old and new systems.
  • Block model and continuous working time model.
  • Accounting according to legal regulations and tariff agreements.

Digital HR office module

  • Fully automatic archiving of specific printed documents, e.g. gross/net accounts, income tax certificates, etc.
  • Archiving of employment contracts, certificates, and other documents created using other programs, e.g. Word.

XML transfer

  • Transfer program for the electronic transmission of tax data provided in a standardized XML format.
 

Test SBO for free
and calculate prices

You can test Business One online in the free customer area of the website.
You can also use the online configurator to generate a non-binding offer.

Online offer

 

Info hotline

Advice directly on the phone, from our experienced experts. 
You can reach us on
Phone +49(0)8456 27 80 4-0
or by