Overview

The Bank Rec Online Import Wizard allows you to quickly import General Ledger (G/L), Bank Statement, and Outstanding Check records into your bank reconciliation workspace.

The Import Wizard supports data from Excel spreadsheets, CSV files, text files, accounting systems, ERP platforms, and custom reports.

This guide explains:

• How the Import Wizard works
• Required fields for importing data
• How to map columns during import
• How to review imported records
• Common import questions and troubleshooting tips
• Best practices for successful bank reconciliation imports

Table of Contents

• Import Wizard Overview
• Importing General Ledger Records
• Mapping Import Fields
• Completing the Import
• Importing Bank Transactions
• Best Practices
• Frequently Asked Questions (FAQs)

Import Wizard Overview

The Import Wizard converts transaction data from external systems into records that can be used within Bank Rec Online.

Common import sources include:

• Microsoft Excel
• CSV Files
• ERP Systems
• Accounting Software
• Treasury Management Systems
• Custom Reports

After importing records, Bank Rec Online automatically prepares the data for the reconciliation and matching process.

Recommended Import Process

For most reconciliations, Treasury Software recommends:

1. Import General Ledger (G/L) records
2. Import Bank transactions
3. Import Outstanding Checks (first-time setup only)
4. Review imported totals
5. Run Automated Matching
6. Review unmatched transactions

Following this process helps ensure accurate reconciliations and efficient matching results.

Importing General Ledger Records

To begin importing General Ledger data:

1. Select Import G/L
2. Launch the Import Wizard
3. Choose your import source

You can either:

Option 1: Import a Saved File

Click the folder icon and browse to:

• Excel files (.xlsx)
• CSV files (.csv)
• Delimited text files

Option 2: Paste Data Directly

Copy records from Excel or another application and paste them directly into the import grid.

Best Practice

Treasury Software recommends importing from a saved file whenever possible. Saved files are easier to validate, troubleshoot, and re-import if necessary.

Mapping Import Fields

The Field Mapping screen determines which columns are imported into Bank Rec Online.

How Field Mapping Works

1. Highlight a source column
2. Select the destination field from the dropdown menu
3. Repeat for all required fields

Unmapped columns will appear in red and will not be imported.

This is completely acceptable for fields you do not need.

Required Fields

Most imports require the following information:

Depending on your file structure, Amount may be provided as:

• Amount
• Debit and Credit fields
• Amount + Sign field
• Amount_Reverse_Sign

Optional Fields

Bank Rec Online also supports additional fields that can improve reporting and automated matching, including:

• Site
• Text1 (Matching Field)
• Memo
• Additional Text Fields
• User Defined Fields

These fields can help improve matching accuracy and reporting capabilities.

Reviewing Import Records

After mapping fields , the Import Wizard displays a Review Records screen.

This step allows you to verify:

• Record counts
• Control totals
• Transaction amounts
• Data formatting

Invalid Rows

The Invalid Rows section identifies records that will not be imported.

Common invalid rows include:

• Header rows
• Footer rows
• Totals and summary lines
• Blank rows

Bank Rec Online automatically identifies these records and excludes them from the import process. 

For each invalid row, the software displays the reason it was rejected

Recommendation

Before proceeding, confirm that:

• Record counts are correct
• Totals match the source system
• Required fields imported successfully

Completing the Import

Once your records have been validated:

1. Click Next
2. Review the import summary
3. Click Finish

Your General Ledger data is now available within Bank Rec Online.

Congratulations! The General Ledger import is complete.

Importing Bank Transactions

The process for importing Bank transactions follows the same workflow:

1. Select Import Bank
2. Choose a file
3. Map fields
4. Review records
5. Complete the import

Once both Bank and General Ledger records have been imported, you can begin the reconciliation process and run Automated Matching.

Tips & Best Practices

Save Import Layouts

If you routinely import files from the same system, saving your mappings can significantly reduce future setup time.

Verify Control Totals

Always compare imported totals tot he source file before completing an import.

Use Consistent File Formats

Using standardized exports from your accounting or ERP system improves mapping accuracy and reduces import errors.

Import Outstanding Checks During Initial Setup

For new reconciliations, be sure to import Outstanding Check data beginning the first reconciliation cycle.

Frequently Asked Questions

1. What file formats can I import?

Bank Rec Online supports:

• Excel (.xlsx)
• CSV (.csv)
• Delimited Text Files

2. Do I need to map every column?

No. Only the fields needed for reconciliation and reporting must be mapped. Unused fields can remain unmapped.

3. Why are rows marked as invalid?

Why are rows marked as invalid?

Row are typically marked invalid because they are:

• Headers
• Footers
• Summary totals
• Blank rows

These records are automatically excluded from import.

4. Can I paste data directly from Excel?

Yes. The Import Wizard allows data to be copied and pasted directly into the import grid.

5. What should I do after importing data?

After importing:

1. Verify totals
2. Import the corresponding Bank or G/L file
3. Run Automated Matching
4. Review unmatched records

Need Help?

Still have questions? Contact Treasury Software Support or visit www.treasurysoftware.com for personalized assistance.