WEBSTATION COMPUTER CENTRE

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

Example: Import from Stock Item

Example:

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

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