WEBSTATION COMPUTER CENTRE

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
**<WRAP centeralign><fs 1.8em><color #0065cd> Import By Excel Template – AutoCount </color></fs></WRAP>**

----

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.

**<WRAP centeralign><fs 1.5em>Steps On How To Use Import From Excel Template In AutoCount</fs></WRAP>**

{{:home:knowledge_base:webstation:software:autocount_accounting:import_from_excel_1.png?direct 750 |Import From Excel}} 

<WRAP clear/> \\

Example: Import from Stock Item 

{{:home:knowledge_base:webstation:software:autocount_accounting:import_from_excel_2.png?direct 750 |Import From Excel}} 

<WRAP clear/> \\ 

Example: \\ 

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

{{:home:knowledge_base:webstation:software:autocount_accounting:import_from_excel_3.png?direct 750 |Import From Excel}} \\ \\ 

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

<WRAP clear/> \\ 

----

**<WRAP centeralign><color #0065cd><fs 1.5em>AutoCount Accounting Excel Templates Download</fs></color></WRAP>**

<dokuteaser>

|< 100% 50% >|
|  @#73B1FC:**A/P**                                                                                                                   ||
^ A/P Credit Note    | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_ap_credit_note.xls|Click here]]**  |
^ A/P Debit Note     | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_ap_debit_note.xls|Click here]]**   |
^ A/P Invoice        | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_ap_invoice.xls|Click here]]**      |
^ A/P Payment        | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_ap_payment.xls|Click here]]**      |
</dokuteaser>


<dokuteaser>
|< 100% 50% >|
|   @#73B1FC:**A/R**   ||
^ A/R Credit Note     | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_ar_credit_note.xls|Click here]]**  |
^ A/R Debit Note      | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_ar_debit_note.xls|Click here]]**   |
^ A/R Invoice         | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_ar_invoice.xls|Click here]]**      |
^ A/R Payment         | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_ar_payment.xls|Click here]]**      |

</dokuteaser>

<dokuteaser>
|< 100% 50% >|
|   @#73B1FC:**Stock**   ||
^ Stock Item                 | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_stock_item.xls|Click here]]**              |
^ Price Book                 | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_price_book.xls|Click here]]**              |
^ Price Book Rule            | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_price_book_rule.xls|Click here]]**         |
^ Item Price by Location     | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_item_price_by_location.xlsx|Click here]]** | 
^ Stock Open Balance         | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_stock_open_balance.xls|Click here]]**          |
</dokuteaser>


<dokuteaser>
|< 100% 50% >|
|   @#73B1FC:**G/L**   ||
^ CashBook           | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_cashbook.xls|Click here]]**      |
^ Journal Entry      | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_journal_entry.xls|Click here]]** |
^ Budget             | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_budget.xls|Click here]]**        |

|< 100% 50% >|
|   @#73B1FC:**Sales**   ||
^ Last Year Price History      | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_last_year_price_history.xls|Click here]]** |

</dokuteaser>


<dokuteaser>
|< 100% 50% >|
|   @#73B1FC:**Options**   ||
^ Debtor       | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_debtor.xls|Click here]]**    |
^ Creditor     | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_creditor.xls|Click here]]**  |
^ Member       | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_member.xls|Click here]]**    |
</dokuteaser>

<dokuteaser>
|< 100% 50% >|
|   @#73B1FC:**Others**   ||
^ Branch      | **[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?20|width:10em; color:green}}home:knowledge_base:webstation:software:autocount_accounting:import_branch.xls|Click here]]**   |
</dokuteaser>