• About Us
  • FAQs
  • Careers
  • Our Mission
  • Contact Us

Design Data Associates

A financial software company

  • Home
  • Services
    • Classes
    • Desktop Data Access (DDA+)
    • Training
    • Vendor Information Access (VIA)
    • RightSize/iSeries
  • Accounts Payable
    • AP Input Flow
    • Check Reconciliation Flow
    • Check Write Processing Flow
    • Company Controls
    • Data Entry
    • GL Interface Processing Flow
    • Master File Purge
    • Online Processing
    • PO Input Flow
    • Processing Flows
    • Receiver Input
    • Report Write Flow
    • System Narrative
    • System Reporting
    • Vendor Controls
  • Fixed Assets
    • Acct & Ctrl Reports
    • AIM
    • Asset Features
    • Book Features
    • Company Controls
    • General Report Writer
    • GL Interface
    • Optional Modules
    • Report Select
    • System Controls
    • System Features
    • System Narrative
  • General Ledger
    • Acctg and Control Reports
    • AIM
    • Allocations
    • Budgeting
    • Company Control
    • Consolidated Reporting
    • Data Control
    • Ease of Implementation
    • Journal Processing
    • Online
    • Period Aggregate Capability
    • Personal Computer Interface
    • Posting and Closing
    • Report Requests
    • STAR
    • Structure Control
  • Project Accounting
    • Acct and Ctrl Reports
    • Asset Translation Controls
    • Commitment Controls
    • Company Controls
    • Expenditure Controls
    • Optional Modules
    • Project Controls
    • System Narrative
    • Work Unit Controls

Check Reconciliation Flow

Outstanding check information from the Check Write job and cleared checks from banks are brought together in the Check Reconciliation Module, usually on a monthly basis (although it can be run as often as you wish). This module also looks to the input of control data to determine how to process. An online screen is provided for entering cleared checks by hand if the bank does not provide a magnetic file.

Some of the controls include:

  • from which banks have magnetic files been received?
  • after how many days do un-cleared checks expire?
  • which checks, if any, are to be purged from the Check Reconciliation Master file on this run?
  • are recently issued checks (that probably have not cleared) to be summarized on this run? And if so,
  • after what date are issued checks to be summarized?

The Vendor Master file provides company information for producing the Check Reconciliation Register, while the Table Master file validates bank account information for each company using the system.

During check reconciliation, cleared and canceled checks from the bank(s) are matched against the checks produced by the system to screen for:

  • old, un-cleared items
  • number gaps
  • amount discrepancies between issued and cleared items
  • voids that may have cleared

The Check Reconciliation Master file is updated in the process.

The Check Reconciliation Register displays all check clearing information, as well as data relating to the average time it takes checks to clear each bank or bank account. For companies that have banks do their reconciliation, this report provides a good cross-check on the bank.

Contact Us:

Mailing Address

PO Box 33704
Raleigh, NC 27636-3704
Phone: (919) 376-1100
FAX: (919) 376-1200
Email: info@ddasoft.com

Street Address

4000 Blue Ridge Road โ€“ Suite 100
Raleigh, NC 27612

Click here for driving directions

Hours

Monday โ€“ Friday ~ 9 am โ€“ 5 pm

Copyright © 2022 ยท Design Data Associates