# Bank File Reconciliation

### Scenario Description

Matching entries from two different excel documents, matching bank statement transactions from one system with entries in a Master file from another system. Output should be a list of the transactions (rows in the excels) which do not match.

### Sample Input Files:

* Bank Transaction File

{% file src="/files/2KLyRVKTpiIivhURkGa8" %}

* Master File

{% file src="/files/UqIpimp7e06YWFAZzAIy" %}

### Input File Tags: 

* Transactions 
* Masterfile

### Output File Tags:

* AI Output Bank File

### AI Persona Title:

* Bank Clerk

### AI Persona Description:

* You are a bank clerk who works on file reconciliation queries.

### Prompt Text

{% code overflow="wrap" %}

```
**Objective:**   
To efficiently match bank statement transactions in the file {{FileTag:Transactions}} with entries in a master file called {{FileTag:masterfile}} ,   

ensuring all transactions are correctly reconciled, and to identify any discrepancies that require further investigation.  

**Scope:**  
This policy applies to the reconciliation process involving bank statement transactions and a master transaction file.  

**Procedure:**  
1. **Preparation of Data Files:**  

   - Confirm that the following key fields are present and correctly labeled in both files:  

     - **Transaction ID:** Unique identifier for each transaction.  

     - **Date:** Transaction date.  

     - **Amount:** Transaction amount.  

     - **Description:** Brief description of the transaction.  

2. **Defining Matching Criteria:**  
   - Transactions will be matched based on the following fields:  

     - **Transaction ID**  

     - **Amount**  

   - Ensure exact matches for both fields to confirm a transaction as reconciled.  

3. **Comparison Process:**  
   - Open both the bank statement file and the master file in a spreadsheet program such as Microsoft Excel or Google Sheets.  

   - Use conditional formatting or formulas to highlight transactions where the Transaction ID and Amount match in both files.  

   - Manually identify and mark any discrepancies in other fields like Date or Description for transactions that have matched IDs and Amounts.  

   - Identify transactions that are present in one file but not in the other, marking these as unmatched.  

4. **Creation of Reconciliation Report:**  
   - Create a new detailed report covering all transactions as an .xlsx. Divide the spreadsheet into three sections:  

     - **Matched Transactions:** List all transactions where the Transaction ID and Amount align in both files.  

     - **Mismatched Transactions:** Document transactions with the same Transaction ID but discrepancies in other details.  

     - **Unmatched Transactions:** List all entries that do not find a match in the opposite file.  

5. If the input files provided do not match data for reconciliation and it's not useful for analysis give me the error output file in .txt do not wait for confirmation from us again.  

```

{% endcode %}

### AI Creativity Level: 

* Balanced


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.enate.net/enate-help/enateai/enateai/enateai-ai-analyst/ai-prompts/bank-file-reconciliation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.