4. Hoàn tất các thiết lập chung

First, we need to define journal types. All necessary journal types are listed in column E of the DATAVIEW sheet.

• Set up Journal Definition:

Let’s generate an Excel import template for journal types. Go to Lập Báo Cáo > Nhu Liệu, click + to add the dataset name IJNL, select lajournaldefinitions table, save, run and download it. Then fill it up with the journal types data.

There are 15 different journal types in the SmartPro sample dataset. For your convenience here is the link to download the completed journal definitions: IJNL - SmartPro

Go to Kế Toán Sổ Cái > Lập Nghiệp Vụ > Loại Nghiệp Vụ and import it. Don’t forget to adjust the data named range.

Second, we need to create a chart of accounts for this sample data. All necessary account codes are listed in the column L of the DATAVIEW sheet.

• Set up Chart Of Accounts - COA:

Let’s generate an Excel import template for a chart of accounts. You can refer to session IV.1 for more details. Otherwise, go to Lập Báo Cáo > Nhu Liệu, click + to add the dataset name ICOA. Select the lachartaccounts table, save, run and download it. Then fill it up with the chart of accounts data.

To fill the ICOA template, the easiest way is to download the complete sample of Chart of Accounts for Vietnam Accounting System at COA - VAS, then remove unused accounts.

For your convenience here is the link to download the completed chart of accounts: ICOA - SmartPro

Go to Kế Toán Sổ Cái > Tài Khoản and import it. Don’t forget to adjust the data named range.

Third, follow the steps in the previous session Ledger & Currency to set up a currency VND and USD for this sample data. Last but not least, we would need to set up analysis codes, journal presets, customers, suppliers, banks… to generate powerful management reports. But it is not required by now. We would do it when preparing reports.

Import data

Now, go to Kế Toán Sổ Cái > Journal Import, preview your data again and click on the import button.

That’s it.

Now let’s go create desired reports.