> For the complete documentation index, see [llms.txt](https://support.ordereazi.com/central/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.ordereazi.com/central/order-management/suppliers/import-suppliers/filling-in-the-supplier-import-sheet.md).

# Filling in the Supplier Import Sheet

The supplier import template has a column for each detail of a supplier, with a hint under each heading. This page explains what to put in each one. Keep the headings exactly as they are, or OrderEazi refuses the file.

### The required columns

Fill these in on every row:

* **CompanyName:** The supplier's name.
* **PaymentDueDate:** The number of days you have to pay them, such as 30.
* **PaymentDueDateType:** How the days are counted. Copy it from the Payment\_Types\_Lookup sheet, for example DaysFromDateOfInvoice.
* **ContactName:** Your main contact at the supplier.
* **ContactEmail:** Their email address.

### The other columns

| Column                     | What to enter                                                                   |
| -------------------------- | ------------------------------------------------------------------------------- |
| Category                   | A category from the Categories\_Lookup sheet                                    |
| Active                     | true for an active supplier, false for an inactive one                          |
| VatReference               | The supplier's VAT number                                                       |
| Balance                    | What you currently owe them                                                     |
| TaxType                    | A tax type from the TaxTypes\_Lookup sheet. Leave it empty for No VAT           |
| Currency                   | The currency they bill in, such as ZAR or USD                                   |
| OfficeNumber, MobileNumber | Your contact's phone numbers                                                    |
| Postal ...                 | The postal address: building, street, suburb, city, province, country, and code |
| Shipping ...               | The physical address, in the same parts                                         |

**Example:** A row with CompanyName "Cape Chairs", PaymentDueDate 30, PaymentDueDateType DaysFromDateOfInvoice, ContactName "Sipho Dlamini", ContactEmail <sipho@capechairs.co.za>, and Currency ZAR adds Cape Chairs on 30-day terms, billing in rand.

### Related pages

* [Import Suppliers](/central/order-management/suppliers/import-suppliers.md): upload the finished file
* [Editing a supplier](/central/order-management/suppliers/editing-a-supplier.md): what each field does on the supplier screen