Spreadsheet Input
Spreadsheet Input allows you to import a period's transactions from an Excel file. This is the most efficient method when transaction data is already captured in a spreadsheet — for example, daily attendance records, commission calculations, or hours worked.
When to Use Spreadsheet Input
| Scenario | Benefit |
|---|---|
| Hours worked are captured in a time-and-attendance spreadsheet | Import directly without re-entering |
| Commission or incentive amounts are calculated externally | Import the results |
| Multiple transaction codes per employee, varying each period | Import a pre-prepared file |
Setting Up the Spreadsheet
The spreadsheet must follow Belina's required layout:

Required columns:
- Employee Number
- Transaction Code
- Amount (or Units/Hours depending on the transaction type)
One row per transaction per employee. If an employee has three different transactions, they appear as three rows.
Tip: Export a blank template from Belina to get the correct column structure: from the Spreadsheet Input screen, click Export Template.
Importing the Spreadsheet
- Go to Process → Spreadsheet Input

- Click the ellipsis [...] button to browse and select your Excel file
- Click Open
- The data is displayed for review

- Verify the data looks correct
- Click Post to apply all transactions to the payslips

After Importing
Once posted, the transactions appear on each employee's payslip exactly as if entered manually. You can:
- Open Payslip Input for any employee to verify or correct individual amounts
- Run the Calculation Routine as normal
Common Errors
| Error | Cause | Fix |
|---|---|---|
| Employee not found | Employee number in spreadsheet doesn't match Belina | Check the employee number |
| Invalid transaction code | Transaction code doesn't exist in Belina | Create the code or correct the spelling |
| Amount format error | Amount has non-numeric characters | Check for spaces, commas, or symbols in the amount column |
| Duplicate rows | Same employee and transaction code appear twice | Remove duplicates or use Update mode |
Related Pages
Was this page helpful?