Accountants

DATEV payroll: reconcile payments and payroll liabilities

Payroll can remain in the firm's established DATEV process while Hans handles the assigned bank transactions. The payroll journal records expenses and liabilities; the payments settle those liabilities. Decide where both streams meet. If payroll entries exist only in DATEV, that combined ledger is the complete payroll record. The example below reconciles net wages, wage tax and social insurance and explains a documented balance that remains after payment.

Author: DeinHans Team

Updated: 4 min read
In this article

Key takeaways

  • Record payroll expense once and each real bank payment once.
  • Reconcile net wages, wage tax and social insurance separately.
  • Identify the ledger containing the complete payroll and payment entries.

Start with the payroll journal

This simplified teaching example uses amounts already established by a payroll run. They are not tax or contribution rates and are not instructions for calculating wages. It excludes benefits, advances and other deductions.

Payroll entryDebitCredit
Gross wage expense€9,000β€”
Employer social-insurance expense€1,800β€”
Net wages payable—€6,000
Wage tax payable—€1,200
Social insurance payable—€3,600
Total€10,800€10,800

The €3,600 social-insurance liability comprises €1,800 withheld from gross wages and €1,800 employer contribution. Gross wages reconcile as €6,000 net pay + €1,200 wage tax + €1,800 employee contributions = €9,000.

This is the expense and liability entry. A later bank payment must not record the wage expense again.

Then reconcile each payment stream

Assume no opening liabilities. By the September reporting cutoff, the bank shows:

Bank paymentDebitCredit
Net wages paidNet wages payable €6,000Bank €6,000
Wage tax paidWage tax payable €1,200Bank €1,200
Social-insurance paymentSocial insurance payable €3,400Bank €3,400

The remaining liability is:

LiabilityPayroll amountPaidOutstanding
Net wages€6,000€6,000€0
Wage tax€1,200€1,200€0
Social insurance€3,600€3,400€200

In this example, the contribution statement explains that €3,400 was the amount initially paid and a further €200 is due under the final settlement. The €200 is documented and tracked to its applicable due date. Its later payment debits the liability and credits bank for €200.

Do not force the account to zero with an expense adjustment. Total payroll expense remains €10,800. Payments made so far are €10,600 and the remaining €200 is a liability. These illustrative dates and amounts do not replace payroll or social-insurance payment deadlines.

Make the two-system arrangement explicit

A workable division is:

  1. DATEV payroll: calculate payroll and provide the payroll journal to the receiving financial ledger.
  2. Hans: identify the assigned bank payments and post them against the agreed liability accounts.
  3. DATEV financial ledger: import the Hans entries and reconcile them against the payroll journal.
  4. Firm: check the final liabilities, bank movements and reports, then carry out the agreed filings.

The DATEV Lohn und Gehalt product documentation describes DATEV's payroll offering. This workflow does not claim a live Hans payroll interface or automatic import of the entire payroll journal into Hans.

If the firm needs complete payroll-inclusive reports in Hans, the payroll entries must also reach Hans through an explicitly supported and agreed process. Do not assume that mapping the bank payments supplies those missing entries.

Configure separate rules for separate liabilities

Net wages, wage tax and social insurance usually have different recipients and references. Confirm the actual target accounts and payment evidence for each. Sharing the label SKR03 does not ensure that custom accounts agree.

A supported bank rule can assign an identified payment to the defined liability account. The bank agent can help with references and allocation; the underlying payroll schedule provides the amount owed. A familiar recipient alone does not establish whether a movement is the current payment, a correction, a refund or an earlier-period settlement.

Hans processes the bookkeeping of payments that have occurred. It does not initiate salary or tax payments.

Investigate a remaining balance in a useful order

  • Timing: compare payroll month, payment date and the applicable due date.
  • Scope: check that every employee or contribution recipient in the payment list is covered.
  • Returns: look for a rejected transfer or subsequent refund.
  • Corrections: compare amended payroll and contribution statements.
  • Duplication: confirm that only one system supplied each bank posting.

If DATEV's existing bank workflow already posts a payment, exclude that same posting from the agreed Hans import scope. The objective is one expense recognition and one record of each real payment.

For the first month, retain the payroll journal, payment list, bank evidence and final liability reconciliation together. Use the setup guide to agree ownership and the bank guide to check the account as a whole.

Sources

Sources were checked on 06 October 2026. This article provides orientation and is not tax, legal, or accounting advice.

  1. DATEV – Lohn und Gehalt classic
  2. German Commercial Code section 238 – bookkeeping duty

Related resources

  1. Bank reconciliation: prove the balance and explain every movement
  2. Start with Hans alongside DATEV, Agenda or Lexware
  3. Month-end close checklist for accounting firms

Start with your first free mandate

One named mandate stays free for your firm, with all features and personal setup help. No card or automatic paid subscription.

Start freeBook a demo
Back to resources