Some banks will send transactional data with all amounts as absolute (positive) values.  Alongside the data will be a field indicating whether the transaction was debit or credit.

 

For example, data could look similar to:

 

47.22        debit

68.12        debit

42.14        debit

98.11        credit

 

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

 

By default, Bank Reconciliation will use "debit" and "credit" to represent those transactions as such.

 

However, what if the credit used is "d" and "c"?

 

Select the Settings tab > Import,System tab > Import tab.

 

If you are using a version prior to 2013.

1. Select File from the main menu

2. Select Options, then General

3. Under the Import tab, look for "Text for 'Debit' "

4. In its corresponding textbox, change "debit" to "d"

5. Follow same steps with "Text for 'Credit' " entry

6. Click Close

 

When working with your data, replace "d" and "c" above with the text for your particular situation.