AR: How to import debtor/creditor via Excel with 2 different control account numbers

From AutoCount Resource Center
Jump to navigation Jump to search

Question : Let’s say I have 2 debtor control accounts 300-0000 and 301-0000. How to import debtors via Excel with 2 different control account numbers?

Version : 1.8 / 1.9 / 2.0


Answer :

1) Go to the Import Debtor Excel Template and manually add the column of DebtorControlAcc.

Debtor control1.png


2) Copy the highlighted data in Excel (including the header), go to File > Import from Excel > Import Debtor, click on Paste from Clipboard, then click on Import.

Debtor control2.png


Debtor control3.png


Remark : The system will capture the value of Debtor Control Account from Excel. If there is no such column or value in Excel template, you need to add it in as per step (1).


Debtor control4.png


By : Soh Wee 200615, Lay Swan 200618, P200619


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations