Many to Many

Bank Reconciliation > Matching > Types of Matches > Many to Many

Many to Many Matching

Default: Off

Possible Settings: Off, Based on Matching Field, or Based on Check Number

Attributes: Matching Field or Check Number and the amount after being summed on the matching field

In some situations, a check will be listed multiple times on the general ledger. For example, a company paying the utility bills for multiple locations may send one check in payment, but it will be broken up based on site number.  Matching just on check number will not work because the amounts will be different.  Effectively, Many to Many Matching will group bank records and general ledger records on either a matching field or check number and compare this number and the summed amounts to create a match.

In either case, you must turn off Non-Check Matching. Failure to do so will cause records to be matched using those rules and no records will be matched by the Many to Many rules.

If the matching text is alphanumeric, you must turn on Alphanumeric Matching. For instructions on how to change the matching options, see Types of Matches.

Based on Check Number

When Check Number is used, data will be grouped on the check number.  Records without check numbers will not be processed, by design. 
 

Based on Matching Field

Use a matching field when you wish to group data on a field separate from check number. This field, in both bank and general ledger data, must be mapped as Matching_Field.  Records without data in Matching_Field will not be processed, by design.

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