First Republic JPMorgan Chase Conversion CSV Spec
Table of contents
Appendix A
• Observed BAI Codes
Introduction
In order to ease the transition to JPMorgan, First Republic Bank can provide a “Pre-Migration” CSV file which replicates some of the variances between a CSV file generated by First Republic Bank and a CSV file generated by JPMorgan.
First Republic will allow you to simultaneously receive both your existing FRB CSV and the Pre-Migration CSV, or you can opt to only receive the Pre-Migration format.
The Pre-Migration CSV will use your production FRB data. This will allow you to being to prepare for the actual migration to JPMorgan.
The charts in the following pages highlight the differences between a First Republic Bank CSV file, the Pre-Migration CSV file, and a JPMorgan CSV file.
Please be aware that once you migrate to JPMorgan, additional variances may appear.
Standard CSV
JPMorgan |
First Republic Bank |
|||||
---|---|---|---|---|---|---|
Column |
JPMC COL NAME |
Format |
Column Description |
Notes |
FRB COL NAME |
FRB COL NUM |
1 |
CURRENT/PRIOR |
Alphanumeric |
Default to PRIOR for previous-day reports; CURRENT for intraday |
No equivalent in FRB format. Will be enclosed in double quotes. |
N/A |
N/A |
2 |
AS OF DATE |
mm/dd/yyyy |
Post date of transaction in mm/dd/yyyy format |
Straight map from noted FRB column. Will be enclosed in double quotes. |
TRANSACTION_DATE |
COL 1 |
3 |
VALUE DATE |
mm/dd/yyyy |
Effective date of transaction in mm/dd/yyyy format |
No equivalent in FRB format. Only appears for credit or debit rows, will be blank for summary rows. Will be enclosed in double quotes. |
TRANSACTION_DATE |
N/A |
4 |
BANK ID |
Alphanumeric |
US ABA or SWIFT BIC associated with account |
Hard-code “321081669” Will switch to “021000021” after migration. Will be enclosed in double-quotes. |
N/A |
N/A |
5 |
BANK NAME |
Alpha |
Bank name associated with BANK ID Ex: “FIRST REPUBLIC BANK” |
Hard-code “FIRST REPUBLIC BANK” Will switch to “JPMORGAN” after migration. Values are enclosed in double-quotes. |
N/A |
N/A |
6 |
ACCOUNT NUMBER |
Numeric |
Account number |
Straight map from noted FRB column. Will be enclosed in double quotes. |
ACCOUNT_NUMBER |
COL 2 |
7 |
ACCOUNT NAME |
Alphanumeric |
Primary account name |
Straight map from noted FRB column. Will be enclosed in double quotes. |
ACCOUNT_NAME |
COL 3 |
8 |
CURRENCY |
Alpha |
ISO standard currency code associated with account. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
CURRENCY |
COL 6 |
9 |
BAI CODE |
Numeric |
BAI2 transaction code for specific transaction sorting. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
BAI2_CD |
COL 8 |
10 |
DESCRIPTION |
Alphanumeric |
Detailed description of transaction. Matches details on monthly statements. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
TRANSACTION_ |
COL 7 |
11 |
AMOUNT BAL |
Signed Currency |
Amount of balance in USD. This field is signed and includes a minus sign for negative balances. Currency characters (e.g. $) are not included. |
Partial straight map from noted FRB column. Includes Balance-type transactions only. |
AMOUNT |
COL 5 |
12 |
AMOUNT CR |
Unsigned Currency |
Amount of credit transactions in USD. This field is unsigned. Currency characters (e.g. $) are not included. |
Partial straight map from noted FRB column. Includes Credit-type transactions only. |
AMOUNT |
COL 5 |
13 |
AMOUNT DR |
Unsigned Currency |
Amount of debit transactions in USD. This field is unsigned. Currency characters (e.g. $) are not included. |
Partial straight map from noted FRB column. Includes Debit-type transactions only. |
AMOUNT |
COL 5 |
14 |
CUSTOMER REF |
Alphanumeric |
The Customer Reference Number will be the check number for the Transaction Detail type codes 474, 475 and 395. |
Value is “NON REF” by default; may be blank. Will be enclosed in double quotes. |
N/A |
N/A |
15 |
BANK REF |
Alphanumeric |
Bank-assigned reference number for a particular transaction, currently limited to wires and some ACH transfers. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
REFERENCE_NBR |
COL 9 |
16 |
REMARK 01 |
Alphanumeric |
This field contains any additional details about the transaction, currently limited to additional wire details. |
Straight map from noted FRB column. This is an optional field that will remain blank if a value is not present. Will be enclosed in double quotes. |
SUPPLEMENTARY_ |
COL 10 |
Standard CSV Examples
First Republic Bank
TRANSACTION |
ACCOUNT NUMBER |
ACCOUNT NAME |
TRAN TYPE |
AMOUNT |
CURRENCY |
TRANSACTION DESCRIPTION |
BAI2 CD |
REFERENCE NBR |
SUPPLEMENTARY DETAILS |
---|---|---|---|---|---|---|---|---|---|
1/29/2024 |
10001234567 |
BALOOS AIRCRAFT |
Balance |
0.00 |
USD |
OPENING BALANCE |
010 |
||
1/29/2024 |
10001234567 |
BALOOS AIRCRAFT |
Credit |
500000.00 |
USD |
AUTOMATIC TRANSFER TRANSFER FROM ZBA TRANSFER XXXXXXX3868 |
206 |
||
1/29/2024 |
10001234567 |
BALOOS AIRCRAFT |
Debit |
-500000.00 |
USD |
DOMESTIC ONLINE WIRE MCQUACK AVIATION O01TH1129OFS906W |
495 |
20240129MMQFMPRN001234 |
FED_REF=20240129MMQFMPRN001234; ORIGINATOR=BALOOS AIRCRAFT LLC DBA MCQUACK AV/1234 1ST ST STE 101/DUCKBURG-CA-94345/10001234567; ORIGINATORS_BANK=FIRST REPUBLIC BANK/321081669; INSTRUCTING_BANK=; BENEFICIARY=MCQUACK AVIATION/933871234; RFB=FRB TO JPMC; OBI=; BBI=; SENDING_BANK=FIRST REPUBLIC BANK/321081669; SENDING_BANK_REF=FRB TO JPMC; RECEIVING_BANK=JPMORGAN CHASE BANK, NA/21000021; |
1/29/2024 |
10001234567 |
BALOOS AIRCRAFT |
Balance |
0.00 |
USD |
CLOSING BALANCE |
015 |
||
1/29/2024 |
10002345678 |
STARRY SKIES LLC |
Balance |
158240.29 |
USD |
OPENING BALANCE |
010 |
||
1/29/2024 |
10002345678 |
STARRY SKIES LLC |
Credit |
300000.00 |
USD |
INCOMING WIRE STARRY SKIES LLC O01TF1445AMUO2HY |
195 |
20240129MMQFMPRN00123456789012FT01 |
FED_REF=20240129MMQFMPRN00658601234567FT01; ORIGINATOR=STARRY SKIES LLC/1234 WOOD MILL RD/CAPE SUZE CA 94123-1234 US/123456789; ORIGINATORS_BANK=JPMORGAN CHASE/021000021; INSTRUCTING_BANK=; BENEFICIARY=STARRY SKIES LLC/405 EL CAMINO REAL/109/DRAKE POND, CA 91234 US/10002345678; RFB=ATS OF 24/01/29; OBI=STARRY SKIES LLC BANK TO BANK TRANSFER; BBI=; SENDING_BANK=JPMORGAN CHASE/21000021; SENDING_BANK_REF=ATS OF 24/01/29; |
RECEIVING_BANK=FIRST REPUBLIC BANK/321081669; |
|||||||||
1/29/2024 |
10002345678 |
STARRY SKIES LLC |
Debit |
-2110.78 |
USD |
ACH PREFUNDING DEBIT MCQUACK AVIATION CORELLIAN 2463 9993893118 |
455 |
||
1/29/2024 |
10002345678 |
STARRY SKIES LLC |
Balance |
456129.51 |
USD |
CLOSING BALANCE |
015 |
||
1/29/2024 |
10003456789 |
BALOOS AIRCRAFT |
Balance |
2159248.37 |
USD |
OPENING BALANCE |
010 |
||
1/29/2024 |
10003456789 |
BALOOS AIRCRAFT |
Debit |
-650.00 |
USD |
CHECK WITHDRAWAL CK# 1038 |
475 |
||
1/29/2024 |
10003456789 |
BALOOS AIRCRAFT |
Balance |
2158598.37 |
USD |
CLOSING BALANCE |
015 |
||
1/29/2024 |
10004567890 |
GLOMGOLD ENTER |
Balance |
12916.85 |
USD |
OPENING BALANCE |
010 |
||
1/29/2024 |
10004567890 |
GLOMGOLD ENTER |
Credit |
269448.60 |
USD |
ACH CREDIT GLOMGOLD ENTERP DIRECT-PAY MCQUACK AVIATIO 12345678 1234567890 |
165 |
||
1/29/2024 |
10004567890 |
GLOMGOLD ENTER |
Debit |
-32365.45 |
USD |
AUTOMATIC TRANSFER TRANSFER TO ICS SWEEP XX XXXXXXX6783 |
501 |
||
1/29/2024 |
10004567890 |
GLOMGOLD ENTER |
Balance |
282365.45 |
USD |
CLOSING BALANCE |
015 |
JPMorgan
CURRENT |
AS OF DATE |
VALUE DATE |
BANK ID |
BANK NAME |
ACCOUNT NUMBER |
ACCOUNT NAME |
CURRENCY |
BAI CODE |
DESCRIPTION |
AMOUNT BAL |
AMOUNT CR |
AMOUNT DR |
CUSTOMER REF |
BANK REF |
REMARK 01 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PRIOR |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10001234567 |
BALOOS AVIATION |
USD |
010 |
OPENING BALANCE |
0.00 |
||||||
PRIOR |
1/29/2024 |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10001234567 |
BALOOS AVIATION |
USD |
206 |
AUTOMATIC TRANSFER TRANSFER FROM ZBA TRANSFER XXXXXXX3868 |
500000.00 |
NON REF |
||||
PRIOR |
1/29/2024 |
1/29/2024321081669 |
FIRST REPUBLIC BANK |
10001234567 |
BALOOS AVIATION |
USD |
495 |
DOMESTIC ONLINE WIRE MCQUACK AVIATION O01TH1129OFS906W |
500000.00 |
NON REF |
5FX4U67ARMQG-24029 |
YOUR REF=FRB TO JPMC ,PAID TO=JPMORGAN CHASE BANK , NA ,FED ID=021000021 ,ACCT PARTY=/10001234567 MCQUACK AVIATION 2345678901 ,REMARK= ,REC GRP= ,MRN SEQ= ,FED REF=20240129 MMQFMPRN 001234 **VIA FED** |
|||
PRIOR |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10001234567 |
BALOOS AVIATION |
USD |
015 |
CLOSING BALANCE |
0.00 |
||||||
PRIOR |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10002345678 |
STARRY SKIES LLC |
USD |
010 |
OPENING BALANCE |
158240.29 |
||||||
PRIOR |
1/29/2024 |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10002345678 |
STARRY SKIES LLC |
USD |
195 |
INCOMING WIRE STARRY SKIES LLC O01TF1445AMUO2HY |
300000.00 |
NON REF |
X7G36GVIBV5S-24029 |
YOUR REF=ATS OF 24/01/29 ,REC FROM=JPMORGAN CHASE ,FED ID=021000021 ,B/O CUSTOMER=STARRY SKIES LLC 1234 WOOD MILL RD CAPE SUZE CA 94123-1234 US 123456789 ,B/O BANK=JPMORGAN CHASE ,REMARK=STARRY SKIES LLC BANK TO BANK TRANSFER ,REC GFP=STARRY SKIES LLC BANK TO BANK TRANSFER ,MRN SEQ= ,FED REF=20240129 MMQFMPRN 001234 **VIA FED** |
||
PRIOR |
1/29/2024 |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10002345678 |
STARRY SKIES LLC |
USD |
455 |
ACH PREFUNDING DEBIT MCQUACKAVIATION CORELLIAN |
2110.78 |
NON REF |
24029K7ABCD-BCDEFG |
|||
MCQUA2463 9993893118 |
|||||||||||||||
PRIOR |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10002345678 |
STARRY SKIES LLC |
USD |
015 |
CLOSING BALANCE |
456129.51 |
||||||
PRIOR |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10003456789 |
BALOOS AVIATION |
USD |
010 |
OPENING BALANCE |
2159248.37 |
||||||
PRIOR |
1/29/2024 |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10003456789 |
BALOOS AVIATION |
USD |
475 |
CHECK WITHDRAWAL CK# 1038 |
650.00 |
1038 |
||||
PRIOR |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10003456789 |
BALOOS AVIATION |
USD |
015 |
CLOSING BALANCE |
2158598.37 |
||||||
PRIOR |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10004567890 |
GLOMGOLD ENTER |
USD |
010 |
OPENING BALANCE |
12916.85 |
||||||
PRIOR |
1/29/2024 |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10004567890 |
GLOMGOLD ENTER |
USD |
165 |
ACH CREDIT GLOMGOLD ENTERP DIRECT-PAY MCQUACK AVIATIO 12345678 1234567890 |
269448.60 |
NON REF |
24029K7ABCD-ABCDEF |
|||
PRIOR |
1/29/2024 |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10004567890 |
GLOMGOLD ENTER |
USD |
501 |
AUTOMATIC TRANSFER TRANSFER TO ICS SWEEP XX XXXXXXX6783 |
32365.45 |
NON REF |
||||
PRIOR |
1/29/2024 |
321081669 |
FIRST REPUBLIC BANK |
10004567890 |
GLOMGOLD ENTER |
USD |
015 |
CLOSING BALANCE |
282365.45 |
First Republic Bank
TRANSACTION_DATE,ACCOUNT_NUMBER,ACCOUNT_NAME,TRAN_TYPE,AMOUNT,CURRENCY,TRANSACTION_DESCRIPTION,BAI2_CD,REFERENCE_NBR,SUPPLEMENTARY_DETAILS
2024-01-29,10001234567,BALOOS AIRCRAFT,Balance,0.0,USD,OPENING BALANCE,010,,
2024-01-29,10001234567,BALOOS AIRCRAFT,Credit,500000.0,USD,AUTOMATIC TRANSFER TRANSFER FROM ZBA TRANSFER XXXXXXX3868,206,,
2024-01-29,10001234567,BALOOS AIRCRAFT,Debit,-500000.0,USD,DOMESTIC ONLINE WIRE MCQUACK
AVIATION O01TH1129OFS906W,495,20240129MMQFMPRN001234,"FED_REF=20240129MMQFMPRN001234; ORIGINATOR=BALOOS AIRCRAFT LLC DBA MCQUACK AV/1234 1ST ST STE 101/DUCKBURG-CA-94345/10001234567; ORIGINATORS_BANK=FIRST REPUBLIC BANK/321081669; INSTRUCTING_BANK=; BENEFICIARY=MCQUACK AVIATION/9876541234; RFB=FRB TO JPMC;
OBI=; BBI=; SENDING_BANK=FIRST REPUBLIC BANK/321081669; SENDING_BANK_REF=FRB TO JPMC; RECEIVING_BANK=JPMORGAN CHASE BANK, NA/21000021;"
2024-01-29,10001234567,BALOOS AIRCRAFT,Balance,0.0,USD,CLOSING BALANCE,015,,
2024-01-29,10002345678,STARRY SKIES LLC,Balance,158240.29,USD,OPENING BALANCE,010,, 2024-01-29,10002345678,STARRY SKIES LLC,Credit,300000.0,USD,INCOMING WIRE STARRY SKIES LLC O01TF1445AMUO2HY,195,20240129MMQFMPRN00658601291514FT01,"FED_REF=20240129MMQFMPRN00658601291514FT01; ORIGINATOR=STARRY SKIES LLC/1234 WOOD MILL RD/PALO ALTO CA 94123-1234 US/123456789; ORIGINATORS_BANK=JPMORGAN CHASE/021000021; INSTRUCTING_BANK=; BENEFICIARY=STARRY SKIES LLC/405 EL CAMINO REAL/101/DRAKE POND, CA 91234 US/10002345678; RFB=ATS OF 24/01/29; OBI=STARRY SKIES LLC BANK TO BANK TRANSFER; BBI=; SENDING_BANK=JPMORGAN CHASE/21000021; SENDING_BANK_REF=ATS OF 24/01/29; RECEIVING_BANK=FIRST REPUBLIC BANK/321081669;"
2024-01-29,10002345678,STARRY SKIES LLC,Debit,-2110.78,USD,ACH PREFUNDING DEBIT MCQUACK AVIATION CORELLIAN 2463 9993893118,455,,
2024-01-29,10002345678,STARRY SKIES LLC,Balance,456129.51,USD,CLOSING BALANCE,015,,
2024-01-29,10003456789,BALOOS AIRCRAFT,Balance,2159248.37,USD,OPENING BALANCE,010,,
2024-01-29,10003456789,BALOOS AIRCRAFT,Debit,-650.0,USD,CHECK WITHDRAWAL CK# 1038,475,,
2024-01-29,10003456789,BALOOS AIRCRAFT,Balance,2158598.37,USD,CLOSING BALANCE,015,,
2024-01-29,10004567890,GLOMGOLD ENTER,Balance,12916.85,USD,OPENING BALANCE,010,,
2024-01-29,10004567890,GLOMGOLD ENTER,Credit,269448.6,USD,ACH CREDIT GLOMGOLD ENTERP DIRECT-PAY MCQUACK AVIATIO 12345678 1234567890,165,,
2024-01-29,10004567890,GLOMGOLD ENTER,Debit,-32365.45,USD,AUTOMATIC TRANSFER TRANSFER TO ICS SWEEP XX XXXXXXX6783,501,,
2024-01-29,10004567890,GLOMGOLD ENTER,Balance,282365.45,USD,CLOSING BALANCE,015,,
JPMorgan
"CURRENT/PRIOR","AS OF DATE","VALUE DATE","BANK ID","BANK NAME","ACCOUNT NUMBER","ACCOUNT NAME","CURRENCY","BAI CODE","DESCRIPTION","AMOUNT BAL","AMOUNT CR","AMOUNT DR","CUSTOMER REF","BANK REF","REMARK 01"
"PRIOR","01/29/2024","","321081669","FIRST REPUBLIC BANK","10001234567","BALOOS AVIATION","USD","010","OPENING BALANCE",0.00,"","","","","" "PRIOR","01/29/2024","01/29/2024","321081669","FIRST REPUBLIC BANK","10001234567","BALOOS AVIATION","USD","206","AUTOMATIC TRANSFER TRANSFER FROM ZBA TRANSFER XXXX
XXX3868","","",500000.00,"NON REF","",""
"PRIOR","01/29/2024","01/29/2024","321081669","FIRST REPUBLIC BANK","10001234567","BALOOS AVIATION","USD","495","DOMESTIC ONLINE WIRE MCQUACK AVIATION O01TH1129OFS
906W","",500000.00,"","NON REF","5FX4U67ARMQG-24029","YOUR REF=FRB TO JPMC ,PAID TO=JPMORGAN CHASE BANK , NA ,FED ID=021000021
,ACCT PARTY=/10001234567 MCQUACK AVIATION 2345678901 ,REMARK= ,REC GRP= ,MRN SEQ= ,FED REF=20240129 MMQFMPRN 001234 **VIA FED**"234 **VIA FED**"
"PRIOR","01/29/2024","","321081669","FIRST REPUBLIC BANK","10001234567","BALOOS AVIATION","USD","015","CLOSING BALANCE",0.00,"","","","","" "PRIOR","01/29/2024","","321081669","FIRST REPUBLIC BANK","10002345678","STARRY SKIES LLC","USD","010","OPENING BALANCE",158240.29,"","","","","" "PRIOR","01/29/2024","01/29/2024","321081669","FIRST REPUBLIC BANK","10002345678","STARRY SKIES LLC","USD","195","INCOMING WIRE STARRY SKIES LLC O01TF1445AMUO2HY","",""
,300000.00,"NON REF","X7G36GVIBV5S-24029","YOUR REF=ATS OF 24/01/29 ,REC FROM=JPMORGAN CHASE ,FED ID=021000021 ,B/O CUSTOMER=STARRY SKIES LLC 1234 WOOD
MILL RD CAPE SUZE CA 94123-1234 US 123456789 ,B/O BANK=JPMORGAN CHASE ,REMARK=STARRY SKIES LLC BANK TO BANK TRANSFER
,REC GFP=STARRY SKIES LLC BANK TO BANK TRANSFER ,MRN SEQ= ,FED REF=20240129 MMQFMPRN 001234 **VIA FED**"
"PRIOR","01/29/2024","01/29/2024","321081669","FIRST REPUBLIC BANK","10002345678","STARRY SKIES LLC","USD","455","ACH PREFUNDING DEBIT MCQUACKAVIATION CORELLIAN MCQU
A2463 9993893118","",2110.78,"","NON REF","24029K7ABCD-BCDEFG",""
"PRIOR","01/29/2024","","321081669","FIRST REPUBLIC BANK","10002345678","STARRY SKIES LLC","USD","015","CLOSING BALANCE",456129.51,"","","","","" "PRIOR","01/29/2024","","321081669","FIRST REPUBLIC BANK","10003456789","BALOOS AVIATION","USD","010","OPENING BALANCE",2159248.37,"","","","","" "PRIOR","01/29/2024","01/29/2024","321081669","FIRST REPUBLIC BANK","10003456789","BALOOS AVIATION","USD","475","CHECK WITHDRAWAL CK# 1038","",650.00,"","1038","","" "PRIOR","01/29/2024","","321081669","FIRST REPUBLIC BANK","10003456789","BALOOS AVIATION","USD","015","CLOSING BALANCE",2158598.37,"","","","","" "PRIOR","01/29/2024","","321081669","FIRST REPUBLIC BANK","10004567890","GLOMGOLD ENTER","USD","010","OPENING BALANCE",12916.85,"","","","","" "PRIOR","01/29/2024","01/29/2024","321081669","FIRST REPUBLIC BANK","10004567890","GLOMGOLD ENTER","USD","165","ACH CREDIT GLOMGOLD ENTERP DIRECT-
PAY MCQUACK AVIATIO 12345678 1234567890","","",269448.60,"NON REF","24029K7ABCD-ABCDEF",""
"PRIOR","01/29/2024","01/29/2024","321081669","FIRST REPUBLIC BANK","10004567890","GLOMGOLD ENTER","USD","501","AUTOMATIC TRANSFER TRANSFER TO ICS SWEEP XX XXXXXXX6
783","",32365.45,"","NON REF","",""
"PRIOR","01/29/2024","","321081669","FIRST REPUBLIC BANK","10004567890","GLOMGOLD ENTER","USD","015","CLOSING BALANCE",282365.45,"","","","",""
Balances Only CSV
JPMorgan |
First Republic Bank |
|||||
---|---|---|---|---|---|---|
Column |
JPMC COL NAME |
Format |
Column Description |
Notes |
FRB COL NAME |
FRB COL NUM |
1 |
VALUE DATE |
mm/dd/yyyy |
Effective date of transaction in mm/dd/yyyy format |
No equivalent in FRB format. Only appears for credit or debit rows, will be blank for summary rows. Will be enclosed in double quotes. |
TRANSACTION_DATE |
N/A |
2 |
BANK ID |
Alphanumeric |
US ABA or SWIFT BIC associated with account |
Hard-code “321081669” will switch to “021000021” after migration. Will be enclosed in double-quotes. |
N/A |
N/A |
3 |
ACCOUNT NUMBER |
Numeric |
Account number |
Straight map from noted FRB column. Will be enclosed in double quotes. |
ACCOUNT_NUMBER |
COL 2 |
4 |
ACCOUNT NAME |
Alphanumeric |
Primary account name |
Straight map from noted FRB column. Will be enclosed in double quotes. |
ACCOUNT_NAME |
COL 3 |
5 |
CURRENCY |
Alpha |
ISO standard currency code associated with account. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
CURRENCY |
COL 6 |
6 |
BAI CODE |
Numeric |
BAI2 transaction code for specific transaction sorting. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
BAI2_CD |
COL 8 |
7 |
DESCRIPTION |
Alphanumeric |
Detailed description of transaction. Matches details on monthly statements. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
TRANSACTION_DESCRIPTION |
COL 7 |
8 |
AMOUNT BAL |
Signed Currency |
Amount of transaction or balance in USD. This field is signed and includes a minus sign for debits. Credits and balances are unmodified. Currency characters (e.g. $) are not included. Ex: 10000.00 |
Straight map from noted FRB column. |
AMOUNT |
COL 5 |
Balances Only CSV Examples
First Republic Bank
DATE |
ACCOUNT |
ACCOUNT_NAME |
ACCOUNT_NAME_2 |
ACCOUNT_NAME_3 |
DAY_OPENING_BALANCE |
DAY_ENDING_BALANCE |
---|---|---|---|---|---|---|
1/29/2024 |
10001234567 |
BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT) |
0.00 |
0.00 |
||
1/29/2024 |
10002345678 |
STARRY SKIES LLC |
158240.29 |
456129.51 |
||
1/29/2024 |
10003456789 |
BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (FBO DARKWING BOTHAN) |
2159248.37 |
2158598.37 |
||
1/29/2024 |
10004567890 |
GLOMGOLD ENTERPRISES LLC |
12916.85 |
282365.45 |
JPMorgan
VALUE DATE |
BANK ID |
ACCOUNT NUMBER |
ACCOUNT NAME |
CURRENCY |
BAI CODE |
DESCRIPTION |
AMOUNT BAL |
---|---|---|---|---|---|---|---|
1/29/2024 |
321081669 |
10001234567 |
BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT) |
USD |
015 |
Balance |
0.00 |
1/29/2024 |
321081669 |
10001234567 |
BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT) |
USD |
015 |
Balance |
0.00 |
1/29/2024 |
321081669 |
10002345678 |
STARRY SKIES LLC |
USD |
015 |
Balance |
456129.51 |
1/29/2024 |
321081669 |
10002345678 |
STARRY SKIES LLC |
USD |
015 |
Balance |
456129.51 |
1/29/2024 |
321081669 |
10003456789 |
BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (FBO DARKWING BOTHAN) |
USD |
015 |
Balance |
2158598.37 |
1/29/2024 |
321081669 |
10004567890 |
GLOMGOLD ENTERPRISES LLC |
USD |
015 |
Balance |
282365.45 |
1/29/2024 |
321081669 |
10004567890 |
GLOMGOLD ENTERPRISES LLC |
USD |
015 |
Balance |
282365.45 |
First Republic Bank
DATE,ACCOUNT,ACCOUNT_NAME,ACCOUNT_NAME_2,ACCOUNT_NAME_3,DAY_OPENING_BALANCE,DAY_ENDING_BALANCE
2024-01-29,10001234567,BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT),,,0.0,0.0
2024-01-29,10002345678,STARRY SKIES LLC,,,158240.29,456129.51
2024-01-29,10003456789,BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (FBO DARKWING BOTHAN),,,2159248.37,2158598.37
2024-01-29,10004567890,GLOMGOLD ENTERPRISES LLC,,,12916.85,282365.45
JPMorgan
"VALUE DATE","BANK ID","ACCOUNT NUMBER","ACCOUNT NAME","CURRENCY","BAI CODE","DESCRIPTION","AMOUNT BAL"
"01/29/24","321081669","10001234567","BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT)","USD","015","Balance",0.00 "01/29/24","321081669","10001234567","BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT)","USD","015","Balance",0.00 "01/29/24","321081669","10002345678","STARRY SKIES LLC","USD","015","Balance",456129.51 "01/29/24","321081669","10002345678","STARRY SKIES LLC","USD","015","Balance",456129.51 "01/29/24","321081669","10003456789","BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (FBO DARKWING BOTHAN)","USD","015","Balance",2158598.37 "01/29/24","321081669","10004567890","GLOMGOLD ENTERPRISES LLC","USD","015","Balance",282365.45
"01/29/24","321081669","10004567890","GLOMGOLD ENTERPRISES LLC","USD","015","Balance",282365.45
Transactions Only CSV
JPMorgan |
First Republic Bank |
|||||
---|---|---|---|---|---|---|
Column |
JPMC COL NAME |
Format |
Column Description |
Notes |
FRB COL NAME |
FRB COL NUM |
1 |
VALUE DATE |
mm/dd/yyyy |
Effective date of transaction in mm/dd/yyyy format |
No equivalent in FRB format. Only appears for credit or debit rows, will be blank for summary rows. Will be enclosed in double quotes. |
TRANSACTION_DATE |
N/A |
2 |
BANK ID |
Alphanumeric |
US ABA or SWIFT BIC associated with account |
Hard-code “321081669” will switch to “021000021” after migration. Will be enclosed in double-quotes. |
N/A |
N/A |
3 |
ACCOUNT NUMBER |
Numeric |
Account number |
Straight map from noted FRB column. Will be enclosed in double quotes. |
ACCOUNT_NUMBER |
COL 2 |
4 |
ACCOUNT NAME |
Alphanumeric |
Primary account name |
Straight map from noted FRB column. Will be enclosed in double quotes. |
ACCOUNT_NAME |
COL 3 |
5 |
CURRENCY |
Alpha |
ISO standard currency code associated with account. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
CURRENCY |
COL 6 |
6 |
BAI CODE |
Numeric |
BAI2 transaction code for specific transaction sorting. Ex: “495”, “195” |
Straight map from noted FRB column. Will be enclosed in double quotes. |
BAI2_CD |
COL 8 |
7 |
DESCRIPTION |
Alphanumeric |
Detailed description of transaction. Matches details on monthly statements. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
TRANSACTION_DESCRIPTION |
COL 7 |
8 |
AMOUNT CR |
Unsigned Currency |
Amount of credit transactions in USD. This field is unsigned. Currency characters (e.g. $) are not included. |
Partial straight map from noted FRB column. Includes Credit-type transactions only. |
AMOUNT |
COL 5 |
9 |
AMOUNT DR |
Unsigned Currency |
Amount of debit transactions in USD. This field is unsigned. Currency characters (e.g. $) are not included. |
Partial straight map from noted FRB column. Includes Debit-type transactions only. |
AMOUNT |
COL 5 |
10 |
CUSTOMER REF |
Alphanumeric |
The Customer Reference Number will be the check number for the Transaction Detail type codes 474, 475 and 395. |
Value is “NON REF” by default; may be blank. Will be enclosed in double quotes. |
N/A |
N/A |
11 |
BANK REF |
Alphanumeric |
Bank-assigned reference number for a particular transaction, currently limited to wires and some ACH transfers. |
Straight map from noted FRB column. Will be enclosed in double quotes. |
REFERENCE_NBR |
COL 9 |
Transactions Only CSV Examples
First Republic Bank
Date |
ABA Num |
Currency |
Account Num |
Account Name |
Description |
BAI Code |
Amount |
Serial Num |
Detail |
Tran Code |
---|---|---|---|---|---|---|---|---|---|---|
1/29/2024 |
32108669 |
USD |
10001234567 |
BALOOS AIRCRAFT |
AUTOMATIC TRANSFER |
206 |
500000.00 |
0 |
AUTOMATIC TRANSFER TRANSFER FROM ZBA TRANSFER XXXXXXX3868 |
129 |
1/29/2024 |
32108669 |
USD |
10001234567 |
BALOOS AIRCRAFT |
DOMESTIC ONLINE WIRE |
495 |
-500000.00 |
0 |
DOMESTIC ONLINE WIRE MCQUACK AVIATION O01TH1129OFS906W |
824 |
1/29/2024 |
32108669 |
USD |
10002345678 |
STARRY SKIES LLC |
ACH PREFUNDING DEBIT |
455 |
-2110.78 |
0 |
ACH PREFUNDING DEBIT MCQUACK AVIATION CORELLIAN 2463 9993893118 |
983 |
1/29/2024 |
32108669 |
USD |
10002345678 |
STARRY SKIES LLC |
INCOMING WIRE |
195 |
300000.00 |
0 |
INCOMING WIRE STARRY SKIES LLC O01TF1445AMUO2HY |
624 |
1/29/2024 |
32108669 |
USD |
10003456789 |
BALOOS AIRCRAFT |
CHECK |
475 |
-650.00 |
1038 |
CHECK WITHDRAWAL CK# 1038 |
800 |
1/29/2024 |
32108669 |
USD |
10004567890 |
GLOMGOLD ENTER |
ACH CREDIT |
165 |
269448.60 |
0 |
ACH CREDIT GLOMGOLD ENTERP DIRECT-PAY MCQUACK AVIATIO 12345678 1234567890 |
736 |
1/29/2024 |
32108669 |
USD |
10004567890 |
GLOMGOLD ENTER |
AUTOMATIC TRANSFER |
501 |
-32365.45 |
0 |
AUTOMATIC TRANSFER TRANSFER TO ICS SWEEP XX XXXXXXX6783 |
283 |
JPMorgan
VALUE DATE |
BANK ID |
ACCOUNT NUMBER |
ACCOUNT NAME |
CURRENCY |
BAI CODE |
DESCRIPTION |
AMOUNT CR |
AMOUNT DR |
CUSTOMER REF |
BANK REF |
---|---|---|---|---|---|---|---|---|---|---|
1/29/2024 |
321081669 |
10001234567 |
BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT) |
USD |
206 |
AUTOMATIC TRANSFER TRANSFER FROM ZBA TRANSFER XXXXXXX3868 |
500000.00 |
NON REF |
||
1/29/2024 |
321081669 |
10001234567 |
BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT) |
USD |
495 |
DOMESTIC ONLINE WIRE MCQUACK AVIATION O01TH1129OFS906W |
NON REF |
5FX4U67ARMQG-24029 |
||
1/29/2024 |
321081669 |
10002345678 |
STARRY SKIES LLC |
USD |
195 |
INCOMING WIRE STARRY SKIES LLC O01TF1445AMUO2HY |
300000.00500000.00 |
NON REF |
X7G36GVIBV5S-24029 |
|
1/29/2024 |
321081669 |
10002345678 |
STARRY SKIES LLC |
USD |
455 |
ACH PREFUNDING DEBIT MCQUACK AVIATION CORELLIAN MCQUA2463 9993893118 |
2110.78 |
NON REF |
24029K7ABCD-BCDEFG |
|
1/29/2024 |
321081669 |
10003456789 |
BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (FBO DARKWING BOTHAN) |
USD |
475 |
CHECK WITHDRAWAL CK# 1038 |
650.00 |
1038 |
||
1/29/2024 |
321081669 |
10004567890 |
GLOMGOLD ENTERPRISES LLC |
USD |
501 |
AUTOMATIC TRANSFER TRANSFER TO ICS SWEEP XX XXXXXXX6783 |
32365.45 |
NON REF |
||
1/29/2024 |
321081669 |
10004567890 |
GLOMGOLD ENTERPRISES LLC |
USD |
165 |
ACH CREDIT GLOMGOLD ENTERP DIRECT-PAY MCQUACK AVIATIO 12345678 1234567890 |
269448.60 |
NON REF |
24029K7ABCD-ABCDEF |
First Republic Bank
Date,ABA Num,Currency,Account Num,Account Name,Description,BAI Code,Amount,Serial Num,Detail,Tran Code
01/29/2024,32108669,USD,10001234567,BALOOS AIRCRAFT,AUTOMATIC TRANSFER,206,500000.0,000000000,AUTOMATIC TRANSFER TRANSFER FROM ZBA TRANSFER XXXXXXX3868,129 01/29/2024,32108669,USD,10001234567,BALOOS AIRCRAFT,DOMESTIC ONLINE WIRE,495,-500000.0,000000000,DOMESTIC ONLINE WIRE MCQUACK AVIATION O01TH1129OFS906W,824 01/29/2024,32108669,USD,10002345678,STARRY SKIES LLC,ACH PREFUNDING DEBIT,455,-2110.78,000000000,ACH PREFUNDING DEBIT MCQUACK AVIATION CORELLIAN 2463 9993893118,983 01/29/2024,32108669,USD,10002345678,STARRY SKIES LLC,INCOMING WIRE,195,300000.0,000000000,INCOMING WIRE STARRY SKIES LLC O01TF1445AMUO2HY,624 01/29/2024,32108669,USD,10003456789,BALOOS AIRCRAFT,CHECK,475,-650.0,0001038.0,CHECK WITHDRAWAL CK# 1038,800
01/29/2024,32108669,USD,10004567890,GLOMGOLD ENTER,ACH CREDIT,165,269448.6,000000000,ACH CREDIT GLOMGOLD ENTERP DIRECT-PAY MCQUACK AVIATIO 12345678 1234567890,736 01/29/2024,32108669,USD,10004567890,GLOMGOLD ENTER,AUTOMATIC TRANSFER,501,-32365.45,000000000,AUTOMATIC TRANSFER TRANSFER TO ICS SWEEP XX XXXXXXX6783,283
JPMorgan
"VALUE DATE","BANK ID","ACCOUNT NUMBER","ACCOUNT NAME","CURRENCY","BAI CODE","DESCRIPTION","AMOUNT CR","AMOUNT DR","CUSTOMER REF","BANK REF" "01/29/24","321081669","10001234567","BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT)","USD","206","AUTOMATIC
TRANSFER TRANSFER FROM ZBA TRANSFER XXXXXXX3868",500000.00,"","NON REF",""
"01/29/24","321081669","10001234567","BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (ACH TRANSMISSION ACCOUNT)","USD","495","DOMESTIC ONLINE WIRE MCQUACK AVIATION O01TH1129OFS906W","",500000.00,"NON REF","5FX4U67ARMQG-24029"
"01/29/24","321081669","10002345678","STARRY SKIES LLC","USD","195","INCOMING WIRE STARRY SKIES LLC O01TF1445AMUO2HY",300000.00,"","NON REF","X7G36GVIBV5S-24029" "01/29/24","321081669","10002345678","STARRY SKIES LLC","USD","455","ACH PREFUNDING DEBIT MCQUACK
AVIATION CORELLIAN MCQUA2463 9993893118","",2110.78,"NON REF","24029K7ABCD-BCDEFG"
"01/29/24","321081669","10003456789","BALOOS AIRCRAFT LLC DBA MCQUACK AVIATION (FBO DARKWING BOTHAN)","USD","475","CHECK WITHDRAWAL CK# 1038","",650.00,"1038","" "01/29/24","321081669","10004567890","GLOMGOLD ENTERPRISES LLC","USD","501","AUTOMATIC TRANSFER TRANSFER TO ICS SWEEP XX XXXXXXX6783","",32365.45,"NON REF","" "01/29/24","321081669","10004567890","GLOMGOLD ENTERPRISES LLC","USD","165","ACH CREDIT GLOMGOLD ENTERP DIRECT-
PAY MCQUACK AVIATIO 12345678 1234567890",269448.60,"","NON REF","24029K7ABCD-ABCDEF"
Appendix A
Observed BAI Codes
Changes between FRB and JPM are orange.
FRB BAI2 CODE |
TRAN TYPE |
FRB CODE DESC |
JPM BAI CODE |
JPM CODE DESC |
|
---|---|---|---|---|---|
115 |
C |
LOCKBOX DEPOSIT |
115 |
INDIVIDUAL LOCKBOX DEPOSIT |
|
165 |
C |
PREAUTHORIZED ACH CREDIT |
165 |
PREAUTHORIZED ACH CREDIT |
|
171 |
C |
INDIVIDUAL LOAN DEPOSIT |
171 |
Individual Loan Deposit |
|
173 |
C |
BANK-PREPARED DEPOSIT |
399 |
BANK PREPARED DEPOSITS |
|
174 |
C |
OTHER DEPOSIT |
174 |
OTHER DEPOSITS |
|
187 |
C |
CASH LETTER CREDIT |
187 |
CASH LETTER CREDITS |
|
195 |
C |
INCOMING MONEY TRANSFER |
195 |
IND INCOMING MONEY TRANSFER |
|
206 |
C |
BOOK TRANSFER CREDIT |
195 |
BOOK TRANSFER CREDIT |
|
208 |
C |
INDIVIDUAL INTERNATIONAL MONEY TRANSFER CREDIT |
214 |
IND. INTERNATIONAL MONEY TRANSFER CREDIT |
|
252 |
C |
DEBIT REVERSAL |
252 |
DEBIT REVERSAL |
|
266 |
C |
RETURN ITEM |
266 |
RETURN ITEMS |
|
295 |
C |
ATM CREDIT |
295 |
ATM CREDIT |
|
354 |
C |
INTEREST CREDIT |
354 |
INTEREST CREDIT |
|
357 |
C |
CREDIT ADJUSTMENT |
357 |
CREDIT ADJUSTMENT |
|
364 |
C |
LOAN PARTICIPATION |
399 |
Miscellaneous Credit |
|
366 |
C |
CURRENCY AND COIN DEPOSITED |
366 |
Currency and Coin Deposited |
|
395 |
C |
CHECK REVERSAL |
395 |
Check Reversal |
|
398 |
C |
MISCELLANEOUS FEE REFUND |
398 |
MISCELLANEOUS FEE REFUNDS |
|
399 |
C |
MISCELLANEOUS CREDIT |
399 |
MISCELLANEOUS CREDIT |
|
455 |
D |
PREAUTHORIZED ACH DEBIT |
455 |
PREAUTHORIZED ACH DEBIT |
|
466 |
D |
ACH SETTLEMENT |
466 |
ACH SETTLEMENT |
|
469 |
D |
MISCELLANEOUS ACH DEBIT |
455 |
MISC. ACH DEBIT |
|
475 |
D |
CHECK PAID |
475 |
INDIVIDUAL CHECKS PAID |
|
481 |
D |
INDIVIDUAL LOAN PAYMENT |
481 |
IND. LOAN PAYMENTS |
|
484 |
D |
DRAFT |
699 |
DRAFT |
|
495 |
D |
OUTGOING MONEY TRANSFER |
495 |
IND OUTGOING MONEY TRANSFERS |
|
501 |
D |
INDIVIDUAL AUTOMATIC TRANSFER DEBIT |
501 |
IND. AUTOMATIC TRANSFER DEBIT |
|
506 |
D |
BOOK TRANSFER DEBIT |
495 |
BOOK TRANSFER DEBIT |
|
508 |
D |
INDIVIDUAL INTERNATIONAL MONEY TRANSFER DEBITS |
514 |
INT. INTERNATIONAL MONEY TRANSFER DEBIT |
|
552 |
D |
CREDIT REVERSAL |
552 |
CREDIT REVERSAL |
|
555 |
D |
DEPOSITED ITEM RETURNED |
555 |
IND. DEPOSITED ITEMS RETURNED |
|
566 |
D |
RETURN ITEM |
555 |
IND. DEPOSITED ITEMS RETURNED |
|
567 |
D |
RETURN ITEM FEE |
567 |
RETURN ITEM FEE |
|
595 |
D |
ATM DEBIT |
595 |
ATM DEBIT |
|
631 |
D |
DEBIT ADJUSTMENT |
631 |
DEBIT ADJUSTMENT |
|
654 |
D |
INTEREST DEBIT |
654 |
INTEREST DEBIT |
|
661 |
D |
ACCOUNT ANALYSIS FEE |
698 |
ACCOUNT ANALYSIS FEE |
|
698 |
D |
MISCELLANEOUS FEES |
698 |
MISCELLANEOUS FEES |
|
699 |
D |
MISCELLANEOUS DEBIT |
699 |
MISCELLANEOUS DEBIT |
This guide is proprietary to J.P. Morgan and is provided for your general information only. It is subject to change without notice and is not intended to be legally binding. All services described in this guide are subject to applicable laws and regulations and service terms. Not all products and services are available in all locations. Eligibility for products and services will be determined by JPMorgan Chase Bank, N.A. or its affiliates. J.P. Morgan makes no representation as to the legal, regulatory or tax implications of the matters referred to in this guide.
All trademarks, trade names and service marks appearing herein are the property of their respective owners.
J.P. Morgan is a marketing name for the Treasury Services businesses of JPMorgan Chase Bank, N.A., member FDIC, and its affiliates worldwide.
Chase.com | JPMorgan.com | JPMorgan.com/payments
Privacy | Terms of Use | Accessibility | Cookies Policy | Regulatory Disclosures
Remember: We won't ask for confidential information such as your password, personal identification number (PIN) or other account information in a text message or email, or over the phone unless you call us about an issue, such as something to do with your account.
The information provided here is intended to help clients protect themselves from fraud and cyberfraud. It does not provide a comprehensive list of all types of fraud activities or identify all types of cybersecurity best practices. Your company or organization is responsible for determining how to best protect itself against fraud and cyberfraud and for selecting the best practices that are most appropriate to your needs.
Clients who do not use appropriate fraud-prevention tools increase their risk of losses and are liable for all losses incurred for payments originating using any authorized users’ security credentials or others who have designated transaction authority.
© 2024 JPMorgan Chase & Co. All rights reserved.