HADABPOS Free trial
Lesson · Reports, accounting and tax

Import customers and suppliers from Excel

Moving from another program. on Customers or Suppliers press «Import»: Download the template or upload…

HADAB POS › Learning center › HADAB course for companies and accountants › Import customers and suppliers from Excel

Last updated: needs the Accounting plan

https://hadabpos.com/lesson-parties_import-en.html

(moving from another program): on Customers or Suppliers press «Import»:

  1. 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.
  2. Columns: name (required), phone, email, VAT number, ID and credit limit for customers, plus balance and balance date.
  3. Existing parties are matched by VAT number, then phone, then name and updated, never duplicated.
  4. 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.

Applies to these systems

Related lessons

HADAB course for companies and accountants · Learning center · Glossary

هذه الصفحة بالعربي · یہ صفحہ اردو میں · Bu sayfa Türkçe

Ready to start?

Message us on WhatsApp and we will help you install and link with Fatoora.

+966 56 173 9500  ·  +966 50 062 6563

WhatsApp Free trial