On this page you will find information about the option to add custom columns to the pop-up that will help you to determine which transactions to select in order to reconcile the bank statement line.

General pop-up information

The Bank Reconciliation tool uses a pop-up window to show the user potential transactions that can be selected to reconcile. The pop-up shows by default the following columns:

Select
Transaction ID
Date
Type
Remaining
Disc date (if enabled)
Disc available (if enabled)
Disc. taken (if enabled)
Discount (if enabled)
Payment
Total
Memo
Percentage paid
Payment difference reason (if enabled)
Payment discount (if enabled)

To get better insights in the transactions available for reconciliation we offer the user the option to include additional columns that display data from the transaction

Adding a custom column

To add a custom column navigate to SETUP→BANK RECONCILIATION SETUP→BANK ACCOUNT CONFIGURATION. At the bottom of the page go to the sub tab named "Additional Parameters & Fields"→"Bank Statement Additional Columns". Press on the button named "New Bank Statement Additional Columns"

In the window that opens you have the ability to configure additional fields. The configuration allows you to add 3 different fields in one setup

Name: A name for this particular addition column. This is used to display the user an overview of created additional columns on the bank account configuration.
Inactive: When set to checked the additional column won't be displayed in the pop-up
Bank Account-File Mapping: This value is pre-selected and relates to the id from the bank account configuration
Field 1: The first field you would like to add.
Field Internal Id: Internal id of the added field that Netsuite uses
Field 2: Second field you would like to add
Field Internal Id 2: Internal id of the added field that Netsuite uses
Field 3: Second field you would like to add
Field Internal Id 3: Internal id of the added field that Netsuite uses

Now save the configuration. You should see the newly create configuration in the sublist.

Result in the pop-up

If you open the pop-up on a statement that is related to this bank account configuration then you should see the additional columns