Open accruals Excel-import format in Controlling

Owned by Hauke Gulich
Last updated: Apr 11, 2024 by Sabrina Stelter
2 min read

Contents

Related pages

image2021-1-19_13-15-58-20240411-112552.png

Column split

(if cost splitting = J)

Column split

(if cost splitting = J)

Split

SPLIT is set, if cost splitting takes place upon entering the accruals.
→ It is splitted to the positions when importing the file.

Example

List of all open accruals for a service provider– in this case a carrier, transport company – for a specific month in order to book a monthly invoice/collective invoice.

Press F3 → The search result will be displayed as a report (8 columns).

image2021-1-19_13-21-32-20240411-112609.png

You can now export this result to Excel (xls, not xlsx) or as a csv-file in order to load it or possibly edit it in advance.

Side note: Loading the Excel file into a collective incoming invoice

In order to follow the path of these work steps, the previously created Excel file is now used in CargoSoft to create a collective incoming invoice of an invoicing party.

For this, please open the accruals from the list and compare them to the individual files of the payable.

  • The individual amounts are distributed to the sub-files/consol files.

  • Accruals are booked against them.

  • The conformity indicator is automatically set to U in each line.

→ The invoice can now be saved and booked.