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.

1. Education: Bachelor’s degree in finance, Accounting, or related field

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

Treasury Intern