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.