Excel import

It is possible to import bookings from Excel into EZYcount. Go to Bookings -> Import Booking.

Then in Excel Import.

Excel import menu
Excel import menu

There are 4 fields :

  1. Field to select the Excel sheet to import.
  2. Button to start import.
  3. Tips for importing Excel into EZYcount
    1. Excel file set up correctly and ready for import. It is recommended to use this template.
    2. Link to the support page.
  4. List of Excel Imports already done. It is possible to delete an Excel import AND all the imported entries by deleting the import.
Excel import in EZYcount
Excel import in EZYcount

Features

Currently, only entries in CHF are accepted.

If an Excel import is deleted, all entries imported from this import are also deleted.

During an import, it is possible to have errors (in red) or warnings (in orange).
Here is a detailed list of errors and warnings.

Errors and warnings
Errors and warnings
  1. Errors
    1. The debit account does not exist in accounting. Solution: Create the account in your accounting.
    2. The credit account does not exist in accounting. Solution: Create the account in your accounting.
    3. A debit or credit account exists twice in your accounting. Solution: Change the number of one of the two accounts.
    4. Booking amount is missing. Solution: Insert an amount.
    5. An error in the VAT code field follows the following rule:
      1. If one of the two accounts accepts VAT, an active and existing VAT code is required.
      2. If both accounts do not accept VAT or if both accounts accept VAT, the VAT code field must be empty.
      3. To manage the VAT on an account, go to the following help page: https://support.ezycount.ch/version-2-0-2/work-with-vat/link-a-vat-code-with-an-account/
    6. The currency should be CHF.
    7. The date format should be DD.MM.YYYY for example, 15.09.2020
  2. Warnings
    1. The booking number is blank. EZYcount assigns the next free number in your accounting. (recommended method)
    2. The booking number already exists. EZYcount can write with the same number but we do not recommend it.

For all your questions and remarks, please write to us at support@ezycount.ch or directly on the EZYcount forum.