Bank Reconciliation > First Steps > Bank Reconciliation Self-guided Tour > Mapping sample bank data
The Bank Column Mapping (Figure 1 below) dialog box will now be displayed.
 Figure 1 - Bank column mapping dialog box |
Bank Reconciliation will adjust to your data; it does not require you to format your fields in a certain order. To achieve this, the mapping process tells Bank Reconciliation the relationship between fields and their purpose.
For the sample account, the data is mapped automatically. The fields with green headers are mapped, red headers are not. In this case, Date, Check Number, Amount, and Description are mapped and will be the only data used from the source file. Of the fields used in this example, Date, Check Number, and Amount are the minimum to ensure proper matching.
Leave the defaults and click Next.
You will see on the dialog box two status bars appear temporarily and then the Review Records dialog box (Figure 2 below) will appear. On this screen, you will review the data that has been imported successfully.
 Figure 2 - Review Records dialog box |
As a simple check, ensure that the amount and the number of records match the proper data from the Access database. In this case, $425,184.23 was the amount from 234 records. There are no unimportable records. Click the + sign to the left of Importable to expand the grouping and see check number, date, amount, and description of every record that was imported. This corresponds to the fields mapped in the previous step.
Click Next.
The Import Complete dialog box (Figure 3 below) will appear, confirming that data has been imported.
 Figure 3 - Import Complete dialog box |
Click Finish.
At this point, the bank data has been brought into Bank Reconciliation. The next step is bringing in the general ledger data.
Page url: http://www.treasurysoftware.com/TSHelp/index.html?mapping_sample_bank_data.htm