DATEV export
  1. Home
  2. Manual
  3. Accounts and debtors

Manual Tax rates come from the shop, accounts from the tax firm.

In the "Accounts" tab you assign a revenue account to every tax rate, a cash account to every payment method and a debtor to the customers. For the revenue accounts the standard accounts of the chart are suggested.

Revenue accounts

An account for every rate that occurs.

Every tax rate that orders actually carry needs a revenue account - otherwise the export stops. The assistant suggests the standard accounts for 19% and 7%.

  • Tax keys are optional. An automatic account like 8400 carries its rate itself; a key only belongs on accounts without an automatic tax function; your tax advisor says which ones. The key fields are shown with the switch in the "Tax keys (BU)" card.
  • Without accounts of their own, shipping and vouchers are booked proportionally to the revenue accounts; with their own account per tax rate they are shown separately - for domestic sales, and every discount counts as a voucher.
  • The accounts of the foreign cases may stay empty: the export then books to the standard account of the chart and says so in every run.

your-shop.com/admin

Orders › DATEV export › Tenants

Muster Handels GmbH

CancelSave

Master dataBookingAccountsTax & OSSExportSales channels

No revenue account for the tax rate 7 %. Documents with that rate cannot be booked - your tax advisor knows which account is right.

Revenue accounts per tax rate

1 open

Where your sales are posted - mandatory for your shop’s own rates

Your tax rates

Revenue 19 %

8400

Revenue 7 %Without an account the export blocks documents carrying this rate. Adopt standard 8300

standard 8300

Money accounts per payment method

Where the money lands - only with the payment export on

Prepayment

1200

Invoice

1200

PayPalWithout an account the payment is not booked.

e.g. 1200 (bank) or 1000 (cash)

The debtor

Four ways to the personal account.

The debtor is the personal account the revenue is booked against. A collective debtor is required whichever way you choose - a personal account like 10000, not the control account 1400 or 1200, which DATEV does not let you book directly.

  • One collective debtor: One account for all customers. Enough for a pure revenue export.
  • Collective debtor per payment method: An account of its own per payment method. Careful with open items if the payment method changes after the invoice.
  • Collective debtor with diverse addresses: One account, the customers told apart by an address number. The file EXTF_Div-Adressen is created alongside. The tax firm marks the collective debtor as "Diverses Konto" in DATEV; customer numbers at most 9 characters.
  • Individual debtors: Every customer gets an account of their own; a rule says which one - by default their customer number. The file EXTF_DebKred_Stamm is created alongside.

With individual debtors the number has to fit the range of personal accounts, 10000 to 69999 with four-digit accounts; anyone without a usable number books to the collective debtor and is named in the check report. The tax firm imports the master data before the booking batch.

The Accounts tab with the foreign-sales accounts, the debtor account rule and the four ways to the debtor

Cash accounts

Only needed if the tenant exports payments, one per payment method. The payment books debit cash account, credit debtor, a refund the other way round, always against the same personal account as the invoice.

Different per channel

With two or more channels every account line can be set differently per channel. Only the debtor stays the same for all channels.

Cost centres

Rules with a priority assign KOST1 and KOST2, by tenant, channel, payment method, delivery country and tax rate. They never change account, amount or tax.

Cost centre rules

The first matching rule wins.

All active rules are checked by priority, per booking line: a document with 19% and 7% can get two cost centres. An empty condition field means "any" - a rule without a condition at priority 0 catches everything else.

  • Effective only with the "Fill cost centres" switch on the "Booking" tab of the tenant.
  • A rule with a tenant applies only to its exports, without one to all.
  • Letters, digits, underscore and spaces are allowed, at most 36 characters - DATEV rejects a hyphen or an umlaut.
  • On the money line, channel, payment method and delivery country apply; a payment has no tax rate.
A cost centre rule with conditions, priority and the values for KOST1 and KOST2
Questions

What gets asked about it.

Which accounts apply for my tax firm?

The ones the tax firm specifies. The plugin suggests the standard accounts of SKR03 and SKR04; every one of them can be overridden on the tenant.

What if a customer's number does not fit the debtor range?

Then the document books to the collective debtor and the check report names it with the rejected number. The revenue is complete; only the assignment to the customer is missing at the tax firm.

The other chapters

Export and history

Period, preview, test export and export, the running run and the history.

All settings

Every setting on the tenant and the global switches, with default and effect.

Glossary

Booking batch, general reversal, freeze and the other words from DATEV and Shopware.