Overview

Importing your bank and general ledger (G/L) data is the first step in the bank reconciliation process. Once your records have been imported into Bank Rec Online, the system can automatically match transactions, identify exceptions, and streamline the reconciliation process.

This guide explains:

• Preparing your bank and G/L files
• Recommended import fields
• Using the Import Wizard
• Importing an Outstanding Checklist
• Common questions and troubleshooting tips
• Best practices for successful imports

Table of Contents

1. Data Import Overview
2. Before You Begin
3. Preparing Your Files
4. Required and Recommended Fields
5. Importing Bank Transactions
6. Importing General Ledger Transactions
7. Importing an Outstanding Checklist
8. Reviewing Control Totals
9. Best Practices
10. Frequently Asked Questions (FAQs)

Data Import Overview

Bank Rec Online supports importing data from most accounting systems and banks including:

• Excel (.xlsx)
• CSV (comma-delimited)
• Tab-delimited text files

After importing your data:

1. Bank transactions are loaded into Bank Rec Online
2. General ledger transactions are loaded into Bank Rec Online
3. Automated Matching compares the records
4. Users review unmatched items and complete reconciliation

For best results, import both data sets for the same reconciliation period

Before You Begin

Before importing data into Bank Rec Online, confirm that:

• Your Bank Rec Online account has been created
• You have access to the bank transactions file
• You have exported the corresponding general ledger file
• Both files represent the same reconciliation period whenever possible

Recommended Starting Point

Gather:

• Bank transactions file
• General ledger transaction file
• Outstanding checklist (if available and importing your first period)

Having these files prepared before launching the Import Wizard can significantly reduce setup time.

Preparing Your Files

Bank Transaction File

Your bank file should contain transaction activity from your financial institution.

Common transaction types include:

• Checks
• Deposits
• ACH transactions
• Wire transfers
• Service charges
• Interest earned

General Ledger File

Your G/L file should contain the accounting transactions that correspond to the same period as your bank activity.

Most accounting systems can export this information directly to Excel or CSV format.

Required and Recommended Field

Bank Rec Online supports dozens of available fields, bust most organizations can successfully reconcile using a small number of key fields

Most Common Import Fields

These fields provide enough information for most automated matching scenarios

Matching (Text1) Field

The Matching (Text1) field is one of the most powerful reconciliation tools available in Bank Rec Online.

Typical examples include:

• Transaction IDs
• Deposit slip numbers
• Reference numbers
• Batch IDs

Best Practice

The Matching (Text1) value should exist on both the Bank and G/L records.

This field is frequently used by Automated Matching to increase matching accuracy and reduce manual review.

Additional Text Fields

Bank Rec Online also supports:

• Text 2
• Text 3
• Text 4
• Additional user-defined fields

These fields are often used for:

• Research
• Reporting
• Additional transaction details
• Internal reference information

Unlike Matching (Text1), these fields are generally not used by Automated Matching.

Alternative Amount Fields

Some source files separate transactions values into:

• Debit columns
• Credit columns

Bank Rec Online supports alternative amount mapping options, including:

• Debit/Credit structure
• Amount Reverse Sign
• Sign-based imports

For more details, see the Amount Field Help Guide.

Importing Bank Transactions

Step 1: Launch the Import Wizard

Step 2: Map Your Fields

Step 3: Review Import Totals

Filler