Treasury Intern

Job Overview

The Treasury & Reconciliation Executive is responsible for managing daily banking and treasury functions, ensuring the accurate reconciliation of bank accounts, payment gateways, and other financial data. This role requires advanced Excel skills for data analysis, reconciliation, and reporting. The individual will be responsible to streamline processes, maintain accurate financial records, and support cash management activities.

Key Responsibilities

1. Bank Reconciliation

Perform daily, weekly, and monthly reconciliation of multiple bank accounts.

Investigate and resolve discrepancies between bank statements and the general ledger.

Ensure accurate and timely posting of all bank transactions.

2. Treasury Operations

Manage daily fund flow and maintain optimal fund balances.

Monitor and process fund transfers, bank deposits, and payments.

Assist in managing relationships with banks and financial institutions.

3. Payment Gateway Reconciliation

Reconcile transactions from various payment gateways (e.g., PayPal, Stripe, etc.) with internal financial systems.

Identify and resolve discrepancies related to payment processing and settlement.

Track chargebacks, refunds, and fees associated with gateways.

4. Accounting Support

Assist in month-end closing processes by preparing relevant journal entries.

Support the accounts payable and receivable functions as needed.

Ensure compliance with financial policies, procedures, and controls.

5. Advanced Excel and Data Analysis

Utilize advanced Excel techniques (VLOOKUP, Pivot Tables, etc.) for reconciliation, data analysis, and reporting.

Create and maintain financial models, cash flow forecasts, and ad-hoc reports.

Ensure data integrity and accuracy across financial records.

6. Process Improvement

Identify opportunities to streamline and improve reconciliation and treasury

processes.

Implement automation tools or improved methodologies for data reconciliation and reporting.

Ensure internal controls are maintained in all treasury and reconciliation activities.

7. Compliance and Reporting

Prepare regular treasury and reconciliation reports for management.

Assist in audit preparations by providing accurate reconciliations and supporting documentation.

Ensure adherence to relevant regulatory and compliance requirements.

Expectations

1. Education: Bachelors degree in finance, Accounting, or related field.

2. Experience: 0 -3 years of experience in treasury, accounting, or reconciliation roles, preferably

in a banking or financial services environment.

Skills:

Proficient in MS office, Google tools such as google forms, google sheets, Charts, etc.

Knowledge of operating Tally accounting software.

Advanced proficiency in Microsoft Excel (VLOOKUP, Pivot Tables, Macros, etc.).

Strong analytical skills and attention to details.

Strong knowledge of payment gateways and their reconciliation processes.

Ability to communicate effectively with internal and external stakeholders.

High level of accuracy and ability to handle large volumes of financial data.

Ability to work independently and manage multiple tasks under tight deadlines.

4. Additional Preferred Skills: Familiarity with online banking systems and payment gateway

platforms.