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 Import | Location |
|---|---|
| Employee master records | Utilities → Imports → Excel → Employee Master |
| Bank details | Utilities → Imports → Excel → Employee Bank Details |
| Pay rates | Utilities → Imports → Excel → Employee Pay Rates |
| Medical aid members | Utilities → Imports → Excel → Employee Medical Aid Members |
| Next of kin | Utilities → Imports → Excel → Employee Next of Kin |
Payroll Data Imports
| What to Import | Location |
|---|---|
| Current period transactions | Utilities → Imports → Excel → Current Transactions |
| History transactions | Utilities → Imports → Excel → History Transactions |
| Leave opening balances | Utilities → Imports → Leave → Leave Transactions |
Reference Data Imports
| What to Import | Location |
|---|---|
| Cost centres | Utilities → Imports → Excel → Cost Centres |
| Departments | Utilities → Imports → Excel → Departments |
| Banks | Utilities → Imports → Excel → Banks |
| GL codes | Utilities → Imports → Excel → General Ledger Codes |
| NEC grades | Utilities → Imports → Excel → NEC Grades |
| Industries | Utilities → Imports → Excel → Industries |
| Occupations | Utilities → Imports → Excel → Occupations |
| Discharge reasons | Utilities → Imports → Excel → Discharge Reasons |
Import Process
The import process is the same for all Excel imports:
- Navigate to the import menu option
- Click the ellipsis [...] button to browse for the Excel file

- Map the spreadsheet columns to the Belina fields if prompted
- Click Next to validate the data
- Review errors or warnings

- Click Import to post
Exports
Exports are accessed from Utilities → Exports and View (for reports that can be exported).
Payment Exports
| Export | Location |
|---|---|
| EDI Bank Transfer | Utilities → Exports → EDI Bank Transfer |
| EcoCash | Utilities → Exports → EcoCash |
| Third-party payments | Utilities → Exports → Third-Party Payments |
Accounting Exports
| Export | Location |
|---|---|
| Pastel | Utilities → Exports → Pastel Partner Export |
| AccPac / Sage 300 | Utilities → Exports → AccPac Export |
| General GL Journal | Utilities → Exports → GL Journal |
Statutory Exports
| Export | Location |
|---|---|
| TaRMS | Utilities → Exports → TaRMS |
| NSSA | Utilities → Exports → NSSA |
| NEC | Utilities → 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

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.
Related Pages
Was this page helpful?