Mapping General Ledger Data

Bank Reconciliation > Mapping Your Data > Mapping General Ledger Data

Required:

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 Bank 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:

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.

How do I know which field names to use?

Look at the data in the movie above.  Each column is labeled with internal field fields.  Of these, 5 correspond directly to a Bank Reconciliation field while the others can map to a general field if you need to retain them.

Which fields do I map?

Outside of the required fields, you are free to map as many or as few fields as you wish. These decisions are affected greatly by your situation and how much data you wish to retain later in the matching process.  Note that including additional fields does not guarantee increased matching accuracy. You should assume that any fields you include are solely for your benefit later.

Examine your data and determine which fields correspond to the available Bank Reconciliation fields. See

Note that in this case, there are two fields representing an amount, Debit and Credit, instead of an Amount.  Debit and Credit refer to whether a transaction increases or decreases a balance. See Debit versus Credit for more information.

Here is one way for the above data:

1.  Map all required fields (Date, Check Number, Debit, Credit)

2.  Map all fields you wish to retain (Description)

Next Step

If you have more Bank data to import, or have not yet imported General Ledger data at all:

Importing General Ledger Data

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

Matching Your Data

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