Bank Reconciliation - Screen Shots

1. Data Import - Imports records from your Accounting Package and Bank.
2. Automatic Transaction Matching - High speed automated matching
3. Manual Matching - Allows for advanced non-automated many to many matches
4. Unmatched Detail with Exception Reason - Answers why it didn't match (outstanding check, deposit in transit, missing deposit, etc...)
5. Reconciliation Report - 'Audit ready' report reconciling unadjusted to adjusted balances
6. Reporting - Full reporting package with Excel export capability
7. Scheduler - Automate the entire process for an unlimited number of accounts

1. Data Import

Bank Reconciliation can import from every major accounting package on the market, including files in:
• Microsoft Excel
• Microsoft Access
• Text - Fixed Width
• Text - Tab Delimited
• Text - Comma Delimited (csv)
• 'Copy and Paste' from Excel

These files are generated from standard system reports in the Accounting Package, which are then saved to disk.

In addition, the system can import data from your bank using one of the file formats noted above.

Date Formats This system can handle a wide variety of date imports, whether:
• embedded in text
• nonstandard (International)
• Excel Serial date format

Note: The system automatically saves the imported file column mapping. Therefore, the file only needs to be mapped once - or whenever the file layout changes.

2. Automated Transaction Matching (ATM)

Provides high speed automated matching

The system comes completely preconfigured with the following matching routines:
• checks
• voided checks
• deposits and all other transactions

In addition, we maintain a library of credit card, CUSIP and other financial and non-financial (i.e., inventory) matching routines available with additional licenses.

Fail-safe routine: Should the process become interrupted - (i.e., power outage) the system can restore to its prior state.

Complete Audit Trail - Each record in a match receives a unique audit trail number.

Automated process allows your staff to focus on the exceptions, not the routine matching.

3. Manual Matching - Advanced Many to Many Matching

For transactions out of the ordinary that need personal attention.

Displays a full listing of all unmatched records and provides you with the ability to perform matches for:
• one to one
• one to many
• many to many

You can also:
• add offsetting records on the fly
• filter the records by date, amount, site and/or check number

4. Unmatched Detail Report with Exception Reason

Provides detailed explanations indicating why records didn't match.

These include:
• outstanding checks
• deposits in transit
• missing deposits
• amounts differ
• check number cleared bank more than once

as well as special handling for voids:
• voided check, no record of issuance
• check voided multiple times
• amount on voided check differs from amount originally issued

5. Reconciliation Report (Public Reporting Edition only) - move mouse over statement to view detail

Produce an industry standard 'Audit Ready' reconciliation report.

Out of balance?
If you are currently out of balance, or have never been in balance, this system will get you there - and keep you in balance on a going-forward basis.

Don't need to perform a full reconciliation?
That's okay. About 85% of our users don't perform a full reconciliation. They simply use our system to perform high speed matching and report exceptions. They stop at #4: Unmatched Detail with Exception Reason.

6. Reporting

You can produce a variety of industry standard reports, as well as create your own.

All reports can be exported to:
• Microsoft Excel
• HTML
• XML

Our reporting engine comes with 'Microsoft Outlook Style' grouping to enable drill-down and analytical reviews.

7. Scheduler

Our scheduler allows for unattended operation of the entire process from start to finish.

Whether you have one -or multiple accounts- each account can:

• Import Bank

• Import General Ledger

• Automated Transaction Matching (ATM)

• Back up the data file to a Network Server