Skip to content

Map banking transaction groups

Trans group mapping assigns a trans group to imported bank transactions automatically, so fewer lines come in blank. Each rule matches a BAI code and, usually, part of the transaction’s description.

A mapping rule uses three things:

  • The BAI Code of the transaction, shown in the BAI column when you import a bank file.
  • Text to match in the description. Not every rule needs text, but most do.
  • The trans group to assign.

When matching on text, be as specific as you can while still catching every transaction you want. Nexsyis uses the first rule that matches. For example, with rules for “CHECK%” and “CHEC%”, a description of “CHECKING ACCOUNT” matches only one of them, which could assign the wrong trans group.

The % character is a wildcard for one or more characters:

  • “CH%AC%” matches “CHECKING ACCOUNT”: CH, any characters, then AC.
  • “CH%AC%” doesn’t match “MY CHECKING ACCOUNT”, because there’s no leading %, so the description would have to start with CH.

Use as many % characters as you need. It’s usually best to start and end the match text with %.

  1. Open Setup › Accounting › Banking / Cash › Trans Groups.

  2. Select the trans group, for example EFT, and select the edit button.

    The Trans Groups list with EFT selected

    The existing rules are listed under BAI Bank Import Code.

  3. Select the add button to add a line.

  4. In BAI Code, enter the code from the BAI column of the import file.

    A trans group rule’s BAI code matching the BAI column of an imported transaction

  5. Select Requires Text Match.

  6. In Match Text, enter text that matches part of the transaction’s description. It should be unique to this kind of transaction.

  7. Select Other, EFT or Credit Card.

  8. For EFT or Credit Card, select the company from the list below.

  9. Select Save.

    A new rule with BAI Code 108, Requires Text Match, Match Text SF Mutual, EFT and State Farm selected

To match every transaction with a BAI code, whatever its description, leave Requires Text Match cleared.

In the screenshot above, EFT transactions with BAI code 108 and a description containing “SF Mutual” are assigned to the EFT trans group with the payer State Farm. The bank’s description is “SF MUTUAL 05004”, so this rule only works with a trailing %: “SF Mutual%”. Include leading and trailing % characters unless you really want an exact match on the whole description.

The trans group codes and their descriptions

Credit card deposits use the CCRD trans group, with rules for each processor’s description:

The CCRD trans group with rules for %BANKCARD% and %MERICAN EXPRESS%