Importing Bank Reconciliation Information

The following table defines the field references to be used in the MasterBK.DEF file:

Table: tblDLCash & tblBKDeposits
Context Section: CONTEXT,BKREC,HEADER,HBKREC
Field ID	Req'd	Field Length	Default Value	Notes
BKREC_CHECK_FLAG	Y			Required if reconciling checks. Exact word in description field.
BKREC_DEPOSIT_FLAG	Y			Required if reconciling deposits. Exact word in description field.
BKREC_CASH_ACCT	Y	User Defined		GL CSH Account Number
BKREC_REC_DATE	Y	Date		Reconciliation Date. Can be 6, 8, or 10 digit date.
BKREC_DOC_NUM	Y			Check, Deposit, or Document Number
BKREC_AMOUNT	Y	Currency	0.00	Check, Deposit, or Document Amount. Default value must be 0.00. Decimal places must be 0. Indicate sign: + Deposit, or - Check.
BKREC_DESC	N	User Defined		Check or Document Description

Note: You must enter a negative amount for checks.

If your Default Values "Check" and "Deposit" are located in the same column, you should use the value of zero in the CSV string definition. For example, BKREC_CHECK_FLAG,0,CHECK. BKREC_DEPOSIT_FLAG,0,DEPOSIT. The 0 tells the system to look for the Default Values "CHECK" and "DEPOSIT" anywhere on the row.
If your default values "CK" and "DP" are located in two separate columns (2nd and 4th), you should use the two values in the CSV string definition. For example BKREC_CHECK_FLAG,2,CK. BKREC_DEPOSIT_FLAG,4,DP. The 2 and 4 tells the system to look for the "CK" in the 2nd column and the "DP" in the 4th column.
If you choose to use this method, you must also tell the system which column the combined data is in using the BKREC_DESC field ID. For example, if the combined data resides in column 9, BKREC_DESC should be mapped to column 9, as in, “BKREC_DESC, 9”. Otherwise, errors will occur.