Skip to main content

Data Import & Export

Belina provides a comprehensive set of import and export tools. Imports load external data into the payroll; exports extract payroll data for accounting systems, banks, statutory bodies, and analysis.


Imports​

All imports are accessed from Utilities → Imports.

Employee Data Imports​

What to ImportLocation
Employee master recordsUtilities → Imports → Excel → Employee Master
Bank detailsUtilities → Imports → Excel → Employee Bank Details
Pay ratesUtilities → Imports → Excel → Employee Pay Rates
Medical aid membersUtilities → Imports → Excel → Employee Medical Aid Members
Next of kinUtilities → Imports → Excel → Employee Next of Kin

Payroll Data Imports​

What to ImportLocation
Current period transactionsUtilities → Imports → Excel → Current Transactions
History transactionsUtilities → Imports → Excel → History Transactions
Leave opening balancesUtilities → Imports → Leave → Leave Transactions

Reference Data Imports​

What to ImportLocation
Cost centresUtilities → Imports → Excel → Cost Centres
DepartmentsUtilities → Imports → Excel → Departments
BanksUtilities → Imports → Excel → Banks
GL codesUtilities → Imports → Excel → General Ledger Codes
NEC gradesUtilities → Imports → Excel → NEC Grades
IndustriesUtilities → Imports → Excel → Industries
OccupationsUtilities → Imports → Excel → Occupations
Discharge reasonsUtilities → Imports → Excel → Discharge Reasons

Import Process​

The import process is the same for all Excel imports:

  1. Navigate to the import menu option
  2. Click the ellipsis [...] button to browse for the Excel file

Data import screen

  1. Map the spreadsheet columns to the Belina fields if prompted
  2. Click Next to validate the data
  3. Review errors or warnings

Import warning screen

  1. Click Import to post

Exports​

Exports are accessed from Utilities → Exports and View (for reports that can be exported).

Payment Exports​

ExportLocation
EDI Bank TransferUtilities → Exports → EDI Bank Transfer
EcoCashUtilities → Exports → EcoCash
Third-party paymentsUtilities → Exports → Third-Party Payments

Accounting Exports​

ExportLocation
PastelUtilities → Exports → Pastel Partner Export
AccPac / Sage 300Utilities → Exports → AccPac Export
General GL JournalUtilities → Exports → GL Journal

Statutory Exports​

ExportLocation
TaRMSUtilities → Exports → TaRMS
NSSAUtilities → Exports → NSSA
NECUtilities → Exports → NEC

Excel Exports​

Any report previewed in Belina can be exported to Excel from the preview toolbar. You can also export:

Go to Utilities → Exports → Excel

Utilities export Excel


Import Backup Warning​

Always take a backup before importing. If the import contains errors and data is already posted, restoring the backup is the only way to undo it.

See Backup & Restore.


Was this page helpful?