action.skip

Enabling Booking Accounts for Revenues and Taxes

← Booking Account Allocation

JustOn Billing & Invoice Management allows for writing bookkeeping data for revenues and taxes from finalized invoices. These records can then be transferred to accounting systems like DATEV, SAP or Microsoft Dynamics via CSV export or, for DATEV, direct transfer.

To provide for the correct booking account allocation, you create dedicated Assignment Rules - G/L Account and Collective Account settings.

Booking revenue and taxes (without specific use cases like revenue deferral) usually requires the following booking accounts:

Account name Account no.
SKR 03		 Configuration Type
Revenue 19% 8400 G/L Account
Taxes 19% 1776 Collective Account
Revenue 7% 8300 G/L Account
Taxes 7% 1771 Collective Account
Debtor Debtor number

Remember that depending on your accounting system, the booking account numbers may differ.

  1. Create Assignment Rules - G/L Account settings to book the revenue.

    To cover the minimum use cases for revenues with 19% VAT and for revenues with 7% VAT, you need at least the following settings:

    Name G/L Account Tax Code Business Entity
    Revenue 19% 8400 DE_19 business entity name
    Revenue 7% 8300 DE_7 business entity name

    For details, see Configuring G/L Account.

  2. Create Collective Account settings for the tax bookings.

    To cover the outlined use cases, you need at least the following settings:

    Name Booking Account Tax Code Type
    Tax 19% 1776 DE_19 Tax
    Tax 7% 1771 DE_7 Tax

    Depending on your requirements, your Collective Account settings may, in addition, need to define the Business Entity.

    For details, see Configuring Collective Accounts.

  3. Enable the debtor account number.

    Depending on your requirements, the way to define the debtor account number differs:

    For customer-specific debtor numbers, you use the Account field ON_DebtorNo.

    1. Navigate to the fields list of the Account object.

    2. Create the following new field.

      API Name Data Type Description Example Values
      ON_DebtorNo Text (255)
      or
      Formula      		 Specifies the contra account number for booking details. If configured as a formula, it can determine the value based on other fields. 12345
      AnotherField__c

    To support collective debtors (or debtor groups), you use the Invoice field DebtorNo.

    Using a collective debtor number via the Invoice field DebtorNo does not require a collective account setting. Instead, you just set the intended booking account number to be transferred to the booking detail.

    1. Navigate to the fields list of the Invoice object.

    2. Create the following new field.

      API Name Data Type Description Example Values
      DebtorNo Text (255)
      or
      Formula      		 Specifies the contra account number for booking details. If configured as a formula, it can determine the value based on other fields. 12345
      AnotherField__c

    If the field is configured as a text, you can use the ON field mechanism to have it set using values from invoice source objects. Be aware, however, that if the field is configured as a formula, the ON field mechanism will not overwrite the DebtorNo value.

    Info

    When creating booking details, the Invoice field DebtorNo takes precedence over the Account field ON_DebtorNo. If the Invoice field DebtorNo is empty or does not exist, JustOn Billing & Invoice Management uses the Account field ON_DebtorNo to set Contra Booking Account in the booking detail.