Mapping General Ledger Data - Bank Reconciliation and Bank Positive Pay |
|||
Mapping General Ledger Data - Bank Reconciliation and Bank Positive Pay |
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
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: