Site Logo BankReconOnline.com

Comprehensive Bank Reconciliation Online Tool

Sign In To Your Account
If you are not currently a registered user of
BankReconOnline.com and would like to be for FREE, register as a new user.

Or learn more about BankReconOnline.com

Username   
Password   I Forgot

BankReconOnline.com Quick Review
Multi-Matching (Multiple Records Matching) Querying the Bank and General Ledger data to match thousands of transactions in seconds. Complicated and custom matching postings with one-to-one, one-to-many and many-to-many values are welcome. Match rules for reconciliation requiring one or many sub-ledger data subtitution, Card (ATM, Credit etc.), ACH, RTGS and any variants of postings involving debit/credit entries.
Default Matching Rules Transactions Matching may be done between GL and Bank, GL to GL, and Bank to Bank.
Matching includes the following:
  • Match cheques – GL bank account credits to bank statement debits.
  • Match GL Reversals – GL bank accounts debits to GL bank account credits. For example, use this for instantly matching booked stale dated cheques.
  • Match deposits – GL bank account debits to bank statement credits.
  • Bank reversals – bank statement debits to bank statement credits. This is useful for disbursement accounts where the bank habitually debits the account and then reverses the entry with a credit.
Default Matching Columns Alphanumeric cheque/deposit numbers and currrency value.
Allows unique and non unique matching.
Credit Card Match credit cards based on value, credit card type, site (if used) and a date range.
Manual (Individual) Matching The "Click" Matching window allows the matching of items not automatically matched.
You may match one/multiple items to one/multiple items.
This window allows you to focus on any matching combination.
Match Review In this window you may quickly review matches for user selected periods and other criteria. If the reconciliation is "Open" you can un-match incorrect matches. All related matches share a unique match number for audit purposes.
Grouping Outstanding Items This is a big, big feature for quality reconciliation. Your company standardizes on Exception Group Names and outstanding items are user assigned to these based on origin. These are used in risk, reporting and response functions.
Common Group Names are Un-presented Checks and Deposits in Transit. Origins are GL/Bank Debits/Credits.
Customized matching If your reconciliation needs move to the more complicated or exotic, just shout out, even if it seems impossible we generally will really pleasantly surprise you.
Period match information When matched, the date of the offset record's transaction date is recorded. This allows for historical reporting by period.
Loading Bank and GL Data
Single Entry and Batch File Import Transactions are quickly inserted from electronic files received from your accounting package and internet banking window.
Easy Bank/GL Importer Veft imports from Excel and text files (fixed width, ragged right, CSV and other delimited text files).
Starting (Historical) Outstanding Items Load these directly from spreadsheets or other files just as you would in your regular work.
Loading Statement Files Create and save multiple import templates for your data sources. For example – one for GL Bank account, another for Accounts Payable, one for the bank statement.
As many templates as you need.
Reporting
Summary (Cover) Report Reconciliation Summary Report
Displays:
  1. Displays the balances.
  2. Summary of the outstanding items.
    • By Risk Level, Exception Group Name and origin.
  3. Adjusted Balances – also called Free Cash Balance.
  4. Reconciliation Difference if any.
  5. Is the reconciliation completed and approved.
  6. Signatory lines and date stamp.
Reporting capability, with xxport to Excel and PDF Export industry standard reports, as well as user ad hoc reports to the screen, Excel, Word or PDF.
Detailed Reports One report per GL/Bank debit/credit sides.
Displays:
  • Group Subtotal
  • Transaction Date
  • Reference Number
  • Narration/Payee
  • Original Value
  • Unmatched Value
Match date sensitive reporting For example a cheque drawn in January but cashed on March 31 is properly reported as outstanding right up to March 30.
If, in May, you run the February 28 outstanding items that cheque must be displayed as outstanding.
Compare Anything This is used to quickly compare two sets of data in Excel files by cell values. The results may be copied.
Copyright© 2006 - 2017 BankReconOnline.com. All rights reserved. Please read our Terms Of Use and our Privacy Policy