RConsult.biz

Post payroll to SAP Business One automatically - from Sage and DATEV, in one click

PayrollImport reads your monthly payroll export and turns it into a pre-entered journal voucher in SAP B1 - including account mapping, tax codes and cost centres. No more manual re-keying or Excel workarounds.

Request a live demo See pricing

The problem: transferring the payroll journal by hand - month after month

SAP Business One has no German payroll module. Almost every B1 user runs payroll externally - via a tax advisor on DATEV or in-house with Sage - and then transfers the finished payroll journal into financial accounting by hand, month after month.

⚠ Time spent: re-keying or Excel workarounds with every payroll run - every single month.

⚠ Error risk: debit/credit mismatches and wrong cost centres caused by manual entry.

⚠ Compliance risk: the manual transfer path is hard to trace during an audit.

The solution: pick the file, review the preview, done

PayrollImport is a native SAP B1 add-on that automates exactly this step. Choose your source system, select the export file, review the preview - and the pre-entered journal voucher is ready. You check it as usual and post it with one click.

Sage and DATEV in a single tool

Most competitors cover DATEV only. PayrollImport reads the export formats of DATEV, Sage HR Suite and Sage Business Cloud - plus a generic profile for everything else.

Pre-entered voucher instead of direct posting

You stay in control: PayrollImport creates a pre-entered voucher that you review before posting. Nothing ends up in the GL unchecked.

Mapping, tax and cost centres

Account mapping maintained via Excel, tax code per target account, up to five cost-centre dimensions - set up once, consistent every month.

Native in SAP B1

No second system, no duplicate data, no export to the cloud. PayrollImport runs directly inside your SAP Business One.

Supported source systems

PayrollImport reads the common payroll and GL export formats of the German market. Each system has a predefined profile - select it once, the add-on does the rest.

DATEV Lohn und Gehalt

Booking batch (EXTF/DTVF CSV) and Primanota (CSV and Excel). Processes account and contra account, debit/credit indicator, amount, document/period field and cost centres KOST1/KOST2. Detects the typical DATEV structure automatically.

Sage HR Suite (on-premise)

Posting document in .er2 format with record types F/G/K (formerly Sage Personalwirtschaft). Automatically expands the cost-object split of the K records into individual document lines, takes the tax code directly from the file and handles reversals.

Sage Business Cloud Payroll

GL journal as CSV with wage types, amount, debit/credit account and employee code as cost centre. Considers the correction indicator for prior-month corrections and company-car/benefit-in-kind taxation.

Generic import

For any other CSV, TXT or Excel format without a dedicated profile: you map the columns to the target fields once - date, debit account, credit account, amount, cost centre, text, wage type, tax code.

Functional scope in detail

Import and formats

Predefined profiles for DATEV, Sage HR Suite and Sage Business Cloud plus a generic profile. Reads CSV, TXT and Excel (.xlsx) - without installed MS Office. Encoding and delimiter configurable per profile.

Account mapping

Remaps payroll account to GL account, differentiable by wage type and employee. Maintained in the form or via Excel import. Bridges different account-number lengths (e.g. 4 to 7 digits).

VAT

Tax code per target account stored in the mapping (e.g. A2 for 19%) - SAP calculates the tax automatically (AutoVAT). Factor for company-car/benefit-in-kind taxation per account and wage type.

Cost centres

Up to 5 cost-accounting dimensions, source per dimension selectable from the employee master (OHEM) or the mapping. Cost centres only on P&L accounts, automatic reformatting (e.g. D01000 to D-01-000).

Voucher creation

Creates a pre-entered journal voucher - nothing is posted unchecked. Single lines for full traceability or aggregated collective posting. Prior-month corrections are booked in the correct period automatically.

Control and traceability

Preview with debit/credit totals before posting, control-sum check before creation and an import log: which file created which voucher and when.

Pricing and licence models

Recommended

Subscription

EUR 89 /month

The easy start - maintenance, updates and support always included.

  • Setup: EUR 490 one-time
  • Maintenance and updates included
  • Support included
  • 12-month term, monthly cancellation thereafter
Request a live demo

Perpetual licence

EUR 1,990 /one-time

Ideal for long-term planning - unlimited term.

  • Setup: EUR 490 one-time
  • Maintenance and updates: 1st year included, optional afterwards (21%/year)
  • Support: 1st year included
  • Unlimited term
Request a quote

All prices excl. VAT, per company.

Frequently asked questions

Which source systems does PayrollImport support?
PayrollImport ships with predefined profiles for DATEV Lohn und Gehalt (booking batch EXTF/DTVF and Primanota), Sage HR Suite (.er2 posting document) and Sage Business Cloud Payroll (GL journal as CSV). On top of that there is a generic import for any other CSV, TXT or Excel format.
Does PayrollImport post directly into financial accounting?
No - by design. PayrollImport creates a pre-entered journal voucher. You review it in SAP Business One as usual and only then post it with one click. Nothing is posted unchecked.
My payroll system has no dedicated profile - can I still use it?
Yes. With the generic import you map the columns of your file to the target fields once (date, debit account, credit account, amount, cost centre, text, wage type, tax code). This also covers exports from further payroll systems or individual preparations.
Do I need Microsoft Office to read Excel files?
No. PayrollImport reads Excel files (.xlsx) without installed MS Office - no Excel COM required. CSV and TXT are supported as well, with configurable encoding and delimiter per profile.
How does the account mapping work?
The mapping remaps payroll accounts to GL accounts - differentiable by wage type and employee. It is maintained directly in the form or via Excel import for bulk maintenance and initial load. Different account-number lengths (e.g. 4 to 7 digits) are bridged as well.
Are cost centres supported?
Yes, up to 5 cost-accounting dimensions. The source is selectable per dimension - from the employee master (OHEM) or from the mapping. Cost centres are only set on P&L accounts, including automatic reformatting (e.g. D01000 to D-01-000).
How does PayrollImport handle VAT?
In the mapping you store a tax code per target account (e.g. A2 for 19%) - SAP then calculates the tax automatically (AutoVAT). For company-car and benefit-in-kind taxation there is an additional factor per account and wage type.
What about prior-month corrections?
PayrollImport creates period-correct vouchers: prior-month corrections are booked in the correct period automatically. For Sage Business Cloud the correction indicator is evaluated; for Sage HR Suite reversals (negative amounts) are handled correctly as well.
How do I stay in control of the import?
Before creation, PayrollImport shows a preview with debit/credit totals and runs a control-sum check (debit equals credit). The import log documents which file created which voucher and when.
Which SAP Business One versions are supported?
PayrollImport is a native SAP B1 add-on (DI/UI API) for SAP Business One 10.0 - on SAP HANA and Microsoft SQL Server, multi-company.
Does my payroll data end up in the cloud?
No. PayrollImport runs natively in SAP Business One - no second system, no duplicate data, no export to the cloud. Developed and supported by RConsult.biz GmbH, Germany.
Can I try PayrollImport before buying?
Yes. In a free 30-minute live demo we show you the import of your own Sage or DATEV file live in SAP Business One.

See PayrollImport with your own file format?

In 30 minutes we show you the import of your Sage or DATEV file live in SAP Business One - free and without obligation.

Request a live demo
17+
Years of experience
50+
Successful projects
3
Locations