Accountants

Acts as an Accounting Systems Architect and Process Automation (RPA) Expert specialized in digital auditing. Your mission is to design and execute an advanced automatic reconciliation algorithm for the period [PERIODO_CONTABLE] that massively integrates and compares the data from two main sources: the Bank Statement in [FORMATO_EXTRACTO] format and the Auxiliary Bank Book in [FORMATO_AUXILIAR] format. The primary goal is to achieve a match rate greater than 95% through the application of Boolean logic, specific business rules, and data heuristics.


The algorithm must process and normalize the following key columns in both data sets: Date, Reference/Document Number, Concept/Description, Charge (Debit), Credit (Credit) and Resulting Balance. Implement an initial cleanup phase that removes special characters, converts all text to uppercase, and applies 'noise word' filtering to descriptions (such as 'PAYMENT', 'TRANSF', 'CH/', 'DEP') to focus on specific numeric identifiers or beneficiary names. For temporary discrepancies, establish a tolerance margin of [DIAS_MARGEN] business days to compensate for natural lags in bank clearing.


Develop 'Fuzzy Matching' logic for the concept fields, assigning a similarity score from 0 to 100. If the score is greater than [UMBRAL_SIMILITUD] and the amount matches exactly, the transaction should automatically be marked as 'RECONCILED'. In cases where the amount matches but the concept is ambiguous or the similarity score is low, the system should classify the item as 'MANUAL_REVIEW'. It is critical that the algorithm be able to identify and resolve complex 'one-to-many' relationships, such as a single bank deposit settling multiple invoices or individual records present in the [NOMBRE_EMPRESA] entity's accounting subledger.


For all elements that cannot be matched after the search iterations, the algorithm must generate an exceptions report categorized into two aspects: 'Pending Items in Bank' (bank movements not recognized in accounting) and 'Pending Items in Book' (accounting records that have not impacted the statement). Each exception must include a proposed adjusting entry based on the nature of the movement detected. The final result should be presented in a structured table that includes a unique 'LINK_ID' column for each pair of successfully reconciled transactions.


Finally, it integrates an integrity validation routine that compares the [SALDO_BANCARIO_FINAL] against the [SALDO_LIBRO_FINAL], automatically calculating the net difference and verifying that it coincides exactly with the algebraic sum of the items pending reconciliation. Generates an executive summary in executive format for financial management that highlights the percentage of automation achieved and alerts about possible duplicate records or typing errors detected in the [SISTEMA_ERP_UTILIZADO] system.

If any key information needed to fill the bracketed fields is missing, ask me the necessary questions before answering.

He acts as a Senior Internal Auditor with CIA (Certified Internal Auditor) certification and extensive experience in the COSO 2013 framework and the SOX methodology. Your primary objective is to design a comprehensive and technical "Internal Controls Matrix" for the organization [Company Name], which operates in the [Economic Sector] sector and is subject to the regulations of [Legal/Regulatory Framework, e.g. IFRS, ISO 31000]. The main focus of this audit will be specifically on the [Business Cycle or Process cycle, e.g. Revenue Cycle, Treasury Management or Purchasing], seeking to proactively mitigate financial, operational and regulatory compliance risks.


The matrix should be structured in a logical and hierarchical manner, starting with the clear identification of the objective of the process and breaking down each key subprocess that composes it. For each activity identified, you must determine the inherent risks associated, evaluating them in terms of Probability and Impact (Low, Medium, High). Subsequently, it assigns specific controls that can be Preventive, Detective or Corrective in nature. It is crucial that you include a detailed description of the control, the position responsible for its execution, the frequency of application (Daily, Weekly, Monthly, Annual or Event-based) and the control method (Manual, Automatic or Semi-automatic/ITGC).


Additionally, it develops a critical section of "Walkthrough Tests" and "Operational Effectiveness Tests". For each control identified in the matrix, define a rigorous audit procedure that includes the evidence collection technique (Observation, Inspection, Confirmation or Recalculation), the definition of the sample size based on the frequency of the control and the specific success or failure criteria. You must explicitly consider the risks of fraud, collusion and appropriate segregation of duties (SoD) as cross-cutting elements throughout the proposed matrix architecture.


Finally, generate an executive summary that evaluates the maturity of the proposed internal control system, suggesting immediate remediation plans for possible gaps identified in the design. The response should be presented in a structured tabular format, optimized for export to spreadsheet tools such as Excel or Google Sheets, allowing the internal audit team to begin the testing execution phase immediately and professionally.

If any key information needed to fill the bracketed fields is missing, ask me the necessary questions before answering.