Skip to content

Bookkeeping Data for Payment Balances

Accounting Support

With the finleap connect integration and the ability to capture payments from various payment providers via the Self-Service Extension, JustOn is becoming a leading system to receive payment information. Accordingly, it allows for writing bookkeeping data for payment balances. These records can then be transferred to accounting systems like DATEV, SAP or Microsoft Dynamics via CSV export or, for DATEV, direct transfer.

Once created, the booking details can no longer be modified or deleted.

Ideally, you generate bookkeeping data from payment balances on a daily basis. To this end, JustOn provides a dedicated scheduled job. Once generated, you can export the bookkeeping data to accordingly configured CSV files, like DATEV posting batch or SAP CSV, which can then be transferred to the corresponding accounting system.

Info

The support for generating bookkeeping data from payment balances is available as of JustOn 2.57.

Bookkeeping data as generated from payment balances can hold account numbers, which are, typically, debtor numbers and bookkeeping accounts related to bank accounts or payment provider accounts. The data is able to track changes made to payment balances, like amount change or deletion. Payment bookkeeping data is unalterable with regard to balance assignment and overpayment splitting in order to keep the data clean.

Enabling Bookkeeping Data Generation
Scheduling Payment Bookkeeping Data Generation
Best Practice: Generating Bookkeeping Data

Payment Bookkeeping Data Structure

Bookkeeping data is structured in booking periods and booking details. Booking periods and booking details are in a master-detail relationship.

A booking period represents one month in bookkeeping. Hence, it aggregates the booking details produced for this month. Booking periods are grouped by business entities.

Be aware that the booking period status finally decides the booking detail allocation:

  • Open: A booking period with the status Open aggregates the booking details produced for this month.
  • Closed: A booking period with the status Closed is ignored. Any booking details produced for this period are moved to the next open booking period.

    booking_detail_period
    Booking detail allocation with closed booking periods

Note

Make sure to establish business processes to close booking periods according to your requirements.

A booking detail represents a record in an accounting ledger. JustOn creates one booking detail per payment balance change.

The following fields are mapped from the balance to the booking detail:

Balance Field Booking Detail Field
Account Account
Amount Amount
Date Booking Date, Payment Date
Type Type
Id Balance

Accountants may expect specific references to the operation from which produced booking details originate. To support this requirement, you can use booking texts. They define the content and pattern of this human-readable reference information, and JustOn then populates the Booking Detail field Booking Text accordingly.

Workflow

JustOn generates booking details for balances of the following types: Payment, Refund, Prepayment, Payout, Write-off, Dunning Fee, Dunning Income, Chargeback. All other balance types are ignored.

Since payment balances are subject to change, like amount modification, deletion or splitting, JustOn does not track payment balances and booking details in a one-to-one relationship, but uses a payment hash instead. The following Balance fields are used to compute the hash: Account, Date, Payment Method, Payment Provider, Reference, Transaction No and Type. This means, all balances where these fields have the same value are aggregated to the same booking detail.

JustOn uses the Booking Detail field Balance to link back to the first balance. This does not guarantee, however, its accuracy in case of a balance split or recombination. Use this field for information or navigation purposes only.

The bookkeeping data creation does not update existing payment booking details. JustOn always creates a new booking detail record to track an individual payment balance change.

JustOn tracks amount modifications to existing balances as new booking details with a new amount. That is, a change by a delta of 5,00 EUR results in a new booking detail with an amount of 5,00 EUR.

Deleted balances are written off: JustOn creates a new booking detail, reverting the amount, like Amount * (-1).

Note

JustOn generates booking details for balances that have been created or modified in the past eight days. This is why the payment bookkeeping data job must run at least once per week – otherwise it does not detect all new, changed or deleted balances.

Assigning Bookkeeping Accounts

With booking details created from payment balances, the field G/L Account Number specifies the bookkeeping account number of the bank account or payment provider.

The field Business Partner Account Number specifies the debtor number of the related account. The field is filled upon booking detail generation if the custom Account field ON_DebtorNo has beed configured and set accordingly.

You can use the collective accounts feature to provide both the G/L account and business partner account for the bookkeeping data creation.

Handling Provider Fees

Provider fees are tracked on the balance using the field Provider Fee. Some payment provider integrations may also define the custom formula field ON_ProviderFee for calculating the provider fees. If the field is not available or empty, JustOn uses the standard Provider Fee field.

If JustOn detects a provider fee when generating the bookkeeping data, it will create an individual booking detail of the type Provider Fee. You can move these booking details to separate bookkeeping accounts using the collective accounts feature.

Handling Business Entities

If a balance is associated with an invoice, JustOn takes the business entity of the invoice to determine the correct booking period. If a balance is unassigned, the business entity is determined from the customer account using a business entity mapping.

Correction booking details, like for an amount modification or a deletion, always use the business entity of the original booking detail.

Handling Balance Transfer

Users can manually transfer balances that represent payment transactions (Payment, Refund, Prepayment, Payout, Chargeback and Chargeback Fee) from one account to another. If the creation of bookkeeping data is enabled and at least one booking detail exists for the moved balance, JustOn will update the bookkeeping data accordingly.

  • By default, it creates two new payment booking details: one for the new debtor booking account and a "reverse" one for the old debtor booking account (using the bank booking account as a "relay" account).
  • If required by your accounting system, JustOn can bypass this two-step move using a booking detail of the type Transfer. Doing so directly transfers the balance amount from the old debtor to the new debtor without involving the bank. To this end, you enable the global setting Enable Transfer Booking Details.

Payment Booking Details Examples

The following examples show how JustOn writes booking details for payment balances and tracks further changes on involved balances.

Receiving PayPal payment with provider fee

Assume the following actions:

  • Customer pays via the payment page with PayPal
  • Payment balance is created and assigned to the account and invoice
  • Invoice is set Paid
  • Booking detail is created from payment balance

This produces two booking details with the following information:

Field Example Value Description
Name 2019-01-15-12345 Concatenation of payment date and debtor number (with fallback to the account name).
Amount -100 Taken from the Balance field Amount.
Payment Date 2019-01-15 The date of the payment transaction.
Booking Date 2019-01-15 The booking date may be different from the payment date if the target booking period is closed and the booking detail has been moved.
Payment Hash abc123 Calculated by JustOn in order to track changes on involved balances.
Type Payment Taken from the Balance field Type.
Balance - Links to the associated balance.
Account No 12345 The G/L account, taken from the Account field ON_DebtorNo, can be set by collective account rules if it is empty or not available.
Business Partner Account No 67890 The contra account, set by collective account rules.
Field Example Value Description
Name 2019-01-15-76543 Concatenation of payment date and G/L account number (with fallback to the account name).
Amount 2,75 Taken from the Balance fields ON_ProviderFee or Provider Fee.
Payment Date 2019-01-15 The date of the payment transaction.
Booking Date 2019-01-15 The booking date may be different from the payment date if the target booking period is closed and the booking detail has been moved.
Payment Hash xyz987 Calculated by JustOn in order to track changes on involved balances.
Type Provider Fee Set by JustOn.
Balance - Links to the associated balance.
Account No 34567 Set by collective account rules.
Business Partner Account No 98765 Set by collective account rules.
Importing payment entries from finleap connect with manual assignment

Assume the following actions:

  • Import payment entries from finleap connect, match to account
  • Manually assign balance to the next open invoice

The bookkeeping data can be generated before or after the invoice assignment. The result is the same.

Field Example Value Description
Name 2019-01-15-12345 Concatenation of payment date and debtor number (with fallback to the account name).
Amount -75 Taken from the Balance field Amount.
Payment Date 2019-01-15 The date of the payment transaction.
Booking Date 2019-01-15 The booking date may be different from the payment date if the target booking period is closed and the booking detail has been moved.
Payment Hash def567 Calculated by JustOn in order to track changes on involved balances.
Type Payment Taken from the Balance field Type.
Balance - Links to the associated balance.
Account No 12345 The G/L account, taken from the Account field ON_DebtorNo, can be set by collective account rules if it is empty or not available.
Business Partner Account No 67890 The contra account, set by collective account rules.
Manual balance with amount change, debtor number not available

Assume the following actions:

  • Register partial payment on invoice
  • Generate bookkeeping data
  • Change amount of partial payment
  • Generate bookkeeping data

The first booking detail creation:

Field Example Value Description
Name 2019-01-15-Foo Inc. Concatenation of payment date and fallback to the account name (no debtor number available).
Amount -35 Taken from the Balance field Amount.
Payment Date 2019-01-15 The date of the payment transaction.
Booking Date 2019-01-15 The booking date may be different from the payment date if the target booking period is closed and the booking detail has been moved.
Payment Hash asd84578 Calculated by JustOn in order to track changes on involved balances.
Type Payment Taken from the Balance field Type.
Balance - Links to the associated balance.
Account No 1111 Set by collective account rules.
Business Partner Account No 2222 Set by collective account rules.

From the second bookkeeping data creation results a booking detail that covers the amount change:

Field Example Value Description
Name 2019-01-15-Foo Inc. Concatenation of payment date and fallback to the account name (no debtor number available).
Amount 5 Calculated as follows: new amount minus original amount (like -30 - (-35) = 5).
Payment Date 2019-01-15 The date of the payment transaction.
Booking Date 2019-02-01 Moved to the next booking period, since the original booking period has been closed.
Payment Hash asd84578 The same hash as for the original booking detail.
Type Payment Taken from the Balance field Type.
Balance - Links to the associated balance.
Account No 1111 Set by collective account rules.
Business Partner Account No 2222 Set by collective account rules.
Manual balance with deletion

Assume the following actions:

  • Register partial payment on invoice
  • Generate bookkeeping data
  • Delete partial payment
  • Generate bookkeeping data

The first booking detail creation:

Field Example Value Description
Name 2019-01-15-Foo Inc. Concatenation of payment date and fallback to the account name (no debtor number available).
Amount -35 Taken from the Balance field Amount.
Payment Date 2019-01-15 The date of the payment transaction.
Booking Date 2019-01-15 The booking date may be different from the payment date if the target booking period is closed and the booking detail has been moved.
Payment Hash klm654 Calculated by JustOn in order to track changes on involved balances.
Type Payment Taken from the Balance field Type.
Balance - Links to the associated balance.
Account No 1111 Set by collective account rules.
Business Partner Account No 2222 Set by collective account rules.

From the second bookkeeping data creation results a booking detail that covers the balance deletion:

Field Example Value Description
Name 2019-01-15-Foo Inc. Concatenation of payment date and fallback to the account name (no debtor number available).
Amount 35 Calculated as follows: original amount multiplied by -1 (like -35 * (-1) = 35).
Payment Date 2019-01-15 The date of the payment transaction.
Booking Date 2019-02-01 Moved to the next booking period, since the original booking period has been closed.
Payment Hash klm654 The same hash as for the original booking detail.
Type Payment Taken from the Balance field Type.
Balance - Links to the associated balance.
Account No 2222 The original business partner account number.
Business Partner Account No 1111 The original G/L account number.
Payment balance transfer
  • Debtor no for account A: 123
  • Debtor no for account B: 456
  • Account no for the bank: 4711

JustOn creates the following booking detail after a balance with an amount of -1000 has been initially created for account A:

Type Account Amount BP Account No G/L Account
Payment A -1000 123 4711

After manually transferring the balance to account B, the resulting booking details will be:

Type Account Amount BP Account No G/L Account
Payment A +1000 123 4711
Payment B -1000 456 4711

4711 is used as an intermediary account.

Now you enable the global setting Enable Transfer Booking Details: Using a transfer booking detail will directly transfer the balance amount from 123 to 456 without relaying it via 4711:

Type Account Amount BP Account No G/L Account
Transfer B -1000 456 123