Payroll Bank Transfer Excel
by Concept Solutions Oman https://github.com/concept-solutions-oman/payroll_bank_transfer| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Employee Contracts (hr_contract)
• Time Off (hr_holidays) • Employees (hr) • Discuss (mail) • Calendar (calendar) |
| Community Apps Dependencies | Show |
| Lines of code | 3294 |
| Technical Name |
payroll_bank_transfer |
| License | LGPL-3 |
| Website | https://github.com/concept-solutions-oman/payroll_bank_transfer |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Employee Contracts (hr_contract)
• Time Off (hr_holidays) • Employees (hr) • Discuss (mail) • Calendar (calendar) |
| Community Apps Dependencies | Show |
| Lines of code | 3294 |
| Technical Name |
payroll_bank_transfer |
| License | LGPL-3 |
| Website | https://github.com/concept-solutions-oman/payroll_bank_transfer |
Payroll Bank Transfer Excel
Automate and streamline your employee payout process. Generate structured, banking-compliant spreadsheets from selected payslips with absolute precision, zero hassle, and instant validation.
Powerful Integration Features
Designed for businesses operating with 3-decimal currencies and strict commercial banking requirements.
Multi-Bank Compatibility
Formats files exactly as required by corporate banking portals (such as Oman Arab Bank and other regional banks). Ready for straight-through-processing upload.
3-Decimal Precision
Built specifically for currencies like Omani Rial (OMR). Implements exact 3-decimal rounding for net salary, basic salary, extra income, deductions, and SPF.
Automated Data Sanitization
Restricts employee names to a maximum of 30 characters and automatically removes invalid special characters, ensuring your batch isn't rejected by the bank.
Deep Payroll Deductions Map
Extracts and maps basic salary, extra income (allowances/OT), general deductions, and Social Security Deductions (SPF) to respective columns.
Seamless Batch Operations
Launch directly from Odoo’s Payslips List View. Select any number of employee payslips, click action, and generate the master bank transfer file in one click.
Automatic Nationality Flag
Recognizes Omani vs. Expat employees based on country settings, facilitating compliance reporting and accurate social security classifications automatically.
Simple & Intuitive Workflow
Go from employee payslips to a bank-ready upload in just three simple steps.
Select Payslips
Go to Payroll -> Employee Payslips. Mark the checkbox for the payslips you want to pay out, click "Action", and choose "Bank Transfer Excel".
Configure Settings
Review the payer credentials (like CR-NO, Account details) and pick the payment type (e.g. Monthly Salary or Bonus).
Export & Upload
Click "Export". The module will package everything into a perfectly formatted, compliant Excel sheet ready to upload directly to your bank's portal.
Export Sheet Specifications
The system generates a standard multi-column structure formatted using openpyxl for accurate processing.
| Column Header | Field Content | Formatting / Logic |
|---|---|---|
| Employee ID Type | Constant type identifier | "C" (National/Civil Card) |
| Employee ID | Identification Card Number | From Employee Profile |
| Reference Number | Internal Employee Number | From Employee Card |
| Employee Name | Clean alphanumeric name | Sanitized & truncated to 30 characters |
| Employee BIC | Bank Identifier / Swift Code | Uppercase bank identifier |
| Employee Account | Alphanumeric Account Number | Stripped of hyphens and whitespace |
| Salary Frequency | Frequency of disbursement | "M" (Monthly) |
| Working Days | Total payable days | Derived from basic payslip line quantity |
| Net Salary | Final net amount to pay | Formatted to 3 decimals (0.000) |
| Basic Salary | Contract basic pay | Formatted to 3 decimals (0.000) |
| Extra Hours | Overtime duration | Aggregated from payslip OT worked days |
| Extra Income | All additional allowances | Formatted to 3 decimals (0.000) |
| Deductions | Salary deductions (non-SPF) | Formatted to 3 decimals (0.000) |
| Social Security Deductions | SPF Contribution | Formatted to 3 decimals (0.000) |
| Notes / Comments | Automated transfer note | e.g. "Jan 2026 Salary" |
| Nationality | Citizen vs. Expat flag | "OMAN" or "EXPAT" |
| Division | Department classification | From Employee Department name |
Technical Summary
- App Version 17.0.1.0.0
- Framework Version Odoo 17.0 (LTS)
- License LGPL-3
- Author Odoo Addons Developer
Module Dependencies
- hr_payroll_community Required
- salary_structure_custom Required
- python: openpyxl Required
- Auto-Installable No
Please log in to comment on this module