Main Page → Bank Reconciliation → Documentation → Verify → Import Checks (The title could be different per client based on what type of bank import


Contents

 
  • 1 What This Process Does
  • 2 Requirements
  • 3 Import Checks - Steps



What This Process Does


  • This process uploads checks to the Bank Reconciliation module from a bank file.


Requirements


  • The option to Display Upload and Verify Checks Submenu must be flagged in the Generic Setup Variables in order for the Verify tab and it's submenu items to appear.


  • From the Resource Bar: Setup → Generic Setup Variables


  • The file layout has to match the file requirements to import - Could be based on client, but .csv layout is common


Import Checks - Steps


  1. Finance → Bank Reconciliation → Verify Tab → Import Checks
  2. Range accordingly if necessary (it's required that the Closed Date be ranged on).
  3. Click Select (Process wheel).


FIELDSOpt.Rec.Req.Description
Filename——♦Use default name or magnifying glass to locate upload file
Range on Account Number♦——Range on the account number
Range on Amount—♦—Range on amount or range of amounts
Range on Check Number—♦—Range on a check number or range of check numbers
Range on Closed Date——♦Range on the closed date (date check cleared bank)
Opt. = Optional  Rec. = Recommended  Req. = Required


If amounts are zero after the file is imported in RDA this means there is something wrong with the file layout.  Ensure that the file has not been opened after downloading from the bank.  Doing so can change the file format.