Importing sample bank data

Bank Reconciliation > First Steps > Bank Reconciliation Self-guided Tour > Importing sample bank data

Obtaining Bank Data

Normally, before importing data into Bank Reconciliation, it needs to be in the proper format.  The source file can be in any tabular format (columnar with or without headers), including

These files can be obtained by exporting the data from your accounting package, whether it is Peachtree, Great Plains, or any other current package, or by using a report writer such as Crystal Reports, Hyperion, Brio, or similar.

In this case, the bank data and general ledger data have already been created.

Importing Bank Data

Click the Import Bank button (Figure 1).

Figure 1 - Import Bank button highlighted

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

Figure 2 - Bank Import Wizard

When working with your data, you can click the Folder icon to browse for and select the proper file.  For now, leave the default and click Next.

The Select a Table dialog box will now be displayed. It will only appear if using an Access database.  (When using a multi-worksheet Excel spreadsheet, the Select a Worksheet or Range dialog box will be displayed).  This allows you to select the proper table representing your bank records.   In this case, Feb_Bank is the proper table (and is actually the only table in the database).  Represented at the bottom of the screen are a sample of the table's data.

Figure 3 - Select Table dialog box

Click Next.

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