Main Page → Bank Reconciliation → 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 and marks checks as cleared in RDA.


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



Tips on Import Checks

  • 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
  • If the imported checks do not match the cleared checks on the Bank Report, check the import file to make sure it's correct and check the source of the checks in RDA to make sure they are Bank Rec Updated
  • Run reports on the Verify tab - Report of Checks NOT Matching and Report of Checks NOT on file and find the source of the checks to see if they have been Bank Rec Updated - If not, the imported checks won't match checks in RDA