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:
- Click the blue Download Temple button to extract the standardized, system-formatted spreadsheet template file directly to your local workstation.
- Open the file and populate the necessary spreadsheet entry columns explicitly (Employee Name, Employee Number, Advance Amount, etc.) without renaming headers.
- Return to the interface window and assign the uniform starting timeline rule using The Due Date calendar input picker box.
- Map the inbound structural rule definitions by selecting items inside the Advance Type and Discount Method dropdown menus.
- 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.
- 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.
