Solutions Summit 2014

Reconciliation Templates

Suggested Usage and Walkthrough

Jonathan Haynes, CPA

Chesapeake System Solutions, Inc. • Proprietary and Confidential

Main Drivers of Template Selection

Account Type

• Account types where transactional details and age are important

• Account types where individual DR/CR activity isn’t as important

Level of Reconciliation

• Full transactional matching from both sources

• Balance comparison with activity review from one source

• Balances only

Data Sources

• Single source vs multiple sources

• Manual source(s) vs systematic

Chesapeake System Solutions, Inc. • Proprietary and Confidential

Core Templates

• GL to Independent Source or GL to Independent Source/Balance Progression• Must have two sources, uses details from both sources• Useful for Cash/Banking and GL/SL detailed reconciliations

• Balance Comparison• Requires two balance sources, details are not mandatory• Reconciling items can be manually entered or systematically populated

• Balance Verification• Single source only• Used to validate the contents of an account

Core Template Demonstration

Chesapeake System Solutions, Inc. • Proprietary and Confidential

Expanded Use Templates

• Roll Forward• Not technically a reconciliation, but can be used to fit existing

processes• Most typical uses are Equity and Fixed Assets

• Balance Change Analysis• Single source only, detailed transactions required• Shows the change in the balance during the period under

reconciliation, along with total volumes for reasonableness review

Expanded Use Template Demonstration

Chesapeake System Solutions, Inc. • Proprietary and Confidential

Specialized Templates

• Balance to Detail Comparison• Must have two sources• Validates balance of the internal source using detailed import

comparison

• Budget• Used to calculate or confirm the remaining funds available against a

budget or funded account• Focused on project and fund accounting applications

• Roll Forward with Independent Source Comparison• Highly specialized, very specific uses for payment activities

Specialized Template Demonstration

Chesapeake System Solutions, Inc. • Proprietary and Confidential

Thank you for your time

Jonathan Haynes, CPAjhaynes@chessys.com