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

View

2 BACS_UK BACS format Not Available
3 BOA Bank Of America Not Available
4 BOA_4 Bank of America Format #4

View

5 BOA_2 Bank Of America Format (2)

View

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

View

11 WEST-BANK Bank Of The West

View

12 BBTBANK BBT Bank

View

13 BMO_HARRIS BMO Harris Bank

View

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 )

View

18 CHASEPWSBK Chase PWS Delimited Text File

View

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

View

23 CITYNATION City National Bank

View

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

View

28 FTB_2 Fifth Third Bank 2

View

29 FHAWAIBANK First Hawai Bank Not Available
30 HAWAI-BANK First Hawaiian Bank

View

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

View

35 JPM-CHASE2 JP Morgan Chase Bank ( 11 Digits Account )

View

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

View

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

View

45 PVT-BANK Private Bank

View

46 PVT-BANK2 PrivateBank (10 Digits Account)

View

47 ROYALBANK Royal Bank

View

48 SOUTHTRUST South Trust Bank Not Available
49 SOVEREIGN Sovereign Bank

View

50 SUNTRUST_1 SUNTRUST BANK (PAID ITEMS) Not Available
51 US-BANK U.S. Bank Not Available
52 UMB_BANK UMB Financial Corporation

View

53 UMPQUABANK UMPQUA Bank Not Available
54 UBC Union Bank Of California

View

55 UNITEDBANK United Bank

View

56 ACH US Bank

View

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)

View

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

View

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

View

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.