Download Free Trial 2 Min Demo Contact Us
(866) 226-5732
Easily Create & Transmit ACH Files

Mapping Overview

Bank Reconciliation conforms to your data, not the other way around. In the mapping process, you tell Bank Reconciliation what each field of your data represents. This process only needs to be performed once for each unique layout of your data.

 You can use the default template or one of the other 'user-defined' mapping templates.

Before You Begin

Required:

1.You have created your own Account (not using the Sample account).

2.You have already imported your bank or general ledger data.

 

Why do I map the data?

Mapping translates your internal data name into a name the software knows.  Without this step, the software will not know, for example, if a field holds a transaction date or check number.

Choosing fields

For the majority of cases, the mappings below are suggested.

At a minimum, files sent to the bank will include: check number, amount, date, usually the payee name, and sometimes a void indicator.  Perform these mappings as follows:

Field From Data

Bank Reconciliation field

Check number

CheckNumber

Amount

If amounts in file are positive and all checks are issued checks - Amount_Reverse_Sign

If amounts in file are negative and all checks are issued checks - Amount

If amounts in file are both positive and negative but signed correctly - Amount

Date

Date

Payee name

Description

Void check indicator

Void_Check_Indicator

See 'Mapping General Ledger Data' for the steps to actually create the mapping.

In Bank Reconciliation, you will have two kinds of data: bank data and general ledger data.  You must pay special attention to how the amounts are listed.  In some cases, the bank data will have two columns, one marked Debit and one Credit, while other times the amounts are in one field and signed.  Special care must be taken as positive and negative values have different meaning to the bank than to your company.

For Debit/Credit mappings, please see the article 'Debit versus Credit'. 

For amounts in one field, it is important to know that Bank Reconciliation views all negative values as being ones that reduce your general ledger, such as payments and issued checks, while positive values increased your general ledger, such as deposits and void checks.  If this is accurately represented in the bank data, map the amount as Amount.  If the signs are exactly the opposite, map the amount as Amount_Reverse_Sign.  See 'Selecting Fields to Represent Amount' for more information.

How Can We Help You?

Call Us (866) 226-5732
Contact Us Online
Schedule a call

Some of our clients:

Testimonials >>