MANUAL DE USODESARROLLADO POR: FERNANDO OROZCO MERA GILEYDI ANDREA VERGARA DIAZPROYECTO DE PRÁCTICA CUADRE DE IVA AUTOMÁTICO

Tabla de contenido 01. ¿Qué es el cuadre de IVA? 02. Indicadores de IVA 03. Estructura de carpetas por sociedad y archivo maestro 04. Extracción en SAP (Parte 1): Balance/PyG e Indicadores 05. Ejecución de Macros en Excel: Bloques 1 y 2 06. Extracción en SAP (Parte 2): Reclasificaciones y Consolidados 07. Ejecución de Macros en Excel: Bloques 3 y 4 08. Cierre, notificación de reclasificaciones y nuevo periodo 02 02 07 09 12 13 14 16 01

Este control mensual se ejecuta a inicios de mes, entre los días 4, 5, 6 o 7 (a mes vencido), para las sociedades 1010, 1020 y 1030. Su propósito es verificar el uso adecuado de los indicadores de IVA en las cuentas de ingreso del periodo y entregar el cuadre final validado a la Analista de Impuestos. 01. ¿Qué es el cuadre de IVA? Daniela Motoa Analista 02 PALABRAS DE DANI 02. Indicadores de IVA Para realizar este proceso se debe tener en cuenta los siguientes conceptos e indicadores de los componentes del reporte de IVA.

03. Estructura de carpetas y archivo maestro Ingresa a CUADRE DE IVA - AUTOMATICO y selecciona la ociedad (1010, 1020 o 1030). 03 Carpeta y sociedades Usa HISTORICO para archivar insumos anteriores si requieres trazabilidad, y PLANTILLA para el mes actual. Subcarpetas principales BALPYG (Balance/PyG), INDI (Reportes de indicadores), RECLASIFICACION (Cuentas con inconsistencias graves nombradas con el código de cuenta), CONS_ING (Consolidados de ingresos) y CONS_IVA (Consolidados de IVA generado). Carpetas dentro de PLANTILLA Carpetas dentro de PLANTILLA Abre siempre el archivo habilitado para macros (ej. PLANTILLA 1010.xlsm). El archivo estándar es solo respaldo.

04 Hojas principales Consulta1 MES AÑO IVA INDI MES AÑO

05 Hojas principales RECLASIFICACIÓN ING CONSOLIDADO IVA CONSOLIDADO

06 CONSOLIDADO 04. Extracción en SAP Balance e Indicadores

Equal Employment Opportunity Forge is an equal opportunity employer. We extend equal opportunity to all individuals without regard to race, religion, color, sex, national origin, disability, age, or any other status protected by law. Hiring and promotion decisions are based purely on machining skills, qualifications, and performance. At-Will Employment Your employment with Forge is voluntary. This means that both you and the company have the right to terminate the employment relationship at any time, with or without cause, and with or without advance notice. Employee Handbook Forge Family 04 Immigration Law Compliance Forge is committed to employing only individuals who are legally authorized to work. All new employees must complete the required employment eligibility verification forms and provide acceptable documentation upon hire.

02 Working Hours and Operations Our standard workweek begins on Monday at 12:01 a.m. and ends on Sunday at midnight. Regular work schedules for production staff are divided into multiple shifts (morning, afternoon, and night) to ensure optimal machine operation. Your supervisor will assign your shift schedule. [02] Employee Handbook Forge Family05 Rest and Meal Periods Working in a metal fabrication environment requires intense concentration and physical stamina. Forge complies with all regulations regarding employee rest periods. Meal Periods: Employees working more than five hours will receive a 30-minute unpaid meal break. Employees are required to leave the machining area during this period. Rest Periods: Employees are entitled to a 10-minute paid rest period for every four hours worked. Machines must be turned off or placed on safe standby mode during these breaks. 01

Overtime Rules The nature of our manufacturing business sometimes requires strict project deadlines. If you are required to work overtime, we will provide as much advance notice as possible. All overtime hours for non-exempt employees must be pre-approved by the production floor manager. Attendance and Punctuality If you are going to be late or absent, you must call your production floor supervisor at least one hour before your shift begins. Sending a text message or leaving a voicemail with a co-worker does not qualify as an official notification. Repeated tardiness without a valid reason will result in disciplinary action. Inclement Weather Operations While most of our operations are indoors, activities at the loading dock and outdoor material storage areas are heavily affected by the weather. During severe weather or lightning warnings: The use of outdoor cranes and forklifts in open areas must be halted immediately. If extreme weather forces a facility closure, the company will provide instructions via emergency communication channels. Your safety while traveling to work is our top priority. 01 02 Employee Handbook Forge Family 06

Standards of Conduct We expect every employee to maintain the highest level of professionalism, both in the office and on the production floor. Mutual respect is the foundation of our commitment to exceptional quality. Behaviors such as insubordination, negligence resulting in damaged machinery, physical altercations, or the use of abusive language will not be tolerated and may lead to immediate termination. [04] Dress Code Work attire must suit your work environment for safety reasons and professional image. Office Staff Neat and appropriate business casual attire. Production Floor Staff Heavy cotton or flame-resistant workwear. No loose clothing, drawstrings, or dangling jewelry that could get caught in moving machinery. Long hair must be neatly tied back and secured. Protective gear details are further explained in the Occupational Safety section. Cyber Security and Confidential Data Every employee is obligated to maintain client and company confidentiality. Never download sensitive files to personal storage devices (USB drives) or forward them to external emails. Do not share your passwords or lend your access card to anyone. Breaches of client data security may result in termination and legal action. Employee Handbook Forge Family07

Company Vehicles Fleet vehicles, material delivery trucks, and forklifts may only be used for Forge business. Only employees with proper licensing, specialized training, and written approval are permitted to operate these vehicles. Inspection Obligations Operators must perform a safety inspection before their shift begins (checking brakes, lights, hydraulic fluids, and tires). Any technical malfunction or traffic violation while using a company vehicle must be reported immediately to the fleet manager. Work Equipment and Personal Tools Forge provides employees with the specialized tools, safety gear, and equipment necessary to perform their assigned duties efficiently and safely. Employees are responsible for the daily care, proper storage, and routine maintenance of all company-issued equipment. Any loss, significant wear, or malfunction of tools must be reported immediately to your floor supervisor to ensure rapid replacement and prevent operational delays. While the company supplies all required equipment, employees may choose to bring their own personal hand tools to the production floor, provided they meet our strict safety and calibration standards. All personal tools must be inspected and approved by the floor manager prior to use. Please note that Forge assumes no liability for the loss, theft, or damage of personal tools brought into the manufacturing facility. Internet, Email, and Social Media The email system and internet access are provided strictly for business purposes. Personal use should be limited to break times and must not interfere with productivity. Social Media Policy Using mobile phones to access social media or taking photos and videos on the production floor without permission is strictly prohibited for operational safety and client confidentiality reasons. You are not authorized to represent the company in public spaces without written consent from the public relations department. Employee Handbook Forge Family 08

Occupational Health and Safety Safety is a shared responsibility at Forge. We strive to comply with all safety regulations from labor authorities and relevant industry standards. Employees are required to read the Health, Safety, and Environment (HSE) Manual available in the break area. Every piece of heavy machinery is equipped with machine guards. Disabling or bypassing safety systems, or ignoring Lockout-Tagout protocols while performing repairs is a severe violation. Accident Reporting and Investigation All incidents, whether they result in minor injuries or are simply near-misses, must be reported immediately to the floor supervisor or Safety Officer. A prompt investigation will be conducted to identify hazards and prevent similar incidents from recurring. Neglecting to report a workplace injury not only endangers other coworkers but may also invalidate your future workers' compensation claims. [05] Employee Handbook Forge Family09

Personal Protective Equipment (PPE) For anyone stepping onto the factory floor or welding areas, the use of Personal Protective Equipment (PPE) is mandatory without exception. Eye and Ear Protection Industrial safety glasses and hearing protection (earmuffs or earplugs) are mandatory in machining areas. Head and Face Protection Welding helmets or specialized face shields are mandatory when cutting or welding metals. Foot Protection Steel-toe boots approved by safety standards must be worn at all times on the floor. Drug and Alcohol-Free Workplace Operating cutting machines, press brakes, and cranes requires absolute physical alertness and composure. Involvement with alcohol or illegal drugs poses a fatal risk in our factory. The use, possession, or being under the influence of illegal drugs or alcohol while on duty, at project sites, or while operating company vehicles is strictly prohibited. Employees who must take prescription medications that may affect their physical alertness must notify their supervisor before starting their shift. Employee Handbook Forge Family 10

Substance Testing To protect our workforce, Forge reserves the right to conduct substance testing under the following conditions: Pre- Employment All applicants who have received a conditional job offer must pass a screening test. Reasonable Suspicion Testing may be requested if management has a strong reason to believe an employee is under the influence of substances. Post- Accident Employees involved in incidents that damage company property or cause injury may be required to undergo testing for investigation purposes. Workplace Violence Prevention Forge has zero tolerance for threats of violence, aggressive behavior, intimidation, or physical assault within the company premises. Bringing firearms, explosives, or unauthorized sharp weapons into our manufacturing facilities or parking lots is strictly prohibited. Any act of violence or verbal threat at the worksite will be fully investigated, and if necessary, we will involve law enforcement authorities to ensure the safety of our staff. Employee Handbook Forge Family11

Anti- Discrimination and HarassmentWe are committed to providing a workplace that respects the equality and dignity of every individual. We maintain zero tolerance for harassment of any kind, whether verbal, visual, or physical. Sexual harassment, including unwanted advances, explicit jokes on the factory floor, requests for sexual favors, or derogatory comments related to gender or other protected characteristics, is strictly prohibited and will be grounds for immediate termination for the offender. Employee Handbook Forge Family 12 [06] Disability Accommodations and Reporting If you feel you are a victim of harassment or witness discriminatory actions, immediately report the incident to Sarah Whitfield in the Human Resources Department. We guarantee maximum confidentiality during the investigation process and strictly prohibit any form of retaliation against the reporter. Reporting Qualified employees with disabilities have the right to request reasonable accommodations to safely perform their job functions, provided it does not create an undue hardship on company operations.

Compensation and Expense Reimburseme ntEmployees are paid on a weekly basis. If the payroll date falls on a holiday, payments will be processed on the preceding business day. Federal, local, and social security taxes will be deducted from your paycheck as required by law, along with your insurance premium contributions. All salary payments are made via direct deposit to your chosen bank account to ensure administrative speed and security. [07] Business Travel and Expense Reimbursement For sales staff or technicians traveling for field project inspections, the company will reimburse reasonable travel expenses, standard accommodations, and a daily meal per diem. Keep all original receipts and complete the expense report within one week of returning. Company Credit Cards Company cards issued for logistics, purchasing raw metals, or spare parts must be used exclusively for business purposes. Using them for personal expenses is strictly prohibited and constitutes a severe violation. Employee Handbook Forge Family13

Employee Benefits and Leaves Our benefits program includes Major Medical Insurance, Dental Care Insurance, Vision Insurance, and Term Life Insurance. Employees will receive the opportunity to select these insurance coverages during the annual Open Enrollment period or under special qualifying conditions (such as marriage or childbirth). Employee Handbook Forge Family 20 [08] Workers' Compensation and Holidays Workers' Compensation Insurance If you suffer a work-related injury while operating machinery or handling materials, your medical bills and partial lost wage compensation are covered by workers' compensation insurance in accordance with applicable laws. Instant reporting to your supervisor is vital to claim these benefits. Paid Holidays The company recognizes several national holidays each year during which the manufacturing facility will be closed and full-time employees will receive paid compensation. Employee Handbook Forge Family 14

Leaves of Absence Sick and Personal Leave Employees accrue paid sick leave based on hours worked. This time can be used for medical treatments, health recovery, or family emergencies. Family and Medical Leave (FMLA) Eligible employees are entitled to unpaid, job-protected leave to care for a severely ill immediate family member, the birth of a child, or adoption. Military and Civic Duty Leave We support the obligations of employees who are military service members or reservists through unpaid leave for training or duty calls. We also provide necessary time off for jury duty and voting. 01 02 03 Employee Handbook Forge Family15

Closing and Disciplinary Actions Although your employment here is at-will, the company may utilize progressive disciplinary steps to correct behaviors that do not align with operating and safety protocols. Progressive Discipline a verbal warning from the floor supervisor, a formal written warning placed in your personnel file, unpaid suspension from work, and finally termination for serious or repeated incidents. Management reserves the right to take immediate decisive action if there is a direct threat to factory safety. These steps may include [09] Resignation Separation and Acknowledgment If you decide to leave the company, we appreciate a written notice at least two weeks in advance to allow for a smooth transition process and production staff rescheduling. An exit interview will be conducted to handle the return of access cards, tool keys, and company equipment. Employee Acknowledgment You will receive a separate form that must be signed and submitted to the Human Resources department. This form states that you have received, read, and agreed to comply with all guidelines, safety rules, and procedures listed in this handbook during your tenure at Forge. Employee Handbook Forge Family 16

Employee Handboo kA Guide to Policies, Safety, and Workplace Expectations Forge 2035 Edition