Skip to main content

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 TypeDescription
Employee MasterBasic demographics, Works Info (Department, Paypoint), and Tax details.
Current TransactionsTransaction code amounts for the current open period.
History TransactionsHistorical transaction amounts. Can be imported in Summary form (totals in one period) or Detail form (individual amounts per historical period).
Employee Bank DetailsBank Sort Code (must be formatted as Text) and Account Number.
Employee Next of KinEmergency contact details for the employee.
Employee GL CodesSpecific General Ledger mapping applied directly to the individual employee.
Employee PensionsPension fund membership and contribution details.
Employee Medical Aid MembersMedical aid scheme details and membership numbers.
Employee Pay RatesCustom rates of pay assigned directly to the employee master file.
Employee TIN UpdateImporting new employee Tax Identification Numbers
System & Organizational Setup Imports

Column A must usually be the specific Code, followed by the Description.

Import TypeDescription
Transaction Codes GL CodesSystem transaction codes (Earnings, Deductions, Allowances, etc.).
DepartmentsOrganizational department codes and names.
Cost CentresCost centre tracking codes and descriptions.
Pay PointsPhysical or organizational pay point locations.
Internal GradesCustom internal job grading structures.
NEC GradesNational Employment Council grade classifications.
PositionsSpecific job titles or positions within the company.
IndustriesIndustry classification codes.
OccupationsStandardized occupation codes.
Discharge ReasonsCustom reasons for employee termination for the audit trail.
General Ledger CodesChart of accounts/GL codes for financial journal exports.
Department GL CodesGL codes mapped specifically to organizational departments.
Cost Centre GL CodesGL codes mapped specifically to cost centres.
SAP Account CodesSpecific 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.

image

  • 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.

image

  • 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'.

image

  • 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.

image

Was this page helpful?