Importing Bank Data

Bank Reconciliation > Imports > Importing Bank Data

Importing Bank Data

In this section, you will learn:

Required

Before continuing, you must:

1. Have data from your bank in a file or multiple files in tabular format.  See Obtaining Data for more information.

2. Be working in the proper account. See Creating a new account or Switching to a different account

Overview

Obtain a copy of your bank transactions in a usable file format - Excel spreadsheet, comma-separated values (CSV), tab-delimited, etc).

Every bank uses its own format to order the data fields.  Fortunately, Bank Reconciliation will handle any source file as long as it is in a tabular format.

Steps To Import Data

1.  From the Main Screen, click the Import Bank button (Figure 1) or click the Import Bank link in the left pane (Easy Steps).

Figure 1 - Import Bank and Import General Ledger buttons

This will load the Bank Import Wizard (Figure 2 below).

Figure 2 - Bank Import Wizard (Select File icon circled)

2.  In the wizard, you can either:

Note: It is best practice to import a saved file.

When finished, click Next.

       The Select a Table dialog box (Figure 3 below) is displayed.

b.If the file was a multi-sheet Excel spreadsheet
       The "Select a worksheet or range" dialog box would be displayed.

       Choose the proper table or sheet and click Next.

Figure 3- Select a Table dialog box

You will now be at the Bank Column Mapping dialog box (Figure 4 below).

Figure 4 - Bank Column Mapping dialog box

At this point the import process is not yet complete.  The data which has been brought into Bank Reconciliation must be mapped to identify each field to Bank Reconciliation.

Note:  The data only needs to be mapped once.  Bank Reconciliation automatically remembers your settings.

Next Step

Mapping Bank Data

Page url: http://www.treasurysoftware.com/TSHelp/index.html?br_importing_bank_data.htm