Import By Excel Template – AutoCount

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.

Steps On How To Use Import From Excel Template In AutoCount

Import From Excel


Example: Import from Stock Item

Import From Excel


Example:

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

Import From Excel

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


AutoCount Accounting Excel Templates Download

A/P
A/P Credit Note Click here
A/P Debit Note Click here
A/P Invoice Click here
A/P Payment Click here
A/R
A/R Credit Note Click here
A/R Debit Note Click here
A/R Invoice Click here
A/R Payment Click here
Stock
Stock Item Click here
Price Book Click here
Price Book Rule Click here
Item Price by Location Click here
Stock Open Balance Click here
G/L
CashBook Click here
Journal Entry Click here
Budget Click here
Sales
Last Year Price History Click here
Options
Debtor Click here
Creditor Click here
Member Click here
Others
Branch Click here