Sign

 

Usage: Used to hold the debit or credit text, typically for bank imports

Required: No 

Restrictions: Only use when all data in Amount is positive.  Can only map with Amount.

 

Sign is used when amount values are absolute and the sign is indicated in a separate field.  For example, the file may have data similar to:

 

47.22        debit

68.19        debit

32.40        credit

101.80         debit

 

The first column would be mapped as Amount; the second column would be mapped as Sign.

 

The Sign field is Bank-centric.  In other words, Bank Reconciliation will treat amounts associated with "debit" as being negative.

 

For more information on debit and credit related to sign, see Debit versus Credit

 

If your data uses indicators other than "debit" and "credit", see Changing debit and credit text