Import from Excel

If you maintain debtor amounts in Excel, use the Import from Excel feature to copy them to day books in Isah Finance. This feature allows you to import all open items of debtors before you start using Isah Finance. The import process creates day book pages containing day book lines. For the import to be successful, the Excel file must have particular columns, column names and column types.

What are the prerequisites for the Excel file?

The Excel file (.xlsx) to be used for the import has some mandatory columns and some optional columns. All columns should have the prescribed column names and types.

Required columns:

Column name	Column content	Cell type	Remarks
DEBTOR	Debtor	Text
INVOICEREFERENCE	Invoice reference	Text
PAYMENTREFERENCE	Payment reference	Text
PAGEDESCRIPTION	Page description	Text	If the description is missing and 'Ledger' has been specified in the day book settings, the description of the ledger account is used.
INVOICEDATE	Invoice date	Date
INVOICECURRENCYCODE	Invoice currency	Text	If the currency is missing, the currency of the ledger account is used.
LINECURRENCYAMOUNT	Currency amount of the line	Number
LINEACCOUNT	Line account	Text

Optional columns:

Column name	Column content	Cell type	Remarks
PAGECOSTCENTERCODE	Cost center of page	Text	The column is required if it has been set as required for the ledger account.
PAYMENTTERM	Payment period	Text
PAYMENTTERMDAYS	Payment period in days	Number
INVOICEDUEDATE	Invoice due date	Date
PAYMENTCONDITIONDISCOUNTDAYS	Discount period payment condition	Number
INVOICEDISCOUNTDUEDATE	Invoice discount expiry date	Date
INVOICEDISCOUNTPERC	Invoice discount %	Number
LINEDESCRIPTION	Line description	Text	If the description is missing and 'Ledger' has been specified in the day book settings, the description of the ledger account is used.
LINECOSTCENTERCODE	Cost center of the line	Text	The column is required if it has been set as required for the ledger account.
LINECOSTCATEGORYCODE	Cost category of the line	Text
LINEVATFINCODE	Financial VAT code of the line	Text	The column is required if it has been set as required for the ledger account.
LINECURRENCYVATAMOUNT	VAT currency amount of the line	Text

Example of Excel file:

DEBTOR	INVOICEREFERENCE	PAGEDESCRIPTION	PAYMENTREFERENCE	INVOICEDATE	INVOICECURRENCYCODE	LINECURRENCYAMOUNT	LINEACCOUNT	LINEDESCRIPTION
10002	2017-257	Page1	36200-2017459	5/18/2017	EUR	1500.00	4350	Month of April
10002	2017-257	Page1	36200-2017459	5/18/2017	EUR	850.00	4350	Month of May
10009	20178540	Cleaning factory	455-878	5/19/2017	EUR	1145.44	4350	Month of May

Import

To import from Excel, follow these steps:

Select the day book from which you want to copy the ledger account amounts.
Click the Import from Excel button. The wizard starts.
Select the Excel file you want to import. If you decide to continue, the data in the Excel file are verified.
Take a look at the data of the Excel file and correct them where necessary. The corrections are also implemented in the Excel file. If you decide to continue, you will see what the imported data will look like.
Check the import preview. To change any data, go back to the previous step to make your changes.
Complete the import.

Result

Once the import has finished, a day book page has been created for every debtor/sales invoice/reference number combination in the Excel file. Any lines in the Excel file with matching debtors, sales invoices and reference numbers are merged into one line on the day book page. Every line that has a unique combination will have its own line on the day book page.