General Ledger - List of Bank Reconciliation Formats
Formats Supported by CMiC in Standard R12
The list of Bank Reconciliation File Formats supported by CMiC in the Standard R12 product as of October 5, 2020 is provided in the table below.
BA - Bank Reconciliation File Formats | |||
---|---|---|---|
Format Code | Bank Name | File Format | |
1 | AMEGYBANK | Amegy Bank | |
2 | BACS_UK | BACS format | Not Available |
3 | BOA | Bank Of America | Not Available |
4 | BOA_4 | Bank of America Format #4 | |
5 | BOA_2 | Bank Of America Format (2) | |
6 | BOA_3 | Bank Of America Format (3) | Not Available |
7 | BOA1 | Bank of America I | Not Available |
8 | BMO | Bank of Montreal | Not Available |
9 | BMO_2 | Bank of Montreal (2) | Not Available |
10 | BOT | Bank of Texas | |
11 | WEST-BANK | Bank Of The West | |
12 | BBTBANK | BBT Bank | |
13 | BMO_HARRIS | BMO Harris Bank | |
14 | BMOHARRIS2 | BMO Harris Bank (2) | Not Available |
15 | BMONACHA | BMO NACHA | Not Available |
16 | BOA_FLEET | BOA/Fleet Bank | Not Available |
17 | CAPONE-CT1 | Capital One ( Custom-1 ) | |
18 | CHASEPWSBK | Chase PWS Delimited Text File | |
19 | CHITENDEN2 | Chittenden Bank(Check Reconciliation) | Not Available |
20 | CIBC | CIBC Bank | Not Available |
21 | CITIBANK | CITI Bank | Not Available |
22 | CITZN-BANK | Citizens Bank | |
23 | CITYNATION | City National Bank | |
24 | COMERICABK | Comerica Bank | Not Available |
25 | COMMERCE | Commerce Bank | Not Available |
26 | COMPASSBNK | Compass Bank ACH Format | Not Available |
27 | FTB | Fifth Third Bank | |
28 | FTB_2 | Fifth Third Bank 2 | |
29 | FHAWAIBANK | First Hawai Bank | Not Available |
30 | HAWAI-BANK | First Hawaiian Bank | |
31 | HARRIS | Harris Bank | Not Available |
32 | HARRISBK_1 | Harris Bank 1 | Not Available |
33 | IRELANDBNK | Ireland Bank Format | Not Available |
34 | JPM-CHASE | JP Morgan Chase Bank | |
35 | JPM-CHASE2 | JP Morgan Chase Bank ( 11 Digits Account ) | |
36 | JPM-CHASE3 | JP Morgan Chase Bank (Format# 3) | Not Available |
37 | LASALLE | La Salle National | Not Available |
38 | MECHS(CC) | Mechanics Bank(Cleared Check) CSV Format | |
39 | MIDWESTACH | Midwest ACH Format | Not Available |
40 | NATIONAL | National Bank Format | Not Available |
41 | NEB | National Exchange Bank | Not Available |
42 | NICOLETBNK | Nicolet National Bank | Not Available |
43 | NORTHTRUST | Northern Trust | Not Available |
44 | PNCBANK | PNC Bank | |
45 | PVT-BANK | Private Bank | |
46 | PVT-BANK2 | PrivateBank (10 Digits Account) | |
47 | ROYALBANK | Royal Bank | |
48 | SOUTHTRUST | South Trust Bank | Not Available |
49 | SOVEREIGN | Sovereign Bank | |
50 | SUNTRUST_1 | SUNTRUST BANK (PAID ITEMS) | Not Available |
51 | US-BANK | U.S. Bank | Not Available |
52 | UMB_BANK | UMB Financial Corporation | |
53 | UMPQUABANK | UMPQUA Bank | Not Available |
54 | UBC | Union Bank Of California | |
55 | UNITEDBANK | United Bank | |
56 | ACH | US Bank | |
57 | USBANKACH | US Bank ACH Format | Not Available |
58 | WACHACH_A | Wachovia ACH format | Not Available |
59 | WACHOVIA | Wachovia Bank | Not Available |
60 | WACHOVIA_R | Wachovia Bank(Check Reconciliation) | |
61 | WACHACH | Wachovia format | Not Available |
62 | WACHACH_2 | Wachovia(new) format | Not Available |
63 | WACHACH_TD | Wachovia(TD) format | Not Available |
64 | WELLSFARGO | Wells Fargo | |
65 | WELFARGO_2 | Wells Fargo Bank | Not Available |
66 | WELFARGO_3 | WELLS FARGO BANK (R12 - PAID CHECKS, 057 - CHECK) | Not Available |
67 | WFARGO(CC) | Wells Fargo Bank(Cleared Check) CSV Format |
Notes:
All the above formats are supposed to work as per the recommendations set by respective banks at the time of their implementation into CMiC. Any further changes to the acceptable formats by the banks, as reported by the customers, were implemented on specific requests through work orders.
It is NOT guaranteed that some of the above formats work with the current specifications by the bank, and may require programming changes.