Import From Excel

From AutoCount Resource Center
Jump to navigation Jump to search

Import From Excel

This to import data from excel template into AutoCount. Those data that can be import through excel are: Stock Item, Stock Item Price Book, Cash Book Entry, Journal Entry, AR/AP invoice, AR/AP Debit Note, AR/AP Credit Note, AR/AP Payment, Debtor/Creditor and Member. You can download the template from: or you may get in from the AutoCount Installer CD for the required format.


IFE1.png


Example: Import from Stock Item


IFE2.png


Example:

This is part of the excel template of the import stock item.


IFE3.png

The yellow colour part shows the details that need to be copy (including the header part) to paste from the clipboard.

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