You are here: SKB Home » HRMS Payroll » hrmsprocguide » How to import accounting link excel template by Department / Sub. Department

• pms
• procedureguide
• sacc
• saud
• seam
• sef
• sess
• sfar
• sgc
• shrm
• sim
• spay
  • eai
  • faq
  • howto
  • hrmsprocguide
    • Accounting links in HRMS
    • Addition of a taxable deduction
    • Addition of a taxable payment
    • Wages Relativity Adjustment Back Pay procedure
    • Annual Leave Refund/Bank Annual Leave
    • Bank Sick Leave
    • Car Benefit Adjustment in November 2025 Payroll
    • Generate Employee PRGF Flag
    • Generate Default PRGF Contribution flag for new recruits
    • HRMS Contact SICORAX Support
    • Employee CSG flag
    • Monthly MNS CSG Return
    • Monthly MRA PAYE AND CONTRIBUTION RETURN
    • How to create Country of Nationality
    • How to create Non-Working Day Calendar and add Public Holidays
    • Diaspora
    • Director Fees
    • EDF adjustment during the fiscal year
    • EDF submitted by an Expat after 183 days
    • EDF submitted employee not taxable
    • Employee desired flat rate 20%
    • End of Year Bonus
    • Estimating gratuity without generating payroll payments
    • End of Year Bonus (Leavers)
    • CSG on End Of Year Bonus
    • Fair Share Contribution
    • Fair Share Contribution with Tax Benefit
    • Fair Share Contribution with Tax Benefit
    • Finalising gratuity and generating payroll payments
    • Gratuity Module
    • Housing Benefit 10%
    • How to Add a data filter for a User report
    • How to change protected password for exports
    • How to Copy Public Holidays/ Non working days to a New Year and Modify Dates
    • How to create a Task User Report
    • How to create a User Report
    • How to create a job title
    • How to Export to Excel and Export Protect a User report
    • How to fill accounting link excel template by Department / Sub. Department
    • How to fill accounting link excel template by Department / Sub. Department
    • How to fill accounting link excel template by Employee
    • How to generate a document password for e-payslip/for a new recruit
    • How to generate TA planning for future year
    • How to import accounting link excel template by Department / Sub. Department
    • How to import accounting link excel template by Department / Sub. Department
    • How to modify an existing List
    • How to modify an existing user report
    • How to Print a Payslip to PDF
    • How to Print a Payslip to PDF
    • How to Reload criteria for a Payslip
    • How to Reload criteria for a User report
    • How to remove a data filter for a User Report
    • How to save a Payslip in PDF
    • How to save a User report in PDF format
    • How to send payslip via Email
    • How to upload an employee photo
    • How to use report criteria in Payroll
    • Checklists - (Pre Payroll)
    • Reports - (Post Payroll)
    • User Reports - (Pre & Post Payroll)
    • How to Use the Employee Batch Update (Excel Export and Import) Functionality
    • How to use the Revert Period function
    • How to use the Revert Period
    • How to use the Revert Period
    • How to verify vacation leave eligibility
    • How to View/Print a Payslip
    • How to view/print a User report
    • How to view User report with additional criteria
    • HRDC Training Levy 1%
    • HRMS User Account Deactivation
    • Prerequisites for MRA PRGF Exit Statement (full-time employees)
    • New format MRA PRGF Exit Statement August 2022
    • Prerequisites for MRA PRGF Past Services Return
    • Prerequisites for Monthly MRA PRGF Return
    • MRA PRGF Contribution Rates
    • When an employer switches from PRGF to Private Pension Scheme
    • Video/Wiki
    • Illustrations of indemnities in cases of Resignation or Termination when a worker is contributing to PRGF or Private Pension Scheme
    • Leave to care for sick child
    • Monthly MNS PAYE Return
    • Monthly MRA PAYE and Contribution Return
    • Monthly MRA Joint PAYENPFNSF Return
    • New EDF submitted during the fiscal year
    • New EDF submitted during the fiscal year
    • NSF and HRDC Training Levy July 2021 (Automatic NSF Adjustment in August 2021 & NSF and HRDC Training Levy Arrears in July 2021)
    • nsf_ceiling_july_2024
    • nsf_ceiling_july_2025
    • NSF ceiling July 2026
    • PAYE Calculation Checklist
    • Payments and deductions – Transfer to GL
    • Monthly PRGF Return (DO NOT PROCEED)
    • Pre-requisites (Settings)
    • Prerequisites
    • How to view payslip on a given date
    • Reset ESS Password in case of a forgotten password
    • Automatic Government Salary Increase (Full-time employees)
    • Salary Increase Excel Import
    • Migrant Worker (Non-Citizen)
    • Illustrations of gratuity and indemnities at Retirement and Death when a worker is contributing to PRGF or Private Pension Scheme
    • Update PRGF Payment & Deduction indicator flag (DO NOT PROCEED)
    • Yearly Government Increase Scale
    • Solidarity Levy
    • How to apply Solidarity Levy Exemption
    • Solidarity Levy (No EDF - Employer is required to withhold PAYE on Solidarity at the rate 25% or 10%)
    • Payroll Calculation - Solidarity Levy Calculation Checklist
    • Solidarity Levy (No EDF - Employee may request his employer to deduct Solidarity Levy under PAYE System at the rate of 25% or 10%)
    • Solidarity Levy (Tax on Tax)
    • MRA Special Allowance Statement
    • Wages Relativity Adjustment
    • Introduction - Steps to Verify Payroll Before and After Closure
    • Ungenerating gratuity calculations
    • Vacation Leave
    • Video/Wiki
    • Generate PRGF Contribution Arrears (DO NOT PROCEED]
    • Employee EDF
    • EDF Adjustment (applicable after payroll of July is closed)
    • Employee may request to deduct PAYE at a flat rate of 15% or 20% (Fiscal Year 2023-2024)
    • Fair Share Contribution (Employee's desired flat tax rate) of 10% or 15% or 20% for (Fiscal Year 2025-2026)
    • Exempt Employee (Fiscal Year 2023-2024)
    • New Tax Rates (Fiscal Year 2023-2024)
    • New Tax Rates (Fiscal Year 2025 - 2026)
    • New Tax Rates for PAYE (Fiscal Year 2026 - 2027)
    • When no EDF is submitted and emoluments derived in a month exceed Rs25,000, PAYE tax rate is 15%
    • PAYE Flat Rate 15% (Fiscal Year 2023-2024)
    • Tax on Tax/Tax Benefit (Fiscal Year 2023-2024)
    • Exemption Threshold
    • Verification before printing SOE and exporting ROE
    • Annual Return of Employees (ROE)
    • Statement of Emoluments
  • install
  • procguide
  • security
  • setup
  • setupguide
  • setupmanual
  • sitemap
  • statsmanual
  • troubleshoot
  • userguide
  • usermanual
  • HRMS Payroll
• sps
• wiki
• SKB Home