BankRec

Mapping General Ledger Data - Bank Reconciliation and Bank Positive Pay

Mapping General Ledger Data - Bank Reconciliation and Bank Positive Pay

Previous topic Next topic  

Mapping General Ledger Data - Bank Reconciliation and Bank Positive Pay

Previous topic Next topic  

Required:

At this point, you have followed the steps in Importing General Ledger Data to import general ledger data into Bank Reconciliation.

 

Suggested:

It is recommended that you have read the Mapping Overview and Deciding What to Map articles

 

If you need more information on a particular field, please Definitions - Mapping Fields

 

Mapping General Ledger Data

 

At this point, you have a screen similar to Figure 1 (data in grid may be different).

 

Figure 1 - General Ledger Column Mapping dialog box

Figure 1 - General Ledger Column Mapping dialog box

 

This file contains 7 fields (columns), listed by column headers in the 3rd row.  They are:

Date

Description (partially visible)

Journal

Debit (not visible)

Journal ID

Credit (not visible)

Document #


 

The topmost row has green and red headers. Date, CheckNumber, Debit, and Credit are in green while the red boxes have no label. Green means mapped. Red is not mapped.  In the movie below, you can see how to map those same four fields from start to finish.

 

 

 

To map:

1. Click on the red header.

2. In the dropdown, select the appropriate entry

 

The header will turn green and have the field name inside.

 

To unmap:

1. Click on the green header

2. In the dropdown, choose "Select..."

 

The header will turn red and the field name will be removed.

 

Next Step

 

If you have more Bank data to import:

Mapping Bank Data - Bank Reconciliation

 

If you have already imported all General Ledger data and you have no more Bank data:

Matching Your Data