(moving from another program): on Customers or Suppliers press «Import»:
- Download the template or upload your file (Excel or CSV), or paste from Excel — the first row holds the headers, matched automatically, and you can change the mapping.
- Columns: name (required), phone, email, VAT number, ID and credit limit for customers, plus balance and balance date.
- Existing parties are matched by VAT number, then phone, then name and updated, never duplicated.
- Balance (Accounting plan): what the customer owes us or what we owe the supplier on that date; a minus = an advance. It is booked as an opening balance that shows in the statement and the aging, once per party (uploading the same file again does not repeat it); a date in a locked period is refused.
- At the end you get the skipped rows with the reason (no name, invalid VAT number, already has an opening balance…). Without the Accounting plan only the names are imported.
If you get stuck on any step, ask the smart assistant inside the program.