A2.131 : Excel Import Templates
Question :
Where can I get Excel import templates?
Solution :
1. From AutoCount Setup CD/DVD > Accounting > Technical Documents > Import Excel Templates
2. Some POS Import templates can be fuond at AutoCount Setup CD/DVD > POS
POS Voucher Template:
https://wiki.autocountsoft.com/wiki/Pos3/Pos5/FNB:_How_to_import_voucher_no_to_Pos_Backend%3F
--Source from AutoCount Wiki --
Related Articles
A3.146 : Employee - How to upload employee information using Excel import?
Question : How to upload employee information using Excel import? Answer : 1. Download the employee Excel file template. Go to Tools > Options > Excel Import> Templates > Employee. 2. Fill up the necessary information. Notes:Red shaded header means ...A3.101 : How to auto calculate daily rate worker’s salary USING time attendance excel import?
Question : How to auto calculate daily-rated employee’s salary USING time attendance Excel import? Answer : *Make sure that in the affected employee profile, Wages Type and Basic Rate are properly defined. 1) Go to Payroll > Payroll Management > Time ...A3.61 : Leave : How to maintain Carry Forward Leave using Excel template
Question : Employee 001 has 5 days leave balance in Year 2019 and want to bring forward to Year 2020. How can I maintain the carry forward leave for employee? Answer : 1) Go to Tools >Options > Excel Import 2) In the Excel Import, click on Templates, ...A3.139 : How to auto calculate daily rate worker’s salary WITHOUT USING time attendance excel import?
Question : How to auto calculate daily-rated employee’s salary WITHOUT USING time attendance Excel import? Answer : *First, set calendar for daily rated employee 1) Go to Tools > General Maintenance > Calendar > Add New as in Figure 1. Figure 1 2) ...A3.147 : How to upload Year-to-Date payroll transaction?
Question : How to upload Year-to-Date payroll transaction? If you start using AutoCount Cloud Payroll in middle of the year, you are required to import the previous months payroll transaction data via Excel import, this is important for the system to ...