Transaction data can be imported into the payroll from Spreadsheet. This is done by using the Data Import facilities under the ‘Utilities’ menu. Prepare your spreadsheet with the transaction data. The Spreadsheet Layout should have the following layout:
- The first row (only) can be used for column headings if any.
- One column should contain employee code/s in the same format as that found in the payroll (including preceding zeros, if any) e.g. 001.
Information that can be imported from Excel:
-Employee master
-Current Transaction codes
-History data
-Employee GL Codes
-Multicurrency Employee Pay Rates (2 basics in a Multicurrency Environment)
-Medical Aid Membership
-etc.
For more information on how to import data, see: Excel Spreadsheet
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article