You are here: Help Topics > Engagement Management > File Preparation > DATEV
-- How Do I? --

Importing from DATEV

Working Papers imports the full trial balance from a DATEV file, while the general ledger detail is not imported.

File Containing...
DatevexportKMVZ.txt Balance records
DatevexportKTSKI.txt Account Name records
DatevexportMADMPD.txt Company information
SKR*.csv Trial balance file from DATEV
  • If Protection is activated, the File permission "Import" is required to perform this operation.
  1. Open the client file in which you want to import.

  2. On the Engagement tab, in the Data group, click Import | Accounting Software.

  3. In the Import From field, select DATEV and in the Version field, select the default version 5.6/5.61 and later.
  4. In the Import Path field, type or select the exact path to the DATEV data file or use Browse to locate the file manually.

    The Trial Balance (Opening Entries) will be imported.

  5. To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.

  6. In the SKR file path box, type or select the exact path to the SKR data file or use Browse to locate the file manually.

    Note: The SKR file must include the Balance sheet/Income column. If you have more than one SKR file, select the appropriate SKR file using this drop-down menu.

  7. If applicable, select the Import account 10000 and above option.
  8. Indicate the Period date sequence as either:

    • Yearly - If you import as a yearly file, you will see a total of 12 months in Working Papers
    • Quarterly
    • Monthly - If you import as monthly, you will see 12 period balances for every month.
  9. Click OK to begin importing.

Accounting data is imported into the client file.

Related Topics