Main Page → Bank Reconciliation → Documentation → Checks/Returned Checks/Redeposits → Imported Checks (csv file)


Contents

 
  • 1 What This Process Does
  • 2 Requirements
  • 3 Import Checks (csv file)



What This Process Does


  • This process allows checks from a separate data space to be imported to a central office location, where the bank statement is reconciled in OpenRDA.


Requirements


  • The field and file layout has to match in order to be imported. It is recommended that you contact RDA to verify that the layout of the bank file being imported is an accepted layout in OpenRDA.


Import Checks (csv file)


  1. Finance → Bank Reconciliation → Other Tab → Import Checks (csv file)
  2. Range accordingly. Commonly used criteria are listed below.
  3. Click Select.


FIELDSOpt.Rec.Req.Description
Filename——♦Use default name or magnifying glass to locate the upload file
Bank ID♦——The Bank ID associated with the checks being imported
Check Date♦——The check date of the checks being imported
Check Number♦——The check numbers being imported
Entry Date♦——The entry date of the checks being imported
Opt. = Optional  Rec. = Recommended  Req. = Required