The Softex Mapping Automation is a Microsoft Access-based desktop application designed to automate the Foreign Inward Remittance Certificate (FIRC) to Softex form mapping process, significantly enhancing efficiency and accuracy. Key features include:

• Automated FIRC to Invoice Mapping: Applies predefined rules to automatically map FIRCs to corresponding invoices, reducing manual effort and errors.

• Master List Management: Maintains a master list of line items to be ignored or deleted, ensuring only relevant data is processed.

• Data Issue Identification: Highlights line items not imported due to data issues, allowing for prompt review and correction.

• Configurable Buffer Percentage: Provides the ability to set and manage the unallocated portion of the FIRC, offering flexibility in financial reconciliations.

• Adjustable Cutoff Date: Allows users to define a buffer period from the invoice date to search for corresponding FIRCs, accommodating varying transaction timelines.

This automation reduces the FIRC to Softex mapping process from five manual days to approximately 20 minutes for about 150,000 line items, demonstrating a substantial improvement in operational efficiency.