Skip to content
| User Manuals
| User Manuals

en_US English
en_US English ar Arabic fr_FR French

| User Manuals
| User Manuals

Human Resources

  • System Setting
    • Basic Data Settings
      • System General Setting
        • Bank Configuration
        • System General Setting
        • Configure Email                  
        • Email Creation Settings 
        •  Employee Screen Settings  
        • Preparing Questions For Attendance and Departure
        • Other
        • Notifications
        • Program Path Settings 
      • Basic Data Settings
        • Basic Data Settings
        • Work Data Settings
        • Basic Settings
        • Preparing Contracts Documents and Qualifications  
        • Insurance Company 
      • General Account Connecting Setting
        • General Account Connecting Setting
        • Connect Rules
        • Connect Costs Center
        • Connect Government Expenses
        • Connect Vacations
        •  Connect Accruals
        • Connect Cuts
        •  Connect The Penalties
        • Connect End of Service
        • Connect Type Of Operations For Public Accounts
    • Company Branches Settings
      • Company Data Settings 
      • Branches Data Settings 
      • Companies and Branches Documents
        •    Companies and Branches Documents
        • Company Documents
        •    Branchies Documents
    • Other Settings
      • Years and Months Settings 
      • Sponsors Settings
      • Employees Stopping Reasons Settings
      • Branches Capacity 
      • Compensation Settings
  • Human Resources Operations
    • Following Of Documents
      • Requests Notifications 
    • Employees Data
      • Employee Operations
        • Employee Operations 
        •  Staff List
        • Add An Employee
        • Transfer And Promotion Of Employees
        • Contract Renewal
        • Create Contracts
        • Activate_Off
        • Updating Data
        • The Stop EmpBank / Block And UnBlock EmpBank
        •  Change Direct Manager
    • Employee Operations
      • Vacations
        • Search Vacation
        • Direct and modify vacation requests 
        • Annual Vacation
        • Vacation Posting Reviews
        • Taken Vacation Balance
      • Employee Survies
        • Employee Survies
      • Issues
        • Issues
        • Sending Attendance And Departure Questions
        •  Research Issues
        • Delete Employee Issues
      • Permissions
        • Permissions
        •   Search Permissions
      • Correspondence
        • Correspondence
        • Send Massage
        • Send Emails
        • Archive
      • The End of Service Gratuity
        • The End of Service Gratuity
        •  Calculate End Service Gratuity
        • Posting The End Of Service Provision
        • UnPosting The End Of Service Provision
      • Termination Service Request
        • Termination Service Request Overview
        • Service Termination Request 
        • Termination Service Request 
    • Employees Financials
      • Advances
        • Advances                           
        • Add Advance
        • Search And Edit Installments
        •  Payment Advance
        • Realy Advances Aggregate Jornal
        • Upload Advances from Excel
      • Additional Classes Calculations
        • Additional Classes Calculations
    • Employees Salaries
      • Payroll Draft
        • Payroll Draft  Overview 
        • Payroll Draft
        • Closing Payroll
        • Posting Payroll 
        • Termination
        • Bank
        • Archives
        • Exceptions 
        • Archive Payroll
      • Bank Report
        • Bank Report (Rajhi Bank Report)
  • Regulations
    • Financial Settings
      •  Dues Regulation
      •  Deductions Regulation
      •  Bank Currencies Settings
    • Settings
      • Vacation Settings
        •  Vacation Settings
        • Stages Of Approving Leave
        • Official Vacations
        •   List Of Vacations
      • Attend Groups Settings
        •  Attend Groups Settings
        • Adding A New Attend Group
        • View Attend Group
        • Staff Review Of Attend Group 
        •  Assigning Employees To The Attend Group 
        • Application Of Attend Group Over A Period Of Time            
        • Approving The Change Of Finger Print Mobile Devices 
        • Assigning Employees To The Location 
        • Staff Reviews Of The Location
      • Advances Settings
        • Advances Settings
        •  Advance Approval Stages
        •   List Of Advances
        •   Advance Branches Approve Settings
        •  Advance Type Setting
      • Configure Approval Chains
        •  Configure Approval Chains
        •    Link Configuration Approvals
      • Configure Fingerprint Permissions
        •  Configure Fingerprint Permissions
    • Finger Print Deductions Regulations
      • Finger Print Deductions Regulations
        • Finger Print Deductions Regulations
        •   Penalty List
        •  Absence List
        •  Delay List
        • Finger Print List
        •  Early Leave List
    • Other Regulations
      • Other Regulations
        •  Other Regulations
        •   Penalty List
        •   Stages Of Visa Approval 
        •  List Of Government Expenses 
      • Termination Settings
        • Termination Settings
        • End Service Bonus Regulations
        • End Service Approval Stages
  • Requests
    • Approved Requests
      • Requests
        • Requests  
        • Advance 
        • Accompanying
        • Vacations
        • Subsidy
        • Deductions And Penalties
        •  Custom Entitlements
        • Cashing 
        • Buy
        • Miscellaneous Requests
        • Visa Approves
        •  Visa Requests
        • End Service Approval 
      • Purchase Request Budgets
        • Purchase Request Budgets
      • Requests Settings
        • Requests Settings
        •  Creating Requests
        • Review And Modify Orders 
        • Assign Users To Approval Groups
        •  Initialize Consent Groups
  • Reports
    • Finger Print Report
      •   Fingerprint Report
      •  Annual Fingerprint
      • Attendance Missing Insertion Report
      •  Social Fingerprint Report 
      •   Group Attendance Report 
      • Congestion Attendance Fingerprint
      • Daily Delay
      • Employee 
      • Daily 
      • Details Of Employees
      • Congesting Daily And Absence Of Branches And Departments                    
      • Attendance And Leave Employee Report
      •   Absence Report According To The Number Of Days
      • Total Delay Reward Report
      • Absence Report More On Days
      •  Delay By Days Report
      • Early Departure By Days Report
      •  Absence Report By Months
    • Employee Data Report
      •  Employee Data Report
      •  Basic Data Report
      •  New Hires And Termination Report 
      •   Employee Documents Report
      •    Report Evaluation
      • Printing Administrative Forms  
      •   Employee Insurance Report
      •   Employee Financial Report
      • Employee Vacation Report
      •  Report Of Total Users That Have Annual Leave  
      • A Report That Displays Total Overtime And Vacations 
      •  Employee Service And User Termination 
      •   Employee Salaries Report
      • Employee Mobile Numbers Report
      •  Special User Requests Report 
      •   Visa Requests
      •  Certifications Report
      •  Archive File
      • Documents About The End Report 
      •  Training Courses Report 
      • Employee Payrolls Comparison Report
    • Employee Financial Report
      • Salary Track
      • Salary Track (Develop)
      • Comparing The Payroll Months
      • Cuts Dues Report
      •   Bank Statement Report
      •  Grouped Payroll Report By Branch 
      •   Edit Payroll Report
      • Grouped Payroll Report By Branch And Month
      • Grouped Payroll Report By Branch And Section
      •   Termination Report 
      • Termination Report View
      •  Advances Report
      •  Paid And Unpaid Advances Premium Report 
      •  Advances Balance Report
      • Loans Movement For Employee 
      •  Loans Report
      •   Account Statement Report
    • Statistics
      • Employee Documents
      •  Estimated Budget Report For Manpower
      • Employees Count Report
      • Employee Contracts Report
      • Miscellaneous Requests Report
      • Employee Survies Report
    • Historical
      • Vacation Historical File
      • Archive                                                            
  • Requests Approve
    • Requests Approve
      • Requests Approve
  • Authentications
    • Authentications
      • Authentications
      • Users
      • Groups
      • Screen Permissions
      • Branches And Sections
      •  Enable Data Refresh
      •  Report Designer Permissions
      •  Dashboard Permissions
View Categories
  • Home
  • Docs
  • Human Resources
  • Human Resources Operations
  • Employees Financials
  • Advances
  • Upload Advances from Excel

Upload Advances from Excel

1 min read

The Upload Advances from Excel module provides batch processing capabilities to expedite loan system setups. Instead of logging requests row by row, payroll managers can utilize standardized spreadsheets to import hundreds of concurrent loan transactions along with their corresponding monthly deduction methodologies directly into active server registries. 

Configuration Workflow  #

The template parser uses specialized constraint dropboxes located inside the Advance interface boundary module to structure incoming data sheets: 

Import Bulk Financial Advance Spreadsheet Registries  #

Follow these steps to parse, validate, and execute an Excel loan import routine: 

  1. Click the blue Download Temple button to extract the standardized, system-formatted spreadsheet template file directly to your local workstation. 
  1. Open the file and populate the necessary spreadsheet entry columns explicitly (Employee Name, Employee Number, Advance Amount, etc.) without renaming headers. 
  1. Return to the interface window and assign the uniform starting timeline rule using The Due Date calendar input picker box. 
  1. Map the inbound structural rule definitions by selecting items inside the Advance Type and Discount Method dropdown menus. 
  1. Click inside the dashed central rectangular boundary layer hosting the cloud upload icon to select and load your completed spreadsheet file from your local folder directory. 
  1. Click the Save button to execute the automated data validation check, parse individual data fields, and import the bulk loan list live into active personnel profiles simultaneously. 
What are your Feelings

Share This Article :

  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Realy Advances Aggregate JornalAdvances                           
Table of Contents
  • Configuration Workflow 
  • Import Bulk Financial Advance Spreadsheet Registries