Treasury Management Forum

1
Treasury Management Forum
How to meet Audit the Easy way
The application of reconciliation software in the
Public Sector
One rule No exceptions
Gordon McHarg Andy Scott
2
Agenda

• Introductions
• Reconciliation software overview
• Next steps

3
Todays Objectives

• Describe application of reconciliation software
• Implementing efficient audit/trace procedures
• Reporting and analysis on financial data
• Improving efficiency cutting costs

4
Why Automate reconciliations?

• All organisations are under pressure to ensure
  their financial operations
• comply with standards and audit requirements
• tighten financial control and eliminate risk
• are efficient and cost effective
• are transparent and traceable

5
Automated Reconciliation

• Delivers
• Detailed audit
• Fast Efficient handling of transactions
• Removal of paper or manual processes
• Simple on-line access to reporting and analysis
• Consistent, repeatable, robust processes
• AutoRek is a reconciliation reporting solution

6
AutoRek In One Picture
Ledger entries
Bank statements
load data to database
Bank Data txn 1 txn 2 txn 3
Ledger Data txn 1 txn 2 txn 3
Manual or automatic match
Reports and analysis
audit trail
Ad hoc notes..
Ad hoc notes..
7
(No Transcript)
8
Matching
9
Data History
Readable narrative with system events and ad-hoc
notes
10
Detailed Audit Trail
11
Reporting Dashboard
12
Formal Report
13
Benefit Summary

• Fully audited for complete control and
  traceability
• Accurate reporting of positions provides
  operational transparency
• Automated high-performance matching engine -
  frees staff to focus on exceptions and other work
• Applies consistent business rules throughout the
  process - reducing errors and applying repeatable
  standards

14
The Business Impact

• Managed Risk
• Improved staff productivity
• Reduced errors
• Increased control
• Traceability
• Maintain standards
• Reduce costs

15
Next Steps

• Initial consultation review
• Pilot Reconciliation
• 2-day investigation and configuration
• Using your data
• ½ day play back and result analysis
• Project Brief
• AutoRek Configuration
• Project Roll-out

16

• Thank you for your time
• autorek.com
• api-software.com

Contact Andy.Scott_at_api-software.com