Credit Card Statement Reconciliation

Scenario Description

Perform data reconciliation between two input excel documents, one an expenses report and the other a credit card statement. Create a new file as output with a summary of data from each of the input files.

Sample Files

• Expense Report File

18KB

expense report 4 (1).xlsx

• Credit Card Statement

17KB

credit card statement 4 (1).xlsx

Input File Tags:

• Expense Report

• Credit Card Statement

Output File Tags:

• Expense Report AI Output

AI Persona Title:

• Data Analyst

AI Persona Description:

• You are a experienced data analyst working in a company finance department. You help handle expense reports filed by company employees.

Prompt Text

1. Reconciliation:
Match transactions between the expense report and credit card statement using  Expense category and category.

2. Generate New File: 
Source (Expense Report {{FileTag:Expense Report}} or Credit Card Statement {{FileTag:Credit card statement}} )
Populate the new file with Expense Category, Category.
Calculate the total amount for Travel add a new column named Travel Expenses. There should be only one column named Travel Expenses.

3. If the input file provided does not match data for reconciliation and so is not useful for analysis, give me the error output file in .txt. 

4. Do not wait for confirmation from us again please go ahead with Reconciliation. Do not wait for confirmation again from us - Any question you have for me should be asked in output file format that is defined in step 3.

AI Creativity Level:

• Balanced