Posting preparation and application of entries in workbook lines

Posting preparation

In the Workbook Line, the fields Bal. Account Type and Bal. Account No. are available, in which you can select values, just like in a standard General Journal line.

Note

In the background, the General Posting Groups and the VAT Posting Groups are included, so that VAT can also be deducted when posting against G/L accounts. Show these fields on the page if needed.

If you do not want to post the statement line against only one account, but want to distribute it to two or more accounts, open the Workbook Line Allocation function.

Workbook Line Allocation

Here you have the possibility to split the entry to different G/L account, Customer or Vendor accounts. Additionally, you can set manual application via Applies To Document No. or with a Applies To ID.

In each newly created Statement Line Allocatione, the Amount proposed is the difference amount between the Line amount from the Workbook line and the already Allocated Amount.

In the footer, you can see the Line Amount from the Workbook Line, the Allocated Amount and the Difference between them, for control purposes.

Workbook Line Allocation

Transit posting

If you run your statement via Transitkonten, then enter the corresponding Transit account as Balancing account in the Bank statement processing line. This will automatically check Use transit posting so that when the bank statement is posted, corresponding bank transit entries will be created.

Using Transit Posting

Application of entries

For the application of entries you can use the fields Applies To Document Type and Applies To Document No., in which you enter the Document type and the Document number of the document to be applied with this payment, just like in a standard Gen. Journal line.

If you want to apply several entries with a Workbook line, use the apply entries action.

Apply Entries

In the Apply Customer Entries page that then appears, you can mark several items with a Applies-to ID. Then press OK to return to Workbook. The Applies-to ID will be transferred to the field of the same name in the Workbook line.

See also

Processing bank statements

Running the automatic application