User Guide‎ > ‎

How to import Cost Centre from Excel?

Create an Excel Spreadsheet with the following fields at the Row 1:


[COST_CENTRE]
[AUTHORIZED]
[DESCRIPTION]
[REMARKS]
[AUTOPAY_BANK_ACCOUNT]
[CHEQUE_BANK_ACCOUNT]
[SALARY_ACCOUNT]
[OT_ACCOUNT]
[ALLOWANCE_ACCOUNT]
[DOUBLE_PAY_ACCOUNT]
[BONUS_ACCOUNT]
[NOPAY_ACCOUNT]
[PAY_TYPE1_ACCOUNT]
[PAY_TYPE2_ACCOUNT]
[PAY_TYPE3_ACCOUNT]
[PAY_TYPE4_ACCOUNT]
[PAY_TYPE5_ACCOUNT]
[PAY_TYPE6_ACCOUNT]
[PAY_TYPE7_ACCOUNT]
[PAY_TYPE8_ACCOUNT]
[PAY_TYPE9_ACCOUNT]

To get the full list of fields of Cost Centre of your version in Excel, press the Export button from Payroll Cost Centre to export a full list of fields that match your version.

See also: