Import CSV files containing transactions

CSV files that contain transactions can be processed efficiently in Yuki. This can be done by using a CSV file (for example an Excel file that is saved as a CSV file (separated by a list separator).

Only a user with a 'Back office' role in the domain or the 'External accountant' rol can import CSV files that contain transactions.

CSV files containing transactions can be imported from different places in Yuki:

• Hover your mouse over the Financials icon in the navigation bar and then click on Import
• Click on the Back office icon in the navigation bar and then, in the now-opened screen, click on Import.

You can upload the following CSV files in Yuki:

• Opening balance
• Bank statements
• Cash flow statement
• General journal entry:
  • payroll journal entry
  • depreciations
  • outstanding debtors and creditors
  • assets.
• Various accounting entries.

Yuki provides a standard file (containing columns) which you can supplement with your own data. It is important that you copy the data literally as described in the file. You will find all the necessary information in the following examples of CSV files:

• Beginbalans CSV-basisbestand (CSV base file - Opening balance)
• Elektronisch bankafschrift CSV-basisbestand (CSV base file - Electronic bank statement)
• Kasstaat CSV-basisbestand (CSV base file - Cash flow statement)
• Openstaande klanten en leveranciers CSV-basisbestand (CSV base file - Outstanding debtors and creditors)
• Activa CSV-basisbestand (CSV base file - Assets).

These files are attached to this article.

ATTENTION!

The data (and columns) in the CSV file has to be separated by a ';' (semicolon).

The 'Projectcode' and 'Projectnummer' columns can be optionally included in a CSV file. As a result the data will be assigned automatically to the relevant project. These columns CANNOT be included in a CSV file that contains a bank statement.