Skip to main content

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​

ScenarioBenefit
Hours worked are captured in a time-and-attendance spreadsheetImport directly without re-entering
Commission or incentive amounts are calculated externallyImport the results
Multiple transaction codes per employee, varying each periodImport a pre-prepared file

Setting Up the Spreadsheet​

The spreadsheet must follow Belina's required layout:

Spreadsheet 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​

  1. Go to Process → Spreadsheet Input

Spreadsheet input screen

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

Spreadsheet import preview

  1. Verify the data looks correct
  2. Click Post to apply all transactions to the payslips

Spreadsheet post confirmation


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​

ErrorCauseFix
Employee not foundEmployee number in spreadsheet doesn't match BelinaCheck the employee number
Invalid transaction codeTransaction code doesn't exist in BelinaCreate the code or correct the spelling
Amount format errorAmount has non-numeric charactersCheck for spaces, commas, or symbols in the amount column
Duplicate rowsSame employee and transaction code appear twiceRemove duplicates or use Update mode

Was this page helpful?