Import from Excel

If you maintain ledger account amounts in Excel, use the Import from Excel feature to copy them to day books in Isah Finance. This allows you to include your opening balance or wage journal items in 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
ACCOUNT	Ledger account	Text
TRANSACTIONDATE	Transaction date	Date
CURRENCYAMOUNT	Currency amount	Number
DESCRIPTION	Ledger account 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.

Optional columns:

Column name	Column content	Cell type	Remarks
CURRENCYCODE	Currency	Text	If the currency is missing, the currency of the ledger account is used.
COSTCENTERCODE	Cost center	Text	The column is required if it has been set as required for the ledger account.
COSTCATEGORYCODE	Cost category	Text
VATFINCODE	Financial VAT code	Text	The column is required if it has been set as required for the ledger account.
CURRENCYVATAMOUNT	VAT currency amount	Text

Example of Excel file:

ACCOUNT	DESCRIPTION	TRANSACTIONDATE	CURRENCYAMOUNT
0100	Buildings	1/1/2017	250000.00
0500	Equity	1/1/2017	-100000.00
0300	Machines start	1/1/2017	50000.00
2031	Temporary loan	1/1/2017	-200000.00

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 the Excel file. Each row in the Excel file has been converted to a line on the day book page.