Standard Yuki bank import format

Modified on Wed, 10 Jun at 3:58 PM

Don’t have an original bank export file to import your 'historical' transactions? In that case, you can use the standard Yuki bank import format. You can easily create this file yourself in Excel and save it as a CSV file.

Example file

At the bottom of this article, you will find an example of the Yuki bank import format attached,

ATTENTION!

This standard Yuki bank import format is not suitable for importing transactions from online payment providers (such as Mollie, PayPal, etc.)

Import file column specifications

The first row of your file must contain the exact column headers listed below. Fill in the columns according to these guidelines:

Column header (copy exactly)	Required?	Guidelines / Format
IBAN	Yes	The bank account or credit card number. A shortened account number is also acceptable. ATTENTION! Remove all periods, hyphens, spaces, etc.
Valuta	Yes	The account currency (e.g., EUR for euros, USD for U.S. dollars)
Afschrift	No	The statement number. May be left blank. The statement number is displayed if known.
Datum	Yes	The transaction date. Format: dd-mm-yyyy
Rentedatum	Yes	The date on which the transaction accrued interest. If unknown, set this equal to the ‘Date’. Cannot be left blank. Format: dd-mm-yyyy
Tegenrekening	No	The counterparty’s account number. Facilitates automatic recognition but may also be left blank.
Naam tegenrekening	No	The counterparty’s name. Facilitates automatic recognition but may also be left blank.
Omschrijving	No	Free text. Enter invoice numbers, payment references, or names here if known for better recognition.
Bedrag	Yes	The transaction amount in the account’s currency. Positive is AF (e.g., 150.00), negative is BIJ (e.g., -45.50). Use a comma as the decimal separator and do not use thousand separators.

Save and submit import file

To successfully import the file into Yuki, it must meet the following requirements:

Correct column headers: Ensure that the column headers in row 1 exactly match the bolded names in the table above.
File type: Save the Excel file as a Comma-Separated Values (.CSV) file.
Delimiter: The columns in the CSV file must be separated by a semicolon (;).

TIP!

This specific CSV format can also be used by Yuki for manually importing journal entries, cash books, or miscellaneous entries.

Attachments (1)

csv

YUKI - Basisbestand CSV - Import Elektronisch bankafschrift 06092016.csv
1.62 KB