# J.P. Morgan & BofA CashPro BAI2 Statement to Excel CSV

**Use case:** 

Convert J.P. Morgan Access and Bank of America CashPro BAI2 treasury files into flat Excel-ready CSV & JSON with full 88 continuation stitching and 40+ BAI Type Codes decoded.

## Input

```json
{
  "bai2Text": "01,021000021,ACMECORP,261116,0830,001,80,1,2/\n02,ACMECORP,021000021,1,261115,2359,USD,2/\n03,0044918273,USD,010,12500000,,,015,13925050,,,045,13925050,,/\n16,195,1500000,Z,WIRE26111501,CUST-8841,INCOMING WIRE FROM GLOBAL CLIENT INC/\n88,INVOICE REF INV-2026-991 PAID IN FULL/\n16,455,74950,Z,ACH26111509,AWS-CLOUD,AMAZON WEB SERVICES MONTHLY BILLING/\n49,29749950,6/\n98,29749950,1,8/\n99,29749950,1,10/",
  "includeInlineCsv": true
}
```

## Output

```json
{
  "status": {
    "label": "Status",
    "format": "string"
  },
  "accountCount": {
    "label": "Account count",
    "format": "integer"
  },
  "transactionCount": {
    "label": "Transaction count",
    "format": "integer"
  },
  "csvDownloadUrl": {
    "label": "Csv download url",
    "format": "string"
  }
}
```

## How it works

### 1. Sign up on Apify or log in

The BAI2 Corporate Bank Statement Parser to JSON & CSV Actor is ready to run with the inputs already set for "J.P. Morgan & BofA CashPro BAI2 Statement to Excel CSV". [Sign up or log in](https://console.apify.com/create-task-from-example/6OX0FIW3UlefafVzB) and you'll land in Apify Console with a copy of this exact task.

### 2. Start the "J.P. Morgan & BofA CashPro BAI2 Statement to Excel CSV" task

The BAI2 Corporate Bank Statement Parser to JSON & CSV Actor will start running based on the input automatically. You can also change all the input fields, like raw bai2 statement file text and include csv text in json dataset, to match your specific use case.

### 3. Receive the "J.P. Morgan & BofA CashPro BAI2 Statement to Excel CSV" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as status, account count, transaction count, and more.

### 4. Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also [run the "J.P. Morgan & BofA CashPro BAI2 Statement to Excel CSV" task via API](https://apify.com/finops_studio/bai2-bank-statement-parser.md).

## FAQ

### Does it stitch multi-line 88 remittance records?

Yes. Consecutive 88 lines are stitched cleanly onto their parent 03 summary or 16 transaction row.

### Which BAI2 type codes are translated?

Over 40 common corporate codes including 165 ACH Credit, 195 Wire In, 455 ACH Debit, 475 Check Paid, and 275/575 ZBA sweeps.

## About this Actor

This example demonstrates how to use [BAI2 Corporate Bank Statement Parser to JSON & CSV](https://apify.com/finops_studio/bai2-bank-statement-parser.md) with a specific input configuration. Visit the [Actor detail page](https://apify.com/finops_studio/bai2-bank-statement-parser.md) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

This Task's input is already configured above. Use it as-is rather than inventing a new one.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/finops_studio/bai2-bank-statement-parser.md

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).
