The data is accepted in mm/dd/yyyy format.

The columns highlighted with Orange color in the template are mandatory fields.

Excel file (.xls) is supported

Ref # is the important and mandatory field while importing transactions, and it is not editable on the import screen as Xenett Port groups the transactions by Reference Number.

In the case of Qty and Rate, make sure the value of Amount is equal to Qty*Rate.

If the Item name has value, then the Qty is the mandatory field.

If the Billable is marked as yes, then Customer/Job is mandatory.

To add the transaction with multiple line items, you need to add the same Ref # in the next line. Here, in the second line, you can skip adding the details in the transaction level fields such as Date, Name, Location if already added in the first line.

In the case of Journal entries, the total of Negative and Positive amounts should remain zero.

In Journal entries, if you are adding Accounts Payable or Accounts Receivable then you must mention the Vendor and Customer respectively under the Name column.

The due date can't be smaller than the transaction date.

The transaction should not have more than one multi-currency other than Home currency.

In case of multi-currency transactions, make sure to add an Exchange rate not equal to 1.

While importing Items:

While importing Vendors, Customers, Employees:

While importing Chart of Accounts: