Importing Employee Data
Importing data from an Excel spreadsheet saves time and reduces manual entry errors when migrating from another system or spreadsheet. You can import a wide variety of data into Belina Payroll, including Employee Master Details, Opening Balances, Transaction History, Bank Details, GL Codes, Medical Aid, Pensions, and organizational codes (Departments, Cost Centres, etc.). Click this link to download the sample Excel template to see how the data should be structured for various import types.
Crucial Step: We strongly advise that a backup is taken before doing any of the following import processes. This precaution ensures that the system can be quickly restored to its previous state if any mapping mistakes occur during the import.
Formatting the Excel Spreadsheet
Before importing, your data must be structured and formatted correctly to prevent errors:
- Headings: The first row of the spreadsheet must only contain column headings.
- Date Format: All date columns must be strictly formatted as dd/mm/yyyy.
- Text vs. Numeric: Financial values should be entered as numeric values. However, identifying codes (e.g., Employee Code, Cost Centre Codes, National ID, Department Code, Paypoint Code, and Bank Sort Code) must be formatted as Text in Excel.
Employee Data Imports
Column A must always be the Employee Code.
| Import Type | Description |
|---|---|
| Employee Master | Basic demographics, Works Info (Department, Paypoint), and Tax details. |
| Current Transactions | Transaction code amounts for the current open period. |
| History Transactions | Historical transaction amounts. Can be imported in Summary form (totals in one period) or Detail form (individual amounts per historical period). |
| Employee Bank Details | Bank Sort Code (must be formatted as Text) and Account Number. |
| Employee Next of Kin | Emergency contact details for the employee. |
| Employee GL Codes | Specific General Ledger mapping applied directly to the individual employee. |
| Employee Pensions | Pension fund membership and contribution details. |
| Employee Medical Aid Members | Medical aid scheme details and membership numbers. |
| Employee Pay Rates | Custom rates of pay assigned directly to the employee master file. |
| Employee TIN Update | Importing new employee Tax Identification Numbers |
System & Organizational Setup Imports
Column A must usually be the specific Code, followed by the Description.
| Import Type | Description |
|---|---|
| Transaction Codes GL Codes | System transaction codes (Earnings, Deductions, Allowances, etc.). |
| Departments | Organizational department codes and names. |
| Cost Centres | Cost centre tracking codes and descriptions. |
| Pay Points | Physical or organizational pay point locations. |
| Internal Grades | Custom internal job grading structures. |
| NEC Grades | National Employment Council grade classifications. |
| Positions | Specific job titles or positions within the company. |
| Industries | Industry classification codes. |
| Occupations | Standardized occupation codes. |
| Discharge Reasons | Custom reasons for employee termination for the audit trail. |
| General Ledger Codes | Chart of accounts/GL codes for financial journal exports. |
| Department GL Codes | GL codes mapped specifically to organizational departments. |
| Cost Centre GL Codes | GL codes mapped specifically to cost centres. |
| SAP Account Codes | Specific account mapping for SAP financial integration. |
Import Procedure
The process for importing data into the system is the same regardless of which category you are updating.
- Go to the 'Utilities', 'Imports', then 'Excel Spreadsheet' menu options.

- A warning will display advising a backup. Press 'Yes' to continue if a backup has been done.
- Use the ellipsis
...button to browse your computer and select the spreadsheet file you created.

- Press 'Open'. The system will read the file and display the raw data on the screen.
- Check that the spreadsheet data is displaying exactly as expected, then press 'Next'.

- Use the 'Target File' drop-down menu to select the specific type of data you are importing (e.g., 'Employee Master', 'History Transactions', 'Pay Points', etc).
- (For History Transactions only): Use the 'Period' drop-down to select the history period into which the data is being imported.
- Assign Codes: Link the 'Import Field' columns (your spreadsheet headers in the left panel) to the 'Target File' fields (the system fields in the right panel) by clicking the checkboxes to match them up.
- Press 'OK'.
- The system will prompt you to allow the creation of new records and/or the changing of existing records. Tick the appropriate checkboxes.
- Press 'OK' to run the import. A log file will display a list of the records that were successfully imported or flag any errors that need correction.

Was this page helpful?